Projects tagged ‘postgresql’ and ‘storedprocedure’

This program intend to be a way to consume webservice created automatically from stored procedures write in any supported language from postgresql. Createad in c this project produce a fast web server ... [More] to do this and create a structure in database to administrate the details of acl. [Less]

JProcedure is a generic engine written completely in Java (1.5) for invoking stored procedures on variety of database platforms (Oracle, PostreSQL, MySQL, etc). It uses java annotations to describe ... [More] information necessary for a proper stored procedure call and lets you define whether the results should be cached or not. It also allows you to inject custom written interceptors to add specific logic to procedure invocation (you may find interceptors useful for logging or performance measuring purposes) [Less]

What is PgP Generator? PgP Generator (or Pg Square) is a utility written in PgSQL that generates stored procedures around tables. The stored procedures perform the following basic operations: ... [More] Insert into a given table Update a given table knowing the primary key Retrieving data: all records and by the table's primary key Why use PgP Generator? Written in PgSQL it will run anywhere PostgreSQL runs (Linux; Solaris and Windows) Eliminates time spent writting basic CRUD operations Increase productivity and focus on implementing business logic & security for the database Compared to other products this script is light-weight and free Available online Generator allows customized a script file appropriate for your system (setting owner, target schema, updates comments for your system). The current version is optimized and has been tested with PostgreSQL 7.x and 8.3 and is working well. Where is the source code ? The project is hosted here on google PgP-Generator is developed under GPL v3 and comes with NO WARRANTY or implied warranty. Feel free to change; and distribute at will (giving proper credit). Coming Soon Retrieve operations with foreign key support Code optimization Adding a package for logging `Enjoy. [Less]