Fast_page Alternatives

Similar projects and alternatives to fast_page

fast-paginate

4 1,149 0.0 PHP fast_page VS fast-paginate

A fast implementation of offset/limit pagination for Laravel.
Scenic

8 3,338 4.1 Ruby fast_page VS Scenic

Versioned database views for Rails
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.
PgHero

11 7,695 7.2 Ruby fast_page VS PgHero

A performance dashboard for Postgres
Seed dump

2 1,390 0.0 Ruby fast_page VS Seed dump

Rails 4/5 task to dump your data to db/seeds.rb
Large Hadron Migrator

3 1,816 0.0 Ruby fast_page VS Large Hadron Migrator

Online MySQL schema migrations
DatabaseValidations

3 500 0.0 Ruby fast_page VS DatabaseValidations

Database validations for ActiveRecord
Blazer

17 4,375 7.2 Ruby fast_page VS Blazer

Business intelligence made simple
WorkOS

workos.com sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
Shiba

0 293 0.0 Ruby fast_page VS Shiba

Catch bad SQL queries before they cause problems in production
Foreigner

0 1,327 0.0 Ruby fast_page VS Foreigner

Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
SchemaPlus

0 691 0.0 Ruby fast_page VS SchemaPlus

Discontinued SchemaPlus provides a collection of enhancements and extensions to ActiveRecord

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better fast_page alternative or higher similarity.

Suggest an alternative to fast_page

fast_page reviews and mentions

Posts with mentions or reviews of fast_page. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-08-21.

We switched to cursor-based pagination
2 projects | news.ycombinator.com | 21 Aug 2022

There are ways to mitigate the (although not eliminate) the slowing down of offset/limit pagination in later pages. The technique is called a "deferred join" and it is most effective in MySQL. The basic idea is to paginate as little data as necessary, and then do a self-join to get the rest of the data for a single page.
You can read more about it here: https://aaronfrancis.com/2022/efficient-pagination-using-def... or here https://planetscale.com/blog/fastpage-faster-offset-paginati....
There are libraries for Laravel (https://github.com/hammerstonedev/fast-paginate) and Rails (https://github.com/planetscale/fast_page) as well!
Cursor based pagination is wonderful, but sometimes you're stuck with offset/limit for whatever reason. Might as well make it fast.
Faster offset pagination for Rails apps
2 projects | news.ycombinator.com | 16 Aug 2022

In both Django and Rails, passing a QuerySet or ActiveRecord::Relation as an argument to a filter/where creates a subquery - in this case, https://github.com/planetscale/fast_page/blob/main/lib/fast_... creates SELECT ... WHERE id IN (SELECT id FROM ...).
So it's not exactly an inner join, but in theory it will be optimized to the same query plan as an inner join. That said, https://stackoverflow.com/questions/2577174/join-vs-sub-quer... has lots of commentary on why this shouldn't be depended on.