I hope you are enjoying the summer. No doubt many of you are using the summer as a chance to unwind and recharge the batteries after a particularly stressful year. Our friend Stelios Sfakianakis has however chosen a different path. Attentive readers will recall that Stelios authored our C (blog post) and Clojure SDKs (blog post). Well, he has done it again, and now released a PostgreSQL extension (a Foreign Data Wrapper, to be precise) for our API so that you can geocode directly in SQL.
The code, and detailed installation instructions, is on Github in Stelios’ ocgeo_fdw repository
Thank you, Stelios!
As with all the other SDKs, this new library can be found on our libraries page. And with this addition I am delighted to say we now have well over 30 different SDKs, for programing languages and dev environments as varied as ColdFusion to Perl to Haskell to Go and now to SQL. Some are maintained by us, others are open source projects maintained by members of the community. We are always happy to welcome more contributions. If you create something with our API please let us know and we will gladly feature it (though do please follow the guidelines). If you use a language for which we don’t yet have a wrapper library, please get in touch, we will happily pay you to open source a wrapper library. We’re interested in SDKs for any language we don’t yet have.
Happy geocoding (in SQL),