Re: [sqlite] Sqlite catalog - datebase with pictures

2008-03-30 Thread lukasz p.
Martin Engelschalk wrote: > > Hello Lukasz, > > to insert a picture (or any binary data for that matter), you can read > the data from the file and use sqlite3_bind_blob to insert (or update) it. > When selecting it from the database, use sqlite_column_blob to retrieve > the data and sqlite3_

[sqlite] [PHP5] Direct access to SQLite faster than through PDO+APC?

2008-03-30 Thread Gilles Ganault
Hello I wanted to check performance in PHP through caching tools like APC or MemCacheD compared to direct access trough PDO_SQLite, and it seems like APC is actually five times slower than accessing an SQLite database directly: === # ab -kc 10 -t 30 http://localhost/test_apc.php Perc

Re: [sqlite] [PHP] Compiling with latest SQLite?

2008-03-30 Thread Gilles Ganault
On Thu, 27 Mar 2008 09:55:18 -, "Brandon, Nicholas (UK)" <[EMAIL PROTECTED]> wrote: >That's fine for windows, unfortunately the same facility is not >available in the unix world. ... and I'd like to run this on FreeBSD :-) >I compiled a PDO module using 3.5.4 (I think) using the source code f

[sqlite] re gexp dll win32

2008-03-30 Thread stormtrooper
Has anyone created a dll for the Windows version of Sqlite to access the Perl regular expression engine inside Sqlite? I noticed there is a pcre.so file for linux users. Or is easier to use regular expressions from a scripting language? -- View this message in context: http://www.nabble.com/reg

[sqlite] DBD::SQLite::Amalgamation?

2008-03-30 Thread Jim Dodgen
Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing "make test" It hangs forever and never completes I have tried this on multiple boxes running both Fedora and Redhat ES, all 64 bit. ___ sqlite-users ma

Re: [sqlite] Sqlite catalog - datebase with pictures

2008-03-30 Thread Mike Owens
One suggestion I would make is to keep your blobs in a separate table, or at least in a table in which you don't anticipate searching on anything but the primary key. The reason is due to how SQLite manages blobs. If a blob grows larger than a page's payload (approx page size), it will spill over o

[sqlite] Open issues on latest build and last stable build

2008-03-30 Thread Shailesh Birari
Can Some one give me pointers to the blog where all the open and reported issues on different releases is listed. So that If I have to use sqlite in my product I can choose the most suitable build after referring to this list.? Thanks, Shailesh. ___ s