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

Lee Fesperman wrote:
> FirstSQL/J uses SQL. A class is just another database type for a column.
 The only change
> to SQL is to allow you call the methods of a column object and a 'new'
 operator for
> creating objects.

With your approach there is no possibility for server-side query optimization. Every single object needs to be instantiated completely, just to evaluate a simple member. This will perform very badly.

> > Do you use Java serialization to store objects?
>
> Yes, in columns.

What do you do, if user classes are modified?

Serialization and deserialization is very slow and produces lots of storage overhead by the way.

What happens if:

- object A has a member B
- object A is stored to one column in one table
- object B is stored to another column in another table
- one query delivers object A
- another query delivers object B

Kind regards,
Carl

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