Some info on that: it's not totally written in stone yet, but the solution towards which we're going is not based on SQL (even though it might use sqlite as a backend), therefore, it won't make much sense to think "SQL schema" for this. For the curious: we're thinking of doing things the RDF[1] way.
Guillaume [1] http://en.wikipedia.org/wiki/Resource_Description_Framework 2009/11/23 P.Y. Rollo <[email protected]>: > I am not aware of database changing but it would be a great thing as it > could be a chance to improve a lot of things in the database. For > example, using integer primary keys in all tables. > > Adding a new source table and link every media to its source could be a nice > improvement too. That will make possible to clean the database when removing > sources. > > I have a significant experience in database structures and I would > > You are right, it is better to wait to know more about future database > before doing any album management improvement. > > Michał Sawicz a écrit : >> >> Dnia 2009-11-22, nie o godzinie 13:44 +0100, P.Y. Rollo pisze: >> >>> >>> Before begining with that, I'd like to have your opinion about that. >> >> Well I don't know much about the new media scanner, but I think it would >> be a waste of your work if it's not going to use the SQLite database >> anymore. >> >> > > >
