Less Than, Greater Than and Everything in Between

Some new stuff has gone into Sql4o:

• supports all the comparison operations for the queries: <, >, <=, >=, =, <>, != .
  
• supports Integers, Longs and Doubles as well as Strings.
  
• and lastly, you can now build more complex where statements and they get correctly converted into SODA!
• eg: from com.spaceprogram.db4o.Contact c where (age = 10 or age = 20) and income >= 50000.02
  

The latest code in SVN has it all, and of course this also means that you do do all this fun stuff in the latest ObjectManager source.

Next up... Aggregation.

SQL For Objects - Sql4o

I’ve started an SQL for Objects project to enable string based querying support for db4o. This means you will be able to write queries like:

select * from com.abc.Contact c where c.name = 'leroy'

The project page is up here:

http://developer.db4o.com/ProjectSpaces/view.aspx/SQL_Support

The subversion repository with the code is up here:

http://code.google.com/p/db4o-sql/

I’ll release a jar file soon.