Manage Sqlite database with Sqlite Studio

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. The source code for SQLite is in the public domain.
That is a statement of who defines the SQLite developers of SQLite. What is the advantage of using this SQLite?
As the above statement that SQLite does not require such a configuration server in general because SQLite is a library that only supports the SQL language and of course also with the many functions that are not inferior to another database server.

Here is why I am interested in this SQLite investigated.
There are many tools that can be used to manage SQLite database, one which I will discuss here is SQLite Studio.
SQLite Studio can run on multiple platforms, windows, linux and solaris.
The advantage of using SQLite Studio, you do not need to install in your PC or laptop because SQLite Studio is portable, so it can be used on a PC or laptop without having to install it first.

You can download SQLite Studio here.
Open SQLite Studio, the main menu should look like this picture SQLite Studio.

click the close button

To create a SQLite database, click the Add database.

Type the name of the database with the extension as you like, but I recommend using the extention .sdb. and now will see the database you just created.

to connect to the database, right-click your database name and select connect.

 










to create a new table, right-click Tables and select New Table.

 













type the name of the table, to add a field click on this button 

  
 

 














click the create button to finish creating the table.
will be seen in the left menu, table name that we have made.

Thus the use of SQLite Studio tutorial as a database manager to manage SQLite database.
for a complete tutorial on Sqlite Studio visit this link.
in the next post we will discuss ways make delphi connection to sqlite database.