Re: [GENERAL] Generating sample data - Mailing list pgsql-general

From btober@computer.org
Subject Re: [GENERAL] Generating sample data
Date
Msg-id 1285813312.124899411.1482892327155.JavaMail.zimbra@broadstripe.net
Whole thread Raw
In response to Re: [GENERAL] Generating sample data  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
----- Original Message -----
> From: "Rich Shepard" <rshepard@appl-ecosys.com>
> To: pgsql-general@postgresql.org
> Sent: Tuesday, December 27, 2016 7:23:46 PM
> Subject: Re: [GENERAL] Generating sample data
>
> On Tue, 27 Dec 2016, Adrian Klaver wrote:
>
> > As it happens there is a Python version of the a fore mentioned faker:
> > https://pypi.python.org/pypi/Faker/0.7.7
>
> Adrian,
>
>    Impressive and complete. It will generate all the data I need.
>


This is kind of fun:


https://github.com/bmtober/groan


I had to hunt down the original author from the 1990's, which was when I originally downloaded from his personal web
siteat 


http://raingod.com/raingod/resources/Programming/Perl/Software/Groan/


The initial commit on that github page is the original source as provided by Mr. McIntyre.

In a subsequent commit, I removed some of the original code that formatted for HTML output, leaving just plain text,
andalso posted an example grammar for generating fake names and strings that look like social security numbers (i.e., a
U.S.taxpayer identification).  

The script will generate duplicates, but you can do something like

for n in {1..20}
do
   groan.pl ssn.gn
done | sort -u

to get unique source data.

By defining other custom grammars, you could potentially generate all kinds of data.

-- B



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: [GENERAL] Generating sample data
Next
From: "Martijn Tonies \(Upscene Productions\)"
Date:
Subject: Re: [GENERAL] Generating sample data