Steven Van Ingelgem wrote:
Sqlite minor versions should have compatible database formats, so if you're having crashes, there's probably a problem somewhere else.Hi,
1/ I am currently using 2.8.13 and I wanted to upgrade it to 2.8.15... Now when I do that, my program crashes when I try to open (sqlite_open) the database on the following function:
rc = sqliteBtreeFactory(db, zFilename, 0, MAX_PAGES, &db->aDb[0].pBt);
Is that "normal" behaviour (for instance: no binary compatibilities between 2.8.x versions?). Of course that would be better then to immediatly upgrade to 3.0 if i have to convert all the databases ofcourse. But then the same question stays... Is there compatibility between those versions? (again I mean: just update the source & I can still work on the same databases without doing something special).
2/ I use wxSQLite to access databases. When 1 person has my program open (just open, that means not doing anything). Then another person opens a program from a different location, and access the same databases. He can read it without a problem, but he can't do any insert/update/delete ? (so I think he can acquire readlock, but no writelock). [using 2.8.13]. Is this a feature or a bug? (as far as I understood, sqlite locks the database file when it is needed, but not all the time?).
Could someone answer those questions, I would be very gratefull.
BTW, if I am unclear somewhere, please request more information!
Thx,
KaReL (aka Steven)
*Main Webpage* : http://www.karels0ft.be/ *ICQ #* : 35217584
For the other question, how are the two people accessing the database file? NFS, samba, or just different terminals on the same box? This
can make a difference, as locking on network filesystems has varying levels of success(although it is never reccomended).
John LeSueur