Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Spatial data warehousing in PostgreSQL
1 point by wensing on Aug 3, 2007 | hide | past | favorite | 1 comment
In the very near future I will need to create a data warehouse for storing a rather large amount of data. I'm not sure what it will be in terabytes, but let's just say that it won't be huge instantly, but it will be big instantly, and need to scale to support whatever new data sets (dimensions) get thrown its way.

The language will be Python (Django), but I'm waffling on the database. All of my experience is with MySQL, but I believe the out-of-the-box support for some of the software we'll be using is PostgreSQL.

Do any of you have experience with data warehousing? What about a data warehouse with spatial features? And what of the trade-offs between MySQL and PostgreSQL for this task?

Any information/links you can provide on any of these subjects would be fantastic.



I don't know about data warehousing with spatial data, but two guys I was taking two a couple of months ago were both working on web apps that worked with geospatial data. Both of them were using postgres for geospatial use and endorsed it over both mySQL and MS-SQL.




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: