On Wednesday 05 October 2005 02:48 pm, Joseph A. Caputo wrote: > On Wednesday 05 October 2005 13:35, Isaac Richards wrote: > > On Wednesday 05 October 2005 08:38 am, Daniel Kristjansson wrote: > > > I would really like MythTV to be something my completely > > > non-technical > > > in-laws could install, so I'm also interested in the SQL abstraction > > > as > > > it might allow a simple linkable DB, like Berkeley DB. > > > > Qt _does_ include its own copy of SQLite. If it were acceptable to go > > through > > the backend for queries, this could possibly be used. > > Note that, as of a few months ago, SQLite did not work on 64-bit > architectures. *Major* 32-bit assumptions in the code base. I don't > know what the status is right now.
If this isn't an issue anymore, I'm liking this more and more: - Write a tiny little db server app that is the only thing that talks directly to the embedded db. In addition to handling queries, this app does access control + zeroconf advertising, so it can be found automatically by the backend + frontend. - Write a small Qt SQL driver class that talks to the 'mythdbserver' app. Copy it from the existing sqlite one, substitute in a network protocol. Should be pretty easy. This should allow us to almost completely hide the change from the vast majority of the existing source, with only query differences to handle. Would need to transfer data over from existing installations. What this gets us: - No more complaining about mysql being too heavy or hard to install. - Less frontend configuration necessary - depending on how heavy the access controls are, might only need a username & password, or not even that. - No more 'But I want to use Postgres!' or random other database server. - One less big dependency. Isaac _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
