Postgres OnLine Journalhttp://www.postgresonline.com/journal/
an In depth look at the PostgreSQL open source databaseenSerendipity 1.7.8 - http://www.s9y.org/Thu, 02 Jul 2015 18:43:40 GMThttp://www.postgresonline.com/journal/templates/default/img/s9y_banner_small.pngRSS: Postgres OnLine Journal - an In depth look at the PostgreSQL open source databasehttp://www.postgresonline.com/journal/
10021PostgreSQL OGR FDW update and PostGIS 2.2 newshttp://www.postgresonline.com/journal/archives/351-PostgreSQL-OGR-FDW-update-and-PostGIS-2.2-news.html
9.39.4contrib spotlightogr_fdwpostgispostgresql versionswinextensionshttp://www.postgresonline.com/journal/archives/351-PostgreSQL-OGR-FDW-update-and-PostGIS-2.2-news.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3511http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=351nospam@example.com (Leo Hsu and Regina Obe)
<p><a href="https://lists.osgeo.org/pipermail/postgis-devel/2015-June/025016.html">PostGIS 2.2</a> is planned to reach feature freeze June 30th 2015 so we can make the September PostgreSQL 9.5 curtain call with confidence. Great KNN enhancements for PostgreSQL 9.5 only users. I've been busy getting all my ducks lined up. A lot on tiger geocoder and address standardizer extension to be shipped with windows builds, story for later. One other feature we plan to ship with the windows PostGIS 2.2 builds is the <a href="https://github.com/pramsey/pgsql-ogr-fdw" target="_blank">ogr_fdw</a> ogr_fdw Foreign data wrapper extension. I've been nagging <a href="http://blog.cleverelephant.ca/" target="_blank">Paul Ramsey</a> a lot about issues with it, this in particular <a href="https://github.com/pramsey/pgsql-ogr-fdw/issues/25" target="_blank">https://github.com/pramsey/pgsql-ogr-fdw/issues/25</a>, and after some prodding, he finally put his nose in and fixed them and pinged <a href="http://www.spatialys.com/en/about" target="_blank">Even Rouault</a> for some help on a <a href="https://github.com/pramsey/pgsql-ogr-fdw/issues/29" target="blank">GDAL specific item</a>.</p>
<p>Needless to say, I've been super happy with the progress and support I've gotten with ogr_fdw development and really enjoying my ogr_fdw use. The XLSX reading a file saved after the connection was open required a fix in GDAL 2.0 branch (which missed GDAL 2.0.0 release, so because of this, this new package contains a GDAL 2.0.1ish library. Hopeful GDAL 2.0.1 will be out before PostGIS 2.2.0 comes out so I can release without guilt with this fix. </p>
<br /><a href="http://www.postgresonline.com/journal/archives/351-PostgreSQL-OGR-FDW-update-and-PostGIS-2.2-news.html#extended">Continue reading "PostgreSQL OGR FDW update and PostGIS 2.2 news"</a>
Mon, 29 Jun 2015 05:24:00 -0400http://www.postgresonline.com/journal/archives/351-guid.htmlgdalodbc_fdwogr_fdwpostgisPostGIS 2.2 leveraging power of PostgreSQL 9.5http://www.postgresonline.com/journal/archives/350-PostGIS-2.2-leveraging-power-of-PostgreSQL-9.5.html
9.5gisnew in postgresqlpgRoutingpostgispostgresql versionshttp://www.postgresonline.com/journal/archives/350-PostGIS-2.2-leveraging-power-of-PostgreSQL-9.5.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3502http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=350nospam@example.com (Leo Hsu and Regina Obe)
<p>Things are shaping up nicely in PostGIS 2.2 development. We are going to hit feature freeze around June 30th 2015, and plan to ship late August or early September to be in line with PostgreSQL 9.5 release.
So far we have committed a couple of neat features most itemized in <a href="http://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#NewFunctions_2_2" target="_blank">PostGIS 2.2 New Functions</a>.
Many of the really sort after ones will require PostgreSQL 9.5 and GEOS 3.5. The geography measurement enhancements will require Proj 4.9.0+ to take advantage of.
Things I'd like to highlight and then later dedicate full-length articles in our <a href="http://www.bostongis.com/blog/index.php?categories/27-waiting_postgis_22" target="_blank">BostonGIS Waiting for PostGIS 2.2 series</a> once they've been stress tested. </p> <br /><a href="http://www.postgresonline.com/journal/archives/350-PostGIS-2.2-leveraging-power-of-PostgreSQL-9.5.html#extended">Continue reading "PostGIS 2.2 leveraging power of PostgreSQL 9.5"</a>
Sat, 23 May 2015 03:11:00 -0400http://www.postgresonline.com/journal/archives/350-guid.htmlpostgispostgresql 9.5Adding properties to existing JSON object with PLV8http://www.postgresonline.com/journal/archives/349-Adding-properties-to-existing-JSON-object-with-PLV8.html
9.4plv8jspostgresql versionsq&ahttp://www.postgresonline.com/journal/archives/349-Adding-properties-to-existing-JSON-object-with-PLV8.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3494http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=349nospam@example.com (Leo Hsu and Regina Obe)
<p>Lately I've been experimenting with building semi-schemaless apps. These are apps
where much of the data may never be used for reporting aside from story telling and also that as time goes by some of these may be revisited
and converted to more structured fields for easier roll-up and reporting. For the front-end UI, I'm using <a href="https://angularjs.org/" target="_blank">AngularJS</a> which naturally spits out data as JSON and can autobind to JSON data of any complexity.
My stored functions in PostgreSQL take JSON blobs as inputs spit it out into various tables and throws the whole thing in a jsonb field for later consumption (it's a bit redundant). Similarly they return JSON back. One of the things I wanted to be able to do was take this jsonb blob and tack on additional properties from well-structured fields or even a whole set of data like sub recordsets to feed back to my app in JSON.
While there are lots of functions in PostgreSQL 9.3/9.4 that can easily build json objects from records, aggregate rows, etc. I couldn't find a function that allowed me to just add a property to an existing JSON object, so I went to my tried and true old-pal PL/V8 for some comfort. Here is a quickie function I created in PL/V8 that did what I needed. Hopefully it will be of use to others or others might have other ideas of doing this that I missed.</p> <br /><a href="http://www.postgresonline.com/journal/archives/349-Adding-properties-to-existing-JSON-object-with-PLV8.html#extended">Continue reading "Adding properties to existing JSON object with PLV8"</a>
Mon, 04 May 2015 01:45:00 -0400http://www.postgresonline.com/journal/archives/349-guid.htmljsonjsonbplv8DELETE all data really fast with TRUNCATE TABLE CASCADEhttp://www.postgresonline.com/journal/archives/348-DELETE-all-data-really-fast-with-TRUNCATE-TABLE-CASCADE.html
q&ahttp://www.postgresonline.com/journal/archives/348-DELETE-all-data-really-fast-with-TRUNCATE-TABLE-CASCADE.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3480http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=348nospam@example.com (Leo Hsu and Regina Obe)
<p>Though it is a rare occurrence, we have had occasions where we need to purge ALL data from a table. Our preferred is the <code>TRUNCATE TABLE</code> approach because it's orders of magnitude faster than the <code>DELETE FROM</code> construct. You however can't use <code>TRUNCATE TABLE</code> unqualified, if the table you are truncating has foreign key references from other tables.
In comes its extended form, the <code>TRUNCATE TABLE .. CASCADE</code> construct which was introduced in PostgreSQL 8.2, which will not only delete all data from the main table, but will CASCADE to all the referenced tables.</p> <br /><a href="http://www.postgresonline.com/journal/archives/348-DELETE-all-data-really-fast-with-TRUNCATE-TABLE-CASCADE.html#extended">Continue reading "DELETE all data really fast with TRUNCATE TABLE CASCADE"</a>
Mon, 16 Mar 2015 02:18:00 -0400http://www.postgresonline.com/journal/archives/348-guid.htmlLATERAL WITH ORDINALITY - numbering setshttp://www.postgresonline.com/journal/archives/347-LATERAL-WITH-ORDINALITY-numbering-sets.html
9.4postgresql versionsq&ahttp://www.postgresonline.com/journal/archives/347-LATERAL-WITH-ORDINALITY-numbering-sets.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3470http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=347nospam@example.com (Leo Hsu and Regina Obe)
<p>One of the neat little features that arrived at PostgreSQL 9.4 is the <code>WITH ORDINALITY</code> ANSI-SQL construct. What this construct does is to tack an additional column called <code>ordinality</code> as an additional column when you use a set returning function in the <code>FROM</code> part of an SQL Statement.</p> <br /><a href="http://www.postgresonline.com/journal/archives/347-LATERAL-WITH-ORDINALITY-numbering-sets.html#extended">Continue reading "LATERAL WITH ORDINALITY - numbering sets"</a>
Sun, 01 Mar 2015 18:35:00 -0500http://www.postgresonline.com/journal/archives/347-guid.htmllateralunnestwith ordinalityQuerying MS Access and other ODBC data sources with OGR_FDWhttp://www.postgresonline.com/journal/archives/346-Querying-MS-Access-and-other-ODBC-data-sources-with-OGR_FDW.html
9.4contrib spotlightfdwsogr_fdwpostgispostgresql versionshttp://www.postgresonline.com/journal/archives/346-Querying-MS-Access-and-other-ODBC-data-sources-with-OGR_FDW.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3461http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=346nospam@example.com (Leo Hsu and Regina Obe)
<p>If you have the OGR_FDW we discussed in <a href="journal/archives/339-OGR-foreign-data-wrapper-on-Windows-first-taste.html" target="_blank">OGR FDW Windows first taste</a> built with ODBC support,
then you can access most any ODBC datasource from PostgreSQL. This is especially useful for Windows users. Two of the data sources I've been experimenting with are SQL Server
and MS Access. In this article, I'll demonstrate how to connect to MS Access with PostgreSQL running on a windows box. I think there is an Access driver for Unix/Linux most robust utilizes java. I won't go there.</p> <br /><a href="http://www.postgresonline.com/journal/archives/346-Querying-MS-Access-and-other-ODBC-data-sources-with-OGR_FDW.html#extended">Continue reading "Querying MS Access and other ODBC data sources with OGR_FDW"</a>
Tue, 10 Feb 2015 01:30:00 -0500http://www.postgresonline.com/journal/archives/346-guid.htmlogr_fdwpostgresql 9.4Import Foreign Schema hack with OGR_FDW and reading LibreOffice calc workbookshttp://www.postgresonline.com/journal/archives/345-Import-Foreign-Schema-hack-with-OGR_FDW-and-reading-LibreOffice-calc-workbooks.html
9.4contrib spotlightogr_fdwpostgispostgresql versionshttp://www.postgresonline.com/journal/archives/345-Import-Foreign-Schema-hack-with-OGR_FDW-and-reading-LibreOffice-calc-workbooks.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3450http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=345nospam@example.com (Leo Hsu and Regina Obe)
<p>PostgreSQL 9.4 and below doesn't support importing whole set of tables from a FOREIGN server, but PostgreSQL 9.5 does with the upcoming <a href="http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-import-foreign-schema/" target="_blank">Import Foreign Schema</a>. To use will require FDW wrapper designers to be aware of this feature and use the plumbing in their wrappers. <a href="https://github.com/pramsey/pgsql-ogr-fdw/issues/10" target="_blank">IMPORT FOREIGN SCHEMA for ogr_fdw come PostgreSQL 9.5 release</a> is on the features ticket list. The <a href="https://github.com/pramsey/pgsql-ogr-fdw" target="_blank">ogr_fdw</a> comes with this <i>to die for commandline</i> utility called <code>ogr_fdw_info</code> that does generate the table structures for you and will also list all the tables in the Foreign data source if you don't give it a specific table name. So with this utility I wrote a little hack involving using PostgreSQL <code>COPY PROGRAM</code> feature to call out to the <code>ogr_fdw_info</code> commandline tool to figure out the table names and some DO magic to create the tables.</p>
<p>Though ogr_fdw is designed to be a spatial foreign data wrapper, it's turning out to be a pretty nice non-spatial FDW as well especially for reading spreadsheets which we seem to get a lot of. This hack I am about to demonstrate I am demonstrating with LibreOffice/OpenOffice workbook, but works equally well with Excel workbooks and most any data source that OGR supports.</p> <br /><a href="http://www.postgresonline.com/journal/archives/345-Import-Foreign-Schema-hack-with-OGR_FDW-and-reading-LibreOffice-calc-workbooks.html#extended">Continue reading "Import Foreign Schema hack with OGR_FDW and reading LibreOffice calc workbooks"</a>
Tue, 27 Jan 2015 23:57:00 -0500http://www.postgresonline.com/journal/archives/345-guid.htmlfdwforeign data wrapperogrogr_fdwUsing SSL https connections with www_fdw on windowshttp://www.postgresonline.com/journal/archives/344-Using-SSL-https-connections-with-www_fdw-on-windows.html
9.39.4contrib spotlightfdwspostgresql versionswww_fdwhttp://www.postgresonline.com/journal/archives/344-Using-SSL-https-connections-with-www_fdw-on-windows.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3440http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=344nospam@example.com (Leo Hsu and Regina Obe)
<p>One of the foreign data wrappers I included in the <a href="http://www.postgresonline.com/journal/archives/342-Updated-Foreign-Data-Wrappers-for-PostgreSQL-9.3-Windows.html" target="_blank">PostgreSQL 9.3 Windows FDW bag</a> and <a href="http://www.postgresonline.com/journal/archives/340-Foreign-Data-Wrappers-for-PostgreSQL-9.4-Windows.html" target="_blank">PostgreSQL 9.4 Windows FDW bag</a> is the <a href="https://github.com/cyga/www_fdw" target="_blank">www_fdw</a> extension used for querying web services. Someone asked that since I didn't build curl with SSL support,
they are unable to use it with https connections. The main reason I didn't is that the EDB installs come with ssleay32.dll and libeay32.dll (even the 64-bit) which
are dependencies of curl when built with SSL support. I wanted to minimize the issue of distributing dlls that are packaged with Windows PostgreSQL installers already.</p>
<p>Though this article is specific to using www_fdw on Windows systems, many of the issues are equally applicable to other platforms, so may be worth a read if you are running into similar issues with using specialty SSL certificates on Linux/Unix/Mac.</p> <br /><a href="http://www.postgresonline.com/journal/archives/344-Using-SSL-https-connections-with-www_fdw-on-windows.html#extended">Continue reading "Using SSL https connections with www_fdw on windows"</a>
Sat, 24 Jan 2015 13:35:00 -0500http://www.postgresonline.com/journal/archives/344-guid.htmlfdwforeign data wrapperwww_fdwInstalling PostGIS packaged address_standardizer on Ubuntuhttp://www.postgresonline.com/journal/archives/343-Installing-PostGIS-packaged-address_standardizer-on-Ubuntu.html
9.3contrib spotlightpostgispostgresql versionshttp://www.postgresonline.com/journal/archives/343-Installing-PostGIS-packaged-address_standardizer-on-Ubuntu.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3430http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=343nospam@example.com (Leo Hsu and Regina Obe)
<p>One of the changes coming to you in PostGIS 2.2 are additional extensions. Two ones close to my heart are the <a href="http://postgis.net/docs/manual-dev/postgis_installation.html#installing_pagc_address_standardizer" target="_blank">address_standardizer</a> (which was a separate project before, but folded into PostGIS in upcoming 2.2) and the SFCGAL extension for doing very advanced 3D stuff (was just an sql script in older versions, but made an extension in 2.2 and new functions added). We had a need to have address standardizer running on our Ubuntu box,
but since PostGIS 2.2 isn't released yet, you can't get it without some compiling. Luckily the steps are fairly trivial if you are already running PostGIS 2.1.
In this article, I'll walk thru just building and installing the address_standardizer extension from the PostGIS 2.2 code base. Though I'm doing this on Ubuntu,
the instructions are pretty much the same on any Linux, just replacing with your Linux package manager.</p> <br /><a href="http://www.postgresonline.com/journal/archives/343-Installing-PostGIS-packaged-address_standardizer-on-Ubuntu.html#extended">Continue reading "Installing PostGIS packaged address_standardizer on Ubuntu"</a>
Thu, 22 Jan 2015 21:54:00 -0500http://www.postgresonline.com/journal/archives/343-guid.htmladdress_standardizerbook writingpostgisPLV8 binaries for PostgreSQL 9.4 windows both 32-bit and 64-bithttp://www.postgresonline.com/journal/archives/341-PLV8-binaries-for-PostgreSQL-9.4-windows-both-32-bit-and-64-bit.html
9.4pl programmingplv8jspostgresql versionswinextensionshttp://www.postgresonline.com/journal/archives/341-PLV8-binaries-for-PostgreSQL-9.4-windows-both-32-bit-and-64-bit.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3413http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=341nospam@example.com (Leo Hsu and Regina Obe)
<p>I'm still in the middle of building packages for our clients for the packages that aren't normally distributed for windows to make upgrading to PostgreSQL 9.4 smooth. One of those is PL/V8 which we use for some custom functions.
I had mentioned <a href="http://www.postgresonline.com/journal/archives/261-building-plv8js-and-plcoffee-for-windows-using-mingw64-w64-w32.html" target="_blank">how I build PL/V8 for PostgreSQL windows</a>, and the instructions are a bit out of date., but I put more up to date instructions on my <a href="https://gist.github.com/robe2" target="_blank">gist page</a>. I tend to use gist a lot as a public scrap book with hopes someone else can learn from my toils and save them some trouble. At some point I should probably get more organized with my scrapbooks.</p>
<br /><a href="http://www.postgresonline.com/journal/archives/341-PLV8-binaries-for-PostgreSQL-9.4-windows-both-32-bit-and-64-bit.html#extended">Continue reading "PLV8 binaries for PostgreSQL 9.4 windows both 32-bit and 64-bit"</a>
Tue, 06 Jan 2015 00:53:00 -0500http://www.postgresonline.com/journal/archives/341-guid.htmlpljavascriptpllivescriptplv8v8Updated Foreign Data Wrappers for PostgreSQL 9.3 Windowshttp://www.postgresonline.com/journal/archives/342-Updated-Foreign-Data-Wrappers-for-PostgreSQL-9.3-Windows.html
9.3contrib spotlightfdwsogr_fdwpostgispostgresql versionswinextensionswww_fdwhttp://www.postgresonline.com/journal/archives/342-Updated-Foreign-Data-Wrappers-for-PostgreSQL-9.3-Windows.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3420http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=342nospam@example.com (Leo Hsu and Regina Obe)
<p>As stated in <a href="http://www.postgresonline.com/journal/archives/339-OGR-foreign-data-wrapper-on-Windows-first-taste.html" target="_blank">last article</a>, I've packaged FDW binaries for PostgreSQL 9.3 windows 32-bit and 64-bit and added in the <a href="https://github.com/pramsey/pgsql-ogr-fdw" target="_blank">ogr_fdw</a> one. These we've tested with the standard EDB Vc++ built PostgreSQL windows installs and work fine with those.</p>
<p>This package is an updated list from ones we've distributed before that includes ogr_fdw and recompiled with latests source from www_fdw and file_textarray</p>
<br /><a href="http://www.postgresonline.com/journal/archives/342-Updated-Foreign-Data-Wrappers-for-PostgreSQL-9.3-Windows.html#extended">Continue reading "Updated Foreign Data Wrappers for PostgreSQL 9.3 Windows"</a>
Sat, 03 Jan 2015 17:05:00 -0500http://www.postgresonline.com/journal/archives/342-guid.htmlForeign Data Wrappers for PostgreSQL 9.4 Windowshttp://www.postgresonline.com/journal/archives/340-Foreign-Data-Wrappers-for-PostgreSQL-9.4-Windows.html
9.4contrib spotlightfdwspostgispostgresql versionswinextensionshttp://www.postgresonline.com/journal/archives/340-Foreign-Data-Wrappers-for-PostgreSQL-9.4-Windows.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3404http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=340nospam@example.com (Leo Hsu and Regina Obe)
<p>As stated in <a href="http://www.postgresonline.com/journal/archives/339-OGR-foreign-data-wrapper-on-Windows-first-taste.html" target="_blank">last article</a>, I've packaged FDW binaries for PostgreSQL 9.4 windows 32-bit and 64-bit and added in the <a href="https://github.com/pramsey/pgsql-ogr-fdw" target="_blank">ogr_fdw</a> one. These we've tested with the standard EDB VS built PostgreSQL windows installs and work fine with those.</p> <br /><a href="http://www.postgresonline.com/journal/archives/340-Foreign-Data-Wrappers-for-PostgreSQL-9.4-Windows.html#extended">Continue reading "Foreign Data Wrappers for PostgreSQL 9.4 Windows"</a>
Sun, 28 Dec 2014 06:02:00 -0500http://www.postgresonline.com/journal/archives/340-guid.htmlfile_textarray_fdwogr_fdwpostgresql 9.4www_fdwOGR foreign data wrapper on Windows first tastehttp://www.postgresonline.com/journal/archives/339-OGR-foreign-data-wrapper-on-Windows-first-taste.html
9.4contrib spotlightfdwsgisogr_fdwpostgishttp://www.postgresonline.com/journal/archives/339-OGR-foreign-data-wrapper-on-Windows-first-taste.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3392http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=339nospam@example.com (Leo Hsu and Regina Obe)
<p>This christmas I received something very special from <a href="http://blog.cleverelephant.ca/" target="_blank">Paul Ramsey</a> and <a href="http://www.spatialys.com/en/about/" target="_blank">Even Roualt</a>
as detailed in <a href="http://postgis.net/2014/12/19/postgis_fdw" target="_blank">Foreign Data Wrappers for PostGIS</a>.
It's been something I've been patiently waiting for for <a href="http://trac.osgeo.org/postgis/ticket/974" target="_blank">4 years</a>. I think it has a few issues I'm working to replicate, but overall it's much faster than I expected and pretty slick.
</p>
<p>So why is <a href="https://github.com/pramsey/pgsql-ogr-fdw" target="_blank">ogr_fdw</a> so special, because GDAL/OGR is an avenue to many data sources, NOT JUST GEOSPATIAL. It's the NOT JUST that I am most excited about. Though the focus is geospatial you can use it with non-geospatial datasources,
as we described a long time ago in <a href="http://www.postgresonline.com/journal/archives/31-GDAL-OGR2OGR-for-Data-Loading.html" target="_blank">OGR2OGR for data loading</a></p>
<br /><a href="http://www.postgresonline.com/journal/archives/339-OGR-foreign-data-wrapper-on-Windows-first-taste.html#extended">Continue reading "OGR foreign data wrapper on Windows first taste"</a>
Sat, 27 Dec 2014 16:26:00 -0500http://www.postgresonline.com/journal/archives/339-guid.htmlfdwgdalogrogr_fdwpostgisOracle FDW 1.1.0 with SDO_Geometry PostGIS spatial supporthttp://www.postgresonline.com/journal/archives/338-Oracle-FDW-1.1.0-with-SDO_Geometry-PostGIS-spatial-support.html
9.19.29.39.4contrib spotlightfdwspostgispostgresql versionshttp://www.postgresonline.com/journal/archives/338-Oracle-FDW-1.1.0-with-SDO_Geometry-PostGIS-spatial-support.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3380http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=338nospam@example.com (Leo Hsu and Regina Obe)
<p>Oracle FDW is a <a href="http://www.postgresql.org/docs/current/static/sql-createforeigndatawrapper.html" target="_blank">foreign data wrapper PostgreSQL</a> extension that allows you to read and write to Oracle database tables from a PostgreSQL database. You can get it via the <a href="http://pgxn.org/dist/oracle_fdw/">PGXN network</a> or the main website <a href="http://laurenz.github.io/oracle_fdw/" target="_blank">http://laurenz.github.io/oracle_fdw/</a>.</p>
<p>What is new about the latest 1.1.0 release is that there is now support for the Oracle SDO_GEOMETRY type that allows you to map the most common geometry types POINT, LINE, POLYGON, MULTIPOINT, MULTILINE and MULTIPOLYGON to PostGIS geometry type. Much of the spatial plumbing work was done by Vincent Mora of <a href="http://oslandia.com/" target="_blank">Oslandia</a>. If we have any Windows Oracle users out there, yes there are <a href="https://github.com/laurenz/oracle_fdw/releases/tag/ORACLE_FDW_1_1_0" target="_blank">binaries available for windows for PostgreSQL 9.1- 9.4 for both 32-bit and 64-bit</a>. The FDW does have a dependency on the OCI.dll which I think comes shipped with Oracle products. Unfortunately, we are not Oracle users so can't kick the tires.</p>
Sat, 06 Dec 2014 12:33:00 -0500http://www.postgresonline.com/journal/archives/338-guid.htmlfdworacleoracle_fdwPostGIS Day synopsishttp://www.postgresonline.com/journal/archives/337-PostGIS-Day-synopsis.html
9.4new in postgresqlpostgispostgresql versionshttp://www.postgresonline.com/journal/archives/337-PostGIS-Day-synopsis.html#commentshttp://www.postgresonline.com/journal/wfwcomment.php?cid=3370http://www.postgresonline.com/journal/rss.php?version=2.0&type=comments&cid=337nospam@example.com (Leo Hsu and Regina Obe)
<p>Yesterday was PostGIS day or as some may call it, Post GIS day and a couple of interesting things happened this day:</p>
<ul>
<li><a href="http://www.postgresql.org/about/news/1555/" target="_blank">PostgreSQL 9.4 RC1</a> came out.</li>
<li>There were parties and unconferences, many summarized on <a href="http://2014.postgisday.rocks" target="_blank">http://2014.postgisday.rocks</a></li>
<li>I managed to entertain myself with a <a href="http://www.bostongis.com/blog/index.php?/archives/234-PostGIS-Day-Game-of-Life-celebration.html" target="_blank">Conway's game of life</a> PostGIS raster Map algebra style</a> and pondered how wonderful PostGIS would be if it could generate animated gifs with some sort of aggregate function; to which I was politely called crazy by some of my fellow PSC friends.</li>
</ul>
<p>But what was greatest of all and took the cake were these pictures:</p> <br /><a href="http://www.postgresonline.com/journal/archives/337-PostGIS-Day-synopsis.html#extended">Continue reading "PostGIS Day synopsis"</a>
Fri, 21 Nov 2014 16:16:00 -0500http://www.postgresonline.com/journal/archives/337-guid.htmlpostgispostgresql 9.4