[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-19 Thread da...@andl.org
Yes, yours is the kind of situation Andl is aimed at. It does most of that stuff, but it's not ready for prime time yet. It's amazingly good at doing complex queries in just a few lines of code, but it lacks the external connections for it to be used for real applications. I don't really

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-19 Thread Petite Abeille
> On Jun 18, 2015, at 11:11 PM, James K. Lowden > wrote: > > There's a reason Larry Ellison can affort a yacht almost 500 feet long. And an island to moor it. In any case, best luck to David and his project. He will need it.

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-19 Thread da...@andl.org
Thank you for your comment. I take it seriously. Andl uses very few special characters: only about 3 or 4 that would require any explanation. But I take your point: a distinctive feature is that it lacks familiar keywords that draw the eye and help guide understanding. It makes it very compact

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-19 Thread da...@andl.org
Agreed. Two points. 1. Andl can never replace SQL in one step. The challenge is to find some useful niche and demonstrate an end-to-end solution to a problem, and show that as a total solution it's better than could be done with SQL. It should have a cross-platform front end UI/UX (say

[sqlite] Question about the list

2015-06-19 Thread da...@andl.org
Some of the messages I receive have been cross-posted to two lists (eg from jkl): sqlite-users at mailinglists.sqlite.org sqlite-users at sqlite.org When I reply, the first list accepts my post and the second bounces it. That suggests there are two different lists, but it's not obvious what the

[sqlite] Question about the list

2015-06-19 Thread Simon Slavin
On 19 Jun 2015, at 3:14am, david at andl.org wrote: > Some of the messages I receive have been cross-posted to two lists (eg from > jkl): > > sqlite-users at mailinglists.sqlite.org > sqlite-users at sqlite.org > > When I reply, the first list accepts my post and the second bounces it. That >

[sqlite] Question about the list

2015-06-19 Thread R.Smith
There can be only one! (And this is it.) On 2015-06-19 04:20 AM, Simon Slavin wrote: > On 19 Jun 2015, at 3:14am, david at andl.org wrote: > >> Some of the messages I receive have been cross-posted to two lists (eg from >> jkl): >> >> sqlite-users at mailinglists.sqlite.org >> sqlite-users at

[sqlite] SQLite uclinux

2015-06-19 Thread Thomas Mager
Hi, I have to develop an application under uclinux which should use a SQLite database. Since it is running finally on an embedded system it should not use much memory. So, I wanted to build SQLite with my cross compiler and omit some options to reduce the library size and get a very small

[sqlite] SQLite (1.0.97) access via LAN

2015-06-19 Thread Jean Chevalier
Try substituting all backslashes with forward slashes, i.e., file:/PC-Name/C/FolderName/data.db If that doesn't work, maybe there is something going on with URI support in the 64bit build you're using. Takashi Fukuda wrote: > > For x64 target compilation with

[sqlite] Problems in reading a record containing a blob

2015-06-19 Thread Simon Slavin
On 17 Jun 2015, at 5:59pm, Sivananda Nyayapathi wrote: > I am able to store the image in the blob field. However, while attempting to > read, I get the following error two times (as seen in the LogCat entries): > > W/CursorWindow(26737): Window is full: requested allocation 3184896 bytes,

[sqlite] Possible error in FTS5 docs

2015-06-19 Thread Philip Bennefall
Hi all, While reading through the draft documentation for FTS5, I noticed the following in section 4.1.1: "The built-in auxiliary function bm25() returns a real value indicating how well the current row matches the full-text query. The better the match, the larger the value returned." Then,

[sqlite] SQLite (1.0.97) access via LAN

2015-06-19 Thread Donald Griggs
Hello, Takashi, Jean C. actually addressed your question, but I'm writing just to be sure you're aware that opening a sqlite database across a network is problematic and might corrupt your database -- even if it appears to work during testing. https://www.sqlite.org/howtocorrupt.html

[sqlite] SourceForge seems to have grabbed the "sqlite" project there

2015-06-19 Thread Simon Slavin
On 4 Jun 2015, at 2:20am, justin at postgresql.org wrote: > Good point. As long as they don't start bundling their adware crap > with it, it's probably not really hurting anything. The policy that had them host third-party work was reversed yesterday. The sourceforge page for SQLite now just

[sqlite] Possible error in FTS5 docs

2015-06-19 Thread 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 documentation for FTS5, I