fast-paginate
laravel-vue-crud-starter
Our great sponsors
fast-paginate | laravel-vue-crud-starter | |
---|---|---|
4 | 2 | |
1,149 | 390 | |
3.1% | - | |
0.0 | 5.8 | |
18 days ago | about 1 month ago | |
PHP | PHP | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
fast-paginate
-
We switched to cursor-based pagination
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
The PlanetScale team puts out incredible engineering content. Congrats on the release!
If you're using Laravel, there's a package that you can use to achieve the same effect: https://github.com/hammerstonedev/fast-paginate
- Faster offset / limit pagination for Laravel
- hammerstonedev/fast-paginate: A fast implementation of offset/limit pagination for Laravel.
laravel-vue-crud-starter
What are some alternatives?
Laravel - Laravel is a web application framework with expressive, elegant syntax. We’ve already laid the foundation for your next big idea — freeing you to create without sweating the small things.
Laravel-AdminLTE - Easy AdminLTE integration with Laravel
lazy-json-pages - 📜 Framework-agnostic package to load items from any paginated JSON API into a Laravel lazy collection via async HTTP requests.
laravel-crm - Free & Opensource Laravel CRM solution for SMEs and Enterprises for complete customer lifecycle management.
cursor-pagination - Cursor pagination for your Laravel API
twill - Twill is an open source CMS toolkit for Laravel that helps developers rapidly create a custom admin console that is intuitive, powerful and flexible. Chat with us on Discord at https://discord.gg/cnWk7EFv8R.