ActiveRecord Generator for Xojo

Save time and money creating database driven apps

Design of the database schema occurs early in the development process -- often before the the software interface. ARGen connects to a database, scans the schema, and allows developers to quickly build the Xojo classes that interact with the database. ARGen then creates a project with classes and code, writing the repetitive tedious parts in seconds.

Dragging interfaces together can be a real drag. ARGen creates user interface templates that perform basic BREAD (browse, read, edit, add, delete) functionality. No, that's not skirting around saying CRUD. There's actually an extra element to BREAD: Browsing!

Develop faster by leveraging the power of one of the most well known ORM libraries for Xojo. ARGen is also bundled with several optional libraries that include an audit trail and schema updating tools. ActiveRecord offers the features professionals need without sacrificing the simplicity every citizen is hoping to find.

Give both a whirl, and simplify your database code. 

Connection list

How ARGen Works

A quick overview of how to use ARGen

First, connect to any one of the supported database types to scan the schema and get a project started. ARGen supports CubeSQL, Microsoft SQL Server, MySQL, ODBC, PostgreSQL, and SQLite connections.

ARGen will determine as much as possible from the database schema, but allows developers fine tuned control over ActiveRecord class generation. Select the tables and views to generate as well as refine the property type definitions. ARGen can also generate code to automatically lazy-load class objects.

With class configuration squared away, the next step is interface configuration. Select tables and fields to generate BREAD UI elements for. Flexible options allow developers to define editor types and labels at the individual field level.

Finally, select libraries to include as if they were toppings on a pizza and click Generate Project.

... and you're ready to roll!

Why use ActiveRecord?

Put simply: You will write less code

ActiveRecord abstracts database operations to Xojo code. Using the library, tables are classes and field columns are properties. This makes table and column names appear as auto complete suggestions. Developers access records with Xojo code - not SQL - which helps prevent runtime exceptions.

More about ActiveRecord

Roadmap

This is the general plan ahead for ActiveRecord and ARGen. Please be aware this is a living document.

  • Roadmap: ActiveRecord and ARGen
  • API 2.0 ActiveRecord Library
    Major Version In Progress
  • API 2.0 User Interface Generation Summer 2020
  • Multiple DB - Support multiple namespaces in one project
  • Modify Templates - Custom template definitions for additional properties
  • Unify iOS - Connect to database, generate any project type
What of Xojo Web 2.0?

It is not feasible to work on user interface generation features until the Xojo Web 2.0 product has officially released. The ActiveRecord API 2.0 library is planned to support any API 2 only Xojo frameworks. When the new Xojo Web product is released the library will be re-tested and evaluation for UI generation will begin.

Please check back for the updated roadmap once Xojo Web 2.0 has released!

Copyright Tim Parnell, 2020