;-)
>
>
>
> Thanks
>
>
>
> Lynton
>
>
>
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
==
> 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
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
--
=
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
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
--
=
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
> >
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
>
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
the same time as
the error code?
Is this a bug?
enjoy,
-jeremy
--
========
Jeremy Hinegardner jer...@hinegardner.org
___
sqlite-users mailing list
sqlite-u
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
--
==
t make any sense, let me know and I'll try and rephrase.
enjoy,
-jeremy
--
========
Jeremy Hinegardner [EMAIL PROTECTED]
___
sqlite-users mailing list
sql
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
es are empty.
enjoy,
-jeremy
--
========
Jeremy Hinegardner [EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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]
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
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]
of your workflow I would be
quite interested.
enjoy,
-jeremy
--
========
Jeremy Hinegardner [EMAIL PROTECTED]
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]
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/
--
========
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]
;. Maybe it will
provide some insight.
http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM
enjoy,
-jeremy
--
========
Jeremy Hinegardner [EMAIL PROTECTED]
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
--
==
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]
23 matches
Mail list logo