Noah Kantrowitz kirjoitti: >> -----Original Message----- >> From: [email protected] [mailto:[EMAIL PROTECTED] >> On Behalf Of scott >> Sent: Tuesday, June 17, 2008 8:09 AM >> To: Trac Users >> Subject: [Trac] Oracle backend >> >> >> Does Trac support using oracle as a backend database instead of >> SQLite, PostgreSQL, or MySQL. If so is a specific version when it >> started > > No, the only well supported DBs are SQLite and Postgres. We include MySQL > mostly because people seem to insist on it, despite it being fundamentally > broken. The nice folks at Ingress contributed a backend plugin, but I'm not > sure where it ended up. The backend system is modular, so if someone wants > to write it, an Oracle plugin is probably possible. Mostly you just need to > do some API cleanups on the underlying library to make it match the others. > Our SQL is pretty standard, so I doubt that will be much of a problem.
Well I did attempt to do this but failed. First, and most annoying feature in Oracle is dealing with '' (empty string) as NULL. So: select * from foobar where a = ''; evaluates to: select * from foobar where a = NULL; which in turn is something that doesn't evaluate correctly. Second thing is lack of user friendly text field. VARCHAR2 can hold up to 4000 _bytes_ (not characters). There exists CLOB but that uses LOB pointers that are not nice to use, and for example automatic type conversions don't always apply. Ticket related to this spesific issue: http://trac.edgewall.org/ticket/1874 As stated, SQLAlchemy (or any really abstract DB or-mapper/layer) _might_ help, but until it's implemented in Trac, there is not much of a proof of that. -- Jani Tiainen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" 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-users?hl=en -~----------~----~----~----~------~----~------~--~---
