DEV Community

Cover image for Squlite
Darius Cooper
Darius Cooper

Posted on • Updated on


Squlite picture for blog

What is Sqlite?
SQlite is an embedded SQL database engine. Unlike most other SQL databases, SQlite does not have a separate server process. SQlite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQlite a popular choice as an Application File Format. SQlite database files are a recommended storage format by the US Library of Congress. Think of SQlite not as a replacement for Oracle but as a replacement for fopen()

Random coding blog

Why use Sqluite?
SQlite is used to develop embedded software for devices like televisions, cell phones, cameras, etc. It can manage low to medium-traffic HTTP requests. SQlite can change files into smaller size archives with lesser metadata. SQlite is used as a temporary dataset to get processed with some data within an application

Supported by an international team of developers who work on SQlite full-time. The developers continue to expand the capabilities of SQlite and enhance its reliability and performance while maintaining backwards compatibility with the published interface spec, SQL syntax, and database file format. The source code is absolutely free to anybody who wants it, but professional support is also available.

How is SQlite vs MySQL?
Ultimately, SQlite is a lightweight solution designed for small projects that will only have one user, while MySQL works for projects of all sizes and supports multiple users. Due to these differences, MySQL has become the go-to for RDBMS solutions.

Image description

The disadvantages of usiing SQlite?

  • Limited Scalability:
    One of the major disadvantages of using SQlite is its limited scalability. It is designed to handle small to medium-sized databases, and its performance degrades when dealing with large amounts of data or multiple concurrent users.

  • No Built-in Security:
    Another important limitation of SQlite is its lack of built-in security mechanisms. It does not offer any security features, such as encryption, user authentication, or access control. This leaves the database vulnerable to security threats, such as SQL injection attacks, which can compromise the integrity and confidentiality of the data.

  • No stored procedures or triggers:
    SQlite does not support stored procedures or triggers, which limits its functionality and increase the complexity of implementing certain features without an automatism on the database level.


Top comments (0)