Systems | Development | Analytics | API | Testing

Performance Considerations with Offset and Cursor Pagination in Plain PHP and Doctrine ORM

Displaying a list of items from the database is probably the most common functionality built for web applications. This is where pagination with LIMIT clause comes into play, which is most likely what you learned to use. This pattern is called offset pagination. In this post I am going to contrast it with cursor pagination and the performance considerations that come with the choice of pagination algorithm. Examples are with Plain PHP and Doctrine ORM 3.7, which ships a new CursorPaginator class.

What a room of engineers asked me about realtime resilience

I spoke about Ably's approach to resilience at the AWS Cloud Resilience Roadshow in Dublin on 22 September 2026, and the questions afterwards covered CDNs, regional failover, outages, message ordering, and capacity. They got me reflecting on which parts of our approach are common across the industry, which are less so, and how choices made early, well before my time at Ably, have put us in a strong position today.

Best App Deployment Platforms in 2026: Which One to Pick for Your App #Shorts #appdeployment #coding

Best app deployment platforms in 2026: the right one depends on what you ship. Here is the short list by use case, with the free-tier changes that make older lists out of date. THE SHORT LIST Frontend apps: Vercel or Netlify. Every Git push gets its own preview link. Full-stack apps and APIs: Render or Railway, with databases next to your app. Mobile backend: Firebase, with auth, real-time data and hosting. Already on AWS or Google Cloud: AWS Amplify or Google Cloud Run. Static sites: GitHub Pages and Cloudflare Pages host them for free.

MLS Data Quality: 10 Problems That Break Real Estate Products at Scale

A single Multiple Listing Service (MLS) record rarely stays in one place. The same listing feeds the search index, the map, the detail page, analytics, and the public API, so one incorrect value can propagate to multiple downstream surfaces that consume the same source data. A correction made in one system does not necessarily propagate to every downstream surface that consumed the original value.

SwiftUI DatePicker & ColorPicker Tutorial: How to Pick Dates and Colors #Shorts #swiftuitutorial

SwiftUI DatePicker and ColorPicker tutorial: how to pick dates and colors in SwiftUI, choose a DatePicker style (compact, graphical or wheel), show only the date or only the time with displayedComponents, and hide opacity with supportsOpacity. Both are system pickers that bind to a state property: DatePicker to a Date, ColorPicker to a Color. This Short shows each one in a real iPhone app in the iOS Simulator, with the exact code.

Appian Q3 Release Highlights: AI Speed Meets Enterprise Controls

AI is evolving faster than organizations can keep up, and often it’s the most important operations that fall the furthest behind. That’s exactly why Appian is focused on AI for complex, enterprise-grade processes—to make applying AI automation to important work easy. Over the last quarter, Appian has continued to invest in capabilities that help you deploy AI fast without sacrificing control: Over 80% of developers regularly use AI coding tools.

Intelligent Document Processing Platform: 4 Must-Have Features for 2027

An intelligent document processing (IDP) platform uses AI technologies to automatically capture, classify, extract, validate, and route data from unstructured documents such as invoices, contracts, emails, PDFs, or even hand-written scans. As organizations continue to adopt AI into their daily workstreams, IDP is on track to shift from a back-office efficiency tool to a core component of enterprise AI automation.

The Top 5 Root Causes of False Failures in Test Automation And How AI Can Help Eliminate Them

False failures, a leading cause of flaky tests, occur when a test reports a defect that does not exist. The application works, yet the test suite says otherwise. The cost goes well beyond a few minutes of investigation. Perforce's 2026 State of DevOps Report found 50% of test failures stem from brittle scripts and UI changes, not actual defects, and 70% of automation effort goes toward fixing those scripts. Most teams are spending their automation budget on maintenance, not coverage.

EP21: The Architecture of Product Design

In this episode of Discovering the Architecture Middle Path, Asanka is joined by Selvaratnam Uthaiyashankar (Shankar), WSO2's Chief Product Officer, to explore the architecture of product design. The conversation looks at the principles behind product decisions, the tradeoffs that shape those choices, and how architecture, developer experience, deployment models, and different user needs influence product design. They also discuss how product principles evolve as customer expectations and technologies such as AI and agentic systems continue to change.

The Node.js Release Schedule Is Changing

One major per year, every major headed for LTS, and a new Alpha phase: here’s why Node.js is changing a release model that has been in place for more than a decade. For more than ten years, Node.js releases have followed a rhythm that became familiar across the ecosystem: a new major every six months, even-numbered releases moving into Long-Term Support, and odd-numbered releases serving as shorter-lived Current lines. That model brought something Node.js badly needed in 2015: predictability.