Sqlite3/Firebird Questions lazarus / 16-Databases ---------------------------------------------------------------------- xinyiman · 2010-10-01 13:37 I would like to ask questions. 1. Lazarus can connect to a SQLite3 database remotely? 2. How big can be a sqlite3 DB without loss of performance? 3. You can encrypt the sqlite3 DB and then read from Lazarus? Sorry for the questions but first I should take the time to know the answer to these questions! Thanks ---------------------------------------------------------------------- xinyiman · 2010-10-01 14:16 Otherwise Firebird allows things above? Firebird allows you to export the database structure to reimport it into another database firebird? ---------------------------------------------------------------------- 99Percent · 2010-10-01 16:25 SQLite3 is for single user simple database applications. I decided to use Postgresql database instead even though my application is single user. SQLite3 deosn't handle multiple connections or multiple applications accessing the database even if its on the same machine. ---------------------------------------------------------------------- LuizAmérico · 2010-10-01 16:39 QuoteSQLite3 deosn't handle multiple connections or multiple applications accessing the database even if its on the same machine. You are wrong. I have a program that access a sqlite3 file shared in the network where 10 computers access it with good performance. Be aware that this is not the recommended use of sqlite3. If you need to access through the network you must use MySql etc (I'm using this way because of some specificity) In the other side is possible to use sqlite as the db of a (low traffic) website. ---------------------------------------------------------------------- 99Percent · 2010-10-01 18:53 QuoteYou are wrong. I have a program that access a sqlite3 file shared in the network where 10 computers access it with good performance.I believe that here the locking is done at the file level, and not by SQLite but by the network OS and it locks the whole SQLite database each time it is being accessed. Not recommended at all. ---------------------------------------------------------------------- LuizAmérico · 2010-10-01 20:11 QuoteNot recommended at all. I agree that's not recommended (i am already planning to replace the data access by a proper client server architeture) but it's different from "not possible" BTW: the new sqlite version minimizes file locking and improves concurrency using WAL technique (not that this make recommended to use shared in a network but can improve multiple accesses in the same machine). ---------------------------------------------------------------------- coolerfun · 2011-02-07 17:41 How to, for minimize locking in lazarus? ---------------------------------------------------------------------- xenblaise · 2011-02-07 19:41 Quote1. Lazarus can connect to a SQLite3 database remotely? 2. How big can be a sqlite3 DB without loss of performance? 3. You can encrypt the sqlite3 DB and then read from Lazarus? 1. YES like Luiz_Américo said 2.  Actually Ms-Access is lighter in dB bytes size, about performance?, as I knew a lighter performs better, but probably depends the data type used. 3. Yes, not very sure, but it can be from Lazarus SQLdB or Zeos. 4. ---------------------------------------------------------------------- TurboRascal · 2011-02-07 23:04 You can also share DBF files over network, but I wouldn't say that the database handles multiple connections. Same goes for SQLite, you can share a database, but you must implement file locking yourself. And it's not really trivial to design such a system to actually be robust and reliable. Why have so much trouble with it when you may use any multiuser RDBMS like Postgres or Firebird which handles all that for you... ---------------------------------------------------------------------- Lacak2 · 2011-02-08 06:08 Here you can read about how sqlite performs locking: http://www.sqlite.org/lockingv3.html ---------------------------------------------------------------------- TurboRascal · 2011-02-08 21:23 Quote from: Lacak2 on February 08, 2011, 07:08:35 amHere you can read about how sqlite performs locking: http://www.sqlite.org/lockingv3.html Yes, sqlite helps you with locking, but the authors don't really recommend nor is sqlite designed to be used like that. It can be seen both on that page and here: http://www.sqlite.org/whentouse.html