Re: S.O.D.A. database Query API - call for comments

Lee Fesperman wrote:
> It's perfectly reasonable to knock a technique
> for programming being arbitrarily applied to database using a
> hodge-podge of long-ago discredited techniques.

Techniques are always dependant on usecases.

Did you hear about the database project Ericsson brought up to handle high traffic?
It is hierarchical.

How about a benchmark race of storing data, db4o against firstsql? So far we have not found another database to match our speed, even with simple integer values. If you have a JDBC driver for your engine, running our benchmark should cost you 10 minutes:
- download our engine
http://www.db4o.com/db4o/db4o.zip
- edit the JDBC connection parameters in com.db4o.bench.BenchMark.java - run com.db4o.bench.BenchMark.java with db4o.jar in the CLASSPATH If you find anything wrong with our benchmark, I would be glad to discuss it here.

Now that our engine can store objects very fast, we need a performant mechanism to provide complex queries. SQL definitely is wrong for the task. We can still add SQL at a later date, if we provide a lower level typesafe API now. You might not have understood our project yet: Our API can be used as a query parser API at a later date.

Now please tell me:
What is wrong with our approach?

Kind regards,
Carl

---
Carl Rosenberger
db4o - database for objects - http://www.db4o.com