yeh for a easy-to-install stand-alone setup maybe sqlite , but imagine the future with freevo boxes that have multiple front-ends, streaming live video with neat os-specific gui's, a little "whats on now" display and a browsable tv guide, something along those lines anyway. just that i havnt seen plug-ins for vb(win) or perl(nix) to let me access sqlite, just dont want to re-invent the wheel.On Mon, Aug 04, 2003 at 02:41:46AM +0000, Roh . wrote: > when does speed matter? i run the WebVCR+ database on a p1 233 and it > certainly isnt slow
I'm not saying that speed is the issue. I use MySQL for my websites, and I'm happy with it. I'm saying that it isn't suitable for this type of application.
> correct me if im wrong, but a simple file db like that couldnt offerdidnt know there was network support, ill have a play with it, thanks for the correction.
> 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.
You can have concurrent accesses, just not concurrent writes, but neither does MySQL. Network support is via rob's daemon, not via the database.
> If MySQL is too 'beefy' out of the box then surely the freevo project couldyeh i agree it wasnt fair of me to say that without learning a bit more about sqlite, although i do still lean towards the trusty ol' mysql even after some looking. but we'll let that rest now :P
> 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.
I don't think it's really fair to say it's limited, if you haven't looked at it. But that said, whatever happens with the database, it'll be using standard SQL commands for the most part; I don't like database specific extensions, so if you wanted to move it to MySQL, you're welcome to send a patch.
i do have some hacks of code floating around that ive used to get mythtv, webvcr+ and freevo to all share the same database, but its ugly and in perl, i think u guys prefer python yes?
also recently ive stopped playing with myth and have been doing alot to get webvcr and freevo to play together, also have a basic start on the multiple front-ends things. As i clean these things up ill post the code here incase anyone wants to play or the freevo guys like any of the ideas.
> Just my two cents, I use freevo and webvcr+ and mythtv on different boxesyeh i know, and its cool, but ive made up some perl apps using GTK+ that show a small window in the bottom corner of ur screen with a list of "whats on" which is updated every minute. Also made a small win32 VB app that minimises as a icon to the system tray and lets you know when favorite shows are coming up, etc, can click on it and browse the tv guide. things like this i think are cool little extras and are easily done with a common database (again i say this without really trying to get a win32 app to access the database via rob's daemon, but i bet ill get atleast one headache if i do)
> 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).
There is a full web interface to the TV guide. It's been in Freevo for two releases now.
cheers all,
rohbags
_________________________________________________________________
ninemsn Extra Storage comes with McAfee Virus Scanning - to keep your Hotmail account and PC safe. Click here http://join.msn.com/
------------------------------------------------------- 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
