SQLAlchemy 2.0.0 Released

• sqlalchemy-filters

  3 310 5.2 Python

  Filter, sort and paginate SQLAlchemy query objects. Ideal for exposing these actions over a REST API.

Is there any support for something like sqlalchemy-filters? https://github.com/juliotrigo/sqlalchemy-filters

• SQLAlchemy

  123 8,750 9.7 Python

  The Database Toolkit for Python

  

that said, most "pagination" is done for stateless web applications so you would want a strategy that SELECTs only the rows you want in the first place, a good article on that is at https://use-the-index-luke.com/blog/2013-07/pagination-done-the-postgresql-way ; within SQLAlchemy, we have some (older API style, but still general idea works) wiki examples for both a criteria-based solution as well as one that uses window functions: https://github.com/sqlalchemy/sqlalchemy/wiki/RangeQuery-and-WindowedRangeQuery

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project