-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andrew Piskorski wrote:
| On Fri, Dec 24, 2004 at 07:32:07PM -0500, John Richard Moser wrote:
|
|
|>I thought sqlite databases weren't supposed to be opened with two sqlite
|>processes at once. There are unimplemented locking commands due to this
On Fri, Dec 24, 2004 at 07:32:07PM -0500, John Richard Moser wrote:
> I thought sqlite databases weren't supposed to be opened with two sqlite
> processes at once. There are unimplemented locking commands due to this
> right?
>
> I'm bouncing back and forth in my head trying to decide if I
Somewhere I can't find again.
There are several pages on how it all works:
http://sqlite.org/faq.html#q7
http://sqlite.org/lockingv3.html
"ALTER TABLE To change a table you have to delete it (saving its
contents to a temporary table) and recreate it from scratch."
This isn't good is it? I'm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
D. Richard Hipp wrote:
| John Richard Moser wrote:
|
|>
|> I thought sqlite databases weren't supposed to be opened with two sqlite
|> processes at once. There are unimplemented locking commands due to this
|> right?
|>
|
| Where did you hear that?
|
John Richard Moser wrote:
I thought sqlite databases weren't supposed to be opened with two sqlite
processes at once. There are unimplemented locking commands due to this
right?
Where did you hear that?
Locking works great (and always has) on both unix and windows. If
you are running on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I thought sqlite databases weren't supposed to be opened with two sqlite
processes at once. There are unimplemented locking commands due to this
right?
I'm bouncing back and forth in my head trying to decide if I should use
mysql or sqlite to write a
John Richard Moser wrote:
Is sqlite3_open() safe?
By safe, I mean does it create the database file with O_EXCL if it
doesn't exist, with permissions either matching umask() or with 0600
permissions? I don't want to encounter random races here.
SQLite databases are designed to be shared by two or
7 matches
Mail list logo