A SQL Heuristic: ORs Are Expensive (8 minute read)
OR clauses in SQL queries can be much slower than AND clauses due to how query planners use indexes. When using OR, the database might resort to less efficient strategies like merging separate filtered results or performing a full table scan. Rewriting queries to use AND clauses, often by using unions or restructuring the schema, can improve performance. Common schema issues that lead to needing OR clauses can be addressed by creating secondary tables or using an extension table pattern. |
Parallel and recursive route rendering (8 minute read)
RSC routers use a unique approach to route rendering, performing it in parallel on the server and then recursively stitching the results together on the client to avoid waterfalls. They render a list of components in parallel, each potentially with a placeholder, and then serialize the output into a stream. On the client, a recursive component called `StackReader` uses the `Placeholder` component to traverse a stack-like data structure created from the stream, reassembling the nested component tree. |
React ViewTransition: Smooth Animations Made Simple (8 minute read)
React is introducing a new experimental `ViewTransition` component that wraps the browser's View Transition API to create smooth, declarative animations between component states without animation libraries. The component automatically handles enter/exit animations, shared element transitions, and list filtering when used within React's concurrent features like `startTransition` or `useDeferredValue`. It allows CSS customization for different animation effects. |
|
Friction is necessary for Growth (3 minute read)
Overcoming friction is necessary for growth. Readily available AI could stifle creativity by removing the need to struggle and learn through mistakes. Excessive comfort reduces personal potential and can lead to stagnation of your skills. |
To AI or not to AI (7 minute read)
An experiment was conducted over two weeks to build an app with full AI assistance. While the team found AI helpful in specific areas like searching, code snippets, and language tasks, they were frustrated with its limitations in providing context, maintaining code, and uncovering corner cases. Overall, the code became messy, control was lost, and the team returned to their traditional workflow. |
|
Introducing Claude Sonnet 4.5 (5 minute read)
Anthropic has released Claude Sonnet 4.5, a new frontier model with huge improvements in coding, computer usage, reasoning, and math. The model has state-of-the-art performance on benchmarks like SWE-bench Verified and OSWorld (for real-world software coding and computer task abilities). Along with the model, Anthropic has released Claude Code 2.0 and new features to the Claude apps. |
Buy it in ChatGPT: Instant Checkout and the Agentic Commerce Protocol (5 minute read)
OpenAI has launched Instant Checkout in ChatGPT, powered by the Agentic Commerce Protocol developed with Stripe. This allows users in the US to directly purchase items from participating merchants like Etsy and soon Shopify, within the chat interface. The Agentic Commerce Protocol, an open standard for AI commerce, allows AI agents, individuals, and businesses to collaborate on transactions while giving merchants control over payments and customer relationships. |
Give your AI eyes: Introducing Chrome DevTools MCP (8 minute read)
The Chrome DevTools MCP is a new tool that allows AI coding assistants to see and interact with a live Chrome browser through the Model Context Protocol, giving AI "eyes" to observe and debug web applications in real-time. The tool acts as a bridge between AI agents (like Cursor, Claude, and Gemini) and Chrome's DevTools capabilities, letting them navigate pages, inspect DOM elements, analyze performance, simulate user interactions, and debug issues based on actual browser feedback rather than coding blindly. |
|
Subtleties of SQLite Indexes (9 minute read)
This dev improved the performance of SQLite queries for his custom content feed by understanding how SQLite's query planner uses indexes. Composite indexes are better than multiple single-column indexes, and the order of columns in an index matters, following the "Left to right, no skipping, stops at the first range" rule. Also, the conditions in WHERE clauses for partial indexes must exactly match the corresponding query conditions. |
Sandboxing agents at the kernel level (11 minute read)
AI agents can be sandboxed at the kernel level in Linux to prevent unauthorized file access. Tracing the `open` syscall shows three points of failure where file access can be denied: permission checks, mount point redirections, and changing the root directory of the process. Combining mount namespaces and root changes offers control over the agent's filesystem view. |
|
Tuning AIO in PostgreSQL 18 (12 minute read)
When tuning the new Asynchronous I/O (AIO) feature in PostgreSQL 18, users should generally stick with the default `io_method = worker` and increase the `io_workers` setting to around 25% of the system's cores. |
|
| Love TLDR? Tell your friends and get rewards! | | Share your referral link below with friends to get free TLDR swag! | | | |
| Track your referrals here. |
| Want to advertise in TLDR? π° If your company is interested in reaching an audience of web developers and engineering decision makers, you may want to advertise with us.
Want to work at TLDR? πΌ Apply here or send a friend's resume to jobs@tldr.tech and get $1k if we hire them!
If you have any comments or feedback, just respond to this email! Thanks for reading, Priyam Mohanty, Jenny Xu & Ceora Ford
|
|
| |
0 Comments