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.
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.
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
This is the general plan ahead for ActiveRecord and ARGen. Please be aware this is a living document.
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!