# Free SQL databases

**URL:** <https://forum.inductiveautomation.com/t/free-sql-databases/47>\
**Category:** Archived Topics\
**Created:** [April 1, 2006, 6:43pm UTC](https://forum.inductiveautomation.com/t/free-sql-databases/47 "2006-04-01T18:43:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![admin1](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@admin1](https://forum.inductiveautomation.com/u/admin1)\
**Post date:** [April 1, 2006, 6:43pm UTC](https://forum.inductiveautomation.com/t/free-sql-databases/47/1 "2006-04-01T18:43:38Z")

</div>

Free versions include:  
[PostgreSQL](http://www.postgres.com/) - always free  
[MySQL](http://www.mysql.com/) - [Community Edition](http://www.mysql.com/products/database/mysql/community_edition.html) falls under the [GPL license](http://www.gnu.org/copyleft/gpl.html). Don’t sell it to your customer or alter the source code.  
[10g Express](http://www.oracle.com/technology/products/database/xe/index.html) is Oracle’s free database.  
IBM offers [DB Express Community Edition](http://www-306.ibm.com/software/data/db2/udb/db2express/download.html)  
Microsoft offers [SQL Server Express Edition](http://www.microsoft.com/sql/editions/express/default.mspx)

More details about the restrictions [on our web site](http://www.inductiveautomation.com/support/resources/sqldatabases).

---

<div class="post-metadata">

**Author:** ![dymytr](https://avatars.discourse-cdn.com/v4/letter/d/ea5d25/32.png) [@dymytr](https://forum.inductiveautomation.com/u/dymytr)\
**Post date:** [April 12, 2013, 4:02am UTC](https://forum.inductiveautomation.com/t/free-sql-databases/47/2 "2013-04-12T04:02:58Z")

</div>

Propose to add to this list of Firebird RDBMS: [http://www.firebirdsql.org/](http://www.firebirdsql.org/)

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [July 24, 2017, 2:37pm UTC](https://forum.inductiveautomation.com/t/free-sql-databases/47/3 "2017-07-24T14:37:32Z")

</div>

The [Database Module](http://www.perfectabstractions.com/database-module.html) embeds a free SQL database engine into Ignition called H2. The database module is the easiest and fastest way to get started using SQL databases in Ignition.

> **[Database Module](https://www.perfectabstractions.com/database-module.html)**
>
> 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...

---

<div class="post-metadata">

**Author:** ![TruThat](https://avatars.discourse-cdn.com/v4/letter/t/ea666f/32.png) [@TruThat](https://forum.inductiveautomation.com/u/TruThat)\
**Post date:** [July 25, 2017, 3:17pm UTC](https://forum.inductiveautomation.com/t/free-sql-databases/47/4 "2017-07-25T15:17:22Z")

</div>

Nick this looks pretty awesome. Does this save the database on the Gateway. Excuse my ignorance. Still learning SQL part of ignition.

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [July 25, 2017, 5:05pm UTC](https://forum.inductiveautomation.com/t/free-sql-databases/47/5 "2017-07-25T17:05:24Z")

</div>

Yes, it saves it on the same computer server that Ignition is installed. The DefaultH2 database that is automatically created for you is located in the Ignition folder here: Ignition/data/db/userdbs/default

When you make a new datasource you can store your database anywhere you want on the computer. See the documentation for more information: [http://doc.perfectabstractions.com/modules/database/](http://doc.perfectabstractions.com/modules/database/)