PostGre

Roedy Green

unread,

Jun 4, 2012, 10:46:28 AM6/4/12

to

PostGre 9.1.4 was released today.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Controlling complexity is the essence of computer programming.
~ Brian W. Kernighan 1942-01-01
.

Hans Castorp

unread,

Jun 4, 2012, 11:52:25 AM6/4/12

to

Roedy Green wrote on 04.06.2012 16:46:
> PostGre 9.1.4 was released today.

The name is either written as Postgres or PostgreSQL, never PostGre.

Roedy Green

unread,

Jun 7, 2012, 8:02:01 PM6/7/12

to

On Mon, 04 Jun 2012 17:52:25 +0200, Hans Castorp
<REWYRL...@spammotel.com> wrote, quoted or indirectly quoted
someone who said :

>
>The name is either written as Postgres or PostgreSQL, never PostGre

I have added that warning to
http://mindprod.com/jgloss/postgresql.html

Hans Castorp

unread,

Jun 8, 2012, 3:48:35 AM6/8/12

to

Roedy Green wrote on 08.06.2012 02:02:
> On Mon, 04 Jun 2012 17:52:25 +0200, Hans Castorp
> <REWYRL...@spammotel.com> wrote, quoted or indirectly quoted
> someone who said :
>
>>
>> The name is either written as Postgres or PostgreSQL, never PostGre
> I have added that warning to
> http://mindprod.com/jgloss/postgresql.html
>

You got it wrong again

"2012-06-04 It is also known as Postgre, but never Postgres."

No, it's not.

That should read:

"2012-06-04 It is also known as Postgres, but never Postgre."

Luuk

unread,

Jun 8, 2012, 2:13:46 PM6/8/12

to Roedy Green

On 04-06-2012 16:46, Roedy Green wrote:
> PostGre 9.1.4 was released today.
>

I dont see why theese 2 point are "Advantages of MySQL over PostgreSQL":

1) MySQL support is more widespread on ISP (Internet Service Provider)
webservers.
Because its used more, it has an advantage? Whats the technical point in
this?

2) There more books and tutorials on MySQL
Everyone can write a book, but its about the good books that count!

Roedy Green

unread,

Jun 8, 2012, 6:16:43 PM6/8/12

to

On Fri, 08 Jun 2012 20:13:46 +0200, Luuk <lu...@invalid.lan> wrote,

quoted or indirectly quoted someone who said :

>I dont see why theese 2 point are "Advantages of MySQL over PostgreSQL":
>
>1) MySQL support is more widespread on ISP (Internet Service Provider)
>webservers.
>Because its used more, it has an advantage? Whats the technical point in
>this?

If you write an app, you may want to host it somewhere. You have more
choices. This means probably better service, lower price, faster
response etc . Think of the opposite extreme, writing your code for
some obscure engine. Then you pretty well have to host it on your own
server.

>2) There more books and tutorials on MySQL
>Everyone can write a book, but its about the good books that count!

Granted. The more books there are, the more competition, so the
better odds of finding a good one. The most awful books are usually
on some obscure topic without any alternatives.

Roedy Green

unread,

Jun 8, 2012, 6:17:04 PM6/8/12

to

On Fri, 08 Jun 2012 09:48:35 +0200, Hans Castorp

<REWYRL...@spammotel.com> wrote, quoted or indirectly quoted
someone who said :

>

> "2012-06-04 It is also known as Postgres, but never Postgre."

fixed. thanks for your patience.

Luuk

unread,

Jun 9, 2012, 5:14:15 AM6/9/12

to

On 09-06-2012 00:17, Roedy Green wrote:
> On Fri, 08 Jun 2012 09:48:35 +0200, Hans Castorp
> <REWYRL...@spammotel.com> wrote, quoted or indirectly quoted
> someone who said :
>
>>
>> "2012-06-04 It is also known as Postgres, but never Postgre."
> fixed. thanks for your patience.
>

"Postgre JDBC type 4 driver" ==> "PostgreSQL JDBC Driver" ?

Hans Castorp

unread,

Jun 9, 2012, 5:55:58 AM6/9/12

to

Roedy Green wrote on 08.06.2012 02:02:

> http://mindprod.com/jgloss/postgresql.html

In the section "Advantages of PostgreSQL over MySQL", you might want to add the following items

+ More standard compliant than MySQL
+ Supports windowing functions
+ Supports common table expressions (CTE) including writeable CTEs
+ Supports recursive queries
+ No limits on the usage of subselect in DML statements
+ Supports table functions (select * from my_function())
+ Supports transactional DDL
+ Supports user defined aggregate functions
+ Supports partial indexes

Roedy Green

unread,

Jun 11, 2012, 2:15:58 PM6/11/12

to

On Sat, 09 Jun 2012 11:14:15 +0200, Luuk <lu...@invalid.lan> wrote,

quoted or indirectly quoted someone who said :

>"Postgre JDBC type 4 driver" ==> "PostgreSQL JDBC Driver" ?

fixed thanks.

Roedy Green

unread,

Jun 11, 2012, 2:16:31 PM6/11/12

to

On Sat, 09 Jun 2012 11:55:58 +0200, Hans Castorp

<REWYRL...@spammotel.com> wrote, quoted or indirectly quoted
someone who said :

>In the section "Advantages of PostgreSQL over MySQL", you might want to add the following items

added thanks. Will be uploaded within the hour.

Lew

unread,

Sep 26, 2012, 7:20:15 PM9/26/12

to

Hans Castorp wrote:

> Roedy Green wrote:
>> http://mindprod.com/jgloss/postgresql.html
>
> In the section "Advantages of PostgreSQL over MySQL", you might want to add the following items
>
> + More standard compliant than MySQL

In particular PG has a real TIMESTAMP type.

> + Supports windowing functions
> + Supports common table expressions (CTE) including writeable CTEs
> + Supports recursive queries
> + No limits on the usage of subselect in DML statements
> + Supports table functions (select * from my_function())
> + Supports transactional DDL
> + Supports user defined aggregate functions
> + Supports partial indexes

Supports relational integrity without having to beg it to.

See also
http://troels.arvin.dk/db/rdbms/

--
Lew