Hacker News Reader

Sqlite is in python’s stdlib, so how can this be an issue? Was there no local filesystem whatsoever?

sqlite bindings are in the stdlib but not the library itself.

im asking from ignorance, what the difference in effect this context of not having the library itself?

Using the bindings is only possible if the library itself is already installed (since the bindings directly make use of the library, under the hood).

I've never encountered a Python installation on any operating system where `import sqlite3` worked but the underlying libraries were not available.

I imagine this is because SQLite is VERY easy to bundle with Python itself. So on some platforms the OS SQLite is used, but on others it gets shipped as part of the Python installation itself.

It even works in WebAssembly via Pyodide!

+1 I also think it's faster that way on both environment setup and ad hoc rapid experiments, from my experience using the library in a team doesn't scale well, it becomes pretty slow.

Reply on news.ycombinator.com