{"id":16729,"date":"2009-11-30T09:45:00","date_gmt":"2009-11-30T07:45:00","guid":{"rendered":"https:\/\/blogs.autodesk.com\/villagebim\/2009\/11\/fournisseur-osgeo-pour-postgis-une-annonce-importante.html"},"modified":"2009-11-30T09:45:00","modified_gmt":"2009-11-30T07:45:00","slug":"fournisseur-osgeo-pour-postgis-une-annonce-importante","status":"publish","type":"post","link":"https:\/\/blogs.autodesk.com\/villagebim\/2009\/11\/fournisseur-osgeo-pour-postgis-une-annonce-importante.html","title":{"rendered":"Fournisseur OSGeo pour PostGIS – une annonce importante"},"content":{"rendered":"

Mon coll\u00e8gue Orest Halustchak vient de faire une annonce importante sur la liste OSGeo FDO-Internals<\/a>.
J\u2019en copie ci dessous ici le contenu, et vous pourrez obtenir une traduction automatique sur Google Translate<\/a> (la qualit\u00e9 de la traduction est moyenne\u2026 mais c\u2019est mieux que rien).
Je suis certain que ce sera l\u2019une des questions que j\u2019aurais demain, pour mon webinaire consacr\u00e9 \u00e0 l\u2019utilisation de PostGIS avec AutoCAD Map 3D et MapGuide<\/a>\u2026 <\/p>\n

—————————————————————————–<\/p>\n

Hi,<\/font><\/p>\n

Autodesk has had interest from Map3D customers who want to use the FDO PostGIS provider to access and edit data using Map3D and other products.<\/font><\/p>\n

These customers have not been able to use this provider reliably with Map3D. We had a close look at the provider code to determine what work would be needed to complete the implementation of schema and edit support and fix other issues. Unfortunately, we found that the provider as it stands today requires a lot of work to complete the implementation of required FDO interfaces and to add good unit test coverage. Things that still need a fair bit of work include:<\/font><\/p>\n

\u00b7 Creating new schema and new datastore
\u00b7 Spatial filter handling
\u00b7 Huge memory leaks on insert.
\u00b7 Not all schema commands are implemented.
\u00b7 Enable and fix transaction support.
\u00b7 Constraint and default values support.
\u00b7 Lots of TODOs spread all over the code
\u00b7 Virtually no unit tests exist.<\/font><\/p>\n

We looked at the level of effort needed to complete that work. It was quite high. So, we looked at an alternative. There exists an earlier open source community code base for a PostGIS provider that was started a couple of years ago but not finished. That code base used the generic rdbms framework that is shared with the SQL Server Spatial, MySQL, and ODBC providers. Most of the schema processing is handled with that shared code. We spent some time working with the current provider and the other code base to determine the most efficient way to get to a completed provider that would be robust, perform well, and be maintainable.<\/font><\/p>\n

In the end, we determined that taking the earlier code base, adding support for the recent fdo interface changes, and completing other parts that weren\u2019t finished would take much less time. Also, based on performance comparisons, we would get something that was much faster on inserts and selects, e.g. the select performance is about six times faster and schema describe is about three times faster. We couldn\u2019t compare insert times very well because the current provider kept crashing after a certain point and we couldn\u2019t insert a large number of features.<\/font><\/p>\n

So, what we would like to do is complete our work to get a working PostGIS provider and then replace the current open source code with our new copy. Note that we plan to use native PostGIS schema without adding additional metadata tables just as the current provider does. It will be able to read any schemas created by the current version of the provider and itself will generate generic PostGIS schemas.<\/font><\/p>\n

We\u2019ll need to submit an RFC for this, but we wanted to get this information out to you ahead of time.<\/font><\/p>\n

At the same time, we are planning to change the connection parameters to separate out the database name from the service name. This will make it easier for users. They can identify the service (e.g. localhost:5432), and then see the available datastores from which they can choose in a UI. Then, PostGIS schema simply will map to FDO schema. The main drawback to this is that any users with existing MapGuide feature sources and layer definitions will have to update them.<\/font><\/p>\n

In the end, we will end up with a good functioning provider that performs well.<\/font><\/p>\n

Regards,<\/font><\/p>\n

Orest.<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

Mon coll\u00e8gue Orest Halustchak vient de faire une annonce importante sur la liste OSGeo FDO-Internals. J\u2019en copie ci dessous ici le contenu, et vous pourrez obtenir une traduction automatique sur Google Translate (la qualit\u00e9 de la traduction est moyenne\u2026 mais c\u2019est mieux que rien). Je suis certain que ce sera l\u2019une des questions que j\u2019aurais […]<\/p>\n","protected":false},"author":52098,"featured_media":2472,"menu_order":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[3378,3377,3379,3388,3397,3399,3340,3395,3403],"tags":[],"class_list":["post-16729","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-actus","category-autocad-map-3d","category-autodesk","category-autodesk-geospatial","category-autodesk-mapguide-enterprise","category-mapguide-open-source","category-open-source","category-osgeo","category-technologie-mapguide","dhig-theme--light"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/16729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/users\/52098"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/comments?post=16729"}],"version-history":[{"count":0,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/16729\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/media\/2472"}],"wp:attachment":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/media?parent=16729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/categories?post=16729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/tags?post=16729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}