Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

;-) > > > > Thanks > > > > Lynton > > > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- ==

Re: [sqlite] SQLite Database in Shared Memory

> sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Jeremy Hinegardner jer...@hinegardner.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite database for google maps

y different > question. > You may want to look at http://www.openstreetmap.org/ for free geographic data for Earth. Also see their wiki http://wiki.openstreetmap.org/wiki/Main_Page enjoy, -jeremy -- =

Re: [sqlite] A constraint bug?

SERT 0 1 Time: 0.539 ms [jer...@[local]] 13:03:56> select * from mytable; id1 | id2 | sometext -+-+-- 1 | 1 | NULL 1 | 1 | NULL (2 rows) Time: 14.775 ms enjoy, -jeremy -- Jeremy Hinegardner jer...@hinegardner.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] build db in memory then dump to a persistent file.

ggestions for making my loading go faster. Have you tried working with the backup API? If all the data will fit into memory, do all the work in a memory database and then use the backup api to dump it to disk. http://sqlite.org/backup.html enjoy, -jeremy -- =

Re: [sqlite] Multi column ORDER BY across table peformance problem....

rent channels. The above > query would limit to the first 8 showings on or after that time *before* > sorting by channel number. > > > > Jeremy Hinegardner wrote: > > > > How about trying: > > > > SELECT s.startTime > >

Re: [sqlite] Multi column ORDER BY across table peformance problem....

joy, -jeremy On Tue, Apr 21, 2009 at 11:07:15PM -0600, Jeremy Hinegardner wrote: > How about trying: > > SELECT s.startTime > FROM ( SELECT showing.startTime AS startTime > ,showing.stationId AS stationId > FROM showing >

Re: [sqlite] Multi column ORDER BY across table peformance problem....

t; sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > View this message in context: > http://www.nabble.com/Multi-column-ORDER-BY-across-table-peformance-problem-tp23109024p23169251.html > Sent

[sqlite] retrieving message set with sqlite3_result_error()

the same time as the error code? Is this a bug? enjoy, -jeremy -- ======== Jeremy Hinegardner jer...@hinegardner.org ___ sqlite-users mailing list sqlite-u

Re: [sqlite] SQLite 3.6.0 coming soon...

org/draft/doc/c3ref/c_config_getmalloc.html SQLITE_CONFIG_GETMALLOC is listed twice. I'm assuming the 2nd one, at the bottom of the page, should be SQLITE_CONFIG_GETMUTEX. Ticket with patch submitted #3219 enjoy, -jeremy -- ==

[sqlite] accessing the rowid of a blob for incremental IO

t make any sense, let me know and I'll try and rephrase. enjoy, -jeremy -- ======== Jeremy Hinegardner [EMAIL PROTECTED] ___ sqlite-users mailing list sql

[sqlite] [ANN] Initial release of amalgalite, a ruby wrapper for sqlite3

me know what you think. * http://copiousfreetime.rubyforge.org/amalgalite/ * http://copiousfreetime.org/articles/2008/06/21/amalgalite-0-1-0-released.html enjoy, -jeremy -- Jeremy Hinegardner

Re: [sqlite] Skype client using SQLite?

es are empty. enjoy, -jeremy -- ======== Jeremy Hinegardner [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Need sql query help

te to try and do an inverted index by letter here, but it didn't get close to the performance of what the bitset was doing. Ahh, what a fun way to spend part a Sunday :-) enjoy, -jeremy -- Jeremy Hinegardner [EMAIL PROTECTED]

[sqlite] Congratulations to the Integrator!

I would just like to offer my congratulations to D. Richard Hipp for receiving the Open Source Integrator Award for SQLite. http://osdir.com/Article6677.phtml Your work is appreciated. enjoy, -jeremy -- Jeremy

Re: [sqlite] Update variable problems. Bug?

be better to use 'IP' instead of "IP" as "" appears to first evaluate to a column name and if that is not the case then it is a literal. That is, as far as expressions are concerned: without single or double quotes -> column name with double quotes -> column name first, if that fails literal with single quotes -> literal This is what I gleaned from the documentation and experimenting. Did I get this correct? enjoy, -jeremy -- Jeremy Hinegardner [EMAIL PROTECTED]

Re: [sqlite] using sqlite as a temporary database to process lots of data

of your workflow I would be quite interested. enjoy, -jeremy -- ======== Jeremy Hinegardner [EMAIL PROTECTED]

Re: [sqlite] beat 120,000 inserts/sec

I'm running OpenBSD 3.6 with a customer kernel compiled to support OpenBSD's software raid (RAIDFrame). I have the 2 drives arranged in a RAID 1 configuration. enjoy, -jeremy -- ======== Jeremy Hinegardner [EMAIL PROTECTED]

Re: [sqlite] Conversion mysql -> sqlite

sed it many times for mysql to sqlite sql conversion. Right now it really only works with the definition portion of the SQL (CREATE statements) and not with the data manipulation statements. enjoy, -jeremy [1] http://sqlfairy.sourceforge.net/ -- ========

Re: [sqlite] Version 3.1.3

nt printf-8.2... Error: integer value too large to represent 2 errors out of 19732 tests Failures on these tests: printf-8.1 printf-8.2 enjoy, -jeremy -- ======== Jeremy Hinegardner [EMAIL PROTECTED]

Re: [sqlite] Is there any way to enable recursive triggers?

;. Maybe it will provide some insight. http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM enjoy, -jeremy -- ======== Jeremy Hinegardner [EMAIL PROTECTED]

Re: [sqlite] Re: SQLite version 3 design question: '500'=500?

1N The data types of the operands for the operation "=" are not compatible. SQLSTATE=42818 => SELECT * FROM test2 WHERE b>'503'; SQL0401N The data types of the operands for the operation ">" are not compatible. SQLSTATE=42818 -- ==

Re: [sqlite] Close() and file locks...

ons of using semaphores, but I figured it wouldn't hurt to share my thoughts up to this point. Maybe it will help. enjoy, -jeremy -- Jeremy Hinegardner [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]