Roedy Green wrote:
On Sat, 21 Nov 2009 18:59:04 +0000 (UTC), Martin Gregorie
<martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
someone who said :
How do you rate H2 against Derby and HSQL?
For a comparison of PosGreSQL and MySQL see
http://mindprod.com/jgloss/postgresql.html
The information is a few years old.
#PostGres has many data types.
Most databases has.
#You can write triggers in Oracle stored procedure language PL/SQL or in
other languages such as Java.
http://www.postgresql.org/docs/8.2/interactive/triggers.html
does not list Java but several other languages.
And even though PL/pgSQL is very similar to Oracle PL/SQL, then
I assume that Oracle prefer it not to be called Oracle PL/SQL.
> I understand that Derby is fast, but ram resident only.
Not true.
> It is for
> small databases only.
Probably.
#PostGres does not crash under heavy loads.
No databases are supposed to do that.