Databases for REAL
An easy database system
Issue: 9.6 (September/October 2011)
Article Description: No description available.
Article Length (in bytes): 4,797
Starting Page Number: 82
RBD Number: 9613
Resource File(s): None
Related Web Link(s):
Known Limitations: None
Excerpt of article text...
Last time, I first mentioned Storm, the object-relational mapper that I use on nearly all my Real Studio projects. Since my first presentation on Storm at the ARBP Real Studio Summit in March, I've had many people ask if I would make Storm available for purchase. I'm happy to announce that Storm is now available on my website (http://storm.logicalvue.com).
Before becoming a full-time Real Studio consultant, I primarily worked with Microsoft .NET. The company I worked for had an in-house ORM that they used to connect to Microsoft SQL Server. After having worked with this for a while, I quickly came to prefer using an ORM when dealing with database access.
When I first started doing Real Studio consulting, I quickly realized that I would need to have my own ORM or I would go crazy repeatedly writing the same SQL statements and related commands.
Originally I would develop an ORM that was specific for each project. This would simply be a set of classes that matched the database structure, with one class for each table and a property on each class for each column. I then would have custom Save and Load methods on each class to communicate with the database. This worked OK, but it was quite a bit of work to set up, particularly for more complex database designs.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.