Re: [GENERAL] Generating sample data

2016-12-28 Thread Rich Shepard
On Wed, 28 Dec 2016, Martijn Tonies (Upscene Productions) wrote: Not open source, but also not pricey (IMO): Advanced Data Generator. http://www.upscene.com/advanced_data_generator/ Generates e-mail addresses, street names, first & last names, company names, complex relationships etc. And yes,

Re: [GENERAL] Generating sample data

2016-12-28 Thread Martijn Tonies (Upscene Productions)
Hi, Not open source, but also not pricey (IMO): Advanced Data Generator. http://www.upscene.com/advanced_data_generator/ Generates e-mail addresses, street names, first & last names, company names, complex relationships etc. And yes, this is our product. ;) With regards, Martijn Tonies Upscen

Re: [GENERAL] Generating sample data

2016-12-27 Thread bto...@computer.org
- Original Message - > From: "Rich Shepard" > 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 th

Re: [GENERAL] Generating sample data

2016-12-27 Thread Rich Shepard
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. Many thanks, Rich -- Sent via pgsql-general mailing list (pgsq

Re: [GENERAL] Generating sample data

2016-12-27 Thread Rich Shepard
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 It was I use to generate fake/sample data. Adrian, Aha! That's a great start for me. Many thanks, Rich -- Sent via pgsql-general mail

Re: [GENERAL] Generating sample data

2016-12-27 Thread Rich Shepard
On Tue, 27 Dec 2016, Adrian Klaver wrote: What sort of data do you want to create? Adrian, Various text, date, and numeric values. If it is data specific to a field of study then things might get trickier. It's not a common database. I'll probably need to cobble together generic data

Re: [GENERAL] Generating sample data

2016-12-27 Thread Adrian Klaver
On 12/27/2016 12:06 PM, Rich Shepard wrote: On Tue, 27 Dec 2016, Steve Crawford wrote: You could start here: http://www.softwaretestingmagazine.com/tools/open-source-test-data-generators/ I have rolled my own on occasion by just pulling some public lists of most common given names and famil

Re: [GENERAL] Generating sample data

2016-12-27 Thread Adrian Klaver
On 12/27/2016 02:23 PM, Adrian Klaver wrote: On 12/27/2016 12:03 PM, Rich Shepard wrote: On Tue, 27 Dec 2016, Greg Navis wrote: In the Ruby land there's a gem called faker that allows you to generate fake data. However, I'm not sure it can generate data based

Re: [GENERAL] Generating sample data

2016-12-27 Thread Adrian Klaver
On 12/27/2016 12:03 PM, Rich Shepard wrote: On Tue, 27 Dec 2016, Greg Navis wrote: In the Ruby land there's a gem called faker that allows you to generate fake data. However, I'm not sure it can generate data based on a schema so a little bit of scripting my be

Re: [GENERAL] Generating sample data

2016-12-27 Thread Rich Shepard
On Tue, 27 Dec 2016, Steve Crawford wrote: You could start here: http://www.softwaretestingmagazine.com/tools/open-source-test-data-generators/ I have rolled my own on occasion by just pulling some public lists of most common given names and family names and toing a full-join. Same for city,

Re: [GENERAL] Generating sample data

2016-12-27 Thread Steve Crawford
On Tue, Dec 27, 2016 at 12:01 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > You could start here: > http://www.softwaretestingmagazine.com/tools/open-source-test-data- > generators/ > > I have rolled my own on occasion by just pulling some public lists of most > common given names

Re: [GENERAL] Generating sample data

2016-12-27 Thread Rich Shepard
On Tue, 27 Dec 2016, Greg Navis wrote: In the Ruby land there's a gem called faker that allows you to generate fake data. However, I'm not sure it can generate data based on a schema so a little bit of scripting my be necessary. Would this approach work for you?

Re: [GENERAL] Generating sample data

2016-12-27 Thread Steve Crawford
You could start here: http://www.softwaretestingmagazine.com/tools/open-source-test-data-generators/ I have rolled my own on occasion by just pulling some public lists of most common given names and family names and toing a full-join. Same for city, streets, etc. -Steve On Tue, Dec 27, 2016 at 1

Re: [GENERAL] Generating sample data

2016-12-27 Thread Greg Navis
In the Ruby land there's a gem called faker that allows you to generate fake data. However, I'm not sure it can generate data based on a schema so a little bit of scripting my be necessary. Would this approach work for you? Yours Greg

[GENERAL] Generating sample data

2016-12-27 Thread Rich Shepard
My previous databases used real client (or my own) data; now I want to generate sample data for the tables in the two applications I'm developing. My web search finds a bunch of pricey (IMO) commercial products. Are there any open source data generators that can provide sample data based on e