2
edits
Mozilla2:Unified Storage: Difference between revisions
sqlite network and mutliuser limitations
m (Rethinking Your SQL Storage by considering iODBC/ODBC --> SQLite) |
(sqlite network and mutliuser limitations) |
||
| Line 299: | Line 299: | ||
=== Comments from Kingsley Idehen === | === Comments from Kingsley Idehen === | ||
Any reason why you cannot use iODBC (http://www.iodbc.org) to keep your SQL Data Storage and Access DB Engine independent? This will not hinder your choice of SQL Lite as the default SQL Engine since ODBC Drivers already exist for SQL Lite. This is an important architectural decision with longterm ramifications. | Any reason why you cannot use iODBC (http://www.iodbc.org) to keep your SQL Data Storage and Access DB Engine independent? This will not hinder your choice of SQL Lite as the default SQL Engine since ODBC Drivers already exist for SQL Lite. This is an important architectural decision with longterm ramifications. | ||
=== Comments from guanxi === | |||
Per SQLite's website (http://www.sqlite.org/whentouse.html), it performs poorly over networks and they specfically recommend against multiple computers accessing it via a network: | |||
<em><blockquote>SQLite will work over a network filesystem, but because of the latency associated with most network filesystems, performance will not be great. Also, the file locking logic of many network filesystems implementation contains bugs (on both Unix and windows). If file locking does not work like it should, it might be possible for two or more client programs to modify the same part of the same database at the same time, resulting in database corruption. Because this problem results from bugs in the underlying filesystem implementation, there is nothing SQLite can do to prevent it.</blockquote> | |||
<blockquote>A good rule of thumb is that you should avoid using SQLite in situations where the same database will be accessed simultaneously from many computers over a network filesystem.</blockquote></em> | |||
Wouldn't that conflict with the goals of [[Mozilla2:Multi User Sharing]]? Also, users store profiles on network shares; whether that's officially supported or not (?), do we want to create additional issues for them? | |||