Re: [sqlite] sqlite3_open() exclusive?

2005-01-06 Thread John Richard Moser
-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

Re: [sqlite] sqlite3_open() exclusive?

2004-12-25 Thread Andrew Piskorski
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

Re: [sqlite] sqlite3_open() exclusive?

2004-12-24 Thread Roger Binns
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

Re: [sqlite] sqlite3_open() exclusive?

2004-12-24 Thread John Richard Moser
-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? |

Re: [sqlite] sqlite3_open() exclusive?

2004-12-24 Thread D. Richard Hipp
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

Re: [sqlite] sqlite3_open() exclusive?

2004-12-24 Thread John Richard Moser
-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

Re: [sqlite] sqlite3_open() exclusive?

2004-12-24 Thread D. Richard Hipp
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