Database

WebSQL Server supports a variety of databases, including: DynamoDB, Redshift, MySQL, PostgreSQL, Oracle, SQL Server. The database component is intended to work over both relational and non-relational (NoSQL) databases with an unified interface over SQL and a SQL-like language (WebSQL). It uses corresponding ODBC drivers or available APIs to connect databases.

The Web-based IDE allows to manage database connections, manipulate database data, and create stored procedures.

To connect to a database:
  1. In a browser on the websqlgui.html page, click Database and then the Connections tab.
  2. In the Add Connection ... drop-down list, select a database type and fill the connection settings.
  3. Click Save. The connection settings will be uploaded and encrypted on the server.
Different databases require different information to establish a connection.

ODBC: SQL Server, MySQL, PostgreSQL, Redshift, Oracle

Amazon DynamoDB

Amazon DynamoDB Encryption

WebSQL Server supports data encryption before storing data in Amazon DynamoDB. Encryption/decryption are handled transparently and enabled via an additional configuration. In the configuration, you can specify top-level attributes to be protected when an item is stored in Amazon DynamoDB. Top-level attributes can be marked as: public, protected, or private.
Original Item Applied Security Stored Item 
{
    "attr1" : 123,
    "attr2" : 234,
    "attr3" : { any complexity }
}
                    
attr2: protected
attr3: private
                    
{
    "attr1" : 123,
    "attr2" : "NNLIpyYLgpZfOlDtYdYj8c2z4h8=",
    "data"  : "ABCQL0AFWMIX8NRZTKeof9cXsvbvuYLgpZfOlDtYdYj8c2z4h8="
}
To set a table's security:
  1. Ensure your WebSQL Server has an encryption key in the settings.
  2. In a browser on the websqlgui.html page, click Database and then the Connections tab.
  3. Select a database and its table, then click Edit Table Security and enter the security settings.
  4. Click Save. The security settings will be uploaded and encrypted on the server.

See Also:

Database Encryption

WebSQL Reference

Table of Contents