On Sat, Dec 13, 2003 at 08:27:19PM +0100, Dirk Meyer wrote: > My idea would be something that stores metainfos about a file. This > informations include the mmpython infos + some stuff Freevo wants to > save (bookmarks, play times, etc.)
That's the same thing I'm thinking of... kind of like a basic metadata object that can be extended to include other types of information via subclassing. > And you use Python 2.3. Gentoo is still at 2.2.3 because the whole > portage tree depneds on Python. They are testing very carefully. True... it's been around for a long time mind you :) It's up to 2.3.2 at least now. > I'm thinking of all this metainfo stuff, and maybe you can do > something. My knowledge of databases is close to zero, I got my diplom > (similar to a master) without hearing anything about databases and how > to structure them. My SQL knowledge is even closer to zero. If you > have some time, maybe you can add some sqlite support. Ok... I'm on vacation now, so I'll come up with a basic model and we can look at it... even if you aren't an SQL person, you likely understand the concept of linked tables, so we should be able to talk about it in depth. > To do that, maybe we could use some ideas from shelve.py. Since sqlite > can only handle strings, use pickle to store python objects (and let's > hope pickle doesn't use the null character). About an object, we > should be able to access: sqlite can handle almost anything, it's just that you don't need to worry about types since you can pull an int out and put it into a string or whatever because the types are mostly for reference, as opposed to being strict. > o thumbails. sqlite can store 1 MB on a row. I have no idea what a row > is, but the current osd.py stores thumbnails as pickled pygame > objects in less than 400kb. Using the db for this would speed up the > image loading. This also includes mp3 covers from id tags. I can almost guarantee that thumbnails in sqlite will be slower than off the disc. When you deal with a database, you're incurring a default overhead for everything. The speed advantage of databases for straight lookups is small, where it becomes valuable is in relational or complex objects and comparing information quickly. Aubin ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ Freevo-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/freevo-devel
