Lift ORM now supports PostgreSQL and H2

[Maciek Starzyk]

Folks,
In addition to MySQL and Derby - lift's ORM now supports PostgreSQL and H2 databases.

For PostgreSQL all db tables need to be in the "public" schema, which is the PostgreSQL's default schema. This requirement only holds for code that uses Schemifier, so when Schemifier is not used (as in production environment), then it should work with any schema on the "schema search path"
(see: http://www.postgresql.org/docs/8.2/interactive/ddl-schemas.html#DDL-SCHEMAS-PATH)

H2 ( http://h2database.com/) can be an alternative for Derby. It has (among others) these nice features:
- Works in embedded or standalone mode.
- Is fast - although re-connecting to database on each request slows it down.
- Everything is in one 1MB jar file
- Supports in-memory databases (no files created on disk), which is nice for testing.

Cheers,
Maciek

[David Pollak]

On Dec 20, 2007, at 2:16 AM, Maciek Starzyk wrote:

Folks,
In addition to MySQL and Derby - lift's ORM now supports PostgreSQL and H2 databases.

For PostgreSQL all db tables need to be in the "public" schema, which is the PostgreSQL's default schema. This requirement only holds for code that uses Schemifier, so when Schemifier is not used (as in production environment), then it should work with any schema on the "schema search path"
(see: http://www.postgresql.org/docs/8.2/interactive/ddl-schemas.html#DDL-SCHEMAS-PATH)

Very, Very, Very Cool!

I am a PostgreSQL fan and cannot wait to try and use this code.  Pretty soon, much4.us will be on PostgreSQL.

Woo Hoo!

Thanks!

David

H2 ( http://h2database.com/) can be an alternative for Derby. It has (among others) these nice features:
- Works in embedded or standalone mode.
- Is fast - although re-connecting to database on each request slows it down.
- Everything is in one 1MB jar file
- Supports in-memory databases (no files created on disk), which is nice for testing.

Cheers,
Maciek

--

David Pollak

http://blog.lostlake.org

[Oscar Picasso]

Nice,

When I have the choice and need an RDBMS  I go for Postgresql.

Thank you.