[freeside-devel] Does it work with Oracle?

[ivan]

On Fri, May 04, 2001 at 09:14:44AM -0400, Matthew Goheen wrote:
> > I would like to know whether anyone has successfully implemented Freeside
> > with an Oracle backend.
> 
> I started the process, and got through renaming all the various conflicting
> column names, but time constraints made me abandon the project.
> 
> I don't really think there is much that actually has to be done, other than
> getting familiar with the code (which is certainly the biggest obstacle).
> The column names that I came up with include "uid" and "date" (and perhaps
> "schema" and "comment"?).  I also renamed "gid", just to be consistant with
> "uid" (I added "x_" to the names, just to make them easier for me to find,
> using just an "_" was more confusing -- a la "_password").

"date" is already "_date".

"uid" is not an SQL reserved word according to etc/sql-reserved-words.txt
in the distribution.  Neither is "schema" or "comment".  If you have a
list of Oracle reserved words above and beyond standard SQL reserved
words, I'd be interested in getting a copy.

> At that point things didn't work, and I ran out of time.  I'd love to
> see support
> added... :-)

Other than the column names you'd also need to add support for Oracle to
DBIx::DBSchema.  

It seems odd to me that people would expect to see support for a
proprietary database added to a free software project.  If you have
resources to purchase and run Oracle, sponsoring an Oracle port of
Freeside would be insignificant by comparison.

PostgreSQL is free and currently supported, and I've heard positive
reports about MySQL with BDB support.

-- 
meow
_ivan