Title - SQLite Tags - sql
SQLite is a database engine - a piece of software that allows you to use the SQL programming language to interact with relational databases.
In SQLite, a database is stored in a single file, which is not the case with most other database engines. This makes it incredibly easy to copy and share the database (e.g. as an email attachment).
On the other hand, only one user can write to the file at the same time, which makes SQLite a poor choice if you need multiple users to update the table at the same time.
It’s also less secure than some database engines, has limited advanced features, and does not validate data types (meaning it doesn’t reject data that doesn’t conform to a table’s schema like some database engines do). This can lead inserting the wrong data types in columns which can lead to errors that are difficult to fix.