3 min read
Why You Should Avoid LIMIT OFFSET for Pagination in PostgreSQL (And What to Use Instead)
Discover why LIMIT OFFSET is inefficient for pagination in PostgreSQL and learn how keyset pagination can improve performance and user experience.
Get the latest insights, research and news delivered straight to your inbox.
Plus, enter to win the 2nd edition of Omnichannel Retail by Tim Mason & Sarah Jarvis!
No spam. We promise. 💜
AIR Platform: Loyalty & personalization for retailers
Eagle Eye's AI-powered platform unifies loyalty management and 1-to-1 personalization. Capture first-party data, deliver personalized experiences at scale, and measure results. Trusted by leading grocery, fashion, and hospitality brands.
AI Personalization Science→
Unlock the full value of your customer data with AI you can trust, built for retailers to deliver personalization at scale
Real-Time Loyalty→
Build lasting loyalty with a proven engine trusted by leading omnichannel retailers
Omnichannel Promotions→
Drive growth where it counts with the most flexible promotions platform in retail
Learn, explore, and stay ahead
Insights, guidance, and tools to help retailers and partners get more from loyalty and personalization.
Featured content
The A-Z of Customer Loyalty→
A practical guide to building loyalty leadership in 2026 - from AI-powered personalization to real-time decisioning and ROI.
Investor relations
Find results, reports, regulatory announcements, and corporate governance information for Eagle Eye Solutions Group plc.
Featured content
2025 Annual Report→
Company performance, governance, and investor information in one place.
Built for retailers operating at scale
Powering loyalty, personalization, and promotions across complex, multi-channel retail environments.
Giant Eagle case study→
Transformed myPerks into a real-time, scalable loyalty platform, powering millions of personalized offers and faster, more flexible campaign execution.
Tesco case study→
Delivered AI-driven personalized challenges to millions of Clubcard members, increasing engagement and proving 1:1 marketing can scale.
See all our case studies→
Built to partner at scale
Working with technology, solution, and integration partners to help retailers deliver smarter loyalty and personalization.
Become a partner
Explore how we work with partners to build, integrate, and scale loyalty and personalization for retailers.
We're the personalization people.
Our technology helps retailers design and manage world-class loyalty programs that capture rich first-party data - and then applies built-for-retail AI to deliver 1:1 personalization at scale.
Basile is a fullstack developer at EagleAI, where they have been building scalable data systems and high-performance APIs since 2018. A graduate of both ESIGELEC and NEOMA Business School, they bring a unique blend of deep technical expertise and a strong product mindset. Passionate about developer experience, clean architecture, and taming complex databases, they enjoy sharing insights on the subtle backend decisions that drive impactful results.
3 min read
Discover why LIMIT OFFSET is inefficient for pagination in PostgreSQL and learn how keyset pagination can improve performance and user experience.