Juan Ignacio Sánchez Lara Software Engineer

Passionate Software Engineer (resumé).
Remoting from Valladolid, Spain.
Interests: Engineering Management, PostgreSQL, Agile, Scala, Python, geo…

I’m also an amateur writer, under the Ignacio C. Sierra pseudonym.

November 2021 reads

Some interesting content that I ingested during November 2021. Expect collaboration software, AWS, mapping...

November 2021 reads feature image

October 2021 reads

Some interesting content that I ingested during October 2021. Expect Engineering Management, PostgreSQL, Python, mapping...

October 2021 reads feature image

Sit tibi terra levis, Tierra

In August, 24th, I received an unexpected, sad piece of news: we were closing Tierra. This is a brief farewell.

Sit tibi terra levis, Tierra feature image

September 2021 reads

Some interesting content that I ingested during September 2021. Expect Engineering Management, Postgres, mapping, Elixir... and miscellaneous stuff.

September 2021 reads feature image

August 2021 reads

Some interesting content that I read and heard during August 2021. Expect Postgres, Engineering Management and miscellaneous stuff.

August 2021 reads feature image

El manual del Manager

Notes about El manual del Manager book.

El manual del Manager feature image

July 2021 reads

Some interesting content that I read and heard during July 2021. Expect Postgres and miscellaneous stuff.

July 2021 reads feature image

June 2021 reads

Some interesting content that I read and heard during June 2021. Expect Postgres and miscellaneous stuff.

June 2021 reads feature image

May 2021 reads

Some interesting content that I read and heard during May 2021. Expect Postgres and a lot of miscellaneous stuff.

May 2021 reads feature image

April 2021 reads

Some interesting content that I read during April 2021. Expect PostgreSQL, React, AWS... In addition, I've begun listening to podcasts, you'll find some of those as well.

April 2021 reads feature image

March 2021 reads

Some interesting content that I read during March 2021. Expect PostgreSQL, React, AWS, Data visualization, OKRs...

March 2021 reads feature image

February 2021 reads

Some interesting content that I read during February 2021. Expect a lot of PostgreSQL, some links about feature flags and forms in React, and misc about git, Engineer Management and Clickhouse.

February 2021 reads feature image

January 2021 reads

Some interesting content that I read during January 2021.

January 2021 reads feature image

Functional Programming in Scala

Notes from the Functional Programming in Scala specialization.

Functional Programming in Scala feature image

PostgreSQL recipes

Both from a gist with notes and multiple bookmarks and pending Pocket'd entries, I've collected a lot of useful stuff about PostgreSQL. Don't expect a lot of order, though :-)

PostgreSQL recipes feature image

Git recipes

I've been inflating a "Git notes" gist for years with the commands that I need from time to time and that I can't manage to remember, this is a good moment for putting it in order, together with some basic notes about workflow.

Git recipes feature image

Python asyncio

After a couple of days struggling with Python async, multithreading and so on, I want to write down some notes and references at least for my future self.

Python asyncio feature image

"Conventional wisdom"

Terms around functional Programming with Scala

A glossary of functional programming terms that you should master in order to have a proficient reading of code and technical texts.

Terms around functional Programming with Scala feature image

Principal Data Engineer

Description and thoughts about my current position in CARTO, now that I'm back.

Principal Data Engineer feature image

Data Engineering on Google Cloud Platform specialization at Coursera

Notes about Data Engineering on Google Cloud Platform Specialization course at Coursera.

Data Engineering on Google Cloud Platform specialization at Coursera feature image

Essential Scala

Notes about Essential Scala book.

Essential Scala feature image

Calvin: Fast Distributed Transactions for Partitioned Database Systems

Notes about Calvin: Fast Distributed Transactions for Partitioned Database Systems paper.

Calvin: Fast Distributed Transactions for Partitioned Database Systems feature image

99 Bottles of OOP Workshop

Notes, slides and code about 99 Bottles of OOP workshop

99 Bottles of OOP Workshop feature image

Designing Data-Intensive Applications

Personal review and notes of Designing Data-Intensive Applications

Designing Data-Intensive Applications feature image

Back to Linux!

Back to Linux! Here you have some notes from my migration to Ubuntu with a XPS 9570

Intellij IDEA Tips

IntelliJ IDEA is a great tool, let's get the most out of it

Peopleware 3rd Edition Review

Personal review and notes of Peopleware 3rd edition.

PostgreSQL: The one tool to bring to a desert island

TL;DR: if you don't know what your needs will be, build upon PostgreSQL. And, if you know and you pick another DB, think twice.

Do we build the right tools right?

Biased talk about how we choose techology. Do we understand the tradeoffs, or just follow trends?

Software conferences map

There is a CARTO map with many software conferences, and a Google form that you can use to contribute with more.

SQL Performance Explained by Markus Winand

Slides from the "SQL Performance Explained talk by Markus Winand" talk at Cylicon Valley.

Introduction to Location Intelligence with CartoDB

Slides from the "Introduction to Location Intelligence with CartoDB" talk at Picnic Code 2016.

Continuous Integration at CartoDB

Slides and video about the "Continuous Integration at CartoDB" talk.

My name is juanignaciosl and I code

In this first post I'll introduce myself with some links and a CartoDB Deep Insights map.