[mythtv-users] PostgreSQL

Brad DerManouelian myth at dermanouelian.com
Mon Jul 3 15:01:35 UTC 2006


On Jul 3, 2006, at 7:45 AM, Michael T. Dean wrote:

> On 07/03/2006 10:22 AM, Brad DerManouelian wrote:
>> On Jul 3, 2006, at 7:35 AM, Brian Wood wrote:
>>>> I'm starting to wonder if this topic was pointless, I got  
>>>> bounces e-
>>>> mail
>>>> from the developer of the patch for postgresql and the mythtv dev
>>>> team
>>>> has no interest in supporting it :( it would be real nice if I  
>>>> didn't
>>>> even have to run a DB for my PVR at all.
>>>>
>>> I think the use of a DB is to a large extent what gives Myth its
>>> power, it was a design decision at the very beginning that has stood
>>> the project in good stead.
>>>
>>
>> I think what the original poster was suggesting is that he wishes he
>> didn't have to maintain a DB along with his PVR setup. I agree it
>> would be nice to have an embedded DB like SQLite that it still
>> powerful but doesn't really require maintenance. Backing up and
>> restoring is a breeze, too. However, you sacrifice some speed (in
>> complex queries and large databases) when you go this route.
>
> And testing of SQLite shows that you sacrifice too much speed for  
> Myth's
> purposes (at least at this point)...  Straight from the guy who  
> started
> the MythTV project:
> http://www.gossamer-threads.com/lists/mythtv/dev/203898#203898
>
> But, if you don't want to maintain a DB, there's always another route:
> http://www.tivo.com/
>
> Mike

The company I work for has done some pretty extensive things with  
SQLite. I bet if someone was that interested in supporting it, they  
could mess with the SQLite optimizer enough to make the myth-specific  
queries as fast or faster than MySQL. That's one of the great things  
about free (Free as in free - no licensing at all) software. However,  
that person is neither you nor I since we both seem to be perfectly  
fine with maintaining MySQL.

That being said, you can set a SQLite pragma which cuts most query  
time in half (at least) at the expense of the *possibility* that your  
db will become corrupt in the event of a complete power failure,  
however I've never seen this happen.


More information about the mythtv-users mailing list