allyourdatabase.blogspot.com
All Your Database Are Belong To Me: Introducing DrySQL
http://allyourdatabase.blogspot.com/2006/11/introducing-drysql.html
Friday, November 03, 2006. After complaining about Object-Relational Mapping frameworks for years, I finally decided to do something about it. My primary problem with today's ORM frameworks is that I end up defining my DB schema twice. But I have yet to come across a solution that I consider clean, efficient, simple, or remotely DRY (I would be interested in hearing about some though). After experimenting with ActiveRecord and Ruby, I became convinced that I was onto something. Lastly, ActiveRecord provi...
allyourdatabase.blogspot.com
All Your Database Are Belong To Me: Merits of Defining your DB Schema in your Application?
http://allyourdatabase.blogspot.com/2007/08/merits-of-defining-your-db-schema-in.html
Saturday, August 25, 2007. Merits of Defining your DB Schema in your Application? Late last year I developed and released a Ruby plugin called DrySQL. That aims to eliminate any traces of DB schema re-definition in your application. The philosophy behind this effort is that the DB is indeed the place that table structures, constraints, and relationships should be defined, and that it is redundant to re-define any of these artifacts in an application or anywhere else. 1) Controlling The Cost of Change.
infoq.com
ORM with DrySQL and ActiveRecord
https://www.infoq.com/articles/DrySQL
Facilitating the spread of knowledge and innovation in professional software development. 1,296,180 Jul unique visitors. Creating RESTful Services with T4 Based on Model and Interfaces. When generating RESTful services with WebAPI, a lot of boilerplate code has to be implemented. Amel Musić demonstrates how T4 and EnvDTE can be used to create a flexible code generator that dramatically reduces the amount of time and effort this takes. Featured in Architecture and Design. All in Architecture and Design.
allyourdatabase.blogspot.com
All Your Database Are Belong To Me: November 2006
http://allyourdatabase.blogspot.com/2006_11_01_archive.html
Friday, November 17, 2006. Multiple Cascade Paths Error in SQL Server. Has given me an opportunity to learn about the subtle differences between many DBMSs. As my project is designed to run on a number of DBMSs, I crafted a reasonably complex test DB schema that I create on each DBMS in order to run my unit tests. I'll explain the error using the following table layout. Note that all the FOREIGN KEYs were created with cascaded delete and update options. The above error occurs because "a table cannot appe...
allyourdatabase.blogspot.com
All Your Database Are Belong To Me: ORM Frameworks...the horror! (And a solution)
http://allyourdatabase.blogspot.com/2006/10/or-mapping-frameworks.html
Sunday, October 22, 2006. ORM Frameworks.the horror! I've used a lot of Object-Relational Mapping frameworks over the years in the enterprise space. They're supposed to make it easier to objectify relational data, and they do. However, they all seem to force me to contravene one of the most important principles (IMO) of software development: Don't Repeat Yourself. What happens if I change the structure of my DB? On any given table, I can change the names of the columns, remove/add columns, and my Rails a...
allyourdatabase.blogspot.com
All Your Database Are Belong To Me: October 2006
http://allyourdatabase.blogspot.com/2006_10_01_archive.html
Tuesday, October 24, 2006. Some Interesting MySQL facts. I've been doing a lot of research into the internals of MySQL in order to develop. And here are some useful bits of information that I came across:. Check constraints are not supported in the latest version of MySQL (5.1.x). The syntax for check constraints is supported, but any check constraints in your alter/create table syntax are just ignored. For details about implicit defaults). Suppose I create the following table:. If I query the informatio...
allyourdatabase.blogspot.com
All Your Database Are Belong To Me: Generating ActiveRecord Data Validations Automatically
http://allyourdatabase.blogspot.com/2006/11/generating-activerecord-data.html
Tuesday, November 07, 2006. Generating ActiveRecord Data Validations Automatically. Having recently released DrySQL. Which automatically generates validations for ActiveRecord data classes that enforce the constraints declared on your DB, I thought it might be useful to start a discussion about how this works (or should work). My (possibly naive) belief is that the value of application-side validations that enforce DB constraints is twofold:. These validations can be generated automatically by querying t...
allyourdatabase.blogspot.com
All Your Database Are Belong To Me: DrySQL: Answering the Challenge
http://allyourdatabase.blogspot.com/2006/11/drysql-answering-challenge.html
Saturday, November 04, 2006. DrySQL: Answering the Challenge. To support some DB tooling at the financial organization that employs me, I was happy to learn that the functionality provided by DrySQL. Is actually the subject of Dave Thomas's (of Pragmatic fame) challenge to the Rails community at RailsConf 2006. The video of the keynote is available here. Leon Katsnelson, who is involved with the development of the official IBM Rails DB2 adapter. Somehow, I will be interested to hear your feedback about it.
allyourdatabase.blogspot.com
All Your Database Are Belong To Me: DB2 iSeries Adapter for Rails
http://allyourdatabase.blogspot.com/2007/02/db2-iseries-adapter-for-rails.html
Thursday, February 01, 2007. DB2 iSeries Adapter for Rails. I recently released a new version of DrySQL. A Ruby plug-in) that supports DB2 iSeries. I didn't feel it was appropriate to post this on IBM's DB2 Rails Forum, so hopefully people who are interested in trying out this functionality will find this post. Note that you will need to install DB2 Connect and the IBM DB2 Rails adapter in order to use this functionality. You can find more information about this on the DrySQL homepage.