Show HN: DDL 转数据 – 从 SQL 模式生成逼真的测试数据
6 分•作者: ddltodata•6 个月前
在多次拒绝“直接使用生产数据并进行脱敏”的请求后，我开发了 DDL to Data。团队需要填充数据的数据库来进行测试，但从生产环境拉取数据意味着需要进行安全审查、个人身份信息（PII）清洗以及 DevOps 工单。而手写的种子脚本则显得缓慢、脆弱，并且一旦模式发生变化，就会过时。<p>粘贴你的 CREATE TABLE 语句，就能获得逼真的测试数据。它会解析你的模式，保留外键关系，并生成看起来真实的数据，例如邮箱看起来像邮箱，时间戳也合理，并且会遵守唯一性约束。<p>无需设置，无需配置。支持 PostgreSQL 和 MySQL。<p><a href="https://ddltodata.com" rel="nofollow">https://ddltodata.com</a><p>欢迎任何处理测试数据或预发布环境的人提供反馈。还缺少什么功能？
查看原文
I 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.<p>Paste your CREATE TABLE statements, get realistic test data back. It parses your schema, preserves foreign key relationships, and generates data that looks real, emails look like emails, timestamps are reasonable, uniqueness constraints are honored.<p>No setup, no config. Works with PostgreSQL and MySQL.<p><a href="https://ddltodata.com" rel="nofollow">https://ddltodata.com</a><p>Would love feedback from anyone who deals with test data or staging environments. What's missing?