Blogsby GlyphNetSuite to ClickHouse: SuiteAnalytics Connect, Sync Methods & Ledger Modeling Guide
Move NetSuite data to ClickHouse with SuiteAnalytics Connect, an ELT tool or a script. Compare 5 methods and plan for deletes, custom fields and limits.
Databases
Postgres, MySQL, OLAP engines, storage and query performance. 1,670 posts on file, most from ClickHouse, PlanetScale, DuckDB.
Fri Nov 63 posts
ClickHouse release 26.10
ClickHouse 26.10 introduces function composition, more flexible joins, faster GROUP BY queries, disk spilling for IN subqueries, an experimental columns cache, and Freeform and SQLite formats.
+1more from ClickHouse Blog that day
Thu Nov 56 posts
Change Data Capture in SQLite, Without the Triggers
Built-in CDC in Turso Database records every insert, update, and delete for you. Here is how it works, where it is rough, and how to write a consumer that survives restarts.
Managed Postgres on Railway
An overview of Postgres on Railway: maintenance, data browsing, query statistics, high availability, backups, recovery, pooling, and upgrades.
From Toronto Hackathon to Stockholm meetup: Metabase Data App world tour
From a Toronto hackathon to a Stockholm data meetup: how we built data apps for asteroids, F1 telemetry, and a pumpkin ERP on Metabase and ClickHouse.
DataGrip 2026.3: Agentic Development With JetBrains Air, Cross-Database Queries, DuckDB Support, and Major UX Improvements
DataGrip 2026.3, the third major update of the year, is here! Let’s take a look at what’s inside. AI JetBrains Air is now available by default in DataGrip.
Designing a reliable unplanned failover
How Neki detects a failed Postgres primary, and chooses a new one from the WAL that survived.
How JetBrains Built Cross-Database Queries into DataGrip with DuckDB
JetBrains users had long asked to join data across different database connections in a single query. Rather than build its own cross-database query engine, JetBrains embedded DuckDB in DataGrip, using DuckDB’s custom table functions to...
Wed Nov 43 posts
Change the database: Two engineering teams on open source, hard forks, and sovereign data
Based on a conversation with Altinity's Robert Hodges and Max Romanenko, CTO at EDB Some engineering principles survive every product cycle.
Engineered to Run Agents and Apps: Join Nutanix at KubeCon + CloudNativeCon NA 2026
The cloud native community is gearing up for KubeCon + CloudNativeCon North America 2026 in Salt Lake City from November 9–12, and Nutanix is proud to be a Diamond Sponsor.
Fencing a Postgres primary that might still be alive
Promoting a standby doesn't stop the old Postgres primary from taking writes. Here's how the control plane behind ClickHouse Managed Postgres fences it on bare metal, AWS and GCP, and why the design is fail-open.
Tue Nov 39 posts
systemd-sysusers and Directory-Managed Postgres Accounts: Avoiding Startup Failures
Recent EDB and PGDG RPM packages now create the Postgres service account through systemd-sysusers, which can leave hosts using Active Directory or LDAP accounts unable to start the database after a reboot.
One LDAP Login for YugabyteDB Anywhere and Your Database
Discover how a single LDAP directory can manage logins for both YugabyteDB Anywhere and the database. We show how to fix the multiple login issue using LDAP.
DataGrip and Database Tools User Experience Survey #3 Results
Introduction Hello, DataGrip community! We’re back with the results of our third DataGrip and Database Tools User Experience Survey. A big thank you to everyone who took the time to participate!
How SQL Server Uses File Storage
How SQL Server Uses File Storage by Everpure Blog Managing large objects in SQL Server requires choosing the right storage strategy.
The hidden latency inside your database
Network-attached storage is a fine choice and a bad default.
Trace linkage: connect the dots between your app traces and database queries
When an application request slows down, a trace can show a database call. Finding the database query behind it can be tedious, requiring you to switch between traces and database telemetry, as well as match timestamps or query text by...
Does your application need local data or faster Postgres?
Local synchronization makes reads fast, but adds another data layer to manage. Explore how AI agents change the trade-off and when NVMe-backed Postgres can simplify the architecture.
OpenAI appoints Jill Hazelbaker as Chief Corporate Affairs Officer
Jill Hazelbaker will join OpenAI as Chief Corporate Affairs Officer, leading the company’s global communications and corporate positioning.
2 million databases and counting: the architecture behind Sauna's AI teammate
Why Sauna moved off Cloudflare and Litestream, and how Turso now powers around 90,000 new databases a day.
Mon Nov 22 posts
Why we're moving our warehouse product off DuckDB
Five months ago, we rebuilt our warehouse on DuckDB instead of ClickHouse. We did it because a shared ClickHouse cluster couldn't handle hours-long…
What's new in clickhousectl v0.5.0
clickhousectl v0.5.0 takes UDFs from local to Cloud, adds ClickHouse Managed Postgres observability, standardises the command surface, and lists the API-key permissions every Cloud command needs.
Fri Oct 302 posts
Databases as Variables: What Unlimited Databases Actually Changes
What changes when a database is free to create and costs only storage while idle.
Explorer and Notebooks: investigations your team can rerun
Explorer is one editor for your Supabase database and your logs. Save an investigation as a Notebook and anyone on the project can run it again.
Thu Oct 296 posts
Turns out database backups are NOT trivial
I thought backing up a database was simple, you just loop over the tables and copy the rows out. Nipunn sat me down at a whiteboard and showed me why that can give you a backup of data that never existed, and how Convex gets around it.
AI functions reach the SQL standard
At the October meeting of the SQL Standards committee on October 13, two AI topics were on the agenda. EDB colleagues Peter Eisentraut and Bilge Ince presented a discussion paper on model inference functions in SQL.
Designing a planned switchover for minimum disruption
How Neki uses preflight checks, query buffering, synchronous replication, and fast rollback to make Postgres primary switchovers less disruptive.
From Spreadsheets to DuckLake: A Data Engineer's Road to DuckDB
After nearly two decades working with increasingly sophisticated data infrastructure, data engineer [Matt Martin](https://www.linkedin.com/in/mattmartin14/) discovered DuckDB could handle many of the analytical tasks he cared about without...
Multigres private alpha: automatic failover for Supabase Postgres
Multigres brings automatic failover to Supabase Postgres, in private alpha for organizations on a paid plan.
Meet GroeneAI: our autonomous contributor to ClickHouse
Meet GroeneAI, ClickHouse’s autonomous engineering agent that contributed more than 3,000 merged pull requests in under seven months.
Wed Oct 286 posts
The Last Brick: Horizontal Write Scaling Is Coming to EDB Postgres® AI
With sharding in EDB Postgres AI Distributed, you get more scale with the same engine, same groups, and same high availability.
Evaluate AI models for observability: o11y-bench joins Fireworks' Specialized Intelligence Index and reaches v1.1
When evaluating AI models for observability, generating a plausible query or explanation isn't enough. Teams need to know whether an agent's conclusions are supported by telemetry, whether its changes to dashboards actually work, and...
OrioleDB public beta: a Postgres storage engine for update-heavy tables
OrioleDB, an open-source storage engine for Postgres, is in public beta on every Supabase plan.
Bringing the Big Ducks
The pursuit of all things duck-related has led us to some interesting places. In this blog, MotherDuck CEO Jordan Tigani explores the bigger, darker corners of benchmarks on top DuckDB 1.5 (and teases what is possible in DuckDB 2.0).
The new cost-based join optimizer with reordering support for non-inner joins
ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.
+1more from ClickHouse Blog that day
Snowflake Optima Planning: Cross-Query Performance
TL;DR: Optima Planning already learns from repeated queries. It can now also learn across queries, when a brand-new query shares a plan fragment or join with something that has already run, it reuses that feedback on the very first...
Tue Oct 273 posts
Your database is lying to you about time
Date.now() in a Convex mutation isn't actually now, and _creationTime doesn't follow the order things were committed in. Ian sat me down at a whiteboard to explain the three times in a database, how you can miss rows, and how commit...
A Day in the Life: Inside a Principal Sales Engineer Role at EDB
In the fast-paced world of enterprise software, connecting cutting-edge database technology to real-world business challenges requires deep technical expertise and a passion for continuous learning.
Queries are 2x faster, but we're making some event properties temporary
TL;DR We're rebuilding how PostHog stores events making queries about a third faster on average, and up to 2x faster for common queries. $set, $set…