View allAll Photos Tagged postgres

New Database Architechs website home page

morphology study of Scotland's airports. Ordered by bounding box area.

 

QGIS 2.18.13, Postgres/PostGIS, Python.

 

row 2 looks spookily like cuneiform and early hieroglyphs (and Stornoway airport, 3rd from left in second row) looks like a head :-)

  

visualising the size of Scottish islands, by placing them side-by-side.

 

using a mixture of postgres/postgis, qgis and osm2pgsql.

 

used a postgis query to align the islands so that their centroids were all in the same place, then offset each successive island 20km east of its predecessor.

 

used data copyright OpenStreetMap and contributors. Polygons were based on admin_level='6', then split from multipart to singlepart. This made sure that Mull (for example) fragmented into lots of individual Islands so that I could isolate the "mainland" of Mull from the countless other islands just off its coast.

Anastasia is known as author of Index-only scans support for GiST, which was commited to PostgreSQL 9.5 release. Her current project is a new access method based on LSM-trees.

We talk with Mason in our office in Old Arbat, Moscow

Konstantin Knizhnik and Mason Sharp (Postgres-XL).

Kostantin Pan, Stas Kelvich and Konstantin Knizhnik are brainstorming about Postgres cluster.

Alexey Tutubalin and Vladimir Ermakov with Teodor Sigaev.

I tested Nikon D850 at low light, ISO 7200 !

Nikita Glukhov, Oleg Bartunov, Andrey Klimkovsky

Nikita Glukhov, Oleg Bartunov, Andrey Klimkovsky

Oleg Bartunov, Andrey Klimkovsky, Nikita Glukhov

2 4 5 6 7 ••• 66 67