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)!

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...