Fwd: Re: [kronolith] kronolith and oracle..

Jan Schneider jan@horde.org
Fri, 26 Apr 2002 18:34:38 +0200



----- Weitergeleitete Nachricht von Brandon Knitter 
<knitterb@blandsite.org> -----
    Datum: Fri, 26 Apr 2002 09:15:37 -0700
    Von: Brandon Knitter <knitterb@blandsite.org>
Antwort an: Brandon Knitter <knitterb@blandsite.org>
 Betreff: Re: [kronolith] kronolith and oracle..
      An: Jan Schneider <jan@horde.org>

Oh yeah, I'll find something here! :)

In the work I was doing at my last company we wrote a transactional system 
which
we ended up having to write database independent queries.  Most things are
identical, but a few things like date and numeric number storage is 
different
across database systems.  Soas to support multiple database vendors, is 
there
any way you guys would be interested in writing an abstration layer?  Or is 
your
plan in the case of not finding a common ground to just simply say that 
certain
databases are not supported.  For the most part it's quite easy to abstract,
just a matter of making database resource files, typically the largest one 
being
a reusable general one, and just overrides for certain queries on different 
dbs.

Database independence is fun, but it /is/ work! ;-)

-- 
-bk


Quoting Jan Schneider <jan@horde.org>:

> Zitat von Brandon Knitter <knitterb@blandsite.org>:
> 
> > Let me dig out the SQL92 spec, there must be a standard way to insert
> > dats, I
> > would say that perhaps by epoch/milli (number of milliseconds past the
> > epoch).
> 
> But that wouldn't help us, because we need to be independent from the 
unix 
> epoch.
> 
> Jan.
> 
> --
> http://www.horde.org - The Horde Project
> http://www.ammma.de - discover your knowledge
> http://www.tip4all.de - Deine private Tippgemeinschaft
> 
> 



----- Ende der weitergeleiteten Nachricht -----


Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft