Lorem Ipsum for PII

When you’re developing code to handle data it’s almost essential to have a decent sized set of test data, so you can build a test harness to check on functionality and performance as you go.

A common way of doing that is to take a snapshot of your production database and pull out an appropriate subset from there. That works pretty well in most cases, but it’s a really bad idea if the data you’re working with is personally identifiable information, such as email addresses, phone numbers, credit cards and so on.

Test data gets spread everywhere. It’s checked in to source control systems, copied to developers laptops, included in publicly visible bug reports, shared with mailing lists when asking questions and sent to that dodgy overseas outsourcing company your CTO is evaluating. And if the code you’re developing sends email or SMS messages then sooner or later you’re going to misconfigure your test platform and send test messages to the contacts in your test data. (I’ve only done that once, and it was a memorable experience.)

But test data needs to be similar to real data, and look plausible, or it’s hard for manual testers to identify problems using it.

Enter – a simple API for generating random user data – name, email address, birthdate, phone numbers, postal address, social security number, even photos.

Need something more configurable, that lets you create a fake API to test your code against? Try RandomAPI for a web API returning JSON, SQL, CSV or YAML.

Just need some test JSON files you can generate and paste in to your test suite? Try JSON Generator.

Need bulk data, to load into your test database? Look at Mockaroo, DummyData or GenerateData.

Just don’t use your production PII, even if you plan on anonymizing it before use. Really.


Your email address will not be published. Required fields are marked *