MacHouse Software

 

   Last updated: March 17, 2011

 

 

 

 

 

ViewSQL Pro - User's Guide

 

Mac software ViewSQL Pro

 

 

1. Installing and uninstalling ViewSQL Pro

Please read the README file that comes with the application.  Or click here to download one.  Click here to download a sample encrypted database.

 

2. Preferences

ViewSQL Pro is a simple application.  So there isn't much to offer in Preferences.  But let's take a quick look.  Click on the Preferences button on the Toolbar menu.  (See Screenshot P-1.)

 

 

Mac software ViewSQL Pro

Screenshot P-1

 

Mac software ViewSQL Pro

Screenshot P-2

 

 

When you first launch ViewSQL Pro, your default export folder will be automatically set to Desktop.  And you can change it inside the box that says Default export folder.  (See Screenshot P-2.)  Simply, click on the Set button to set a new default export folder.  This default export folder is used for Create (creating SQLite databases), by the way.

There are a couple of checkboxes under Settings.  (See Screenshot P-3.)  So let's see quickly what they are for.  If you enable Run update notification, ViewSQL Pro will access our web server to see if there are any software updates available every time you launch the application.  Enable Require restart if you want to automatically let the application relaunch itself after you close Preferences.  By restarting the application, you can make sure that you will start with new settings.

 

 

Mac software ViewSQL Pro

Screenshot P-3

 

Mac software ViewSQL Pro

Screenshot P-4

 

 

Switching to Database, you can set default database values.  (See Screenshot P-4.)  When you fill these edit fields, ViewSQL Pro will use them as default values.  Make sure you will not leave a space in the database table name.  As for Default fields, all you have to do is write fields, all of which are followed by their data types (Integer, Text, Blob, Varchar...).  And these fields must be separated by a comma with or without a space.  Click here for more information.  If you use SQLite or REAL Studio, you should know how to set table fields.  So we won't go into details.

 

 

Mac software ViewSQL Pro

Screenshot P-5

 

Mac software ViewSQL Pro

Screenshot P-6

 

 

Next, let's switch to View (formerly labeled Passwords).  As the tab name suggests, it's used for View, where to see the contents of database/tables.  This is where you can import encrypted REALSQL database files one by one so that ViewSQL Pro can store encryption keys for you.  Simply, click on the Add button and drag and drop an encrypted REALSQL database file onto the drop box.  (See Screenshot P-5.)  After entering its encryption key, press the Save button.  If you select a database file and click on the Delete button, you will get a confirmation window.  (See Screenshot P-6.)  Click on Yes to delete the selected database profile.

 

3. Create

 

When you launch ViewSQL Pro, you will always start with Create.  Create is where you can generate SQLite database files, which can also be used with REALSQL.  On the left-hand side of the window, you should see a total of five green/red validation lights.  Then there's a button at the bottom, which is probably grayed out for the moment.  Only if all five validation lights are green, the Create button will become accessible, avoiding possible problems.  The descriptions of these validation lights are given in the following.

 

  • Top one - If a file with the specified database name already exists at the export destination, the light will become red.  If the database file name is not even specified, then it will become dark gray.  If no file with the same name exists at the export destination, the light will become green.
  • 2nd one from the top - If the export folder exists, the light will become green.  Otherwise, it's red.
  • 3rd one from the top - If the database file name is valid, the light will become green.  If it's invalid, it's red.
  • 4th one from the top - A database must have at least one table.  If no table is selected, the light will become red.
  • 5th one from the top - A database cannot contain tables sharing the same name.

 

If you have set an appropriate default database name in Preferences, you should have only one red light (4th one) to start with.  So click on the New button to create a database table.  In the next window, the Okay button may be grayed out.  This button will remain grayed out if the table name is invalid (No space is allowed.) and/or no field is entered.

 

 

Mac software ViewSQL Pro

Screenshot 3-1

 

Mac software ViewSQL Pro

Screenshot 3-2

 

 

As stated before, the SQLite database format is such that you must have one or more fields, all of which are followed by their data tapes.  And these fields are separated by a comma.  Don't include parentheses or semicolons.  If necessary, click on the Example check button to set example fields.

 

 

Mac software ViewSQL Pro

Screenshot 3-3

 

Mac software ViewSQL Pro

Screenshot 3-4

 

 

 

If you have set at least one table, make sure any of them is selected.  If necessary, click on Select all to enable all of them.  (See Screenshot 3-3.)  Finally, if the Create button has become accessible, click on it to genereate a database file.  It shouldn't even take a second.  But ViewSQL Pro will require you to wait for 3 seconds.  (See Screenshot 3-4.)  And this window will automatically close itself.

 

 

Mac software ViewSQL Pro

Screenshot 3-5

 

 

 

 

You should be able to crack-open the database file with a text editor like TextEdit though not all characters may not be recognizable.  (See Screenshot 3-6.)  But you should check and see all tables are there.

 

 

    Next page >>