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

2010-10-31 Thread Jeremy Hinegardner
;-) > > > > 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

2010-06-06 Thread Jeremy Hinegardner
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

2009-11-28 Thread Jeremy Hinegardner
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] A constraint bug?

2009-10-31 Thread Jeremy Hinegardner
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.

2009-10-05 Thread Jeremy Hinegardner
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] Multi column ORDER BY across table peformance problem....

2009-04-23 Thread Jeremy Hinegardner
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] Multi column ORDER BY across table peformance problem....

2009-04-21 Thread Jeremy Hinegardner
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....

2009-04-21 Thread Jeremy Hinegardner
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

[sqlite] retrieving message set with sqlite3_result_error()

2009-01-04 Thread Jeremy Hinegardner
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] SQLite 3.6.0 coming soon...

2008-07-14 Thread Jeremy Hinegardner
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

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

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

2008-06-21 Thread Jeremy Hinegardner
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?

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

Re: [sqlite] Need sql query help

2006-06-25 Thread Jeremy Hinegardner
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]

[sqlite] Congratulations to the Integrator!

2005-08-04 Thread Jeremy Hinegardner
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?

2005-07-03 Thread Jeremy Hinegardner
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]

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

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

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

2005-04-08 Thread Jeremy Hinegardner
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]

Re: [sqlite] Conversion mysql -> sqlite

2005-03-16 Thread Jeremy Hinegardner
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] Version 3.1.3

2005-02-19 Thread Jeremy Hinegardner
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] Is there any way to enable recursive triggers?

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

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

2004-01-15 Thread Jeremy Hinegardner
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]