10 ms·
Python 3.12 will include a SQLite CLI/REPL in the standard library too[0][1]. This is useful because most operating systems have sqlite3 and python3, but are mi
by polyrand 3y ago
Python 3.12 will include a SQLite CLI/REPL in the standard library too[0][1]. This is useful because most operating systems have sqlite3 and python3, but are missing the SQLite CLI.
[0]: https://github.com/python/cpython/blob/3fb7c608e5764559a718ce8cb81350d7a3df0356/Lib/sqlite3/__main__.py#L65 https://github.com/python/cpython/blob/3fb7c608e5764559a718c...
[1]: https://docs.python.org/3.12/library/sqlite3.html#command-line-interface https://docs.python.org/3.12/library/sqlite3.html#command-li...
- chmaynard 3y ago> This is useful because most operating systems have sqlite3 and python3, but are missing the SQLite CLI. Not sure what you mean -- sqlite3 is the SQLite CLI.
- TeMPOraL 3y agoThey likely mean libsqlite3, i.e. the .DLL/.so.
- polyrand 3y agoYes, I meant the DLL/.so file. The library is almost always present in the OS, the CLI is not.
- chmaynard 3y agoNot sure why my comment is being downvoted. From the sqlite.org website: The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL statements against an SQLite database or against a ZIP archive.
- maleldil 3y agoIt's weird that they're adding code to the stdlib without type annotations.
- RGBCube 3y agoLots of code in the stdlib does not have type annotations. Though I think most popular modules in the std either are annotated or have stubs somewhere.
- maleldil 3y agoI know, but I expected that to be restricted only to older modules. I don't expect them to annotate all existing modules. I don't see why they would introduce _new_ code without annotating it, when that's clearly the trend for 3rd party libraries. From a quick look, it doesn't seem like it would be difficult to type either.
- telotortium 3y agoMaybe submit a patch?
- extasia 3y agoThe standard library has type hints in the "typeshed" github repo. Please do not submit PRs to cpython to add type hints (I made this error before too:))
- RGBCube 3y agoIsn't the change for the CLI? That's not accessible from scripts, so that may be why. Though, I agree that typing everything is good. Especially when combined with a good typechecker like pyright.
- agumonkey 3y agoslightly related, emacs also includes an sqlite client / view now.. I find it funny to see everybody chasing the same need, and unsurprising since.. it's always good to have sqlite close to you.