I bet you didn’t know, but OpenBase makes their excellent database server, OpenBase SQL 10, available for free for REALbasic developers (OpenBase Unlimited for REALbasic).  This edition includes Code Builder, a free license to On-Target Reports and requires you to use the REALbasic Connectivity module (not the plugin) to connect.
Scott Keith of OpenBase was kind […]

Let’s take the entities we created last time and turn them into tables. Once we do this we’ll create these tables in a REALbasic database using SQL.
Mapping entities to tables is fairly straightforward. Typically each entity becomes a table and each attribute becomes a column. You may have to do a few adjustments of table […]

In this article we will discuss some basic database design skills such as how to identify entities, attributes, and relationships. We will also learn what it means to normalize a database. Let’s get started!
Database Analysis
This is the first step when designing a relational database. In the analysis phase, we are looking to identify entities and […]

As I’m sure you are aware, our favorite programming system, REALbasic, has built-in database capabilities. These capabilites are frequently misunderstood and underutilized. My goal while writing these articles is to help you improve your database knowledge so that you can determine when a database is appropriate for your application.
What is a Database?
There are […]