'Stored routines' Tag

• Taking common_schema's rdebug to a test-drive

  April 9, 2013

  This is a simple step-by-step introduction to rdebug: Debugger and Debugging API for MySQL Stored Routines, as part of common_schema. In other words: let me take you through the steps for debugging your stored routines on your own server. We will step into, step over, step out, modify variables, set a breakpoint, run to breakpoint... [...]

  posted in MySQL by shlomi

• common_schema 2.0.0-alpha: rdebug, GPL

  April 9, 2013

  A new release for common_schema: an alpha version of rdebug: MySQL Debugger and Debugging API is now included with common_schema. With a different license in mind for rdebug, common_schema changes license to GPL (2 or above). common_schema 2.0 is ready for download. All things rdebug, it is alpha -- otherwise it's a stable release. rdebug [...]

  posted in MySQL by shlomi

• MySQL Stored Routines Debugger & Debugging API: sneak preview II, video

  March 21, 2013

  This is the 2nd sneak preview of common_schema's rdebug: debugger & debugging API for MySQL stored routines (see 1st preview here). rdebug will be released as part of common_schema, free and open sourced. In this sneak preview I present: Compiling multiple routines with debug info Starting/stopping a debug session Step-over, step-in, step-out Showing stack trace [...]

  posted in MySQL by shlomi

• MySQL Stored Routines Debugger & Debugging API: sneak preview video

  February 19, 2013

  This is a sneak peek video introduction/preview of an in-development free and open source server side debugger & debugging API for MySQL stored routines. MySQL does not provide server side debugging capabilities for stored routines. Some tools exist, including MySQL's own, that assist in stored routine debugging. These are all GUI based and, to the [...]

  posted in MySQL by shlomi

• common_schema over traditional scripts

  December 12, 2012

  If you are familiar with both openark kit and common_schema, you'll notice I've incorporated some functionality already working in openark kit into common_schema, essentially rewriting what used to be a Python script into SQL/QueryScript. What was my reasoning for rewriting good code? I wish to explain that, and provide with a couple examples. I'm generally [...]

  posted in MySQL by shlomi

• Things that can't (and some that can) be done from within a MySQL stored routine

  August 2, 2012

  I'm doing a lot of stored routine programming lately, working on common_schema. I'm in particular touching at the extremes of abilities. Some things just can't be done from within a stored routine. Here's a list of can't be done: Cursor for SHOW statements: can't be done -- this is explicitly blocked from operating (it once [...]

  posted in MySQL by shlomi

• MySQL error handling on server side: a NO GO!

  July 18, 2012

  There is no reasonable way to catch and diagnose errors on server side. It is nearly impossible to know exactly what went wrong. To illustrate, consider the following query: INSERT INTO my_table (my_column) VALUES (300); What could go wrong with this query? We might hit a UNIQUE KEY violation Or a FOREIGN KEY violation my_column [...]

  posted in MySQL by shlomi

• On stored routines and dynamic statements

  June 18, 2012

  I very much enjoyed reading Overloading Procedures by Michael McLaughlin: good stuff! I'm dealing with similar issues in common_schema/QueryScript, where I implement a whole new scripting language within MySQL, interpreted by stored routines. I am now finalizing the next version of common_schema/QueryScript, with a major addition to the scripting language to put yet even more [...]

  posted in MySQL by shlomi

• Auto caching tables

  March 6, 2012

  Is there a way to create a caching table, some sort of a materialized view, such that upon selecting from that table, its data is validated/invalidated? Hint: yes. But to elaborate the point: say I have some table data_table. Can I rewrite all my queries which access data_table to read from some autocache_data_table, but have [...]

  posted in MySQL by shlomi

• Documentation in SQL: CALL for help()

  January 11, 2012

  Documentation is an important part of any project. On the projects I maintain I put a lot of effort on documentation, and, frankly, the majority of time spent on my projects is on documentation. The matter of keeping the documentation faithful is a topic of interest. I'd like to outline a few documentation bundling possibilities, [...]

  posted in Development, MySQL by shlomi