Re: [sqlite] Index in seperate db file, low impact change?

Russell Leighton wrote: > > Big distruptive code change? Also more opportunites for things to go wrong with mismatched index/db files Also no longer can copy/move db as a single file -- Lindsay

Re: [sqlite] Database is locked on SELECT only calls?

ur app on 1000's of PC's, if it failed the PC's would crash - badly. Believe me I would know ... -- Lindsay

Re: [sqlite] Speed Test Done !

Richard wrote: Still have found no sql program yet, that can beat Panorama in speed. Since Panorama is RAM based, how about if you did your speed test with a SQLite in memory database ? -- Lindsay

Re: [sqlite] Convert SQLite to Java

it in anger yet though. -- Lindsay

Re: [sqlite] Convert SQLite to Java

that we'd be allowed to upload DLL's or compile C on the platform. -- Lindsay

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

? is the 2 oppressed by being under the 5 ? how is this the fault of the patriarchy ? discuss -- Lindsay

Re: [sqlite] Lite Network wrapper

it :( Interested in the protocol, it looks simple eniugh to integrate into a webapp. -- Lindsay

Re: [sqlite] Lite Network wrapper

use a very similar custom protocol  over http to feed db data to a web app of mine. -- Lindsay

Re: [sqlite] uSQLiteServer Source code available

SCII line based protocol. _javascript_ has excellent functions for parsing ASCII data, but support for XML Parsing is erractic, in IE its done via a ActiveX object. -- Lindsay

Re: [sqlite] uSQLite, doing HTTP

[EMAIL PROTECTED] wrote: Agree in principle with what you're saying here as well, one suggestion - perhaps you could mod your server to accept/general queries/output via standard in/out. That way its could be piped over a multitude of channels. Cheers - Lindsay

Re: [sqlite] Re: LIMIT and paging records

almost as long as retrieving > all the records. I have noticed exactly that behaviour recently in MySQL and MSSQL (where it had to be emulated). This was when implementing a web paging access as the original poster is doing. -- Lindsay

[sqlite] Appropriate Uses For SQLite

can be fragmented and distributed over many VMs and still be accessible with a common interface and query language. Many thanks. Best Regards Lindsay On Wed, Feb 18, 2015 at 11:11 AM, Darko Volaric wrote: > I second this notion. I think SQLite is uniquely suited to server based > applic

[sqlite] sqlite3 shell .import bug (edge case)

rfc4180 compliant, CSV. It all imported cleanly. sqlite3 is a wonderful bit of software. I have been using it for some time now to munge and query multi-gigabyte size data sets and am very impressed with its performance and capabilities. Best Regards, Lindsay ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Request for help with SQLite Query to return missing Date/Time Ranges

be greatly appreciated. Regards Andrew Lindsay ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Execute import from php

I'd like to import a file into a table from php. Is there anyway to execute the .import from php. I am using the pdo interface. Patty ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLl question

Try select n.name, p.type, p.addr from p join name on p.id = n.id union select n.name, e.type, e.addr from e join name on e.id = n.id Patty On Fri, May 15, 2009 at 12:14 AM, Evan Burkitt wrote: > This isn't a Sqlite question per se, but I know there are some SQL gurus

Re: [sqlite] Read Notifications

Bert Verhees wrote: Hi, Since we are using the new List-headers on sqlite-list, I am experiencing two disadvantages. I recieve many emails twice, please do not send your emails twice, but manually remove one from the To or CC when your emailer does not support List-reply. But at least we can

Re: [sqlite] Sqlite & COM/EXE server

Eugene Lin wrote: Bert, It is a COM-related problem, not a SQLITE problem I can now tell you that it IS a sqlite problem NOT a COM problem. Sqlite is trying to create its temporary database at some location (which I'm not sure where) and it failed. I have found that you can force sqlite

[sqlite] ANN : wxSQLite has moved

wxSQLite has moved to http://sourceforge.net/projects/wxsqlite and is currently in an active phase of development. No file releases yet (soon ! when I get the bind/reset api finalised) CVS is usable though: linux (via configure & make install) and a Win32 VC project are supported.

Re: [sqlite] Newbie questions

Kurt Welgehausen wrote: 2) use a cursor to browse a result set ? ... No. The sqlite_compile/step/finalize paradigm allows (requires really ) forward browsing through a result set.

Re: [sqlite] Simple web query tool

iently into a spreadsheet, or another db, for further munging you could set csv mode and/or force a download. As a note, unless you are sorting a very large dataset the resource usage of all of this is quite low as sqlite just pipes the dataset out over the http response as it is generated. /Linds

Re: [sqlite] Simple web query tool

go it was 6Mb or so. SQLite has added some incredible functionality in recent years and the shell cli still comes in under 1Mb for a nicely feature-full build. Apples and oranges. Still... /Lindsay On Fri, Feb 3, 2017 at 2:13 PM, Michael Falconer < michael.j.falco...@gmail.com> wrot

Re: [sqlite] json_each() in a table trigger for an 'attached' db causes an error

-osx) 01:12:06 [e0d30c1862] *MERGE* Merge fuzz test cases computed by dbfuzz2. (user: drh) 01:04:18 [d57873337a] Improved corrupt database detection in the relocatePage() routine of the b-tree module. (user: drh) /Lindsay On Fri, Nov 2, 2018 at 4:49 PM Lindsay Lawrence wrote: > Hi, > >

Re: [sqlite] json_each() in a table trigger for an 'attached' db causes an error

o test your fix or if the fix itself is the issue. Regards, /Lindsay On Fri, Nov 2, 2018 at 10:38 AM Richard Hipp wrote: > Please try your test script on the latest trunk check-in and let us > know whether or not it is working for you. > > -- > D. Richard Hipp > d...@sqlite.o

Re: [sqlite] json_each() in a table trigger for an 'attached' db causes an error

. A big thank you to Dr Hipp for the prompt fix. /Lindsay Code output from shell built from latest trunk snapshot tarball: SQLite version 3.26.0 2018-11-02 17:38:39 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a

Re: [sqlite] json_each() in a table trigger for an 'attached' db causes an error

;.open FILENAME" to reopen on a persistent database. sqlite> .load './json1.so' sqlite> attach "test.db" as test; sqlite> INSERT INTO test.people (name, age) VALUES ('Alice', 30), ('Bob', 42); Error: no such table: test.json_each /Lindsay On Fri, Nov 2, 2018 at 10:0

[sqlite] json_each() in a table trigger for an 'attached' db does not work

-DHAVE_READLINE shell.c sqlite3.c -ldl -lreadline -lncurses -Os -o sqlite3 /Lindsay ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] json_each() in a table trigger for an 'attached' db causes an error

qlite3.c -ldl -lreadline -lncurses -Os -o sqlite3 /Lindsay ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users