SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. To use SQLite engine, first you need to create a database. You can create it by script in your code, But for the first time, maybe it's hard for you to create a database. This tutorial will give you a quick start with SQLite and Valentina Studio and make you comfortable with creating SQLite database
Step 1: Install the Valentina Studio
Valentina Studio is a powerful software to create and manage SQLite database, Although it has many features of MySQL and Postgre. For installing you should go the Valentina Studio website and download the Valentina Studio. After download and install is finished you should get a free license from the website.
Step 2:Running the Valentina Studio
As you can see in the below picture the first and main page of software includes three sections. The first column is related to the server configuration that you don't need it
Step 3: Create a new database
Now we are ready to create our first database with Valentina Studio. There are two ways to achieve create form in the software. One way is you go to the file menu and select New Database menu item and then select SQLite files.
As you can see in this picture, The other way is from the second column of software so select New Database item and then select SQLite.
After you select New Database item and then select SQLite, you can see the new window and you should select the name and path of your database that you want to create. Then click on ok to go to the next step.
After you click on last window Valentina Studio create a new database on your path. But our database is empty now. We should create tables to read and write data. In the next step I will show you how to create them.
Step 4: Create new tables
As you can see in the picture there are columns. First column is database column. When you have many databases you can change between them by this column. The second column shows the tables of each database and third column shows the fields of each table. Now, right click over the middle column and select create table to see the table creation window.
Step 5: Create new fields
When you click on create new table you can see this window that has many tab containing features to use. First go to the table tab and select the name of new table. Then go to the second tab for declaring new fields.
In the second tab you can declare new fields. As you can see, There are 9 types of fields in SQLite that are BLOB, Boolean, Date, DateTime, Double, Integer, Numeric, Real and Text so you can choose between them based your table design.
After defining your fields you can define index and primary key in other tab and save your changes by clicking on Ok button on the buttom of the page.
Points of Interest
I think this is the best and simple way to create your first SQLite database. Also, it's very powerful tools for developers to manage and maintain databases.