DDL to Data: Generate Realistic Test Data from SQL Schemas
By
ddltodata
Plain bagel done well. Pleasantly substantive.
Summary
DDL to Data is a tool that generates realistic test data from SQL schemas, addressing the common problem of needing populated databases for testing without using production data. The creator built it to avoid security reviews, PII scrubbing, and DevOps tickets associated with production data, as well as the fragility of hand-written seed scripts. The tool parses CREATE TABLE statements, preserves foreign key relationships, and generates realistic test data automatically.
Key quotes
· 5 pulledI built DDL to Data after repeatedly pushing back on 'just use production data and mask it' requests.
Teams needed populated databases for testing, but pulling prod meant security reviews, PII scrubbing, and DevOps tickets.
Hand-written seed scripts were the alternative slow, fragile, and out of sync the moment schemas changed.
Paste your CREATE TABLE statements, get realistic test data back.
It parses your schema, preserves foreign key relationships, and generates realistic test data automatically.
You might also wanna read
Litestream 0.5.0 Release: User Advises Caution Before Production Deployment
The author, a regular Litestream user, advises caution about the newly released Litestream 0.5.0, recommending users wait for another releas
mtlynch.io·7mo ago
Why Average LLM Use Is Likely Destroying Value in Software Development
The author argues that, contrary to prevailing hype, the average use of Large Language Models (LLMs) is likely destroying value rather than
unessays.substack.com·10h ago
How AI Accelerated Prototyping: From Idea to Tangible in Record Time
The author reflects on how AI has transformed their prototyping workflow. Previously, the biggest bottleneck was the time needed to scaffold
darylcecile.net·10h ago
GitLab 19.0 launches with Secrets Manager, agentic workflows, and self-hosted AI models
GitLab 19.0 has been released, positioning itself as an intelligent orchestration platform for DevSecOps. The release includes expanded secr
bit.ly·23h ago
Centralizing Error Handling in Rust with Custom AppError Enums
This article discusses the importance of centralizing error handling in Rust applications using a custom AppError enum combined with map_err
Zig Devlog: Build System Rework Separates Maker and Configurer Processes
This devlog entry from the Zig programming language project announces a major rework of the build system, separating the maker process from
ziglang.org·1d ago