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 there is a Python

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

Re: [GENERAL] LYDB: What advice about stored procedures and other server side code?

2016-12-27 Thread Alban Hertroys
> On 27 Dec 2016, at 23:03, Guyren Howe wrote: > > I am putting together some advice for developers about getting the most out > of SQL servers in general and Postgres in particular. I have in mind the > likes of most web developers, who through ignorance or a strange

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

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] LYDB: What advice about stored procedures and other server side code?

2016-12-27 Thread Steve Atkins
> On Dec 27, 2016, at 2:03 PM, Guyren Howe wrote: > > I am putting together some advice for developers about getting the most out > of SQL servers in general and Postgres in particular. I have in mind the > likes of most web developers, who through ignorance or a strange

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

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

[GENERAL] LYDB: What advice about stored procedures and other server side code?

2016-12-27 Thread Guyren Howe
I am putting together some advice for developers about getting the most out of SQL servers in general and Postgres in particular. I have in mind the likes of most web developers, who through ignorance or a strange cultural preference that has emerged, tend to treat their database server as a

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

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

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

Re: [GENERAL] Error in column constraint syntax

2016-12-27 Thread Rich Shepard
On Tue, 27 Dec 2016, David G. Johnston wrote: ​5.3.1 is instructional. The SQL Command chapter is the authoritative source for syntax. David, I'll read that, too. CHECK ( expression ) [ NO INHERIT ] | -- you are missing the mandatory ( ) surrounding your expression All of the examples

Re: [GENERAL] Error in column constraint syntax

2016-12-27 Thread David G. Johnston
On Tue, Dec 27, 2016 at 9:39 AM, Rich Shepard wrote: > I'm encountering DDL syntax errors using postgres-9.6.1 that I've not > before seen, and I'm having a difficult time finding the cause when reading > the appropriate sections of the manual; Section 5.3.1 in this

[GENERAL] Error in column constraint syntax

2016-12-27 Thread Rich Shepard
I'm encountering DDL syntax errors using postgres-9.6.1 that I've not before seen, and I'm having a difficult time finding the cause when reading the appropriate sections of the manual; Section 5.3.1 in this case: CREATE TABLE Agencies ( org_name VARCHAR(48) PRIMARY KEY, acronym VARCHAR(8)

Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)

2016-12-27 Thread Adrian Klaver
On 12/26/2016 11:43 PM, thomas.deboben@rohde-schwarz.com wrote: This has worked for different version, but now we get sometimes trouble Which version did it work on? I'm working with PostgreSQL 9.5.0.1. We download the Win x86-32 and Win x86-64 installation packages from

Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x0000274D/10061)

2016-12-27 Thread Thomas . Deboben . ext
>Von: Adrian Klaver >An:thomas.deboben@rohde-schwarz.com, pgsql-general@postgresql.org >Datum: 19.12.2016 19:05 >Betreff: Re: [GENERAL] Windows installation - could not connect to server: Connection refused (0x274D/10061) > >On 12/16/2016 07:01 AM,

[GENERAL] Indexes and loops or some kind of pg error?

2016-12-27 Thread Арсен Арутюнян
Hello. I have a few questions: 1)  JobStatusTest1 function has only one request and JobStatusTest2 function has as many as six requests. Why function JobStatusTest2 is faster?  JobStatusTest1 : 981.596 ms JobStatusTest2 : 849.133 ms 2) Two functions JobStatusTest3 and JobStatusTest4 perform the