Home

Database changes to PostgreSQL

Aren Cambre's picture
Tue, 09/21/2010 - 21:17 — Aren Cambre

This project's database technology is changing to PostgreSQL.

Microsoft MapPoint 2010 is too primitive to be my comprehensive GIS solution. After a little searching, it was clear that PostgreSQL, thanks to PostGIS, dominates the database layer of GIS tools.

On top of this, I need good geospatial query support. MySql's geospatial features are minimal and apparently slow.

Fortunately, existing data is very simple tables, so data conversion is easy. But unfortunately, I put a lot of effort into learning .NET Framework 4's Entity Framework v2. The free Npgsql PostgreSQL ADO.NET provider doesn't support the DDEX necessary for full Entity Framework compatibility. (OK, so you can do Entity Framework stuff manually, but you can't do much in Visual Studio, so it is still incomplete.) I could pay for Devart's dotConnect for PostgreSQL for $180, which does support Entity Framework.

But given that no Entity Framework provider seems to support geospatial field types, it may not matter.

Decisions, decisions.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <small> <sup> <sub> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <h2> <h3> <h4> <img> <br> <br /> <p> <div> <span> <b> <i> <table> <td> <tr> <tbody>
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <pre>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <mysql>, <php>, <ps1>, <python>, <r>, <ruby>, <sql>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.