Re: [school-discuss] Web-based School Administration...

[Quentin Smith <quentins@comclub.org>]

On Tue, 26 Aug 2003, Les Richardson wrote:

> Date: Tue, 26 Aug 2003 07:36:20 -0400 (EDT)
> From: Les Richardson <les@celery.richtech.ca>
> Reply-To: schoolforge-discuss@schoolforge.net
> To: schoolforge-discuss@schoolforge.net
> Subject: Re: [school-discuss] Web-based School Administration...
> 
> Hiya,
> 
> > I'm also surprised that you have not been able to get the open source
> > databases to perform to a level equal or better than SQL server
> > (Sybase). From what I have seen the main two - MySQL and Postgres have
> > very good performance specs. I have found both to be very reliable
> > though somewhat different in performance.
> 
> Do you have any experience, etc. with this? I've used both, but haven't
> pushed Postgres very hard at all. For me, MySQL was familiar after my
> initial usage of mSQL. However, I've used the DBI interface with my admin
> software so a switch to postgreSQL would be possible. (although ugly
> since, AFAIK, it doesn't have the auto-increment type...)

Hi-
It does indeed have an auto-inrementing type, serial.
http://www.postgresql.org/docs/7.3/interactive/datatype.html#DATATYPE-SERIAL
HTH,
--Quentin