Re: [opennms-devel] Re: [opennms-discuss] Once Upon a Time ...

[Derek Chen-B. <db...@cp...>]

Peter Nixon wrote:
> On Thursday 03 June 2004 22:17, DJ Gregor wrote:
> 
>>>On May 28, 2004, at 11:55 PM, Tarus Balog wrote:
>>>
>>>>2) More Java. People love or hate Java, but if I am honest the hardest
>>>>part of working in OpenNMS is where we intersect with C++, and to a
>>>>lesser degree, Perl. We hope to be as pure Java as we can by the end
>>>>of the year. This may mean some big changes (JRobin instead of
>>>>RRDtool, a different database than Postgres) but imagine being able to
>>>>drop a .jar file on your system and be ready to go.
> 
> 
> Why would you switch from postgres? It is in my opinion by far the best 
> OpenSource DB available.. Do you plan to store all data in a native java DB 
> of some description?
> 

I agree that postgres is a great DB, but I would also agree that making 
things more generic would be great. IIRC, there are only a few 
postgres-specific stored procedures (notably IPLIKE). The ideal scenario 
for things like that would be to provide a query engine class that has 
specialized subclasses for the different DBs. That way it will always 
work with any JDBC-compliant driver, but you can provide a subclass 
(that possibly hooks stored procedures) to improve performance. Kind of 
how Hibernate uses a generic query interface that delegates to a 
DB-specific "dialect" class.

Derek


-- 
----------------------------------------------------------------------
Derek Chen-Becker
Senior Network Engineer
CPI Corp, Inc.
1706 Washington Ave
St. Louis, MO 63103
Phone: 314-231-7711 x6455
Fax:   314-613-6724
db...@cp...
PGP Key available from public key servers
Fingerprint: 1C34 D81E D8A0 641D 6C8C  E952 3B15 693F 9184 BC58
----------------------------------------------------------------------