TLDR WEB DEV 2024-12-06

KEYSET CURSORS, NOT OFFSETS, FOR POSTGRES PAGINATION

Offset pagination in Postgres can decrease performance and correctness as the offset increases. Keyset pagination, using a compound cursor based on multiple columns, has much better performance and handles deletions gracefully, maintaining a stable order even with data modifications. However, keyset pagination still has subtle correctness issues related to concurrent inserts causing rows to be skipped, but there are strategies to get around this.

7 DATABASES IN 7 WEEKS FOR 2025

This article lists seven diverse databases to explore in 2025, with each warranting a week of dedicated study. The list includes both embedded databases like SQLite and DuckDB (focused on local and analytical processing respectively) and distributed systems like CockroachDB and FoundationDB. Each entry includes suggested projects for a better understanding of the database and its capabilities.

HAUNTED BY MY OWN PROJECTS

This developer is struggling to finish their numerous side projects, often abandoning them before completion in pursuit of new ideas. Currently, despite having time and motivation, they're paralyzed by the perceived effort required to revive their unfinished projects, even though they genuinely want them to be completed. The allure of starting something new overshadows the almost-finished projects, even though finishing them would be relatively easier.

WHY DO OPEN SOURCE APPLICATIONS OFTEN HAVE LESS POLISHED UIS THAN COMMERCIAL SOFTWARE

Open-source software often prioritizes functionality over aesthetics due to limited resources and volunteer-driven development. Commercial software companies, in contrast, dedicate large budgets to UI/UX designers and maintain consistent design languages through centralized teams.

see what teams can do with Loom

REACT 19

React 19 introduces numerous new features, including hooks for managing asynchronous actions and optimistic updates (`useActionState`, `useOptimistic`), a new resource reading API (`use`), and improved form handling. Large changes include a refactoring of how refs are used and new support for enhanced document metadata, stylesheets, and scripts.

INTRODUCING CHATGPT PRO

OpenAI's ChatGPT Pro is a $200 monthly subscription that offers unlimited access to the company's most powerful AI models. It includes a "pro mode" with better accuracy and reliability for complex tasks.

CHECKMATE

Checkmate is an open-source, self-hosted server and website monitoring application that tracks uptime, performance, and incidents. It has real-time alerts and reports and optionally utilizes an agent for detailed server resource monitoring.

TEACHING ELDERLY PEOPLE TO USE ANDROID - LESSONS LEARNED

This developer created a comprehensive video course teaching elderly people how to use Android smartphones. The project involved extensive work, including scriptwriting, video production, app development, and marketing, and took approximately a year to complete. However, reaching the target audience proved challenging due to their limited online proficiency and the course not appearing in relevant search results.

DATAVIZ ACCESSIBILITY PRINCIPLES, DEMONSTRATED BY THE 2024 PRESIDENTIAL ELECTION DASHBOARDS

Several 2024 US presidential election dashboards had accessibility issues, including problems with zooming, keyboard navigation, screen reader compatibility, and sufficient alternative text for images. Automated testing revealed numerous WCAG 2.1 violations, ranging from 3 to 62 errors per dashboard, with Fox News having the most problems.

LOSSLESS LOG AGGREGATION

Log storage in observability has a high cost and the common practice of reducing log volume by discarding data. Lossless Log Aggregation (LLA) is a possible solution, which is a technique that aggregates similar logs to drastically reduce storage needs without losing any data. LLA works by deduplicating common metadata and merging similar logs.

INTRODUCING PALIGEMMA 2: POWERFUL VISION-LANGUAGE MODELS, SIMPLE FINE-TUNING

PaliGemma 2, a new vision-language model by Google, builds upon its predecessor with improved scalability, longer captioning capabilities, and better performance across various tasks, offering easier fine-tuning for users.

DON'T F*CK WITH SCROLL

Momentum scrolling plugins negatively impact web usability, accessibility, and performance by disrupting natural scrolling behavior, causing motion sickness, creating inconsistencies across devices, and adding unnecessary complexity.

TAILWIND COLORS

Free Tailwind CSS resources, including color cheatsheets and a preview of the upcoming v4 OKLCH color system.

GITLAB NAMES BILL STAPLES AS NEW CEO

GitLab appointed Bill Staples as its new CEO, replacing co-founder Sid Sijbrandij, who transitioned to Executive Chair of the Board to focus on his health.