New SQL backend

[marcus]

On Wednesday 13 September 2006 06:25, Robby Stephenson wrote:
> Tellico 2 will be SQL-based, if I can get that done, so maybe
> relationships will be easier then.

Which DB backend are you going to use for Tellico 2?

I have used SQLite (public domain) with success in a desktop application 
I wrote. The files are very small and it can even be used across 
platforms. I have used the same DB on Linux and Windows without any 
changes, or additional libraries. Never lost any data sofar because the 
changes are committed immediately. And access to data is very fast.

The DB is just one small file, like the current .tlc file. So backups do 
not need any special knowledge either, just copy the file.

The main advantage is that users do not have to setup mysql or a similar 
DB. That can cause installation problems and means extra support 
questions. If the DB setup is too complicated, less experienced users 
would give up on Tellico. And that could happen.

For example, I set up MythTV a few weeks ago and the sticking point was 
the mysql setup. I had to install an admin program to get an overview, 
and then manually sort out the permissions etc. A real drag. SQLite 
does not require any setup or admin, meaning less support issues :-)
For a desktop app I think it's the way to go.

One tip: It can be 5 times faster to use two separate SQL queries 
instead of a join. At least that was true with an older version of 
SQLite, not sure about mysql. I don't know enough about the mechanics 
of SQL DBs to say why this is. Play around with those things.


http://www.sqlite.org/


Marcus