In general, databases can be divided into two categories: single-user databases and database servers.
Databases included with Real Studio
SQLite (aka RealSQLDatabase) is the single-user database engine included with Real Studio. SQLite is a public domain database and is used by all kinds of software from browsers such as Firefox to programming tools such as Real Studio and frameworks such as CoreData.
PostgreSQL is a full-blown database server. It is open-source and free, available for use for just about any purpose. It can be a bit tricky to install, but is powerful and fast.
PostgreSQL is cross-platform and works on Linux, OS X and Windows.
With Real Studio you use the PostgreSQLDatabase class to connect to a PostgreSQL database server.
Now owned by Oracle, MySQL is also an open-source database server, but has less comprehensible licensing. Real Studio is able to connect to the Community (free) edition of MySQL, but this edition usually requires you to open source software that connects to it (due to its GPL license). MySQL is very easy to install and is often available by default on many web servers. If you choose to use it, be sure you understand its licensing.
MySQL is cross-platform and works on Linux, OS X and Windows.
Use the MySQLCommunityServer class to connect to MySQL.
Oracle Database is one of the most powerful database servers around. It is often used for enterprise software and by larger companies. Oracle Database has a reputation for being a beast to manage and configure, but is also known to be fast. It can also be rather expensive. It runs on Windows and Linux and used to be available for OS X, but it does not look like that is an option any longer.
There is also a free Oracle Database Express Edition.
The OracleDatabase class is used to connect to Oracle database.
Microsoft SQL Serverhttp://www.microsoft.com/sqlserver
Microsoft SQL Server is a database server that runs only on Microsoft Windows. It is generally easy to use. Both paid and free versions are available.
The MSSQLServerDatabase class is used to connect to Microsoft SQL Server. It can only be used with Windows applications.
ODBC is not a database, but rather a standard for connecting to databases. It stands for Open DataBase Connectivity. Originally created by Microsoft in the 1990s, it is now an industry standard. Using Real Studio's ODBC plugin, you can connect to any database for which you have a driver. Driver availability varies by platform, but I have successfully used ODBC to connect to Microsoft Access, FoxPro and even IBM DB/2 mainframes.
Use the ODBCDatabase class to connect to any database for which you have an ODBC driver.
Other Databases that work with Real StudioThese databases are provided by 3rd party developers and all easily work with Real Studio.
CubeSQL is a database server that uses SQLite as the database back-end. It is fast and extremely easy to configure. CubeSQL is cross-platform, running on Linux, OS X and Windows.
To use cubeSQL with Real Studio, you install its plugin and use the CubeSQLServer class to connect.
OpenBase SQL is a database server that was originally created for OpenStep. It works on OS X, Windows and Linux.
OpenBase SQL comes with a custom library (written in Real Studio itself) to connect to the database.
FrontBase is a database server. It is freely available for Linux, OS X and Windows. A native plugin for Real Studio is available from FrontBase, but it is Carbon-only.
Valentina is both a single-user database and a database server. It is cross-platform for Linux, OS X and Windows and uses a native plugin for Real Studio. Valentina is a "columnar" database and has a reputation for speed.
Studio Stable Databasehttp://www.studiostable.com/database
Studio Stable Database is a database server that is built on top of SQLite. It is intended to be a simple way to bring multi-user support to your SQLite applications. SSD uses a library (written in Real Studio) to connect to the database and is available for free.
MBS SQL and JDBC Pluginshttp://www.monkeybreadsoftware.de/realbasic/plugin-sql.shtml
If you need to connect to a database that is not listed here, be sure to check out the SQL Plugin from MonkeyBread which has support for Oracle, Microsoft SQL Server, Sybase, DB2, Informix, Interbase/Firebird, Centura SQLBase, MySQL, PostgreSQL, ODBC and SQLite.
In addition, the JDBC plugin (Java DataBase Connectivity) is particularly useful, allowing you to connect to any database for which there is a JDBC driver.
Database UsageOther than SQLite, databases that use the Real Studio database API require Real Studio Professional, Web or Enterprise. When Real Studio 2012 Release 2 is available, databases that use the database API will need a Database Access license in order to use them in your built apps.
The following databases work with Real Studio Personal and will not require a database license for Real Studio 2012 Release 2 (mostly because they do not use the standard Real Studio database API):
- SQLite (standard API)
- OpenBase (proprietary class library)
- Valentina (plugin with proprietary API, standard API is also available but not required)
- Studio Stable Database (proprietary class library)
- MBS (proprietary API)
All other databases connect to the database using our standard database API and require Real Studio Professional, Web or Enterprise for now and a Database license starting with Real Studio 2012 Release 2.