Latest Tech News

Stay updated with the latest in technology, AI, cybersecurity, and more

Filtered by: postgresql Clear Filter

PgEdge Goes Open Source

news.ycombinator.com Dave Page 2025-09-29 11:01:57

In November last year after nearly two decades at my previous gig, I came to the conclusion that I didn’t want to work at what seemed to be rapidly becoming an AI-focused company and moved to pgEdge where the focus is well and truly on distributed PostgreSQL and Postgres generally. Distributed databases (and particularly Postgres of course) have always been a passion of mine – even being a key topic of my master’s dissertation many years ago. Moving to pgEdge was a breath of fresh air. Not only

Topics: distributed pgedge postgres postgresql source
Read More
Shop Amazon

PG Auto Upgrade – Docker (and K8s) container to auto upgrade your database

news.ycombinator.com Unknown 2025-11-08 23:10:30

pgautoupgrade This is a PostgreSQL Docker image to automatically upgrade your database. Its whole purpose in life is to automatically detect the version of PostgreSQL used in the existing PostgreSQL data directory, then automatically upgrade it (if needed) to the required version of PostgreSQL using pg_upgrade with the --link option. After this, the PostgreSQL server starts and runs as per normal. The old cluster data will be removed. The reason this Docker image is needed, is because the of

Topics: data docker image pgautoupgrade postgresql
Read More
Shop Amazon

ClickHouse matches PG for single-row UPDATEs and 4000 x faster for bulk UPDATEs

news.ycombinator.com Unknown 2025-11-10 10:52:43

TL;DR · On identical hardware and data, ClickHouse matches PostgreSQL for single-row UPDATEs and is up to 4,000× faster in our tests for bulk UPDATEs. · Why it matters: Bulk updates are common in OLTP workloads, and ClickHouse’s columnar design + parallelism make them far faster. · Caveat: PostgreSQL is fully transactional by default; ClickHouse isn’t. Results compare each engine’s native execution model, not identical transaction guarantees. PostgreSQL is the most popular open-source

Topics: clickhouse data postgresql update updates
Read More
Shop Amazon

Show HN: SnapQL – Desktop app to query Postgres with AI

news.ycombinator.com Unknown 2026-03-01 00:08:18

SnapQL cursor for data ⚡️ - explore your postgresql db in seconds demo.mp4 generate schema-aware queries in seconds with AI supports any PostgreSQL database fully local desktop app use your own OpenAI key Build SnapQL locally I will eventually ship some precompiled binaries, but that takes some setup. In the meantime, follow these steps to build a local copy:

Topics: build local postgresql seconds snapql
Read More
Shop Amazon
Trending Topics
Hot Now
ai 3583 apple 2975 new 2359 google 1991 content 1710
Popular
like 1476 company 1408 pro 1305 iphone 1128 app 1113 zdnet 1094 said 1043 data 1036 does 896 reviews 882
Emerging
editorial 861 amazon 854 game 800 samsung 764 phone 756 pixel 754 android 730 just 712 available 680 users 676
About GoKawiil

GoKawiil is a project by nerdhub.co that curates technology news from trusted sources. We built this site to provide a cleaner, more mobile-friendly experience without intrusive ads or heavy JavaScript.

Privacy

Your privacy matters. GoKawiil doesn't use Google Analytics or Facebook Pixel. The only tracking occurs through affiliate links to Amazon.

Advertising

Interested in advertising? Contact us at [email protected]