databases Archive

  • I’m preparing for release 1.0 of DbFit — one of the new things will be support for In/Out parameters. A pre-release with this functionality is now available for testing. - To use In/Out parameters, just define two columns for the same parameter. The one for OUT direction should have a...

    DbFit – experimental support for In/Out parameters

    I’m preparing for release 1.0 of DbFit — one of the new things will be support for In/Out parameters. A pre-release with this functionality is now available for testing. - To use In/Out parameters, just define two columns for the same parameter. The one for OUT direction should have a...

    Continue Reading...

  • For the last couple of years, I’ve been working with mid-size and large UK bookmakers, trying to introduce agile development practices into those environments on several projects. Although for most of the readers of this blog using agile practices is no longer a question, agile development is fairly rare when...

    Fighting the monster

    For the last couple of years, I’ve been working with mid-size and large UK bookmakers, trying to introduce agile development practices into those environments on several projects. Although for most of the readers of this blog using agile practices is no longer a question, agile development is fairly rare when...

    Continue Reading...

  • One of the most interesting new features of Oracle 11 for me is the new function result caching mechanism. Until now, making sure that a PL/SQL function gets executed only as many times as necessary was a black art. The new caching system makes that quite easy – here is...

    Speed up database code with result caching

    One of the most interesting new features of Oracle 11 for me is the new function result caching mechanism. Until now, making sure that a PL/SQL function gets executed only as many times as necessary was a black art. The new caching system makes that quite easy – here is...

    Continue Reading...