Automatically generated test data to a DB from a schema?

postgresql database test-data
Léo Léopold Hertz 준영 picture Léo Léopold Hertz 준영 · Aug 18, 2009 · Viewed 8.9k times · Source

I have a discussion-db, and I need a great amount of test data, for different sized samples. Please, see the ready SELECT, JOIN and CREATE-queries, please scroll down in the link.

  1. How can I automatically generate test data to the db?

  2. How to generate test data in different sized samples?

  3. Is there some ready tool?

Answer

Bill Karwin picture Bill Karwin · Aug 18, 2009

Here are a couple of suggestions for free tools that generate test data:

  • Databene Benerator: supports many JDBC-capable database brands, uses XML format compatible with DbUnit, GPL license.

  • Super Smack: originally a load-test tool for MySQL, it also supports PostgreSQL and it includes a generator of mock data.

I asked a similar question here on StackOverflow in February, and the two choices above seemed like the best options.

Related questions

How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More
Import SQL dump into PostgreSQL database

We are switching hosts and the old one provided a SQL dump of the PostgreSQL database of our site. Now, I'm trying to set this up on a local WAMP server to test this. The only problem is that I …

Read More