Realbasic DOM Wizard 2008

What is DOM Wizard?

First of all, the name. DOM is well known acronym for Document Object Model. However, in the case of DOM Wizard we alter that slightly to be Database Object Model. Many refer to this as a Object-Relational Mapping (ORM).  Bottom line, DOM Wizard is a developer's tool that steps (wizard) you through a process that generates Realbasic classes to create an object model based on your database design.

DOM Wizard has 3 main goals. First, abstract the database from the developer so that the developer only has to think about classes, objects and properties and not databases, tables and columns. Second, free the developer as much as possible from the often redundant and always mundane and tedious SQL maintenance tasks. Third, give the developer the ability to inject her/his own code into the generated classes and also allow those classes to be extended. The result is an extremely rapid, reliable and repeatable development process.

Why do you want an object model of your database?

Let’s go back to those 3 main goals and talk about the details.

  • Abstraction – Referencing your objects and properties with dot notation (Customer.LastName, Order.Total) is a good thing. Referencing strongly typed objects that map directly to your database column data types is an even better thing. Plus, DOM Wizard has built in "SelectBy" methods that get the data from your database and populate your objects for you. With DOM Wizard, all you need to do to get a "Customer" for example, is call Customers.SelectBy_CustomerID(databaseConnection, YourCustomerID). When you are ready to save that data back to the database, all you need to do is call Customers.Save(databaseConnection).
  • Maintenance – Our belief is that 90% of the SQL you "would have written" is written by DOM Wizard. Of course you will have scenarios that are out of the scope of DOM Wizard, but for the most part you are freed from all that work.  Plus, when database changes occur, it is much easier to modify a SelectBy method call than to figure out a hand written SQL query.  Finally, if a data type change is made or a column is dropped in the database, the compiler will tell you where to change your code.
  • Extensible – The classes generated by DOM Wizard have calculated properties with Get/Set accessors.  Often times developers need to trim, encode or otherwise scrub their data before it is displayed on screen or goes into the database.  Calculated properties are perfect for this type of work.  DOM Wizard allows you to save your own custom code into those Get/Set accessors so you can have greater control of the presentation and data.

You will find that you will not only code faster... you will code better. Your quaility will increase and your data integrity will improve. You will have more time spend on interface and design and you will spend less time debugging SQL errors.

Key Features:

  • Graphical step-by-step code generation interface
  • 100% Realbasic code
  • No plug-ins...except for your database of course
  • Supports Realbasic 2007 or better
  • Supports RealSQLDatabase, PostgresSQL and Microsoft SQL (more to come)
  • Save methods that detect an insert or update
  • Full entity relationship support
  • XML support
  • Extensible and customizable code
  • Collections of objects and much.. much more

Want to be a beta tester?

We are looking for Realbasic beta testers for RealSQLdatabase and PostgreSQL at this time. If you are selected as a beta tester, you will receive a full version of the software when released. Please send us an email @ rbbeta@medianotion.com and tell us about yourself and why you would be a good beta tester.

Have a question? Want more information?

We would love to hear from you. If you would like to make a comment or would just like to be notified when more information is available, please send us an email @ rbinfo@medianotion.com and let us know what is on your mind.