[ILUG] SQL DB that does Stored Procedures....

[Glen Gray]

All that ranting about Microsoft stuff and the client/server projects
I've worked on got me thinking. I wanted to port a simple project I'd
done to GNOME and a Linux SQL server but never got around to it.

I was hoping to implement it as easily as possible. I have scripts that
will generate the DB and add all the tables, users etc. But access to
the DB is done via stored procedures and audit trails are kept via the
use of triggers.

It's a three tiered approach, 

SQL DB backend

C++ library middle layer

Gnome based GUI.

The C++ library has business objects and data access objects. The data
access objects call storeded procudures on the DB to get/set/process
data. Any insert, update or deletes trigger appropriate Triggers which
store the date, time and user in an audit table.

I looked at PostgreSQL and although I like it alot it doesn't have
Stored Procedures in the ANSI sense and would mean rewritting a hell of
a lot of SQL code if I went that way. I want a DB that will let me do
something like (not syntax accurate this)

CREATE PROCEDURE load_client(int id NOT NULL)
BEGIN
	..

	SELECT client_id, client_name FROM client_table
	WHERE client_id = id

	..
END

Anythoughts pointers appreciated, preferably and open source DB of the
MySQL, PostgreSQL standard.

Glen