Re: [sqlite] SQLITE_ENABLE_ATOMIC_WRITE on windows, good or bad?

On this note, how does one figure out if your system does support atomic writes (or other FS things, like safe appends)? Is there an easy way to have SQLite tell you what it finds out? Alternatively (for my current use case), does Ext3 on 2.6 Linux support atomic writes or safe appends? On Mon,

[sqlite] fcntl file locks from different threads? (what constitutes a "troublesome system"?)

other process locks when we unlock and not when we exit time.sleep(3) #!/usr/bin/python import fcntl, time time.sleep(1) f = file("/tmp/test-fcntl", 'w') print "locking 2" fcntl.lockf(f.fileno(), fcntl.LOCK_EX) print "locked 2" Thanks -JT __

Re: [sqlite] sqlite database handle caching and write permissions

en nailed. Any ideas on the shared cache issue? I went and reread the documentation, and it's still unclear to me as to whether or not the shared cache feature works across two database handles open to the same database in non-concurrent sequence. -JT _

Re: [sqlite] sqlite database handle caching and write permissions

to cast a sqlite_stmt struct to the Vdbe struct, and just check the readOnly flag? In other words, how static is that struct? My Lua interface could require that all SQL gets prepared, and then I could reject prepared statements that aren't readOnly myself. -JT On Thu, Jul 15, 2010 at 12:41 PM

Re: [sqlite] sqlite database handle caching and write permissions

will definitively, actually hit disk, whereas filtering by SELECT seemed unclear to me as to whether it would quite cover or catch everything. If that is truly the best way, then that's fine I guess. -JT On Thu, Jul 15, 2010 at 12:25 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On

[sqlite] sqlite database handle caching and write permissions

in read-only mode. Thanks in advance, -JT ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mathematical "power" operator?

Hi, Look at the new "loadable extension" feature: http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions It also describe an example that could be really easy to convert to your sqrt problem. -- Julien - To

[sqlite] how to create an autoincremented rowid in a view

small, localized numbers. -- jt

Re: [sqlite] Inserting python data structues into database

From pysqlite http://initd.org/tracker/pysqlite. On 6/2/06, John Stanton <[EMAIL PROTECTED]> wrote: Python newsgroup wrote: > Hi, > > What is the most efficient way to enter python binary data such as lists or > dictionaries in to sqlite? Has anyone had any experiences with this? We > will >

Re: [sqlite] Inserting python data structues into database

Try the pickle module, it dumps nearly any datastruct (except file object) in a string. You can load it back afterwards. On 6/1/06, Python newsgroup <[EMAIL PROTECTED]> wrote: Hi, What is the most efficient way to enter python binary data such as lists or dictionaries in to sqlite? Has anyone

[sqlite] SQLITE3.exe from Windows CMD

Hi, I want to use SQLITE3.EXE to run automated reports in Windows. I use an init file to load parameters and a SQL script file. All goes well until the SQL script has been executed, then the SQLITE3.EXE command prompt appears. The command prompt only closes once you manually type in ".exit" or

Re: [sqlite] quote() and constraints

On 3/29/06, Pam Greene <[EMAIL PROTECTED]> wrote: > On 3/29/06, jt <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I'm implementing a log procedure with triggers on my tables (following > > some ideas found in http://www.sqlite.org/cvstrac/wiki?p=Undo

[sqlite] quote() and constraints

it? Why is " SELECT quote('foo')!='foo' "? config: sqlite 3.3.4 -- jt

[sqlite] forcing primary key range

problem, I can ensure that a range will not be overflowed. So I need to be able to set the pkey range, back and forth depending on the "occasion". I tried to fool the sqlite_sequence table but it didn't work. Is there a way to do this natively? -- jt