Re: [sqlite] Do I need to migrate to MySQL?

2011-06-03 Thread Matthew L. Creech
ttp://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 Obviously a bit biased toward PostgreSQL (since it's hosted there), but it points out some fairly specific differences in features, performance, etc. (I have no personal experience either way, but was just curious m

Re: [sqlite] [sqlite-dev] SQLite 3.7.0 coming soon....

2010-06-30 Thread Matthew L. Creech
the latest snapshot and set journal_mode=WAL, no further tweaking of checkpointing or anything, and log performance improved by ~30%. Looking forward to 3.7.0! -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

Re: [sqlite] How to determine when to VACUUM?

2010-07-06 Thread Matthew L. Creech
some ratio of 'PRAGMA freelist_count;' to 'PRAGMA page_count;' to make your determination: http://sqlite.org/pragma.html Once the number of unused pages gets large enough compared to the total database size, it might be an appropriate time to VACUUM. -- Matthew L. Creech

[sqlite] WAL: no longer able to use read-only databases?

2010-07-09 Thread Matthew L. Creech
ny additional flags or ways of doing this that I'm missing? Or is it a bug? Thanks! -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL: no longer able to use read-only databases?

2010-07-15 Thread Matthew L. Creech
y straightforward, so I could probably take a stab at this if you want. What do you guys think? -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL: no longer able to use read-only databases?

2010-07-15 Thread Matthew L. Creech
e even for a read-only app, if I understand correctly. I believe that it's okay to put that in a ramdisk, issues with chroot() aside. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread Matthew L. Creech
select * from Images; > > i get no results returned to me. i just get returned > to the prompt. is there anything that i missed? thanks > again!!! > You're missing a bind for the first column (the imageID), and more importantly, a call to sq

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Matthew L. Creech
e if that works? (Or apply the diff at http://www.sqlite.org/cvstrac/chngview?cn=4857 ) Thanks! -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.5.7 compile failure, with SQLITE_OMIT_VIEW

2008-03-19 Thread Matthew L. Creech
cleaned up the header generation, since it was using the default [empty] config.h rather than the one output by the configure script. Let me know if you find any other issues. Thanks! -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.

Re: [sqlite] Proper use of sqlite-amalgamation.

2008-04-03 Thread Matthew L. Creech
rgets to do the same. It links the library itself with "-lpthread -ldl", which is why you don't have to add those lines if you're just linking a program against the shared library - gcc is instructed automatically by libsqlite3.so to link them in. -- Matthew L. Creech

Re: [sqlite] 3.5.7 Compile Fails On sqlite3.c

2008-04-04 Thread Matthew L. Creech
make > Yeah, this was reported & fixed in CVS shortly after the 3.5.7 release: http://www.sqlite.org/cvstrac/chngview?cn=4890 -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.5.7 & TCL: "undefined symbol: sqlite3StrICmp"

2008-04-04 Thread Matthew L. Creech
libsqlite3.so. We need to either rename it so that it's part of the library's exported API, or do something different in tclsqlite.c. It's the only internal function this is a problem with, by the way - you can check "nm -D libtclsqlite3.so" for all 'U' (undefined) symbols. -- Matthew L. Creec

Re: [sqlite] Proper use of sqlite-amalgamation.

2008-04-04 Thread Matthew L. Creech
he amalgamation into a library and install it with the headers (there are only 2). No idea about python integration, though. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
ipt is picking up standard headers like on Linux which aren't supported in Visual Studio. If you want to build the amalgamation on Linux without detecting Linux-supported headers, you don't need to use autoconf - try: 1. Unpack the source tarball 2. cp Makefile.linux-gcc Makefile 3

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
ssion right now: whether we even need the specifically-sized types at all. If not, the inclusion of and definition of those types may disappear in the interest of portability. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
autoconf is to detect resources (header files, etc.) that aren't portable. You can instead start with the pristine source, then: cp Makefile.linux-gcc Makefile make sqlite3.c bypassing the configure script altogether. That should do what you want -- Matthew L. Creech

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
that's only performed if building in-tree. Let me know if you see any more problems. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-13 Thread Matthew L. Creech
sure - DRH would know more about this. The makefile does have a target to re-generate sqlite3.def on the fly, but that's meant for Cygwin-based builds. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A question about the use of localtime

2008-06-19 Thread Matthew L. Creech
tart, you may want to try calling tzset() yourself before each time you modify the flags, and see if that fixes the problem. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A question about the use of localtime

2008-06-19 Thread Matthew L. Creech
On Thu, Jun 19, 2008 at 4:35 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote: > > I think this behavior is probably due to the way localtime() works in > glibc. From what I've seen (at least on my embedded ARM-Linux board), > localtime() only invokes tzset() the f

Re: [sqlite] sqlite on flash devices

2008-10-02 Thread Matthew L. Creech
ind the scenes, so throw in a multiplier to account for that, and you'll at least get an order-of-magnitude accurate idea of how long it'll last worst-case. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

2009-02-22 Thread Matthew L. Creech
use "default_cache_size" if you want it to. http://sqlite.org/pragma.html -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] UNION with results distinct on a particular column?

2009-03-24 Thread Matthew L. Creech
an the inner SELECTs do on their own (i.e. without the GROUP BY which eliminates rows with duplicate 'col1' values). Any ideas on how I could do this more efficiently? Thanks! -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-27 Thread Matthew L. Creech
ta() can just do sqlite3_bind_XXX() followed by sqlite3_step() (and sqlite3_reset()), which will be _much_ faster than sqlite3_exec(). -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-28 Thread Matthew L. Creech
ple is doing it, _every_ time through the loop it does an exec(), which re-compiles the same SQL code (which is not a fast operation). There are plenty of other examples floating around on this mailing list, I'm sure - just do some digging. -- Matthew L. Creech

Re: [sqlite] Cross-Compile and Installation of Sqlite

2009-06-25 Thread Matthew L. Creech
s --host=arm-unknown-linux-gnueabi make install If all you want is to run the sqlite3 executable, though, you can just take the cross-compiled binary + shared-lib and throw them onto the target. Note that you'll need to set LD_LIBRARY_PATH when running "sqlite3" to prevent it from com

[sqlite] Index usage

2009-09-18 Thread Matthew L. Creech
o grab the first [b] rows (ordered by time) which also match [a]? Or am I just going to have to guess at which way will be faster, and use "INDEXED BY" to force it? (The documentation says I shouldn't have to do this) Thanks for the help! -- Matthew L. Creech _

Re: [sqlite] Index usage

2009-09-21 Thread Matthew L. Creech
ster for when I do the real query. Seems like a pain for this relatively simple scenario, but I can see how it'd be deceptively easy-looking to optimize. Thanks for the response -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http:

[sqlite] VACUUM & journal size

2010-03-14 Thread Matthew L. Creech
ns, so I'd need a programmatic solution - "move the DB somewhere else, VACUUM, then move it back" won't work, unfortunately. :-) Any tips are appreciated. Thanks! -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http:/

Re: [sqlite] VACUUM & journal size

2010-03-15 Thread Matthew L. Creech
no different than the directory that the database & journal are stored in. There's also not nearly enough free memory to hold the small database, so I can't use temp_store = MEMORY, unfortunately. I'll give this a try tomorrow on a real device with journaling off, and see how

Re: [sqlite] VACUUM & journal size

2010-03-15 Thread Matthew L. Creech
On Mon, Mar 15, 2010 at 2:11 AM, Matthew L. Creech <mlcre...@gmail.com> wrote: > > I'll give this a try tomorrow on a real device with journaling off, > and see how much space it uses in /tmp with journaling turned off. > I ran some tests on a real device with a real

Re: [sqlite] SQlite C API screwing port access?

2010-03-23 Thread Matthew L. Creech
or example, sqlite3_close() doesn't take a string - you did say it's pseudocode, I'm just wondering if there's a problem with the arguments along those lines. -- Matthew L. Creech ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposed: drop support for LinuxThreads

2010-05-12 Thread Matthew L. Creech
pported system, so I'd take that as a sign that LinuxThreads is on its last legs. Obviously there will always be some exceptions, but I'd imagine that few of them are concerned with keeping those systems up to date with the very latest SQLite. -- Matthew L. Creech _