apsw
apsw copied to clipboard
rogerbinns
Another Python SQLite wrapper
Bumps [pypa/cibuildwheel](https://github.com/pypa/cibuildwheel) from 2.8.1 to 2.9.0. Release notes Sourced from pypa/cibuildwheel's releases. v2.9.0 🌟 CPython 3.11 wheels are now built by default - without the CIBW_PRERELEASE_PYTHONS flag. It's time to...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
`SQLITE_ENABLE_COLUMN_METADATA` is off by default. When it is on then additional column [information](https://www.sqlite.org/c3ref/column_database_name.html) is available. Examining the SQLite code shows that the cost of turning on `SQLITE_ENABLE_COLUMN_METADATA` is 3 additional...
if I know, what columns will be requested I can optimize virutal table retrieval - ie.; askim wmi interface only about needed columns, or not reading files, that are used...
vscode (and probably others) show type information from the stubs when you hover, but turn out to also show docstrings if they are present. Consequently we need to add to...
I'm using apsw from pypi (thanks for that!) I found some issues with the type stubs. Some valid code that fails type-checking: ```python import apsw conn = apsw.Connection(":memory:") cur =...
The find function provides capability to use function filters in virtual tables https://sqlite.org/vtab.html#xfindfunction It should be great to be able to use it. if the findfunction was returning a integer...
_From [rogerbinns](https://code.google.com/u/rogerbinns/) on January 22, 2012 23:50:30_ Last 3 at http://www.sqlite.org/c3ref/module.html _Original issue: http://code.google.com/p/apsw/issues/detail?id=128_
[Supporting the `IN` constraints in `xBestIndex` is somewhat more complicated](https://www.sqlite.org/c3ref/vtab_in.html) than other operators (since it takes a sequence of values on the RHS) and requires access to a few sqlite...
see: https://www.sqlite.org/vtab.html related to: https://github.com/rogerbinns/apsw/issues/188