#Postgres
253 related articles
·3 min
GitHub Daily · July 13: Rust Rewrite of Postgres Ignites the Community, Claude Ecosystem and Local-First Wave Surge Together
GitHub Daily July 13: pgrust rewrites Postgres in Rust and passes 100% regression tests, surging 789 stars in a day. Claude cookbooks and local-first Home Assistant also trend.
Read more →
·3 min
pgrust: Rewriting Postgres in Rust — 100% Regression Tests Passing
pgrust is an open-source project rewriting PostgreSQL entirely in Rust, claiming 100% regression test passage. This article analyzes the technical motivation, implementation approach, and key challenges.
Read more →
·3 min
PostgreSQL Lock Contention: The Root Cause and Solutions for High-Concurrency Scalability Bottlenecks
An in-depth analysis of PostgreSQL's lock scalability bottlenecks under high concurrency: LWLock contention, the cost of the multi-process model, negative scaling, and practical strategies like connection pooling, transaction optimization, and horizontal scaling.
Read more →
·5 min
Postgres Is Enough More Often Than You Think: Stop Piling On Your Tech Stack
Many teams add message queues, search engines, and caches before they ever need them. This article maps out what Postgres can cover—task queues, full-text search, JSON storage—and when you actually need Redis, Kafka, or Elasticsearch.
Read more →
LTAP Architecture Deep Dive: Storing P…
·3 min
LTAP Architecture Deep Dive: Storing Postgres Data in Parquet Format on S3
A deep dive into LTAP architecture: storing Postgres data in Parquet columnar format on S3 for compute-storage separation, lower costs, and unified transactional and analytical workloads.
Read more →
·3 min
Chinese Open-Source AI Conquers Silicon Valley: The Industry Upheaval Behind a 58% Compute Share
Chinese open-source AI models surged from under 10% to 58% of U.S. AI consumption. Kimi K3, DeepSeek, and Qwen are reshaping AI cost structures as DoorDash, Airbnb, and other Silicon Valley giants adopt them at scale.
Read more →
·4 min
IntelliJ IDEA Efficiency Configuration Guide: Lessons from Seven Years of Java Development
A senior Java developer shares 7 years of IntelliJ IDEA configuration tips: JVM tuning, AI-assisted coding, Testcontainers testing, debugging tricks, and Spring toolchain setup.
Read more →
·3 min
Chinese Open-Source AI Conquers Silicon Valley: The Industry Upheaval Behind a 58% Compute Share
Chinese open-source AI models surged from under 10% to 58% of U.S. market share. Kimi K3, DeepSeek, and Qwen are being adopted by DoorDash, Airbnb, and other Silicon Valley giants, reshaping AI costs and competition.
Read more →
·3 min
Apache Cassandra Explained: A Linearly Scalable and Highly Available Distributed Database
Deep dive into Apache Cassandra's core design: linear scalability, decentralized architecture, tunable consistency, and ideal use cases for engineering teams.
Read more →
·3 min
Self-Hosted Receipt Tracking Tools: Monitoring Grocery Expenses and Price Changes
Explore self-hosted receipt tracking tools for grocery expense management, covering OCR recognition, price tracking, food categorization, and budget management with open-source solutions like Firefly III.
Read more →
Chat2DB: An AI-Powered Database Manage…
·1 min
Chat2DB: An AI-Powered Database Management Tool for Operating SQL in Natural Language
Chat2DB is an open-source AI database management tool by the OtterMind team, supporting MySQL, PostgreSQL, Oracle, and more. Generate SQL via natural language. 26,000+ GitHub stars.
Read more →
·2 min
The New Bar for AI/LLM Roles: A Practical Guide to Agent Observability and Evaluation
Enterprise AI/LLM roles now demand engineering skills: streaming recovery, high concurrency, multi-tenancy, LLM gateways, Langfuse observability, and evaluation platforms. Master these 8 core competencies.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows via Python, type overrides to solve ZIP-code leading-zero loss, STRICT table mode switching, drop-index, and more. A deep dive into the design and AI-assisted dev workflow.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows with Python, field type overrides fixing leading-zero ZIP codes, STRICT table mode switching, drop-index, and more. A deep dive into each design and the AI-assisted dev workflow.
Read more →
·7 min
0 Lines of Hand-Written Code, 3 Hours to Build an AI Product That Can Take Payments
A real case: a creator launched an AI photo generation product in 3 hours with zero code, and got paid the next day. This article breaks down the full loop methodology.
Read more →
·7 min
Zero Lines of Hand-Written Code, 3 Hours to Build a Revenue-Generating AI Product
A real case: a creator launched an AI photo generation product in under 3 hours with zero code, and got paid the next day. This article breaks down the full loop methodology.
Read more →
GitHub Daily · July 24: Agentic Tools …
·3 min
GitHub Daily · July 24: Agentic Tools Blossom Everywhere, from CMS to Databases Embracing AI
GitHub Trending July 24: Agentic capabilities go from concept to standard feature. Instatic and Chat2DB deeply integrate AI into CMS and database clients, while dive-into-llms remains the go-to Chinese LLM tutorial.
Read more →
GitHub Daily · July 24: Agentic Tools …
·3 min
GitHub Daily · July 24: Agentic Tools Blossom Everywhere, From CMS to Databases Embracing AI
GitHub Trending July 24: Agentic capabilities go from concept to standard, with Instatic and Chat2DB embedding AI deeply into CMS and database clients.
Read more →
·7 min
Getting Started with Claude Code: Five Dimensions to Understand Why It Outperforms Regular AI
Claude Code isn't just a chat AI—it can directly read projects, modify code, and run commands. This article compares Claude Code with regular AI across five dimensions to help you decide if it's worth trying.
Read more →
·7 min
Getting Started with Claude Code: Five Dimensions That Show Why It Outperforms Ordinary AI
Claude Code isn't just a chat AI—it can directly read projects, modify code, and run commands. This article compares Claude Code with ordinary AI across five dimensions: interaction, context, execution, memory, and tool calling.
Read more →