SQLite
SQLite Database: How to Create, Open, Backup & Drop Files
SQLite databases are very lightweight. Unlike other database systems, there is no configuration,...
SQLite is an open-source, embedded, relational database management system, designed circa 2000. It is a lightweight database, with zero configuration, no requirements of a server or installation. Despite its simplicity, it is laden with popular features of database management systems.
Key Features
Despite its simplicity, it is laden with popular features of database management systems.
Tutorial | How to Download & Install SQLite on Windows |
Tutorial | How to Create, Open, Backup Database in SQLite |
Tutorial | SQLite Create, Alter, Drop Table with Examples |
Tutorial | SQLite Primary Key & Foreign Key with Example |
Tutorial | SQLite Data Types with Example |
Tutorial | SQLite Query: Select, Where, LIMIT, OFFSET, Count, Group By |
Tutorial | SQLite Join Tables: Inner, Natural, Left Outer, Cross (Examples) |
Tutorial | SQLite INSERT, UPDATE, DELETE Query with Example |
Tutorial | SQLite Index, Trigger & View with Example |
Tutorial | SQLite String Functions: REPLACE, SUBSTR, TRIM, ROUND (Examples) |
Tutorial | Top 20 SQLite Interview Questions & Answers |
Tutorial | SQLite PDF |
If you are developing embedded software for devices like televisions, Mobile phones, cameras, home electronic devices, etc., then SQLite is a good choice.
SQLite can handle low to medium traffic HTTP requests and manage complex session information for a website
When you need to store an archive of files, SQLite can produce smaller size archives and with lesser metadata included than regular ZIP archives.
If you want to do processing on some data within an application, you can use SQLite as a temporary dataset. You can load the data into an SQLite in-memory database and execute the desired queries. You can extract the data in a format you want to display in your application.
It gives you an easy and efficient way to process using in-memory variables. For example, you are developing a program where you have to perform calculations on some records. You can create an SQLite database and insert the records there, and with only one query, you can select the records and perform calculations.
When you need a database system for learning and training purposes, SQLite is a good fit. As we explained earlier, no installation or configuration is required. Copy the SQLite libraries in your computer, and you are ready to learn.
Following guide will help you determine whether you should choose SQLite for your next project
It is free. SQLite is an open source, no commercial license required to work with it.
SQLite is cross-platform database management system. It can be used on a broad range of platforms like Windows, Mac OS, Linux, and Unix. It can also be used on a lot of embedded operating systems like Symbian, and Windows CE.
SQLite offers an efficient way of storing data, the length of the columns is variable and is not fixed. So SQLite will allocate only space a field needs. For example, if you have a varchar(200) column, and you put a 10 characters' length value on it, then SQLite will allocate only 20 characters' space for that value and not the whole 200 space.
A broad range of SQLite APIs – SQLite provides APIs for a broad range of programming language, for example.Net languages (Visual Basic, C#), PHP, Java, Objective C, Python and a lot of other programming languages.
The following are the list of unsupported features and limitations in SQLite:
SQLite supports neither RIGHT OUTER JOIN nor FULL OUTER JOIN. It supports only LEFT OUTER JOIN.
VIEWs are read-only – you can't write INSERT, DELETE, or UPDATE statements into the view. However, you can create a trigger on a view and do the INSERT, DELETE, or UPDATE statements into it.
GRANT and REVOKE commands are not implemented in SQLite. There are only normal file access permissions implemented in SQLite. This is because SQLite reads and writes to the disk files, unlike other Database management systems.
TRIGGERS – As we will see in the incoming tutorials, SQLite only supports FOR EACH ROW triggers, and it doesn't support FOR EACH STATEMENT triggers.
SQLite databases are very lightweight. Unlike other database systems, there is no configuration,...
In this article, we will see how to create tables, modify tables and dropping tables in SQLite3...
Data types in SQLite are different compared to other database management system. In SQLite, you...
In the daily use of SQLite, you will need some administrative tools over your database. You can...
The data modification clauses in SQLite are INSERT, UPDATE, and DELETE statements. It is used for...
$20.20 $9.99 for today 4.6 (119 ratings) Key Highlights of SQLite PDF 159+ pages eBook Designed for...