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

[Glen Gray]

I've not been able to spot much after a look through a search for
"T-SQL" postfgresql module on google. I made a few variations on this
too. If you know of any sites to look through then let me know.

I'm suprised too. Looks like Sybase is available freely for development
on Linux so I might go down that road. 

I did have a code generator written that did the grunt work for me. i.e.
I had a standard set of stored procedures that where stored in a
template. The GUI let you connect to a DB via ODBC (this was a windows
tool). You'd select the tables you wanted code for and off it would go
and parse the table definitions through the template(s) and generate a
.sql file that would create all the code stored procedure code for you.
I also extended it to create VB/VC classes for data access with a
standatd set of functions etc. Worked like a charm. I was hoping to do
something similar on Linux but just haven't had the time/motivation to
do it. But if I did I'm sure I could work out a way to get it generate
code that worked for both T-SQL and non T-SQL DB's.

Would have been nice to be able to just run the create_db.sql file and
have it all there though.

Glen



On 10 Jul 2001 08:16:56 -0500, John_White at dell.com wrote:
> Glen,
> 	you can get language modules for PostgreSQL, . . . I'd imagine
> someone has already written a T-SQL language module for Postgres . . . . if
> so, all you need to do is get it and load it.
> 
> 
> 
> 
> 
> 
> -----Original Message-----
> From: Glen Gray [mailto:glen at antefacto.com]
> Sent: 10 July 2001 13:10
> To: ilug at linux.ie
> Subject: [ILUG] SQL DB that does Stored Procedures....
> 
> 
> 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
> 
> 
> 
> -- 
> Irish Linux Users' Group: ilug at linux.ie
> http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information.
> List maintainer: listmaster at linux.ie