2009/11/6 Bob McConnell <rmcconne(at)lightlink(dot)com>:
> bob(dot)vanslobig(at)att(dot)net wrote:
>> At the same time, I am looking at reducing cost and thoughtabout
>> switching from MS SQL to MySQL. Ialso thought of adding some kind of
>> GUI front-end in order to use lesstechnical people to process data
>> requests. In talking with a customer support person at a company that
>> developsfront-ends, he suggested looking into PostgreSQL and that is
>> why I am here.
>> I did not see references to anyone moving from an MS SQLenvironment
>> to PostgreSQL and was curious if anyone has had experience doingthat?
>> Also, are there any suggestionsfor front-ends? I need something that
>> cangenerate SQL commands but also allow a passthrough if someone
>> needed to writetheir own.
> Take a close look at PostgreSQL before you switch. MySQL is fine for small
> projects and private web sites, but for anything serious you will need the
> Enterprise license and support. The future of those is in serious doubt
> right now given the state of Sun, which currently owns it, and the
> possibility the European Competition Committee may prevent Oracle from
> rescuing them.
I would like to re-inforce what Bob has said here:
PostgreSQL is definitely better for large projects, and there are no
There are great "extras" also, like PostGIS.
> If you do a Google Search on moving from MySQL to Postgres, you will find a
> lot of sites with information on that conversion. There was one project at
> work that did it several years ago, when MySQL AB switched to the per server
> license fees. They found Postgres easier to use and more stable. We now have
> three major products deployed using Pg and two more on the drawing board.
> PgAdmin III is the best admin front end. It is available on most platforms,
> including MS-Windows. I use OpenOffice.Base as an application front end.
> Good luck,
> Bob McConnell
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
In response to
pgsql-novice by date
|Next:||From: Jasen Betts||Date: 2009-11-07 12:21:02|
|Subject: Re: Table design for basic user management|
|Previous:||From: Michael Lush||Date: 2009-11-06 16:44:32|
|Subject: Re: how does psql know where to go?|