What SQL databases are available?
This is one of CDC’s strength’s over cLdc/Midlets. You can use a regular SQL database and program to the JDBC API you’re already familiar with.Here is a list of options: • PointBase – $$ commercial, pure Java, designed from the ground up for high-performance, small footprint, mobile devices. • Oracle Lite – $$ commercial, native binary for PocketPC. • Sybase SQL Anywhere (ASA) and Native Ultralite for Java – $$ commercial, native binary for PocketPC and ative Ultralite for Java. • IBM Cloudscape aka Apache Derby – free/open-source, pure Java. I haven’t used this on PocketPC, but it is pure Java with a small footprint, so it should work with J9 or Creme on PocketPC. • Microsoft SQL Server CE – I believe this is free if you own a SQL Server license, and I’m not sure if there is a good JDBC driver (not the JDBC-ODBC bridge) for the SQL CE edition. In addition, there are a lot of embeddable Java databases out there. Though they don’t specifically say they’re meant to run on PocketPC-type d