[mythtv] add support for SQLite?

Rob Smith kormoc at gmail.com
Tue Mar 6 01:26:06 UTC 2007


On 3/5/07, James Chapman <jchapman at katalix.com> wrote:
> I look at SQLite as a _potential_ drop in replacement (configured at
> compile time) for MySQL. Maybe I'm being naive. :) If lots of existing
> SQL clauses have to be conditionally compiled for SQLite then I'll
> abandon the SQLite idea.

Take a look at this:
http://www.sqlite.org/omitted.html
http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql

ALTER TABLE is a bit lacking

Also, SQLite only allows database locking during writes, so say while
mythfilldatabase is running, you have the chance that writes to the
database will be blocked... not so happy.

SQLite is a great little engine, but there are limits.

~Rob


More information about the mythtv-dev mailing list