[mythtv] add support for SQLite?

James Chapman jchapman at katalix.com
Mon Mar 5 17:05:56 UTC 2007


Michael T. Dean wrote:
> On 03/05/2007 09:33 AM, James Chapman wrote:
>> Isaac Richards wrote:
>>  > James Chapman wrote:
>>   
>>>> Anyways, the reason for my original post was to find out if anyone was
>>>> already working on SQLite so as to avoid doing duplicate work. It seems
>>>> no. So I'll go away and develop a patch.
>>>>       
>>> We don't really want to have to support multiple database types.  It's quite a 
>>> bit of extra work.  I _would_ like to switch to embedded mysql - that should 
>>> get us most of the largest benefits of moving to sqlite without the added 
>>> pain of reworking large amounts of code.
>>>     
>> Rework large amounts of code? Wouldn't all of this be handled by the Qt 
>> SQL abstraction? I was thinking none of the SQL code of MythTV would 
>> need to be changed, unless perhaps an obscure SQL feature was being 
>> used. Maybe I'm missing something?
> 
> There are a lot of MySQL-specific things in there. 

Do you have examples, Mike?

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.

-- 
James Chapman
Katalix Systems Ltd
http://www.katalix.com
Catalysts for your Embedded Linux software development



More information about the mythtv-dev mailing list