Re: [Freevo-devel] SQLite

[Joakim Berglund]

Hi there   Well since sqlite handles locking on file level there is no problem in accessing the same file (aka db) from several threads or programs at the same time. Ive have used this extensivly in a coding project Im in.... 3 diff programs and each having 5+ thread open to the same db file at the same time.   Not tried it from diff machines though but in teory it should work just fine.   An easy test is to open the db file with the sqlite tool at the same time as freevo and watch it updating the db.   Joakim Yes, but as I understand it it is imposible for another application to access sqlite at the same time as freevo ? (or am I wrong here ?) ie. have my webserver access the data at them same time that freevo is updateing it without using freevo as a frontend to the database (notice the webserver is not freevo in this case). And what I wanted was not to change to mysql (especially as I dont really like mysql) but to have an open database standard something along the lines of an object persistance layer like jdo/hibernate/* ie. to move the database code away from freevo and allow it to be swapped at will. I think this was mentioned previously.