> MySQL supports both subselects (as of 4.0) and foreign keys (throughwhen does speed matter? i run the WebVCR+ database on a p1 233 and it certainly isnt slow
> innodb tables). Also, I'd be wary of SQLite's statements that it's faster
> than MySQL since its tests were ran against 3.23 and not the latest 4.0
> (which is odd since 4.0 has been stable for quite a while).
The rub is that MySQL's hack to allow subselects, etc. is slower than databases like PostgreSQL. Speed isn't so much the issue though, as is ease of use.
as for ease of use, MySQL is easier to setup than apache and you only do that once anyway.
correct me if im wrong, but a simple file db like that couldnt offer multiple lookups like mysql can? and i presume no network support either? sounds too simple and i dont think linux users want simple, we want full-featured can-do-anything kinda stuff. using MySQL makes it easy to write clients for other OS's, like a TV-Guide GUI that shows whats on, etc.To get Sqlite working in python you install the module. That's it. The application creates and manages the db internally, so there is no daemon's to watch or issues with installing and configuring.
If MySQL is too 'beefy' out of the box then surely the freevo project could offer an optimised version, or example config files/recommended changes to suit freevo, or use PostgreSQL, just something that isnt as limited as Sqlite sounds.
Just my two cents, I use freevo and webvcr+ and mythtv on different boxes all over my house, so i like the idea of a central database that i (and other apps on lan) can access from anywhere. My ideas above my sound odd, but im using freevo to stream live video while i record it, and i watch it remotely, so to me running remote X11 and windows GUIs for the TV Guide is an important feature. (thats also why i dont see the pretty front-end as being as important as a featured back-end).
regards,
rohbags.
_________________________________________________________________
Hotmail is now available on Australian mobile phones. Go to http://ninemsn.com.au/mobilecentral/signup.asp
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ Freevo-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/freevo-users
