Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 9.4

COLUMN

Serving SQLite

Using SQLite as a Server

Issue: 9.4 (May/June 2011)
Author Bio: Paul Lefebvre has been using Real Studio for 9 years. His company, LogicalVue Software, specializes in creating database applications using Real Studio. Paul also runs the RBDevZone community site and is a founding member of the Association of REALbasic Professionals.
Article Description: No description available.
Article Length (in bytes): 5,855
Starting Page Number: 82
Article Number: 9411
Related Link(s): None

Excerpt of article text...

I presented a couple sessions at the ARBP Real Studio Summit this past March in Atlanta. For my databases session, I gave an overview of some databases that work well with Real Studio and then I talked about object-relational mappers.

Although I briefly touched on the topic of ORM many years ago in this column, it seems like it is worth revisiting.

Object-Relational Mapping Overview

During my session, I asked the audience: "How many of you use an ORM in your projects?". Out of 45 people or so, only 2 or 3 raised their hands. I was quite surprised by this because I rarely have a project that doesn't use an ORM. In talking with people after the session, it seems like a lot of people are interested in the topic, but don't quite understand how to get started.

Simply stated, an ORM is a way to deal with your relational database in an object-oriented way.

Without using an ORM you will communicate with your database using SQL, RecordSets, DatabaseRecords and other features of Real Studio. This all works well enough, but it is not object-oriented and can get a bit repetitive. It also tends to result in your database code being sprinkled throughout your application, which can become a problem if you ever need to switch to another database engine, for example.

...End of Excerpt. Please purchase the magazine to read the full article.