What’s New

You ask for it - we deliver! Now the new Database Manager gained even more powers in superb connectivity and defining database relations!
You can connect to any remote database with all the high security and encryption you need! Connecting to Amazon RDS or Digital Ocean RDS is now a breeze!
Defining relations between tables is now also super easy! Just add a “reference” field and you will create a full relation between tables!

Full blown database connectivity with the level you need! From simple local SQLite databases to large enterprise grade Clustered RDS solutions from Amazon RDS or Digital Ocean Managed Databases.

New Database Manager

New Connection Dialog

Greatly improved direct connection definition now with brand new dialog, that supports:

• Secure connections with SSL with keys and certificates or servers of Amazon RDS and Digital Ocean RDS
• Support for accessing fully isolated databases in VPC (Virtual Private Cloud) environments with over SSH
• New extensive test connection possibility
• Added full support for SSL connections with key, CA and Cert files
• Added support for MySQL 8
• Added full connection import and export to url connection strings

Database Manager General

• Improved sorting of tables in the order of creation
• Allow creation of new database connections
• Added full support for adding new Database Connections and directly define the associated one in Server Connect
• Rename database connections.
• Delete of database connections - and all related files and folders will be cleared as well. A strong confirmation is show as well.
• Added Expand All and Contract All to the context menu
• Optimized Database View - do not show the active target any more
• Display schema of tables and fields always in chronological order
• Reset changes counter after a project switch
• Added comment fields
• Context menu creation actions start now with “New …”, so New Connection, New Table, New Field
• Added also New Reference to directly create reference fields
• Check for duplicated field and table names on rename or creation and alerts to change if used.
• Refresh only selected connection when you hit the refresh icon or apply changes

Full Support for SQLite Database Management!

Now you can quickly and easy create a local SQLite database directly in Wappler and use it on your web site with Server Connect!

• Added full support for SQLite! Now you can create local databases
• Place the SQLite database file always project root site relative
• Add default extension on new database file creation for SQLite

Database Relations

• Added support for defining relations between tables. Now you can choose from a field type reference and choose which other table it references and the relation and foreign keys between the tables will be created automatically
• Support for relations in MySQL - engine must be InnoDB
• Recognize the primary keys and incrementals for existing databases
• Added Support for Database automatic on Delete and on Update relation actions
• Correctly handles default values
• Follow the order of database tables and column creation on display
• Detect primary key and incrementals for MySQL
• Improved PostGress existing schema reading
• Automatic ID selection when selecting reference table
• SQLite primary and increments readings
• Added check for MySQL tables made with the MyISAM engine - those doesn’t support relations and have to be converted to InnoDB first

Server Connect

• Improved support of SQlite databases. Allow site root relative paths
• Improved Database schema retrieval for PHP to skip Wappler migration tables and work better with SQLite

Database Connector

• Copy also the new connection file to the corresponding target folder under .wappler when the target is the active one.

FTP Manager

• Greatly improved working with SFTP and keys. Now key files can be in the user home dir and will be fetched from there. Just make sure you reselct your key files.
• Password is no longer required with SFTP if you supply a key file