Open-source tool benchmarks PostgreSQL across 23 EC2 instance types for cost efficiency

·1 views

Developer Andrei has released a benchmarking tool that tests PostgreSQL performance across 23 Amazon EC2 instance types and various disk configurations. The tool allows users to input parameters such as required requests per second and disk size to identify the most cost-efficient instance for their workload. Initial benchmarks focused on a mixed 90/10 read/write workload across selected configurations. The project is open source, available on GitHub under the name sanebench, with an accompanying visualization tool hosted at postgres.saneengineer.com. Andrei built the tool as part of a broader effort to promote leaner backend architecture alternatives to complex, big-tech-inspired system designs.

Read the full story at Hacker News

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

How Claude Code Uses Rules, Skills, and Agents to Enforce SQL Conventions

AI coding agent Claude Code can generate stored procedures, migration scripts, and complex SQL reports rapidly, but unreviewed generated code risks drifting from established team conventions. A practical framework addresses this through three mechanisms: rules files that automatically apply coding standards at generation time, slash commands that encapsulate repeatable tasks, and agents that orchestrate multi-step data workflows. Rules files stored in a repository are passed to Claude Code on every request, effectively replacing a style guide that relies on human memory with one that is machine-enforced by default. The approach is designed specifically for SQL and ETL work, where recurring patterns such as naming conventions and procedure layouts are common enough for reliable AI reproduction. The framework emphasizes that enforced conventions and human understanding of the underlying business question must work together for AI-assisted SQL development to be worthwhile.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

AI Agent Projects Often Fail Due to Poor Data Prep, Not Model Limitations

A growing number of AI agent projects run over schedule and budget not because of model failures, but because of unresolved data problems that teams fail to plan for upfront. Engineers typically scope costs around tokens, vector stores, and orchestration, while overlooking the significant effort required to clean, deduplicate, and govern the underlying data. There are two distinct data challenges: knowledge data, such as documents and FAQs, which breaks down due to format inconsistency and terminology drift, and operational data, such as customer records, which fails due to identity resolution and access authority gaps. Unresolved data issues can cause agents to return confidently wrong answers, as illustrated by a demo where the same pipeline query returns wildly different totals depending on how many flawed records are retrieved. Experts recommend teams honestly assess whether a competent human could answer the agent's intended questions from existing data before committing to any AI agent build.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Accrual vs Cash Accounting: Why the Difference Matters for Cross-Border API Builds

Software developers building accounting integrations must understand the distinction between cash-based and accrual accounting, as the method a business uses fundamentally changes what financial data means. Cash-based accounting records revenue and expenses only when money physically moves, making it simple but potentially misleading about a company's true financial performance across periods. Accrual accounting recognizes revenue when earned and expenses when incurred, offering a more accurate long-term picture and forming the basis of both GAAP and IFRS reporting standards. The rules governing which businesses must use accrual accounting differ significantly across the US, UK, and Europe, with thresholds, defaults, and mandates varying by jurisdiction and company size. Developers pulling financial data through APIs without knowing the accounting basis risk building flawed risk models, forecasts, or dashboards based on misunderstood figures.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer builds terminal snapshot tool to restore Claude Code sessions after crashes

A developer has released a tool called claude-sessions that snapshots the full state of an iTerm terminal every five minutes using a launchd daemon and AppleScript. The snapshot records open tabs, working directories, and any active Claude Code sessions, storing up to 100 distinct states as a history file. After a machine crash, users can run a single command to restore all tabs to their previous directories and resume Claude sessions automatically. The developer deliberately avoided auto-restore, making users the explicit trigger to distinguish crashes from intentional quits. The project, available on GitHub, also includes a cross-project session picker that lets users resume any Claude Code session from any repository in a single interface.

0 comments Read more at DEV Community