| |
|
Freaky SQL is a tool for REALbasic developers which allows the creation, viewing, and modification of REAL Databases for use in REALbasic projects in version 5.5 and later.
|
Forward Format Conversion
One of the first things you'll most likely want to do with Freaky SQL is convert data from your old formatted databases into version 5.5 databases. Yes, Freaky SQL can do this with ease.
Until now, to do this you either needed to know that there was a converter burried on REAL Software's FTP site, fork over hard-earned cash to get a third party app to do it, or spend the time to hand-code a converter specific to your application which is as good as spending money in the first place.
|
|
| Schema Editor
If you're paranoid about the conversion working, or if you're creating a new database from scratch, the simple and easy to use schema editor will be of great use to you. With a few simple clicks of the mouse and entering names, you can edit tables in a more intuitive manner than REALbasic's own editor! And because we've wanted to make Freaky SQL as full featured and useful as possible, Freaky SQL can edit tables which contain data. This means you can actually change column names and types without have to start over from scratch!
|
 |
| Data Viewing and Modification
Aside from the fact that the REALbasic IDE can't edit data at all without the aid of SQL statements, when it comes to viewing and editing data, REALbasic's built-in tools are simply no match. Editing data is as simple as clicking in a field and changing it. Adding a row is as simple as clicking a button. Deleting is a breeze as well; Just select the rows you want to delete and click a button.
Freaky SQL's filter area will also come in handy. If you've got hundreds or thousands of rows of data and simply want to change a handful or even just one of them, enter in a few search critera fields and off you go. You can even use a custom SQL 'WHERE' clause to help you.
|
 |
| Custom SQL Execution
In those cases where you need to execute an entirely customized SQL statement, such as a complicated 'SELECT' or finding the MAX of a column, the Query tab allows you to do just that.
|
 |
| CSV & XML Importing/Exporting
And as all decent database tools should, Freaky SQL provides full CSV and XML importing and exporting, as well as the ability to export table schemas as SQL to be excuted later.
|
 |
|
|
|
