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

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

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

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
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()

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

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

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

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

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

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

2005-02-19 Thread Jeremy Hinegardner
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?

2005-01-04 Thread Jeremy Hinegardner
;. 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?

2004-05-13 Thread Jeremy Hinegardner
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...

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