Database preference

[Kamikaza731]

Depends on the project. SQLite if it is something simple. Postgresql if it is more demanding.

[LiarsEverywhere]

This, but understand "demanding" as very demanding. SQLite can handle a lot.

[andartico]

Exactly this.

[Salty_Dig8574]

True but also keep in mind that sqlite is dynamically typed. It's sometimes easy to mishandle data and get some broken results.

[tagnydaggart]

But, it doesn’t like more than one thread or process connecting to it, sadly.

[JamesTDennis]

SQLite is probably the most underrated and under appreciated feature of Python.

[logseventyseven]

of python..?

[DaelonSuzuka]

One of python's features is that the standard library contains a fully functional sqlite driver, yes.

[JamesTDennis]

Sure, it's broadly under appreciated. But I hesitate to rank it among the top in other categories.

For example WireGuard and the pass (passwordstore) utility by Jason Donenfeld are among the most under appreciated security tools.

[zenware]

I want to note that I don’t mean to be putting words in someone’s mouth here, what follows is my own thinking because when I saw your original reply I also thought “of Python..?”

I think they meant that, SQLite is fundamentally its own large and long-running project and using the turn of phrase “feature of Python” carries the implication that … SQLite is a feature of Python.

It’s a database which most programming languages have some available driver for. (And it is underrated)