ARGen - ActiveRecord Generator

Write less code when creating database driven apps

ARGen automates the generation of ActiveRecord classes and template code for a database driven app. ARGen connects to an existing database, scans the schema, and creates a Xojo project to get development started quickly.

More than just class definitions, ARGen also creates user interface elements that perform simple browse, read, edit, add, and delete functionality.

Develop faster by leveraging the power of one of the most well known ORM libraries for Xojo. 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.

ARGen project window

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 and pre-set some options. Developers can also manually select the tables and views to generate as well as refine the property type definitions.

With class configuration squared away, the next step is interface configuration. Select tables and fields to process and ARGen will generate UI elements to browse, read, edit, add, and delete rows. Flexible options allow developers to define editor types and labels at the individual field level.

... then click Generate!

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 ActiveRecordSample ARGen Project

What's new in ARGen?

API 2.0

ActiveRecord and ARGen have both been updated to support Xojo API 2.0

Multiple Namespaces

The ActiveRecord library now supports multiple database connections in one project

Verify Class Properties

Verify that class properties still exist in the database at runtime

  • Other new features:
  • Console Xojo Project Type
  • Foreign keys that are nil are now inserted as NULL values
  • Customizable naming for arrays, objects, and private properties
  • Completely redesigned interface and code generation engine
  • Easily switch between any project type after connecting
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 designed 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.

Roadmap

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

  • Roadmap: ActiveRecord and ARGen
  • Modify Templates - Custom template definitions for additional properties
    In Progress
  • Package Manager - Add-on libraries à la carte
Version History / ChangelogDownload Older VersionsLicense Terms