New topic: SQLite Database Access
<http://forums.realsoftware.com/viewtopic.php?t=38797> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message merft Post subject: SQLite Database AccessPosted: Wed Apr 27, 2011 11:13 am Joined: Wed Mar 19, 2008 6:27 pm Posts: 29 All the examples I've seen using a SQLite database open an instance of the db object and allow it to persist through the life of the session and/or application. Doesn't this create file locking issues? I had a desktop application where I ran into this problem. I changed it up so that the FolderItem was stored as an persistent object and whenever a query or update was run it would instance the database, execute what it needed, and then commit/close the database. This effectively allowed me to create a multiuser database while significantly reducing the file lock issues. With WE would this same idea work by storing the database and a global FolderItem and store the DB in the Session, that is opened and closed as it is required? Or is this too much overhead for WE? Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
