Concerning Converting the sqlite database into XML format
Dear Galaxy team, I am Sondos Seif, an undergrad student, in Cairo University, Biomedical Engineering Department. I want to replace the SQLite database with XML, I was just wondering if there is a way to do that without having to edit in the engine or detaching SQLAlchemy? Regards, -- Sondos Seif El-Din
sondos seif wrote:
I am Sondos Seif, an undergrad student, in Cairo University, Biomedical Engineering Department. I want to replace the SQLite database with XML, I was just wondering if there is a way to do that without having to edit in the engine or detaching SQLAlchemy?
Hi Sondos, SQLAlchemy is really the core of Galaxy and its object to data store mapping, so replacing it would likely be a large amount of work. It does support more database engines though, the full list is here: http://www.sqlalchemy.org/docs/05/reference/dialects/index.html We test with SQLite, MySQL and Postgres, but others should work (but the database versioning and migration scripts would likely need to be tweaked for other engines). I'm not extremely familiar with XML DBs, but due to the complex relations between objects in Galaxy, I'd be worried about the performance drawbacks of an XML data store. --nate
participants (2)
-
Nate Coraor
-
sondos seif