The Serverless Option - SQLite

What is SQLite?

Unlike almost every other database engine we will discuss, SQLite is not a client-server database engine. It does not run as a background process (daemon) waiting for connections. Instead, SQLite is a C-language library that interacts directly with a standard file on the disk.

Key Characteristics:

• Serverless: There is no "startup" script or service to configure. The database is just a file.
• Zero Configuration: No config files, no port numbers, and no user accounts to manage within the database engine itself.
• Single File: The entire database (tables, indices, data) resides in a single cross-platform file. This makes "backups" as simple as copying that file.

Best Use Cases:

• Embedded Devices & IoT: Because it is lightweight and requires no maintenance, it is perfect for smart gadgets.
• Mobile Apps: Android and iOS use SQLite extensively for local data storage.
• Application File Formats: Many desktop applications use an SQLite database file instead of a custom proprietary format to save project data.