Sqlite Browser make things makes things easy espicially for programmers that want to create ther own database that can be used in a project, beacuse with the software you can create Database, add tables and insert entries to your tables by which you can later export it.
Table of Contents
How to Create Database in SQLite Broqser
To create database in the sosoftware you have to make sure you download and install updated SQLite Browser on your device then you open it.
Read Also: How to Download SQLite Browser on your pc
Once you open the software navigate to File > Create Database then you write the name of your database and select the location you intended to save it in your computer, it will automatically add an sql query
CREATE DATABASE DATABASE NAME
After that it will eventually pops up a window asking you to add a table then you write the table name example Table One, after that you can add many fields to you table choosing the right entry proprtyies, which can either be Integer, text, Blob, Real or Even Numeric.
Below you can see an executable sql query if you have experience of using the sql syntax you can manually used it withiot using the visual components., this is an example of table syntax.
CREATE TABLE "Table One" (
"Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
"Name" TEXT NOT NULL,
"Address" TEXT NOT NULL
);
After that then you click ok.
Important things you can do
With the software you can perform the following operations related to database.
- Create a software
- Create tables and add enteries to your table.
- Adding, deleting and updating recoerds to your ttables
- Import and export database
- Search a certain record in a database
- plot a simple graph of your data
Limitations
Although the software has many functionalities but also it has limitation like it does not have command line tool to execute sql in a shell but you can execute the database query and export your project easily.
