[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