I am curious to know whether the developers are able to estimate
roughly when the FTS5 extension might appear in an official release of
SqLite?
Kind regards,
Philip Bennefall
Thanks, Dan. Do you have any idea when FTS5 will be merged into the
amalgamation, if at all?
Kind regards,
Philip Bennefall
On 6/19/2015 8:54 PM, Dan Kennedy wrote:
> On 06/19/2015 08:34 PM, Philip Bennefall wrote:
>> Hi all,
>>
>> While reading through the draft docu
How about using prepared statements in conjunction with bind?
http://www.sqlite.org/c3ref/bind_blob.html
Kind regards,
Philip Bennefall
On 2014-07-09 15:03, - wrote:
Hello all,
I'm quite new at SQLite3, and have a bit of a problem with grasping the
handling of a database.
After having used
.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
table if not exists dictionary using
spellfix1(edit_cost_table=editcosts);
When searching, I specify top=5 to get these timings.
Is there anything I can tweak to speed up the search for short words, or
is there anything that can be done by the developers to optimize this
further?
Kind regard
. Is this
to be expected?
Kind regards,
Philip Bennefall
On 7/23/2014 11:57 PM, Philip Bennefall wrote:
Hi all,
I have been running some tests with spellfix using a table containing
about 30 words, extracted from the Moby project's single word list
as well as names and places. Moby can be found at:
http
thoroughly.
Kind regards,
Philip Bennefall
On 7/24/2014 12:25 AM, Richard Hipp wrote:
On Wed, Jul 23, 2014 at 6:18 PM, Philip Bennefall <phi...@blastbay.com
<mailto:phi...@blastbay.com>> wrote:
I have to amend my last message. The timings I just gave was for
looking
and the date string being accurate if the date is in fact valid?
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi Simon,
That is what I tried to do in my query examples that I included in the
original message. Based on those, would you say that I am doing it
correctly?
Kind regards,
Philip Bennefall
On 8/9/2014 11:49 PM, Simon Slavin wrote:
On 9 Aug 2014, at 9:53pm, Philip Bennefall <
about the time of day; just that the date is valid. So based on
your description I gather that I'm doing it correctly in my example? I hope?
Kind regards,
Philip Bennefall
On 8/10/2014 12:00 AM, Keith Medcalf wrote:
The result of converting an "invalid" datetime string with
be
completed. I
have looked at the example VFS implementations, but it is hard to
determine which parts of the code that are implementation details as
opposed to being
part of the stable public API so to speak.
Kind regards,
Philip Bennefall
me to implement things immediately without having
to search third party sources and hack around to find what works and
what doesn't. It would be ideal if the same could be true for the VFS layer.
Kind regards,
Philip Bennefall
On 5/24/2015 10:38 PM, Roger Binns wrote:
> -BEGIN PGP SIG
return when, etc.
Kind regards,
Philip Bennefall
On 5/24/2015 6:19 PM, Jeff M wrote:
> I searched stack overflow for "sqlite3_vfs_register" and got a few hits. For
> example, this was a good starting point on which I based my own VFS.
>
> http://stackoverflow.com/a/3
compression code has the same public
domain clearance guarantee as the rest of sqLite? Is this assumption
true, or could there potentially be contributions from other Fossil
developers that are still under the terms of the BSD license?
Thanks!
Kind regards,
Philip Bennefall
Something I forgot in my prior post; I found the delta creation code in
sqldiff.c so my question really concerns the combined delta code found
in RBU and sqldiff.c (both creating and applying deltas).
Kind regards,
Philip Bennefall
Thanks for the clarification, Dan. Might be too picky but perhaps a short note
should be added to the sources verifying this for people as paranoid as myself?
:D
Kind regards,
Philip Bennefall
From: sqlite-users-bounces at mailinglists.sqlite.org
Hi all,
Are there any plans in fts5 to add support for something equivalent to
fts4aux? This would be of great use to me.
Thanks!
Kind regards,
Philip Bennefall
Thanks, Dan. I'll keep my eyes on this. Thanks for the great work on FTS5!
Kind regards,
Philip Bennefall
On 10/16/2015 11:10 AM, Dan Kennedy wrote:
> On 10/15/2015 03:35 AM, Philip Bennefall wrote:
>> Hi all,
>>
>> Are there any plans in fts5 to add support for
. Recursive triggers
may be turned on by default in future versions of SQLite.
However, in sqlite.org/limits.html it says:
Beginning with version 3.7.0, recursive triggers are enabled by default
but can be manually disabled using PRAGMA recursive_triggers.
Kind regards,
Philip Bennefall
On 9/17
Sorry for the unrelated content below my last message; I responded to a
prior post to make sure I got the address right and forgot to clear it.
On 9/18/2015 12:32 AM, Philip Bennefall wrote:
> Hi all,
>
> I have found what I believe is a mistake in the SqLite documentation.
>
more threads."
Isn't this outdated? Doesn't this depend on the SqLite threading mode
nowadays?
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
and
convert that back into an in-memory database later, if that makes any sense.
Serialization of the database, basically. Is there any reasonable, non
hack-ish way of doing this?
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users
y database
On Wed, Jun 5, 2013 at 11:55 AM, Philip Bennefall <phi...@blastbay.com>
wrote:
Hello all,
This may be a somewhat strange question, but I can't find an answer to it
on
the website so I figured I would give it a shot.
Is it possible to put the full contents of an SqLite in-me
- Original Message -
From: "Petite Abeille" <petite.abei...@gmail.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Wednesday, June 05, 2013 9:15 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, a
an in-memory database
On Jun 5, 2013, at 9:10 PM, Philip Bennefall <phi...@blastbay.com> wrote:
Yes, I have seen the backup API. But I would like to avoid the disk file
entirely and just serialize to and from memory.
Lateral thinking… write your db to tmpfs…
__
- Original Message -
From: "Petite Abeille" <petite.abei...@gmail.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Wednesday, June 05, 2013 9:32 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, a
- Original Message -
From: "Petite Abeille" <petite.abei...@gmail.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Wednesday, June 05, 2013 9:39 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, a
- Original Message -
From: "Petite Abeille" <petite.abei...@gmail.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Wednesday, June 05, 2013 9:54 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, a
09:15:21PM +0200, Petite Abeille scratched on the
wall:
On Jun 5, 2013, at 9:10 PM, Philip Bennefall <phi...@blastbay.com> wrote:
> Yes, I have seen the backup API. But I would like to avoid the disk
> file entirely and just serialize to and from memory.
Lateral thinking? write yo
- Original Message -
From: "Petite Abeille" <petite.abei...@gmail.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Wednesday, June 05, 2013 10:04 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 201
y database
On 5 Jun 2013, at 8:38pm, Philip Bennefall <phi...@blastbay.com> wrote:
On 5 Jun 2013, at 8:32pm, Petite Abeille <petite.abei...@gmail.com> wrote:
write to tmpfs… read the file into byte[]… do what you meant to do… to
reload… write byte[] do tmpfs… open db… and be merry…
-memory database
Sorry I am missing a bit,
What is the problem of using sqlite3_backup again?
Hi Paolo,
I would like to avoid using a temporary file, but rather just save and load
the database as a memory block. Serialize to and from memory, in other
wo
like the best approach.
Kind regards,
Philip Bennefall
P.S. I have looked at the encryption and compression add-ons for SqLite, but
I don't need encryption/compression on the fly (just on the entire database
in one go), and I don't have the money to
y database
On 6 Jun 2013, at 9:01am, Philip Bennefall <phi...@blastbay.com> wrote:
Since I don't believe that Windows for example has tmpfs (seems to be a
Unix thing), would the idea of constructing a vfs that just reads and
writes a huge memory block be doable?
Doable ? Yes. Use the code
database
On 6 Jun 2013, at 10:45am, Philip Bennefall <phi...@blastbay.com> wrote:
I have a bunch of data structures in memory that I am looking to replace
with an SqLite database, primarily for the purpose of avoiding reinventing
the wheel with various sorts etc. I would then like to ser
more elegant if
nothing else.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
capture groups? The
source seems to indicate no, but I just wanted to make sure.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- Original Message -
From: Richard Hipp
To: phi...@blastbay.com ; General Discussion of SQLite Database
Sent: Friday, June 07, 2013 1:14 PM
Subject: Re: [sqlite] regexp.c
On Fri, Jun 7, 2013 at 5:30 AM, Philip Bennefall <phi...@blastbay.com> wrote:
Hel
dropped by about
500 KB when I switched from Dev-C++/MinGw to Code::Blocks/MSVC++. This is
mere speculation on my part in this case, however, as I don't actually know
what compiler that is being used to build the official dll.
Kind regards,
Philip Bennefall
- Original Message -
From
Hi Dan,
Thanks for that info. Do you have any views on compiling SqLite optimized
for speed rather than size? Is the difference in performance generally small
enough to be ignored? I am using Vc++ 2010 express and have been optimizing
for speed up until now.
Kind regards,
Philip Bennefall
Hi Richard,
What about "probability" or "likelyhood"? This works in both the case where
the likelyhood is great as well as when it is low. From the list you
provided, I would pick "unlikely".
Kind regards,
Philip Bennefall
- Original Message -
From: &
this knowledge to my specific problem.
Does anyone have any suggestions?
Thanks in advance for your help.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
. How well the ordering matched.
Do you have any tips?
Kind regards,
Philip Bennefall
- Original Message -
From: <pc...@sympatico.ca>
To: <sqlite-users@sqlite.org>
Sent: Thursday, June 14, 2012 7:01 PM
Subject: [sqlite] Full text search without full phrase matches
I had
SqLite
search.
So I guess my main question is, is there absolutely no way to match a subset
of the words in a query?
Kind regards,
Philip Bennefall
- Original Message -
From: "Simon Slavin" <slav...@bigfraud.org>
To: "General Discussion of SQLite Database"
,
Philip Bennefall
- Original Message -
From: "Simon Slavin" <slav...@bigfraud.org>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Thursday, June 14, 2012 8:24 PM
Subject: Re: [sqlite] Full text search without full phrase matc
Hi Michael,
That seems to be under either gpl/lgpl/apache licenses, which I cannot use in
my project for various reasons. The reason I am so interested in SqLite is
because it's public domain. I appreciate the tip though.
Kind regards,
Philip Bennefall
- Original Message -
From
that are similar.
Kind regards,
Philip Bennefall
- Original Message -
From: Black, Michael (IS)
To: phi...@blastbay.com
Sent: Thursday, June 14, 2012 9:34 PM
Subject: Re: [sqlite] Full text search without full phrase matches
Apache license is about as liberal as you can get. Damned
2000/2001. Does SqLite's implementation
differ in any significant ways from the C implementation found at the above URL?
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
Thanks, Richard. That's good to know because I am trying to decide whether to
add a new tokenizer with some custom processing, as opposed to using the built
in stemmer.
Kind regards,
Philip Bennefall
- Original Message -
From: Richard Hipp
To: phi...@blastbay.com ; General
reference to custom ones, but
what about the internal implementations?
Kind regards,
Philip Bennefall
- Original Message -
From: Richard Hipp
To: phi...@blastbay.com ; General Discussion of SQLite Database
Sent: Friday, June 15, 2012 1:03 PM
Subject: Re: [sqlite] Port
is
basically how I might take an existing fts virtual table, change its tokenizer
and then rebuild the index?
Kind regards,
Philip Bennefall
- Original Message -
From: Richard Hipp
To: phi...@blastbay.com ; General Discussion of SQLite Database
Sent: Friday, June 15, 2012 3:14
Understood. Thank you very much for your quick help. Now I have all the
information I need to get coding. And thanks once again for a great library!
Kind regards,
Philip Bennefall
- Original Message -
From: Richard Hipp
To: phi...@blastbay.com ; General Discussion of SQLite
em to need to do this at all.
Can anyone throw some light on this?
Thanks in advance.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
In that case you want to specify a NULL pointer for that argument. Then
SqLite will pick an appropriate vfs to use for whatever platform it's being
run on.
Kind regards,
Philip Bennefall
- Original Message -
From: "Arbol One" <arbol...@programmer.net>
To: &qu
Incredible. Congratulations to Richard, Dan, Joe and the rest of the
team on this incredible achievement. I'm not very active on this list,
but I've been a casual sqLite user for years and it just keeps getting
better. Keep up the great work!
Kind regards,
Philip Bennefall
On 5/29/2016 7:28
Thanks, Richard. I actually arrived at that by experimenting, but I had
no idea whether I was doing it right. Thanks for the explanation - it
confirms that I've got it set up correctly.
Kind regards,
Philip Bennefall
On 9/5/2016 12:13 PM, Richard Hipp wrote:
On 9/5/16, Philip Bennefall <
of
*user* allocations. The user is able to plug in their own malloc/free
replacements as well in which case the memory pool is redundant, but the
pool is there as a shield in the default configuration.
Kind regards,
Philip Bennefall
On 9/5/2016 7:39 PM, Richard Hipp wrote:
On 9/5/16, Philip
at the same time. Am I doing
something wrong or is this expected?
Thanks in advance for any tips!
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite
?
Thanks,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Only the requirement for attribution in binaries. That can be
significant in certain use cases.
Kind regards,
Philip Bennefall
On 5/6/2018 6:19 PM, Richard Hipp wrote:
On 5/6/18, Philip Bennefall <phi...@blastbay.com> wrote:
Hi all,
I had a quick question regarding the lic
of the SqLite codebase. Of course it
is an extension so you don't need to include it, but I'm curious
nonetheless.
Thanks in advance for any clarification.
Kind regards,
Philip Bennefall
On 5/7/2018 4:54 PM, Peter Da Silva wrote:
On 5/6/18, 11:23 AM, "sqlite-users on behalf of P
since
this license differs from the rest of the SqLite codebase. Of course it
is an extension so you don't need to include it, but I'm curious
nonetheless.
Thanks in advance for any clarification.
Kind regards,
Philip Bennefall
On 5/7/2018 4:54 PM, Peter Da Silva wrote:
On 5/6/18, 11:23 AM, "s
cleared this up so there's no more ambiguity on my end.
Kind regards,
Philip
On 5/7/2018 11:11 PM, Warren Young wrote:
On May 7, 2018, at 9:53 AM, Philip Bennefall <phi...@blastbay.com> wrote:
It was merely an idea to possibly avoid some potential ambiguity regarding
public domain, which is
/05/07 5:33 PM, Philip Bennefall wrote:
Thanks very much for that information, Richard! :)
I don't know if it would make any difference legally, but perhaps
this could be made explicit in the comments?
So it's not enough to get it free... the free giver has to now put
some extra labour for zero
contain
the delta compression code are marked as public domain. Does that mean
that the delta compression code extracted from Fossil is also public
domain? Could I borrow it from SqLite and use it without being bound by
the BSD license?
Kind regards,
Philip Bennefall
upwards through the levels until I
find a node with no parent?
Thanks in advance for any pointers.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo
On 5/12/2019 2:14 PM, Igor Tandetnik wrote:
On 5/12/2019 6:19 AM, Philip Bennefall wrote:
Hi everyone,
I have a tree of folders and I want to find the complete path from
any arbitrary point back to the top level directory. The schema is:
CREATE TABLE IF NOT EXISTS folders(
id INTEGER
There is the sqlar archive format, which you can test using the official
sqlite3 command line shell. There is also a library for it as part of
the Sqlite3 repository.
https://www.sqlite.org/sqlar.html
Kind regards,
Philip Bennefall
On 8/27/2019 3:56 PM, Peng Yu wrote:
Hi,
I haven't found
I will unfortunately not be able to participate, but I am wondering if
it will be recorded and put on YouTube or similar? I have seen some
talks of yours from TCL and other conferences and enjoyed them very much.
Kind regards,
Philip Bennefall
On 9/3/2019 3:12 AM, Richard Hipp wrote
The earliest version of the shell which ships with the archive support
is 3.22.0, according to the page I linked to. If you have an earlier
version you could simply grab the Mac OSX precompiled binaries from the
download page on sqlite.org and you'll be good to go.
Kind regards,
Philip
Hi Richard,
I can see the advantage of both, but personally I prefer the greater
speed with slightly more memory approach (e.g. what we have now).
Kind regards,
Philip Bennefall
On 12/14/2019 2:27 PM, Richard Hipp wrote:
A new feature on a branch has the following disadvantages:
(1
a while back offering to work on an audio captcha for Fossil,
but cannot locate the exact post. I did not receive much response at the
time, but am wondering if this would be of interest?
Thanks!
Kind regards,
Philip Bennefall
On 3/13/2020 4:53 PM, Richard Hipp wrote:
On 3/13/20, Philip
in the system
itself. I just tried to create an account on the SqLite forum, but could
not. The absolute majority of captcha systems offer some kind of audio
version now, which is very important for me and other blind users.
Kind regards,
Philip Bennefall
On 3/13/2020 4:22 PM, Richard Hipp wrote
code this evening and write back
if I have questions. Should I write to you directly, or to the Fossil forum?
Thanks!
Philip
On 3/13/2020 5:16 PM, Richard Hipp wrote:
On 3/13/20, Philip Bennefall wrote:
I submitted
a thread a while back offering to work on an audio captcha for Fossil,
I don't
74 matches
Mail list logo