Live data from Hacker News

Show HN: DDL to Data – Generate realistic test data from SQL schemas

news.ycombinator.com

31–34 of 34 posts

Re: Show HN: DDL to Data – Generate realistic test data from SQL schemas

#31
Real Test data génération as saas was not a viable business for us.

Developers use their tool or develop a script (with ai or not)

We made it free, the value comes when you can use it in your development process.

https://www.tabulify.com/learning-tabulify-step-9-how-to-fil...

The cost of calling a service is also not free.

In all case, all the best in your endeavour.

Re: Show HN: DDL to Data – Generate realistic test data from SQL schemas

#33
post #18

Earlier quoted context omitted.

The realistic cardinality is actually a good start (the problem with things like using Faker for DB seeds being that everything is entirely too random). If one were be able to use metrics as source then, depending on the quality of the metrics, it might be possible to distribute data in a manner similar to what's observed in production? You know, some users that are far more active than others, for example. Consideri…

This is useful. What if you ran a CLI locally that extracts just the statistical profile from prod cardinality, relationship ratios, etc. and uploaded that? We'd never touch your database, you just hand us the metrics and we match the shape.

We do exactly that in one of our products. It's called data profiling.

Re: Show HN: DDL to Data – Generate realistic test data from SQL schemas

#34
hey tbrannan, nice tool! i was actually comparing a few of these recently for the staging DB and ended up trying https://seedfa.st/ since i needed something that works in CI pipelines(we use github actions). the main difference i actually noticed is that ddl-to-data is web-based and seedfast is os-native(because its actually a cli tool first) and integrates with CI/CD pipelines smoothly. both handle FK constraints fine, but tbh i prefer not having to copy-paste schemas into a web UI every time. though your pricing looks much more straightforward for small projects which i like more
Post reply on HN