SQLite
SQLite lets Windows users and developers create, query and manage local SQL databases without running a separate database service.
Operating system: Windows
Publisher: Richard Hipp
Release : SQLite 3.53.4
Antivirus check: VirusTotal report
SQLite is a database library and command-line tool for working with structured data on Windows. Developers can add it to applications that store settings, records or other information locally. The included shell lets users create databases, define tables and run SQL queries from a terminal. It can also help users inspect or update existing database files.
Store a complete database in one file that an application can read and update directly.
The library keeps each database in a single file that can be moved between supported systems. It supports transactions, selective indexes and queries that build on earlier query results. Programs written in C can access the database through the library, while shell users can export query results to CSV. Applications do not need a separate database process to read or write their data.
Features:
- Create tables and query records with SQL
- Store each database in one portable file
- Run database commands from a terminal
- Export query results to CSV files
- Group database changes in transactions
- Add database storage to C applications
No external runtime dependencies
PROS
Stores complete databases in portable single files.
Preserves transactions across crashes and power failures.
CONS
Command-line tools lack a built-in graphical interface.
No built-in user authentication or network server.
