Creating a database with the desired query language with the DatabaseSample online library & performing import & export operations by automatically generating the codes of the created database
Hello everyone 🖐, today I will talk about how to design a database with the desired query language with the Database Sample online library and how to automatically create, import and export the codes of the tables combined in the database. I hope it will be a useful article. Happy reading to all of you 📙.
WHAT IS THE DATABASESAMPLE ONLINE LIBRARY?
DatabaseSample Online Library is an online library that offers a variety of open source database samples. Our goal is to provide resources for developers, researchers, and anyone interested in database management and analysis. At the same time, we can create as many tables as we want by designing our databases through the sandbox, and we can import and export these tables by automatically generating them into the desired query language. There is also an option to create an artificial intelligence-supported automatic database. By giving a detailed explanation to the artificial intelligence about the database we want, it can create the desired databases with their tables and present them to us. You can use the search bar at the top of the page to search for specific database samples by name, type, or keyword. Additionally, you can browse through databases page to discover relevant samples.
STEPS TO CREATE A NEW DATABASE ONLINE VIA SANDBOX:
To create a new database via DatabaseSample, first click on the Get Started tab at the top right. It will then redirect us to the sandbox page. If I were to explain what Sandbox is, it allows the user to create and store their own databases securely in a virtual environment. Virtualized databases are generally not published publicly. It is user specific. It offers the user an isolated environment. Following a general definition, the sandbox page is the section where sample databases are listed, databases are imported and a new database is created. A new database is created by clicking the New database option. It allows you to run queries, test database operations, and explore data without needing to set up a local database instance.
Import Database:
Database code is written in the desired query language and the database is created automatically.
Creating New Database:
To create a new database, the database name is entered in the upper left corner.
ADDING DATABASE TABLE:
Edit Table:
To give a general introduction on the database creation page, this is the section where the relational database tables are listed. At the same time, you can add tables and use the added tables in the export tab by translating query languages such as DBML, PostgreSQL, MYSQL and MSSQL with an automatic code generator, and use the created tables wherever you want. In the import section, the code can be written with the desired database query language and tables can be created automatically in the sandbox. Tables can also be deleted with the Clear tab. There is also an option to save tables. Click on the Add table tab to create a new table. Then, to add more than one field, the Add field after option can be clicked. The fields to be added can be aligned with Move up or Move Down according to their order of importance. Related fields can be deleted with the Remove field option. Delete table is used to delete the table. After clicking Commit, we create our table.
Export Table:
To export the tables, we click on the export tab above and we can automatically generate the database codes of the tables we designed according to the desired database query language and use them in the database provider we want.
1-DBML:
2-PostgreSQL:
3-MySQL:
4-MSSQL:
Import Table:
To import any table into the database, we can first create our own tables automatically in our virtual environment by writing the relevant codes in any query language. We can import on 4 query languages as shown in the picture below.
Adding a comment line to the table:
Changing the color of the table:
OPEN SOURCE DATABASE EXAMPLES:
here are many types of open source database examples that will be useful to you in the database sample online library. You can make changes to any database or apply it exactly in your projects. For more open source database examples, you can visit https://databasesample.com/databases.
RESULT:
In this article, I tried to convey as much information about DatabaseSample Online Library. Thank you for reading. If you found my article useful, how about pressing the applause button below? 😉
