cauchyk
PostgreSQL 19: What's New in Monitoring
Postgres on NVMe Benchmarks
We Scale PgBouncer in ClickHouse Managed Postgres
Scaling PgBouncer across every core with SO_REUSEPORT and peering
Query Insights for Postgres, Powered by ClickHouse
Pg_stat_ch: We built low-overhead Postgres metrics exporter to ClickHouse
ClickHouse: How we made our internal data warehouse AI-first
Show HN: A modern C++20 AI SDK (GPT‑4o, Claude 3.5, tool‑calling)
Hi all,I’m hacking on new features for the ClickHouse native client and wanted the same “just call the model” ergonomics JavaScript and Python now enjoy. It didn’t exist for modern C++, so I wrote one.ai‑sdk‑cpp (Apache‑2.0) gives you:- Unified calls to OpenAI (GPT‑4o) and Anthropic (Claude 3.5) with a single C++20 API. - Streaming, multi‑turn chat, error handling—all...
Show HN: AI-SDK-Cpp – Unified C++ SDK for OpenAI, Anthropic, and More
Why Every PeerDB Cloud Tenant Still Gets a Private Postgres
Why Every PeerDB Cloud Tenant Still Gets a Private Postgres
Building MySQL Change Data Capture for ClickHouse
Show HN: Model Context Protocol (MCP) Server for ClickHouse
Postgres to ClickHouse: Data Modeling Tips
Change Data Capture (CDC) Tools should be database specialized not generalized
Reference: https://x.com/saisrirampur/status/1824694191537959159 Parent Tweet: https://x.com/craigkerstiens/status/1824114371737616794Change Data Capture(CDC) is hard, it has 100s of edge cases / failure points. At PeerDB (https://www.peerdb.io/) , instead of focusing on multiple sources we just focused on Postgres. This helped us ensure that we gave enough care to iron out as many edge cases...
Reducing BigQuery Costs
Five tips on Postgres logical decoding
While it would certainly be possible to package them into individual binaries, I found it significantly easier to define the stack in a docker compose file with the requisite environment setup.
Are there any instructions on installing? It'd be great if the `.so`s are released as part of GH releases.
For CDC, change stream does give us events in case of schema changes, we would have to replay them on the destination. Schema changes on the destination are not supported, the general recommendation is to build new tables / views and let PeerDB manage the destination table.
For streaming the results of a query, as long as the query itself can execute (say a few columns were added or untouched columns were edited) mirror job will continue to execute. In case this is not the case, there will be some manual intervention needed to account for the schema changes.
Thanks for the question, this is a requested feature and on our roadmap.
Sunset from “The Fighting Temeraire” in GLSL
Ask HN: What are some of the best written macOS apps?
I'm looking for github repositories of applications. Note, I do not care how many stars/forks a repo has or how useful the application itself is. I'm looking for well structured tested code that can serve as a reference to write a macOS application.