database interface API for review

[carpeliam]

I've finished the basic API for a database interface. Before implementing it for different databases, I wanted to put it up for review.

It can be found at

http://www.wpi.edu/~lmorley/db-api/.

This includes both the API (org.wpi.gdc.db) as well as a sample usage (org.wpi.gdc.cms.db).

Does this work for others who would like a layer of abstraction between the database and the application? I'm hoping that you can suggest improvements, or give general comments. I'd also like to know if I'm simply reinventing the wheel. Liam Morley
lmorley@gdc.wpi.edu
"light the deep, and bring silence to the world.
light the world, and bring depth to the silence."

 

[wushutwist]

Well, I haven't given a detailed look over your API docs but a Database Layer is used by most serious developers in all projects. It is definitely not something that is new and it is a Design Pattern for J2EE that is highly suggested by Sun. Where I work we have a tool that we created for automatically producing the Database Layer (though we call it the Persistance Layer). The one thing I noticed that your tool might lack (again I only glanced at it) is a way to do complex queries involving joins, group by, and aggregate functions.

If I get a chance to look over your stuff in more detail I will give you additional feedback.

 

[carpeliam]

wushutwist,<br>regarding your last statement, that's very true. The database demands placed on this system are currently quite low, and so there is currently no need to add those sorts of functionality. There was actually a conscious decision to wait until later. It's a tradeoff between scaleability and speed, but we're currently in more need of speed ) so that's the way we've gone.<br><br>As far as it not being a new thing, I'm sure it's been done before. I haven't seen any open source API's as of yet, however, so I wanted to offer some ideas up as well as find out if there are any well known open API's that offer what I'm looking for.<br><br>Thanks for taking a look ) <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;