computerwoche.de

Archiv

Database System GS-Base Is Easy as a Spreadsheet--And the Price is a Steal

12.03.2012
At $20, GS-Base 9 is very inexpensive and requires virtually no prior database knowledge to use. Furthermore, it uses a number of metaphors and options which should be very familiar to those comfortable with spreadsheets, a fact that makes it useful to a large set of business users who rarely venture away from Excel. Indeed, it shares many of the functions and syntax found in Citadel's inexpensive, but functional, .

Creating a database is GS-Base is straightforward; so is creating the tables within that database. The user follows the basic pattern of creating fields and setting their types. Once created, the table structure can be edited, using clear dialog box that displays the fields in a tree structure on the left, and the relevant options and values on the right.

Field types in GS-Base are fairly limited: Text (for short text, like names or addresses), Number, Date, and File/Image. Numbers can be formatted as currency, integer, and so on, but you can't directly specify that a field can only be an integer. You can, however, enter a formula into the field that will perform a conversion on entered data, such as rounding down entered values. Or, you're supposed to be able to; I was unable to get the formula to return anything but an error.

This really is the heart of all of my issues with GS-Base; there are too many small bugs that keep popping up and undermining what could be a very useful tool.

GS-Base allows you to specify formulas for fields, rather than having them contain entered values, and this is where a lot of the program's functionality lies. You can use formulas use to create references to other tables, for example look up an item's price and availability by referencing the item's name. The formula syntax of GS-Base is very similar to that of most spreadsheet programs: Few database developers would establish a relationship via "VLookup". In Version 9 of GS-Base, an auto-increment feature, which is virtually essential to make this style of relationship practical, has been... sort of... added. You can set a field to autoincrement, and then hit Ctrl-T after you enter a row to set the field value appropriately. While this is easier than manually entering a unique ID, it's still inferior to the expected behavior of an autoincrement field filling the data in automatically.

The most useful feature of GS-Base is the built-in pivot table feature. This allows for rapid totals and sub-totals of information, with the ability to easily switch how information is categorized and broken down. That this feature is so prominent further cements the concept that this is "The database for spreadsheet users."