Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

iSee

macrumors 68040
Oct 25, 2004
3,539
272
Nice!
I've been meaning to look into it, just out of curiosity.
I guess I've got a good excuse now.
I'll see if I can give it a try this week some time (on Leopard 10.5.1).
 

Nugget

Contributor
Nov 24, 2002
2,121
1,356
Tejas Hill Country
PostgreSQL is such an excellent database. I honestly do not understand why any developer would choose to use MySQL. PostgreSQL is better and free-er.
 

SC68Cal

macrumors 68000
Feb 23, 2006
1,642
0
Why are you installing this in ~/Applications? Why don't we just follow the standard install procedure?
 

ChrisA

macrumors G5
Jan 5, 2006
12,541
1,653
Redondo Beach, California
PostgreSQL is such an excellent database. I honestly do not understand why any developer would choose to use MySQL. PostgreSQL is better and free-er.

I've used both. Once I really wanted to use PostgreSQL but we prototyped using each DBMS and fond for our simple application MySQL outperformed PstgreSQL by a factor of more then ten. Basically we were just using a DBMS table as a queue. One writer and mutliple readers. We had a real time application that needed to store snapshots of the current state and there were about 10 readers who woud periodically read out subsets of the data to drive their "real time-ish" displays. we had tens of millions of records per hour.

In our tests, MySQL did the job but as you added more users (readers) PostgreSQL would eventually catch up. It seems postgres was smarter about how it handles locks and multiple readers can share a lock while MySQL did very course grain locking forcing user to wait for locks. It was simpler so it was faster for a low number of users we had.
 

will

macrumors regular
Original poster
Aug 29, 2002
179
0
Why are you installing this in ~/Applications? Why don't we just follow the standard install procedure?

I chose to show how to install there so that all users, even those without root, could install it. I do plan to add info on an install under /usr.
 

SC68Cal

macrumors 68000
Feb 23, 2006
1,642
0
I chose to show how to install there so that all users, even those without root, could install it. I do plan to add info on an install under /usr.

Doesn't it install there by default? I'd just toss it there since it's usually run as a daemon anyway. It's a good idea because then it'll also be protected by root ownership and permissions.

I just start to get antsy when someone installs a major system component like that in a non-traditional area because it can cause problems down the line as an administrator.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.