i've been experimenting with sapdb recently and asking questions
on
the sapdb mailint list, here's a quick summary of my thoughts.
- its designed for 24x7
- it has around a thousand run time config options
- its a pain to compile (uses old c++ compiler for bin
compatiblity,
custom make system build environment)
- the exposed python/perl interfaces make writing admin scripts
fairly easy.
- triggers seem slightly non standard in execution behavior and
somewhat limited (no before triggers)
- the procedural language is nice, reminds me of a downsized
pl/sql, there seem to be plans for java stored procs at a later date.
the procedural language includes cursor support, exception handling,
(in|out|in/out) var args, transaction control.
- nice usage docs, skimy dev docs.
more importantly from an acs point of view,
it doesn't currently (7.308) support stored procs calling other
stored procs. so it looks like a non starter till this is done.
