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)
SELECT client_id, client_name FROM client_table
WHERE client_id = id
Anythoughts pointers appreciated, preferably and open source DB of the
MySQL, PostgreSQL standard.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!