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,
hread.join()
# make sure 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"
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
safe 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 a
ement 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 wrote:
>
> On 15 Jul 2010, at
closing the database and then reopening 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
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 unsubscribe
Store the sum instead of the amount, then if you need the amount just use this
amount(0) = sum(0)
amount(t_i) = sum(t_i) - sum(t_(i-1))
This way, if you need to select all amount it only takes O(n).
Insert/delete/update takes longer but you select more often than youi
insert/delete/update.
On 7/
refer small, localized numbers.
--
jt
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
> be
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 h
That did the trick. Thank you very much!
Kind Regards
Josef
-Original Message-
From: Arjen Markus [mailto:[EMAIL PROTECTED]
Sent: 05 May 2006 08:56 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLITE3.exe from Windows CMD
Josef Hlawatschek (JT) wrote:
>Hi,
>
>I wa
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 ".
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
t.
Is there another way to do it?
Why is " SELECT quote('foo')!='foo' "?
config: sqlite 3.3.4
--
jt
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
16 matches
Mail list logo
