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

e, 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]

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 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 -- ==

[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

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

now and I'll try and rephrase. enjoy, -jeremy -- ==== Jeremy Hinegardner [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.

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] retrieving message set with sqlite3_result_error()

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

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

p://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 from the SQLite mailing list archive at

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....

the first 8 showings on or after that time *before* > sorting by channel number. > > > > Jeremy Hinegardner wrote: > > > > How about trying: > > > > SELECT s.startTime > > FROM ( SELECT showing.startTime AS startTime

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

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

Re: [sqlite] Update variable problems. Bug?

d 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]

[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] build db in memory then dump to a persistent file.

ou 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] 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] SQLite database for google maps

that is a completely 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] Close() and file locks...

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]

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

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

Re: [sqlite] Version 3.1.3

eger 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] Conversion mysql -> sqlite

l 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] beat 120,000 inserts/sec

unning 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]