Databases for REAL
Using SQLite as a Server
Issue: 9.3 (March/April 2011)
Article Description: No description available.
Article Length (in bytes): 6,017
Starting Page Number: 78
RBD Number: 9312
Resource File(s): None
Related Web Link(s):
Known Limitations: None
Excerpt of article text...
SQLIte is a wonderfully flexible database, but for most purposes it really is intended for use as a single-user database engine. But because of its speed and flexibility, it is also possible to use it as a server, if you're careful. This month we will look at using SQLite on a network, Studio Stable Database, CubeSQL Server, and SQLite Write Ahead Logging.
SQLite on a Network
Although not technically a server, you can put your SQLite database file on a shared network folder so that multiple clients can connect to it. This will decrease your performance, perhaps significantly, but can be useful for specific situations.
You'll have to code more carefully because SQLite only allows one client to write to the database at a time. You'll need to check for a database error whenever you write to the database (which you should be doing anyway) and possibly wait a short period and try to write again.
For applications that have a few clients connecting to the database or that are mostly read-only, this option can work reasonably well.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.