Spatial data comes in many shapes (sic) and sizes. To conduct spatial analysis with PostgreSQL you need to be able to handle geographic objects, and to be able to handle geographic objects, you need the PostGIS extension. In this post, tjukanov explains how to set up a hosted Postgres database, how to install PostGIS, and some of the key terminology associated with spatial data analysis.
Spatial data analysis and PostGIS → 16 tips from one of our Postgres team members who was instrumental in choosing talks for the last week's PgDay SF conference. We believe these tips will be useful to you for developer events, and especially Postgres events.
16 tips → At FOSDEM PGDay Postgres committer Andres Freund walked through why he's been working on a proposal for a new PostgreSQL AIO Architecture (the takeaway: so Postgres can better utilize increasing hardware parallelism). Check out his slides to get a feel for what he is proposing.
Read Andres’s slides on Asynch IO → One of Rob Conery’s friends recently asked him a whole series of questions about getting started with Postgres. So, if you’re like Rob’s friend, and you want to start from the very beginning with Postgres, read on! And even if you’re already a Postgres expert, you might just enjoy how Rob explains Postgres as much as we did.
Getting started with Postgres → On January 21st PgDay SF 2020 was a success. Woot! Our Citus and Postgres teams here at Microsoft were a sponsor", and some of our Postgres team members also volunteered to help organize the event. Thank you to everyone who: worked so hard to create it, spoke, sponsored, and attended. Magnus Hagander—the President of PostgreSQL Europe—kicked off the day with a keynote on the Postgres community. Seven other technical talks followed, from advanced data types, to EXPLAIN, to time series data, and more. The website has been updated with oodles of photos from the event, and slides for most talks have been posted too. Check it out, and make plans for next year!
PgDay SF photos & more → For those of you who run (or are looking to run) your app on Azure Database for PostgreSQL, Narendra has created a useful checklist. He first steps you through various things you can do to optimize the connection between your application and your Postgres database. He then shares multiple basic monitoring methods with details of what, when, and how. Try out these Postgres optimization and monitoring techniques to improve your app’s performance on Azure.
Performance checklist → In his talk at both PGCon 2019 and PGConf.EU 2019, Jeff Davis explores deep Postgres extensions in Rust. Watch Jeff give his presentation at PGConf.EU, and follow along with the slides from his talk. Jeff walks you through postgres-extension.rs which supports development of extensions in Rust, a memory-safe language that integrates nicely in any environment, has powerful libraries, a vibrant ecosystem, and a prolific developer community.
Watch the video → Earlier this month we announced the public preview of Azure Private Link support for the Azure database for PostgreSQL Single server. Azure Private Link is a secure and scalable way for you to consume Azure database for PostgreSQL Single server service privately from your Azure Virtual Network (VNet).
More on private link → In this post, Craig explains how extensions have driven the Postgres shift from a relational database to a more versatile data platform. Postgres extensions are lower-level APIs within Postgres that change or extend its functionality. These extension hooks allow Postgres to be adapted for new use cases without upstream changes to the core database.
More about Postgres extensions → If you’re trying to decide whether to manage your Postgres database yourself, or to use a fully-managed database as a service in the cloud—on Azure, AWS, or GCP, this post might help. A guest blogger on the Azure Postgres blog wrote this compare-and-contrast article on the pros and cons each method.
To manage, or not to manage → Spring conference season is upon us Submit a proposal to one of these recently opened CFPs |