SQLITE3 is a popular lite database option for light projects that require SQL. It is used as a database file format, known as a .db file. It is very common for it to get hung on Repl.it, and it is Spotandjake's enemy. However, it is very efficient if you don't have a SQL server, don't want to setup Mongo, and need more than a key-pair system. It supports data types
- TEXT
- INTEGER
- BLOB, NULL
- and REAL.
But wait - some things to know before you try it:
- More than one instance of your project can't be used as the db will get locked otherwise
- You cannot simply connect to a db file in the cloud, it has to be in the project directory
- Python has built in support for it!