Thread: When to use postgreSQL
Hi guys,
Our company is looking into the possibility of using it.
Firstly, we would like to find out what kind of applications are suitable for using postgreSQL. From the internet, it seems like it is good for web development. Is it true ? And how can it benefit by it ?
And are there other types of application which postgreSql is performing better than the other dbs ?
Thanks for your help.
Regards,Ken
On Tue, 4 Jan 2011 23:37:19 +0800, Man Lam <mklam3@gmail.com> wrote:
> Firstly, we would like to find out what kind of applications are suitable
> for using postgreSQL. From the internet, it seems like it is good for web
> development. Is it true ? And how can it benefit by it ?
You'll need a hosting that supplies you with Pg databases.
> And are there other types of application which postgreSql is performing
> better than the other dbs ?
Almost all: consider Pg (very) close to an open-source oracle.
JY
--
The cow is nothing but a machine which makes grass fit for us people to eat.
-- John McNulty
Hi Ken, On 04.01.2011, at 16:37, Man Lam wrote: > Hi guys, > > Our company is looking into the possibility of using it. > > Firstly, we would like to find out what kind of applications are suitable for using postgreSQL. From the internet, it seemslike it is good for web development. Is it true ? And how can it benefit by it ? > And are there other types of application which postgreSql is performing better than the other dbs ? I just switched three Django projects from MySQL to PostgreSQL mainly because of two resaons: - licensing/development outlook (I don't like the direction MySQL takes under Oracle) - enforced data integrity (I shot myself in the foot a couple of times with MySQL) After the switch, I have not seen a performance difference (yet) compared to MySQL 5.1 (MyISAM), but I never cared to optimizemy database server and MySQL promises to be a lot faster. Kind regards, Jan
On 01/04/2011 10:37 AM, Man Lam wrote: > Hi guys, > > Our company is looking into the possibility of using it. > > Firstly, we would like to find out what kind of applications are suitable for > using postgreSQL. From the internet, it seems like it is good for web It's suitable for any application that needs a database, large or small. > development. Is it true ? And how can it benefit by it ? > And are there other types of application which postgreSql is performing better > than the other dbs ? It's probably going to be roughly as fast as any general-purpose relational database you use, if not faster, but that depends on the particular usage patterns and how you set the tuning parameters for the various systems. -- Lew Ceci n'est pas une pipe.