ORM DataModel

DataModel is an ORM system integrated into Jet. The definition of ORM says that it provides data conversion between a relational database and an object-oriented application. That definition is accurate, but I would add that it really makes the job a lot easier in the first place, and especially eliminates the work that is really repetitive and annoying. Jet DataModel doesn't just provide data conversion between objects and the database by a long shot. While it's a basic and important feature, it does so much more:

  • It looks at entire sets of entities as one big entity - see the modeling principle and internal relations section - and connect these larger entities using external relations.
  • Definitions and data modeling with a dedicated tool within Jet Studio that will make your job fundamentally easier.
  • Generate forms based on data models. While this is not a Jet DataModel thing, but a subsystem of forms, in practice the two are used together.
  • The ability to directly create REST APIs on top of data models.
  • A backend for MySQL/MariaDB, SQLite, PostgreSQL, MS SQL is integrated and Oracle support is in the works.
  • A properly designed and developed application can be run on a variety of relational databases.
  • If you are creating modular applications, Jet Studio offers the ability to generate a data administration module (CRUD - view, add, edit and delete data, including logging operations and checking permissions) directly on top of the data model. Thus, you can have the basics of certain functionality ready in a few minutes - literally and without exaggeration.
  • Easier and very efficient query creation.
  • There are a number of methods to upload data, including partial instance upload or working with raw data.
Previous chapter
Main module class - Jet\Application_Module
Next chapter
Modeling principle