Postgres vs Derby



Do any of you have experience of using both these RDBMS?

I'm about to build a database application and am leaning toward Postgres (which is installed) though I'm wondering about using Derby instead.

The initial application will be written in Java, so I've already discounted MySQL because its JDBC driver is inadequate for handling large retrieved data sets: unlike the Postgres driver it doesn't have a stream interface and insists on loading the entire data set into memory rather than fetching it in chunks or row by row through the cursor. As a result a sufficiently large query result will crash it.

TIA


--
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |
.