Someone recently asked me why I am giving away the Database Module for free. Here are the reasons why: Common database solutions such as MySQL and SQL Server Express and PostgreSQL are free and I figure that people who use those solutions might not want to pay for a database solution and I want them […]
Securing the Database Editor
Because the Database Editor project can execute any arbitrary SQL database query provided by a user it is important to secure it properly. I recommend securing it by giving the project the same security role(s) as the Ignition Designer and using good passwords for any user account that has an Ignition Designer security role. Doing […]
Database Editor 1.2 Improvements
Here are some new improvements to the Database Editor: Editing Date Type Values The Database Editor now supports the editing of date/time fields in the SQL Editor tab. These fields have the format ‘yyyy-MM-dd HH:mm:ss’. For example: “2017-07-11 12:33:48”. Note that a field will turn red if the format is invalid. An easy way to […]