postgresql
Why PostgreSQL CDC Breaks in Production
PostgreSQL CDC doesn’t fail because of WAL. It fails because of gaps between snapshot, checkpoints, and ordering. Real failure modes and what actually works in production.
Dmitry Narizhnykh
Founder of DBConvert (Slotix s.r.o.). Building database migration and synchronization tools since 2001, starting with Access2MySQL under DMSoft Technologies.
postgresql
How to Inspect a pg_dump Without Restoring It
A database backup is usually made for recovery. Sometimes you only need to know what is inside it.
How to Open MDB and ACCDB Files Online Without Microsoft Access
You can inspect an Access .mdb or .accdb file in a browser on Mac, Linux or Windows. What a viewer shows, and when you still need Access.
snowflake
How to Load Data into Snowflake: COPY INTO, Snowpipe and Snowpipe Streaming
Three ways in, one rule underneath: Snowflake ingestion appends. How COPY INTO, Snowpipe and Snowpipe Streaming work today, and what it takes to keep a table current from MySQL or PostgreSQL.
ai
Text-to-SQL on a Real Database: Two Questions, Five-Table Joins
Two real business questions typed in plain English against a live MySQL database in DBConvert Streams — and the five-table joins text-to-SQL wrote to answer them. What it got right, and the decision it made without telling me.
chatgpt
MySQL vs PostgreSQL Syntax: Translate Queries with AI — Then Verify the Results
Some dialect differences fail loudly. The dangerous ones return different numbers with no error. Real error messages, a live verified example, and the AI loop that proves a translation.
chatgpt
ChatGPT and Your SQL Database: Stop Pasting Schemas, Connect Them Instead
Pasting schemas into ChatGPT works for one-off queries. For real database work, connect the AI read-only to your database via MCP or in-app AI Chat.
Change Data Capture
PostgreSQL Change Data Capture (CDC): Real-Time Replication with Logical Decoding
Set up PostgreSQL CDC with logical decoding - replication slots, WAL, and the failure modes that break change data capture in production.
database migration
How to verify a database migration before cutover
A database migration can complete successfully while the actual values are wrong. Here’s how to compare MySQL and PostgreSQL directly before cutover.
mcp
What a good database MCP server gets right
Wrapping a few queries as MCP tools is the easy weekend part. What makes a database MCP server safe to point at real data is everything around the tools: read-only by default, narrow tools, per-request scoping, and bounded results.
dbconvert streams
Database Explorer: From Schema Browser to Full Data Workspace
Database Explorer in DBConvert Streams is a free workspace for browsing databases, files, S3 storage, SQL results, and editable data grids before and after migration or CDC.
DuckDB
Embedded DuckDB Starts Simple. Then It Needs a Process Boundary.
Embedding DuckDB inside an API process is simple until native execution shares the same failure domain. A federated query crash showed why DBConvert Streams is moving interactive DuckDB work behind a supervised query worker.