203 private links
SQLite est un système de BDD super, mais simple. Cependant, des extensions ont été dévelopée :+1:
Richard Hipp is the creator of Fossil too.
(Background: SQLite is the most used database in the world. Everyone uses it. It's in Windows, in Photoshop, in Firefox, in your smartphone, in your connected TV, in your fitness bracelet, it's in almost every connected object. It is used to store and organize information, and it has the advantage of being remarkably reliable, light and running on virtually all existing systems (processors, languages, operating systems ...). It is probably one of the most used software in the world... but the general public does not know it).
Optimisations:
- Make use of SQLite PRAGMA statements when possible
- Use prepared statements
- Do a batched insertions
- PyPy is actually 4x faster than CPython
- Threads / async may not be faster always
In CPython: 510s
In PyPy: 150s
In Rust: 33s
It is possible.
Some tips for it
Les bonnes raisons d'utiliser SQLite.
(via sebsauvage)
Queries can be run on multiple databases 💚 (see https://www.sqlite.org/lang_attach.html for more)
The command ATTACH 'other.db' AS other;
In python, there is the db.attach for it !
A reason to use sqlite for small projects.
SQLite is not client/server, however. The SQLite database runs in the same process address space as the application. Queries do not involve message round-trips, only a function call. The latency of a single SQL query is far less in SQLite. Hence, using a large number of queries with SQLite is not the problem.