Does your business require a database? And you’re feeling a bit overwhelmed by all the choices: MongoDB, PostgreSQL, MariaDB, MySQL, or Amazon RDS?
Don’t worry. You have come to the right place.
In this blog post, we are introducing a simple database software that lets you easily set up a SQL database – without writing code.
This blog post is a step-by-step guide on how to create a simple database. Though we do not need to write any SQL to create our database, it is helpful to understand what relational databases are, how they store data, and why they are generally more performant than other ways of storing data.
This guide presumes that readers are familiar with things such as Database Schemas, Entity-Relationship Diagrams, Primary Keys, Foreign Keys, or SQL Data Types.
Last, to follow the steps shown in the video below, make sure to sign up for a free download of Five, a simple database software that lets you create a MySQL database in just a few clicks.
Before we start building our database, a few words about choosing your database.
As mentioned in the introduction to this article, there is a large variety of different database systems, such as MongoDB, PostgreSQL, MySQL, MariaDB, etc.
For someone new to the field of databases, this can be pretty overwhelming. So here are three important things to note:
Now that we’re ready, let’s set up our first database! We will be using Five to create a MySQL database.
Five is a development environment used to rapidly create database-driven business applications. To follow along, make sure you have installed Five on your computer. Simply sign up for a free download and you are ready to go.
Five is an extremely simple database software. It allows users to:
Five also comes with a visual database modeler that lets you inspect, edit, and manage your database completely visually.
To get started with creating your database, create a new application in Five and then click on Data > Table Wizard.
Here is a short video explaining the steps to create a table with Five.
Follow the entire video series to learn how to build an entire database-driven web app using Five. Or download one of our template applications!
Once your database is ready, the next question usually is where to host it. Traditional database GUIs such as MySQL Workbench do not offer hosting services. Instead, you have to move the database to the cloud, picking AWS, Azure or Google Cloud as your hosting platform, for example.
Five, on the other hand, offers a simple single-click deployment feature that lets you deploy your application (and its database) for as little as US$29.99 per month to cloud. This gives you a fully-provisioned cloud-hosted database.
Even better, you can use Five to create an entire application for your database. This application can contain forms, reports, charts, or dashboards.
The front end can also be configured for different user roles with different access rights. Five makes it incredibly simple to assign CRUD permissions to different user roles.
Of course, if you don’t want to host your database with Five, no worries at all. You can also export the database that you have just created with Five as a SQL dump, and then host it elsewhere!
Let’s face it: the reality is that the question is not so much if your business needs a database, but rather when to get started with databases. As explained above, setting up a database can be accomplished by using more traditional database GUIs, such as MySQL Workbench or DBeaver, or by using tools such as Five.
In our example, we’ve shown how Five can be used as a simple database software for MySQL, creating an entire MySQL database in just a few clicks.