Architecture and Data Blog

Thoughts about intersection of data, devops, design and software architecture

Using rake and activerecord to generate boilerplate DB Code

Generating code that is necessary for standard code

IN many projects, there are tables which need default audit columns such as Created_By, Created_Date, Modified_By, Modified_date and other columns that need to be updated every time some actions are done against the tables and/or columns. This type of functionality can be implemented using triggers.

Posted by Pramod Sadalage on Monday, July 20, 2015

Ruby OCI 2.0 Array binding

How to use stored procedures as interface to the data

We have been doing some data moving lately using Ruby and Ruby-OCI. We started with Ruby OCI 1.0 and did use prepared statements with bind variables (since we are using oracle database and pulling data from an oracle database and pushing data to an oracle database). Later we found this really cool feature in Ruby-OCI8 2.0 where you can bind a whole array and just make one database trip for many database operations.

Posted by Pramod Sadalage on Thursday, October 8, 2009

avatar

Developer, Data Architect, Data Specialist, Author and Thoughtworker

FEATURED TAGS
agile analytics bdd cd data database dba design developer devops evolutionary-design framework index lessons migration news nosql oracle practices refactoring ruby security testing