Noah Kantrowitz kirjoitti: > > On Oct 7, 2007, at 5:28 PM, David Peckham wrote: > >> In the long term, I'd like to see Trac support Oracle or SQL Server. >> I'm still relatively new to Python and Trac, but I'd like to >> contribute. Can someone tell me what remains to be done with >> SQLAlchemy and where I can help? > > "A lot". As SQL is not a very standard standard, the way most ORMs > deal with cross-DB magic is to force you to use their object layer. > Trac has already done this for schema generation (as that is more non- > standard than most things), but we still use raw SQL for most > queries. Beyond the work involved in moving everything to an ORM, we > need to actually decide this is a wise course of action. The DB > system is already modular, so as long as the query syntax for your DB > of choice is the same as the others we use, you should be able to > make a backend plugin.
ORM is in most cases pretty good option, if there is need to support multiple DB backends. I've been long term Hibernate user in Java (and lately even in .NET platform) and been pretty happy. I can switch between different database backends just by changing row or two in configuration files and HQL/Criteria query engines takes care of rest. Since most of queries in Trac are pretty simple in nature it would work well. Only thing is that how custom additions would work with ORM? Currently you just write piece of SQL to make custom queries in your plugins and everything works well. But if there is switch to ORM, how it would work? IIRC there was some initial decision to switch over to some ORM before 0.11 development started but it seems that it has been dumped somewehere in memories only... -- Jani Tiainen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Development" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en -~----------~----~----~----~------~----~------~--~---
