[Solar-talk] Oh and 'Database Support'

[Paul M Jones]

Hiya Kilbride,

> Any Oracle support available yet?? US Navy requires the use of  
> Oracle every time I turn around
Fricking swabbies.  (This from an ex Zoomie. ;-)

> so if Oracle support isn't available it's going to be a slightly  
> tougher sell possibly. (or not if adding it is relatively  
> painless). I noticed Oracle isn't listed on the supporting  
> databases, but figured that the web pages might not be up to date.
Not yet, sorry.  :-(  The 30-character limit on entity names (tables,  
indexes, etc) makes it difficult for me to write a "portable" adapter  
for Oracle that's consistent with the other adapters.

I'm beginning to think that there need to be two "types" or "castes"  
of database adapters in Solar:  the ones that *can* be made portable  
between each other (MySQL, PostgreSQL, Sqlite, perhaps eventually  
Derby/DB2 and Interbase/Firebird), and then the ones that are just  
too difficult to target for portability (Oracle and Microsoft SQL).

Or perhaps there is some other way of looking at this that I have  
missed, happy to hear more discussion on this.


--

Paul M. Jones  <http://paul-m-jones.com>

Solar: Simple Object Library and Application Repository
for PHP5.  <http://solarphp.com>

Join the Solar community wiki!  <http://solarphp.org>

Savant: The simple, elegant, and powerful solution for
templates in PHP.  <http://phpsavant.com>