Database Populating (Test Data)

[Anon]

Testing a database with a handful of rows in each table is known to be asking for trouble.

To run meaningful tests on a new database one needs to populate it to a real-world size.

It would make testing easier to have dummy but realistic addresses rather that random text.

Does anyone know of freely available bogus data on the web ?

[[deleted]]

What kind of data are you looking for, and why don't yuo just use rand() to generate some bogus stuff?

[Anon]

I could of course use rand(), the trouble with this approach is you end up with junk-looking data that is difficult to differentiate from real junk produced by buggy code.

For example, I would like my dummy suscribers' adresses to look like real-world adresses.

Furthermore I don't know how to query for a randomly generated value.

There may exist well-known solution to this problem but I'm quite new to the field of database development. So thanks for any clue...