SQLite Migrator 1.3.0 Now Available
February 12th, 2010, by Paul Lefebvre in Databases
Quick and easily migrate your data from any database to SQLite. Press Release SQLite Migrator Web Site

SQLite Manager on Sale
September 14th, 2009, by Paul Lefebvre in Databases
For those of you that use SQLite (REALSQLDatabase) with REALbasic, you might be interested to know that SQLite Manager (from SQLabs) is on sale at MacZot today for only $24 (half price)!

REALbasic Reporting Tools
June 3rd, 2009, by Paul Lefebvre in Databases, Reports
Reporting Tools that work with REALbasic remain a hot topic, so I thought it would be worth a brief post to list the options that are currently available. On-Target Reports: $200 The oldest and most mature of the reporting solutions. It is a set of encrypted REALbasic classes that you drop in your project....

New: SQLite Migrator 1.3.0
February 2nd, 2009, by Paul Lefebvre in Databases, Featured Articles, General
If you use REALbasic’s built-in database engine, then you may find SQLite Migrator useful. It allows you to migrate any database that you can connect to using ODBC to SQLite/REALSQLDatabase. It works great with Access, FoxPro, MySQL and just about any database you might be using.

Starting with SQLite (aka REALSQLDatabase)
January 9th, 2009, by Paul Lefebvre in Databases
This article originally appeared in REALbasic Developer Magazine 4.4 (Mar/Apr 2006) REAL SQL Database (REALSQL) is the single-user database engine included with REALbasic. It is based on SQLite 3 (http://www.sqlite.org), a fast and powerful embedded open-source database engine. REALSQL supports all...

Some Stored Procedure Examples
December 16th, 2008, by Paul Lefebvre in Databases
This article originally appeared in REALbasic Developer Magazine 4.3 (Jan/Feb 2006) Now that we know what stored procedures are, let’s take a look at a few more examples. The accompanying Code Listing shows a simple stored procedure for MySQL, PostgreSQL, OpenBase, FrontBase, SQL Server and Oracle....

An Overview of Stored Procedures
December 12th, 2008, by Paul Lefebvre in Databases
This article originally appeared in REALbasic Developer Magazine 4.2 (Nov/Dec 2005) If you find yourself working with database servers, you may be wondering about stored procedures. Depending on who you talk to, stored procedures are either something you should definitely be using or something you should...

Database Servers: FrontBase
December 11th, 2008, by Paul Lefebvre in Databases
This article was originally published in REALbasic Developer 6.1 (Nov/Dec 2007) FrontBase is a full-featured database server that is available for Mac OS X, Linux and Windows. It was created by a Denmark company and was initially release just for Mac OS X. But in 2004, it went cross-platform with releases...

Free OpenBase SQL 10 for REALbasic Developers
January 4th, 2008, by Paul Lefebvre in Databases
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...

Databases 103: Creating Tables and Data
March 1st, 2007, by Paul Lefebvre in Databases
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...