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 5.1

FEATURE

REAL SQL Server Released

REAL Software ships easy-to-use server product

Issue: 5.1 (September/October 2006)
Author: Will Leshner
Author Bio: Will Leshner is one of the principle developers of REAL SQL Server. He also develops and maintains the REAL SQL Database engine built into REALbasic.
Article Description: No description available.
Article Length (in bytes): 3,721
Starting Page Number: 11
Article Number: 5108
Related Web Link(s):

http://www.realsoftware.com/download/

Excerpt of article text...

REAL Software recently released REAL SQL Server, a server product that, together with REALbasic, makes developing and deploying client/server products a snap. REAL SQL Server is a fast, full-featured SQL server that uses the same database engine that powers REAL SQL Database, REALbasic's built-in single-user database engine. That means you can take the same database files you have been using with the REAL SQL Database and start serving them immediately with REAL SQL Server.

REAL SQL Server runs on all the same platforms as REALbasic itself: Mac OS X, Windows, and Linux. If you are developing a client/server application in REALbasic, then you will be able to run the server on the same platform.

Launching REAL SQL Server is as easy as launching the REAL SQL Server application that is included in the server installation. REAL SQL Server application allows you to launch and quit the server, as well as set basic server settings. But you don't have to run the server using REAL SQL Server application. You can launch the server from the command line, or from a shell script. This means that the server will happily operate in a headless server environment.

REAL SQL Server also comes with a full-featured administration application that allows you to create users and groups, assign privileges, set up backups, create databases, tables, and indexes, and monitor the health of the server. Unlike REAL SQL Server, which must run on the same machine as the server itself, the REAL SQL Server Admin can be run on any machine. As long as it has an Internet connection, it can connect to any server.

To start developing client applications for REAL SQL Server, simply drop the plugin that comes with the server into REALbasic's Plugins folder and you are ready to start writing code. Because REAL SQL Server uses the same database engine as the REAL SQL Database, any code you have written for REAL SQL Database will work, with only minor modifications, with REAL SQL Server. In fact, the only thing you really have to change is the way you connect to the database. With REAL SQL Database, you specify a FolderItem to connect to. With REAL SQL Server, you supply host, username, password, and database information in order to connect to a database. All the rest of your database code (and SQL) can remain the same.

REALbasic and REAL SQL Server together make an unbeatable client/server development system. REALbasic makes it easy to build clients, and REAL SQL Server makes it easy to deploy, setup, and administer servers. Plus, having both products come from the same company greatly simplifies support issues.

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