Have begun testing ArcSDE with PostgreSQL. Decided to go to PostgreSQL for Several reasons:
- Cost
- Experience
- Licensing
PostgreSQL
PostgreSQL is Open Source and is free. For some users, the fact that it is Open Source is an instant turn off and cause for concern. In my experience, the user community for PostgreSQL is vibrant with lots or resources available. The PostgreSQL has extensive documentation, user forum, and several other useful links. There are newer books available as well as several free digital downloads.
My concern is also minimized by a comfort level with the database. I have run PostgreSQL on our webserver with hardly a problem for several years. It is used as a data repository for some of our most queried datasets (1000+ hits per day) and the backend of our blog.
When I first became interested in PostgreSQL I stumbled across it while looking at MySQL. I needed a DB that could possibly be included in a commercial application. The possible licensing costs associated with MySQL were a concern. When I reviewed PostgreSQL, I noticed that it used a BSD license, a license which has fairly few restrictions.
ArcSDE
As we test ArcSDE, I will make an attempt to post my findings,
Posted by wilsongis