Every application developed in Five comes with a MySQL relational database. By clicking on “Tables” inside of Five, software developers can create their own, customizable MySQL database. Commonly used SQL statements can all be performed in point-and-click, such as CREATE TABLE with a PRIMARY KEY, insert data into a table using INSERT INTO, establish relationships between tables using a FOREIGN KEY, create constraints such as NOT NULL or UNIQUE, define data types (INT, FLOAT, BINARY, etc.), or even create a ON DELETE CASCADE.
What if your SQL database exists already? Software developers can also import an existing MySQL straight into Five, using Five’s database importer. Five accepts SQL dumps, which can be easily created from inside tools such as MySQL Workbench. For instructions on how to create a SQL dump, check out the MySQL documentation. Upon successfully importing the database, developers can continue to work on their database from inside Five.
Inside Five, software developers can create SQL queries for charts or reports in two ways. They can use Five’s intuitive and easy-to-use drag-and-drop SQL Designer. The SQL Designer gives developers a visual way to build complex queries using JOIN, WHERE, AS or SORT SQL commands. It lets developers visually inspect the database schema and Five automatically generates an optimized SQL query based on the visual representation. For those developers who prefer writing SELECT * FROM … statements by hand, Five provides a SQL Editor. Five’s SQL Editor is similar to those found in any database manager, such as MySQL Workbench or Beekeeper Studio, and gives developers full control and flexibility.
Five is the best database builder to replace Excel spreadsheets with a highly-scalable, customizable cloud database. Simply upload CSV files, and Five will map the fields of the CSV to the custom database. With a single click, data gets uploaded and inserted into a web-hosted MySQL database. Software developers can also write custom SQL queries to query data and generate reports, charts, or dashboards.