 |
 |
|
February 17, 2004mySQL now supports Stored ProceduresThis is more for me than anything else. Just came across the fact that mySQL 5.0 now supports stored procedures. (Finally!) It follows the syntax for SQL:2003, but there are plans to consider PL/SQL and T-SQL in the future. Documentation can be found here. Perfect timing, as I am just preparing to work on a project that will need that. Posted by SilverStr at February 17, 2004 09:51 AM | TrackBackComments
Take note of what they say... "the MySQL implementation of stored procedures is still in progress" They also don't discuss things like precompiling, caching, table triggers, and so on. If you want real database features, I still highly recommend to use PostgreSQL. Be leary of using a brand new major feature in a Beta release, whereas many other databases have had stored procedures & triggers for over 10 years. Here's the equivalent section from the PostgreSQL documentation on Server Programming. Posted by: Wim at February 18, 2004 09:56 PMYep, already know about PostgreSQL functions. Was looking at the idea of using stored procedures that may in time follow the same syntax as Oracle or SQL Server. Thanks for the pointer to the docs though. In the future I won't have to hunt it down when reevaluating it. Posted by: SilverStr at February 18, 2004 10:31 PMSection 37.11 in the above mentioned documentation and the Pg Techdocs have some good info on porting from Oracle. PL/SQL is very similiar to PL/pgSQL. I've ported a SQL Server database to PostgreSQL before. Lots of tedious procedure rewriting, although I did create some perl scripts to ease the process. Posted by: Wim at February 19, 2004 07:03 PM |
 
My 5 Favorite Books
Writing Secure Code
Secure Programming Cookbook Security Engineering Secure Coding Principles & Practice Inside the Security Mind
My 5 Favorite Papers
Smashing the Stack
Penetration Studies Covert Channel Analysis of Trusted Systems DoD Trusted Computer System Evaluation Criteria NSA Security Recommendation Guides
Archives
June 2007
May 2007 April 2007 March 2007 February 2007 January 2007 December 2006 November 2006 October 2006 September 2006 August 2006 July 2006 June 2006 May 2006 April 2006 March 2006 February 2006 January 2006 December 2005 November 2005 October 2005 September 2005 August 2005 July 2005 June 2005 May 2005 April 2005 March 2005 February 2005 January 2005 December 2004 November 2004 October 2004 September 2004 August 2004 July 2004 June 2004 May 2004 April 2004 March 2004 February 2004 January 2004 December 2003 November 2003 October 2003 September 2003 August 2003 July 2003 June 2003 May 2003 April 2003 March 2003 February 2003 January 2003 December 2002 November 2002 October 2002 September 2002 August 2002 July 2002 |
|
