{"library":"sqlakeyset","type":"library","category":null,"description":"sqlakeyset implements keyset-based paging for SQLAlchemy (both ORM and core). It provides an efficient alternative to traditional offset-based pagination, which can become slow with deep pages. The library supports SQLAlchemy 2.0, includes type hints, and is tested with PostgreSQL, MariaDB/MySQL, and SQLite. The current version is 2.0.1775222100. While no explicit release cadence is stated, the GitHub repository shows regular updates and contributions.","language":"python","status":"active","version":"2.0.1775222100","tags":["sqlalchemy","pagination","keyset pagination","offset-free paging"],"install":[{"cmd":"pip install sqlakeyset","imports":["from sqlakeyset import select_page","from sqlakeyset import get_page","from sqlakeyset.asyncio import select_page"]}],"homepage":null,"github":"https://github.com/djrobstep/sqlakeyset","docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlakeyset/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":3.5,"avg_import_s":0.91,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/sqlakeyset/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":null}}