Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-16 Thread Rory Campbell-Lange
On 29/11/03, Randal L. Schwartz ([EMAIL PROTECTED]) wrote: Well, since I need 2.5 ideas per month for the three columns I'm still writing, I'm certainly in a position to write nice things about PG, although I always have to work it in from a Perl slant. Actually, I'm sure that any of the

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-04 Thread Alex Satrapa
Chris Travers wrote: Here is a paper I have written for the purposes of providing some additional educational material for the MySQL crowd. Here's my contribution: Why I choose PostgreSQL (PostgreSQL in 21 Seconds) I choose referential integrity, meaning my lookups always work. I choose

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-01 Thread Rick Gigger
, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments Rod K [EMAIL PROTECTED] writes: Paul Thomas wrote: Much of the populatity of MySQL seems to stem from PHPs out-of-the-box support for it. This is incorrect. The embedded mysql client library

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-01 Thread Rick Gigger
Note: I am a php developer and I love it, but... In dealing with web applications and frontends to database or even just a dynamic web site PHP has every bit the power and ability that Java does and the development time is way down. Uh, how about threads. I know that you don't need them much

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-01 Thread Rick Gigger
PROTECTED] Sent: Sunday, November 30, 2003 5:49 AM Subject: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments Re: [GENERAL] PostgreSQL Advocacy, Thoughts and CommentsRegarding the learning curve issue, maybe people can recommend their favorite books. I recommend SQL Unleashed (I forget

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-30 Thread Chris Travers
Tony [EMAIL PROTECTED] Wrote: Now many consultant/developer/sys-admins like myself are going to client site on a contract (this is especially true in the UK, I can't speak for anywhere else) and finding complex stocktrading systems, inventory systems, CRM systems, and others, all written in

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-30 Thread Tony
Title: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments Comments within: Chris Travers wrote: Tony [EMAIL PROTECTED] Wrote: Now many consultant/developer/sys-admins like myself are going to client site on a contract (this is especially true in the UK, I can't speak

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-30 Thread Paul Thomas
On 29/11/2003 16:24 Jason Tesser wrote: [snip] A programmer that doesn't document stuff needs to find a new job :-) Agreed. So you're replaced him and inherited a documentation-free application. How many favours has he done you by squirrelling away section of business logic in the database?

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Oliver Elphick
On Sat, 2003-11-29 at 04:37, cnliou wrote: Jason Tesser [EMAIL PROTECTED] MySQL cannot even handle sub-queries yet. Ohh! Really? Allow me to pay my highest respect to the genius mySQL programmers! I completely have no clue on how to construct any single tiny database on a DBMS having

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Tony
HI All, I'm glad that this thread prompted some thoughtful response. I think one of my main points I was trying to make, Jason hit the nail on the head. The article to which I was referring uses a great example which I have experienced many times before, but in order to grasp this, PHP et

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Unihost Web Hosting
Further to this post, what might actually work is to convince O' Reilly (since they have PostgreSQL book/s) to do some articles like they have for PG, but making full use of the PG database. For instance, building a simple data-warehouse using PG. Articles that show off an OSS

Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Paul Thomas
On 28/11/2003 17:10 Jason Tesser wrote: [snip] I completely disagree. I do a lot of programming with PHP and the features of Postgres come in handy. Let me give you an example of just some basic things. Triggers! Why should I have to write insert and update triggers in the logic (PHP) if I

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Rod K
Paul Thomas wrote: On 28/11/2003 17:10 Jason Tesser wrote: [snip] MySQL cannot even handle sub-queries yet. I also use Python for standalone interfaces to the data. Why should I not be able to use the same views and triggers etc in there that I use for my web apps. PHP is

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Chris Travers
From: Paul Thomas [EMAIL PROTECTED]: Stored procedures can be a 2-edged sword. They can lead to business logic being scattered between the persistence layer and the business layer. Thats not good for maintaining the application 3 years down the line. Triggers can also cause maintenance

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread Paul Thomas
On 27/11/2003 09:19 Tony wrote: Hi All, I've just been reading an article in PHP Architect magazine (http://www.phparch.com) which is the cover story for October called Migrating from MySQL to PostgreSQL. I must say that this is a highly compelling article, especially for me, and is aimed at

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread Jason Tesser
hi, huge snip Maybe there's not such a need for the advanced features of PostgreSQL amongst PHP programmers as you seem to believe. Most of the PHP stuff I've seen is read-only content display stuff and that doesn't really require a top-notch RDBMS; a more limited database should also be

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread cnliou
Jason Tesser [EMAIL PROTECTED] MySQL cannot even handle sub-queries yet. Ohh! Really? Allow me to pay my highest respect to the genius mySQL programmers! I completely have no clue on how to construct any single tiny database on a DBMS having no sub-query capability. Being too dumb, I solicit

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread Chris Travers
Jason Tesser [EMAIL PROTECTED] wrote: I completely disagree. I do a lot of programming with PHP and the features of Postgres come in handy. Let me give you an example of just some basic things. Triggers! Why should I have to write insert and update triggers in the logic (PHP) if I can

[GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-27 Thread Tony
Hi All, I've just been reading an article in PHP Architect magazine (http://www.phparch.com) which is the cover story for October called Migrating from MySQL to PostgreSQL. I must say that this is a highly compelling article, especially for me, and is aimed at programmers that aren't