3 ms·
> ... Python dot not have anything in the standard library that supports database interaction, this has always been a problem for the community to solve. Pytho
by promiseofbeans 3y ago
> ... Python dot not have anything in the standard library that supports database interaction, this has always been a problem for the community to solve.
Python has built-in support for SQLite in the standard library: https://docs.python.org/3/library/sqlite3.html https://docs.python.org/3/library/sqlite3.html
- dikei 3y agoAlso, DB-API 2.0 is a standard that's followed by most database drivers, similar to what JDBC is for Java, though not as strictly enforced.
- uranusjr 3y agoPython also has the DBAPI specification, which defines what interface a library must support to be considered a database driver. The author claiming Go’s sql package encourages writing SQL directly while Python doesn’t really seems a bit awkward.
- reportgunner 3y agosqlite-utils[0] is a great library for working with SQLite [0] https://sqlite-utils.datasette.io/en/stable/ https://sqlite-utils.datasette.io/en/stable/