3 ms·

If it were easier to do the thing I want, I'd do it all the time. What I want is to be able to point to either a database with empty tables or an SQL file and f

by nanis 5y ago

If it were easier to do the thing I want, I'd do it all the time. What I want is to be able to point to either a database with empty tables or an SQL file and fill in the tables correctly with bogus data while respecting all the constraints. I have not found a tool that does that. It is trivial to write something where a tool takes a spec written in a way the tool understands (but possibly nothing else) and then spew out data without having to worry about, e.g., foreign key relationships. If I have a choice, I wire together something Perl that does what I want. Sometimes, I do not have a choice and have to use something like https://www.mockaroo.com/ https://www.mockaroo.com/ or https://generatedata.com/ https://generatedata.com/ but then I have fiddle with stuff. I am fond of David Golden's https://metacpan.org/pod/Data::Fake https://metacpan.org/pod/Data::Fake

long_time_gone 5y ago
> If it were easier to do the thing I want, I'd do it all the time. What I want is to be able to point to either a database with empty tables or an SQL file and fill in the tables correctly with bogus data while respecting all the constraints. I have not found a tool that does that. I was thinking more of a virtual CSV file that you can query like a SQL table. > Sometimes, I do not have a choice and have to use something like https://www.mockaroo.com/ https://www.mockaroo.com/ or https://generatedata.com/ https://generatedata.com/ but then I have fiddle with stuff. This is exactly the type of thing I was looking for, I will check them out. I do worry that each use case is too specific for a tool like this. Thanks for the help.
gerardnico 5y ago
Tabulify understands basic relational constraints. https://tabulify.com/docs/getting_started/9_data_generation https://tabulify.com/docs/getting_started/9_data_generation When you got double column primary key, this is really hard to model it. May be one day, I would add this feature.

by nanis 5y ago

long_time_gone 5y ago

> If it were easier to do the thing I want, I'd do it all the time. What I want is to be able to point to either a database with empty tables or an SQL file and fill in the tables correctly with bogus data while respecting all the constraints. I have not found a tool that does that. I was thinking more of a virtual CSV file that you can query like a SQL table. > Sometimes, I do not have a choice and have to use something like https://www.mockaroo.com/ https://www.mockaroo.com/ or https://generatedata.com/ https://generatedata.com/ but then I have fiddle with stuff. This is exactly the type of thing I was looking for, I will check them out. I do worry that each use case is too specific for a tool like this. Thanks for the help.

gerardnico 5y ago

Tabulify understands basic relational constraints. https://tabulify.com/docs/getting_started/9_data_generation https://tabulify.com/docs/getting_started/9_data_generation When you got double column primary key, this is really hard to model it. May be one day, I would add this feature.