Article Preview
Buy Now
| Print: | |
| PDF: |
REAL SQL Server
Article
Issue: 5.3 (March/April 2007)
Article Description: No description available.
Article Length (in bytes): 4,756
Starting Page Number: 38
RBD Number: 5313
Resource File(s): None
Related Web Link(s):
http://www.sqlabs.net/realsqlserver
http://realsoftware.com/products/realsqlserver
http://realbasic.com/store/realsqlserver_pricing
Known Limitations: None
Excerpt of article text...
Last Summer, REAL Software released their REAL SQL Server product. REAL SQL Server is a database server that is built on SQLite. This is somewhat interesting because SQLite is normally a single-user database engine. You may (or may not) remember from past columns that a database server is typically used when you need to allow multiple people to connect to your database simultaneously, but database servers have many other benefits as well. Overview Essentially REAL SQL Server allows you to turn your single-user REALSQLDatabases into multi-user databases. If you've ever worked with database servers, you know that setting them up and administrating them can be a challenge. REAL SQL Server makes it incredibly easy. To start the server, you just launch the REAL SQL Server application in the Server folder. Give your server a name and you are done. Your server is now running, although it is not actually "serving" any databases. Unfortunately, the server is not a Universal Binary for Mac OS X. Now you can run the REAL SQL Server Admin tool (also not yet a Universal Binary for OS X). Once launched, note the "Path To Databases". Simply copy any existing REALSQLDatabase file that you have to that folder in order to add them to the server. Keep in mind that REAL SQL Server can work with many databases at once. Now you can click the Databases tab in the Admin tool and see the databases available to the server. The Database tab also allows you to create new databases and administer (create/edit tables) existing databases. In addition, you can also create backup schedules for your databases. The Users, Groups and Permissions tabs lets you create user accounts for server access. Unlike single-user REALSQLDatabase, in order to connect to a database on the server, a user account is needed. The admin account is created by default, but you would not want your users using it to access the database because the admin account can do anything. You can create a user account that is part of a group with restricted permissions. Available permissions include: Create Tables
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.
|
