t the Fossil captcha 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
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
n 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
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
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,
P
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
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
* traverse 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/mailma
ready 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 wrote:
It was merely an idea to possibly avoid some potential ambiguity regarding
public domain, which is a bit of a gray ar
/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 labou
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, &qu
s 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, "sq
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 wrote:
Hi all,
I had a quick question regarding the licensing of the delta compression
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
?
Thanks,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
er 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, P
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 Benn
t 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/s
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
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
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
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
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 s
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
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.
>
. 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
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
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
ror codes I may 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://stacko
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 PG
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
care 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 w
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 wrote:
Is it
he conversion between the floating point julianday
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
ter reading the code more 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 <mailto:phi...@blastbay.com>> wrote:
I have to amend my last message. The timings I just gave was for
looking up
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 foun
rtual 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 r
.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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:
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
size 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 -
- 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 wrote:
Hello all,
I was having a quick
pport 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
ory location to another seems a lot 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
- Original Message -
From: "Simon Slavin"
To: ; "General Discussion of SQLite Database"
Sent: Thursday, June 06, 2013 1:45 PM
Subject: Re: [sqlite] Serialize an in-memory database
On 6 Jun 2013, at 10:45am, Philip Bennefall wrote:
I have a bunch of data
- Original Message -
From: "Simon Slavin"
To: ; "General Discussion of SQLite Database"
Sent: Thursday, June 06, 2013 10:51 AM
Subject: Re: [sqlite] Serialize an in-memory database
On 6 Jun 2013, at 9:01am, Philip Bennefall wrote:
Since I don't believe
out into a new file and then finally deleting the
temporary file. That seems wasteful to me, and so that's why I am looking
into solutions that avoid the temporary files. So far, the memory vfs seems
like the best approach.
Kind regards,
Philip Bennefall
P.S. I have looked at the encryptio
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
words.
Kind regards,
Philip Bennefall
___
sqlite-users mailing list
sqlite-u
- Original Message -
From: "Simon Slavin"
To: ; "General Discussion of SQLite Database"
Sent: Thursday, June 06, 2013 12:15 AM
Subject: Re: [sqlite] Serialize an in-memory database
On 5 Jun 2013, at 8:38pm, Philip Bennefall wrote:
On 5 Jun 2013, at 8:
- Original Message -
From: "Petite Abeille"
To: "General Discussion of SQLite Database"
Sent: Wednesday, June 05, 2013 10:04 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, at 10:02 PM, Philip Bennefall wrote:
That is exactly th
ll:
On Jun 5, 2013, at 9:10 PM, Philip Bennefall 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?
A few months back, wasn't there talk about a VFS that used a
- Original Message -
From: "Petite Abeille"
To: "General Discussion of SQLite Database"
Sent: Wednesday, June 05, 2013 9:54 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, at 9:44 PM, Philip Bennefall wrote:
I use Windows. This loo
- Original Message -
From: "Petite Abeille"
To: "General Discussion of SQLite Database"
Sent: Wednesday, June 05, 2013 9:39 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, at 9:38 PM, Philip Bennefall wrote:
I don't want it in a
- Original Message -
From: "Petite Abeille"
To: "General Discussion of SQLite Database"
Sent: Wednesday, June 05, 2013 9:32 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, at 9:25 PM, Philip Bennefall wrote:
Doesn't that st
m: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Petite Abeille [petite.abei...@gmail.com]
Sent: Wednesday, June 05, 2013 3:15 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, at 9:10 PM, Philip Bennefall wrot
- Original Message -
From: "Petite Abeille"
To: "General Discussion of SQLite Database"
Sent: Wednesday, June 05, 2013 9:15 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Jun 5, 2013, at 9:10 PM, Philip Bennefall wrote:
Yes, I have seen the bac
- Original Message -
From: "Andreas Kupries"
To: ; "General Discussion of SQLite Database"
Sent: Wednesday, June 05, 2013 9:07 PM
Subject: Re: [sqlite] Serialize an in-memory database
On Wed, Jun 5, 2013 at 11:55 AM, Philip Bennefall
wrote:
Hello all,
Th
g 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-
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
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"
To: "General Discussion of SQ
my case. But I don't seem 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
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
wondering 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,
ference 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] Porter Stemmer
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 ; Ge
than 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/mailma
s 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 ge
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 -
gards,
Philip Bennefall
- Original Message -
From: "Simon Slavin"
To: "General Discussion of SQLite Database"
Sent: Thursday, June 14, 2012 8:24 PM
Subject: Re: [sqlite] Full text search without full phrase matches
On 14 Jun 2012, at 7:13pm, Philip Bennefall wrote:
T
the result of the broader 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"
To: "General Discussion of SQLite Database"
no match is made.
2. How well the ordering matched.
Do you have any tips?
Kind regards,
Philip Bennefall
- Original Message -
From:
To:
Sent: Thursday, June 14, 2012 7:01 PM
Subject: [sqlite] Full text search without full phrase matches
I had to implement something like this fo
apply 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
74 matches
Mail list logo
