Bakhtiyar-Garashov

PostgreSQL is Enough

• Just Use Postgres for Everything
• Simplify: move code into database functions

Background Jobs

• https://github.com/citusdata/pg_cron

Message Queues

Bakhtiyar-Garashov

TMS vs XYZ

Web map raster tile URL templates usally look like this: //{servername}/{somepath}/{z}/{x}/{y}.png

Z is the zoom level (0 being zoomed all the way out so the earth fits on a single 256px x 256px tile, 18 or higher getting you down to street level) X and Y are the tiles coordinates, but there are two different standards for where the origin of the Y coordinate is.

If you look at [http://www.maptiler.org/google-maps-coordinates-tile-bounds-projection/](this site) which shows the various tile coordinates, you'll see that the X's are identical for 'Google' and 'TMS', but the Ys are different. 'Google', aka 'XYZ' aka a few other names that nobody seems to agree on places the Y origin at the north end of the earth, while TMS places it in the south.

Re-serve a TMS tileset as an XYZ tileset using express.js

Bakhtiyar-Garashov

How Make Youtube Less Boring

Mark as "Not interesting" all the videos.

Paste the below code in your browser console (F12 > Console):

await markAllVideosAsNotBeingInteresting({
    iterations: 1
});

async function markAllVideosAsNotBeingInteresting({iterations}) {

Bakhtiyar-Garashov

Find the original here article here: Devops Best Practices

DevOps started out as "Agile Systems Administration". In 2008, Andrew Shafer did a talk called "Agile Infrastucture" addressing issues around involving more of the company in the same disciplines as programmers.

In 2009, Patrick Debois created "DevOpsDays" conference to help to bring it to light. However, it wouldn't begin to trend until about 2010, when people would begin to describe it as a standalone discipline.

Today, DevOps goes beyond just developers, systems administration and infrastructure, its about [dev, ops, agile, cloud