Re: [sqlite] NFS--how to test?

On Nov 8, 2008, at 11:06 AM, Joshua Paine wrote: > Joshua Paine wrote: >> Some web hosts, like DreamHost and Mosso, provide only NFS-based >> storage. I would very much like to know if it's possible to run >> SQLite >> safely on these (Mosso, actually), so I need some way of testing >> if

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

> From: "Igor Tandetnik" <[EMAIL PROTECTED]> > > "Rob Sciuk" <[EMAIL PROTECTED]> wrote in > > > > The other bit of trickery involved is that in order for the value > > types to be correct (meaningful), you have to take a "step" as it > > were ... with sqlite3_step 8-). > > You can use

Re: [sqlite] Saving a memory-based SQLite database to disk

Tito Ciuro wrote: > If I open a SQLite database in memory (using :memory:), would it be > possible to save it on disk? Open a disk db and use the ATTACH sql command to add a memory DB. Do your ops in the memory DB, then insert select the results into your disk db. -- Joshua Paine LetterBlock:

Re: [sqlite] .dump often fails silently

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kees Nuyt wrote: > Did you try > .bail on > It won't change the destination of error messages, but at > least it aborts the sql script at the first error it > encounters. That is not true of errors returned by sqlite3_exec when doing .dump.

[sqlite] Saving a memory-based SQLite database to disk

Hello, If I open a SQLite database in memory (using :memory:), would it be possible to save it on disk? Here's the reason: Using a file-based SQLite database: 2008-11-08 15:15:44.180 XML2Plist[5554:10b] Number of XML documents converted successfully: 2861 2008-11-08 15:15:53.053

Re: [sqlite] Open SQLite database without storing database on disk?

Igor, > You could, I suppose, implement a VFS on top of a block of memory. See > http://sqlite.org/c3ref/vfs_find.html Great suggestion. An idea for a future release of SQLite might be a memory based VFS that would allow "small" SQLite databases to be manipulated entirely in memory. SQLite

Re: [sqlite] sqlite3 for server (experience)

> Since the server is one process there is no need for Sqlite to use its > sync capability derived for multiple processes and you can KISS by > wrapping Sqlite in your own synhronization. yes, or by using an exclusive transaction as a lock, as I've just learned. ;) > > The nice feature of a

Re: [sqlite] sqlite3 for server (experience)

Ken, thanks for your hint -- I removed the pragma statement, the share cache switch and even the busytimeout value and then tried the exclusive transaction encapsulation of my select and update loop. This seems to do the job -- No deadlocks anymore. I found one little issue in my implementation

Re: [sqlite] Open SQLite database without storing database on disk?

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is it possible to open a SQLite database without physically storing > the SQLite database file on disk? > > Background: Customer has application that generates SQLite databases > with proprietary pricing information. They would like

Re: [sqlite] .dump often fails silently

On Sat, 8 Nov 2008 11:44:23 +1100, raf <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : >but that's my point. >i'm not getting any errors. >it's just failing silently. Did you try .bail on ? It won't change the destination of error messages,

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

"Rob Sciuk" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > The other bit of trickery involved is that in order for the value > types to be correct (meaningful), you have to take a "step" as it > were ... with sqlite3_step 8-). You can use sqlite3_column_decltype[16] without calling

Re: [sqlite] Distinguishing between sqlite3_stmts

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Stanton wrote: > Perhaps this featrure could be reserved for "Sqlheavy", a replacement > for Oracle. Or a #if OMIT_STATEMENT_CACHE like all sorts of other functionality that can be omitted. > We have actually implemented the cacheing of

Re: [sqlite] NFS--how to test?

Joshua Paine wrote: > Some web hosts, like DreamHost and Mosso, provide only NFS-based > storage. I would very much like to know if it's possible to run SQLite > safely on these (Mosso, actually), so I need some way of testing if the > NFS implementation is adequate. A quickie port of my app to

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

On Sat, 8 Nov 2008, Simon Davies wrote: > > Hi Rob, > > I haven't tried this, but sqlite3_column_type(sqlite3_stmt*, int iCol) > should do what you want: > http://www.sqlite.org/c3ref/column_blob.html > > Rgds, > Simon Thanks, Simon. I found this out about two minutes after I'd posted the

[sqlite] Open SQLite database without storing database on disk?

Is it possible to open a SQLite database without physically storing the SQLite database file on disk? Background: Customer has application that generates SQLite databases with proprietary pricing information. They would like their users to download these databases from their SSL secured website

Re: [sqlite] Distinguishing between sqlite3_stmts

Dan wrote: > On Nov 8, 2008, at 3:25 AM, Roger Binns wrote: > > >>-BEGIN PGP SIGNED MESSAGE- >>Hash: SHA1 >> >>Douglas E. Fajardo wrote: >> >>> ( To the 'powers that be'... I wonder if some form of 'cache' for >>>prepared statements might be built in to the 'sqlite3_prepare*'

[sqlite] sqlite crash with "WHERE x in ()" query

Hi all, I've hit what I believe may be a crash bug in SQLite. I'm using the version bundled with Python 2.5.2 on Windows, which is SQLite 3.3.4, it would appear. I know, this isn't the latest version, but this happens to be the version bundled with the version of Python my product relies on.

[sqlite] sqlite3_auto_extension

Hi, What is sqlite3_auto_extension used for? What kind of extensions can it hold; and what are extensions? Thanks, Maurício ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

2008/11/7 Rob Sciuk <[EMAIL PROTECTED]>: > > I don't see in the documentation a function to return whether or not the > database value returned by the sqlite3_step() function is NULL. Surely > there should be such a beast, no? > > Something like: >int sqlite3_column_isNull( stmt, i ) ; >