For a few days, I was looking for a tool to design a database online, but its features were not very important. I wanted more tools so that I could have tables and connections between tables in one page and next to each other.
I found various programs and websites that mostly required account recharging, and the features offered in the free account had limitations that made that tool virtually useless to me.
Among the searches I did, I came across the QuickDBD website. Of course, this website, like the rest of the sites, had limited restrictions on its free account, but what caught my eye was that it provided free special account features for a while, and Also, the simplicity of this tool was very interesting.
By writing a few lines, I could easily create the table I needed and apply the relationships between them. The design speed of the database was better than the rest of the services, as well as the complete documentation that helped me get the results I wanted quickly.
It was very easy to register on this website and after entering the user panel, you will be given a menu at the top of the page and two columns.
The above menu includes editing the current document as well as extracting or entering information.
The left column is marked for writing code, and by writing the code, the result will be displayed in the right column.
Let's take a look at some of the basics:
Add comments or descriptions:
By placing the # sign for any text that is written after this sign, it will be specified as an explanation:
# This is a comment
We also use the CTRL + Space terminal keys to use the auto-complete feature.
To create a new table, just write the name of the table in the new line:
In the above code, we introduced two tables, Product and Order.
To specify the fields of each table with a few dashes, enter the table fields below the table title:
Product ---- Id int pk Title string Description string
In the example above, we created a table called Product that has three fields, Id, Title, Description, and the Id field is identified as the main key.
Defining fields, as you can see, is: Data field type title
We can also set settings for this field after specifying the type of field, such as the default value of the field.
If you read the documentation, you will see that you can use the following symbols to indicate the connection between the tables:
- - one TO one - <- one TO many > - - many TO one > - <- many TO many -0 - one TO zero or one 0- - zero or one TO one 0-0 - zero or one TO zero or one -0 <- one TO zero or many > 0- - zero or many TO one
As you can see, by writing a few characters, you can easily determine the different relationships between the tables. One of the reasons why this software is interesting for me was the ease of use and shorthand in this software.
At the end of the documentation of this program, there is an instructional video on how to use this software, which you can learn to work with the software at once by watching this video.