Database Module
The Database Module is the easiest, fastest and most convenient way to use SQL databases with Ignition.
Installing the Database Module sets you up with everything you need to start working with a database in Ignition immediately.
The Database Module embeds a fast, pure Java SQL database engine called H2 in Ignition. In addition it provides a simple graphical user interface called the Database Editor that is used to create/alter/drop database tables and view/query/edit data in database tables.
Upon installation the Database Module does the following things:
The Database Module is free. Download it here: Database-Module.modl.
The Database Module runs where Ignition runs i.e. Windows, Linux, OS X etc. It runs in Ignition 7.7.8 and up and Ignition 7.8.3 and up and Ignition 7.9.0 and up.
Documentation for the Database Module is here: http://doc.perfectabstractions.com/modules/database/
Installing the Database Module sets you up with everything you need to start working with a database in Ignition immediately.
The Database Module embeds a fast, pure Java SQL database engine called H2 in Ignition. In addition it provides a simple graphical user interface called the Database Editor that is used to create/alter/drop database tables and view/query/edit data in database tables.
Upon installation the Database Module does the following things:
- Embeds the H2 database engine into Ignition.
- Automatically creates a default H2 datasource called "DefaultH2". This can be used immediately to create database-backed Ignition projects.
- If not already installed, installs the Database Editor project.
The Database Module is free. Download it here: Database-Module.modl.
The Database Module runs where Ignition runs i.e. Windows, Linux, OS X etc. It runs in Ignition 7.7.8 and up and Ignition 7.8.3 and up and Ignition 7.9.0 and up.
Documentation for the Database Module is here: http://doc.perfectabstractions.com/modules/database/
|
|
See the the video demo of the Database Module:
Video: Install A SQL Database System in Ignition in 30 Seconds
Here's a video that shows the Database Module install a SQL database system and a graphical user interface for managing databases and create a database and configure a database connection, all in 30 seconds:
You can use the Database Module to easily and quickly start the development of Ignition projects. You can use it for testing, and you can use it for demonstration purposes, like showing how easy it is to install and use SQL databases with Ignition. You can use it for other purposes you can imagine.
The databases you make with the Database Module can be used for the life of your applications or you can switch to another database system at the end of development or at some point in the life of your projects. The database system provided by the Database Module tries to be compatible with popular database systems and provides compatibility modes to make switching to other database system easier.