Using stored procedures as an API to the database is a perfectly
acceptable way of doing things, and provides some nice benefits:
You can lock out all other access to tables. This limits what can be
done if the application gets compromised.
It means you don't have to worry about people embedding
Hi,
I'm developing one application using this wonderful Database, and I've
like of use the concepts correctly.
Then, i decided that all my SQL statements will be in database using the
procedure language (plpgsql or plpython), I go create functions for all
interactions in database, and use in the
