I’m beginning a monthly post with content (articles, books, podcast episodes) that I enjoyed. Here we go!

Hiring and onboarding, with focus on remoting

• Best practices for remote onboarding.
• 7 Tips for Onboarding Remote Employees.
• Scaling engineering organizations.
• How do you (GitLab) onboard new team members?.
  • Guide for starting a remote job.
  • GitLab Onboarding Buddies.
  • Considerations for a Productive Home Office or Remote Workspace .
• Questions for our first 1:1.

PostgreSQL

• CrunchyData learning portal.
• The Surprising Impact of Medium-Size Texts on PostgreSQL Performance.
• Lessons learned scaling PostgreSQL database to 1.2bn records/month. This led me to experiment with from_collapse_limit and join_collapse_limit parameters, because our SQL queries are quite complex and the plan time vs. execution time trade-off should pay off.
• SQL Optimizations in PostgreSQL: IN vs EXISTS vs ANY/ALL vs JOIN.

PostGIS

• PostGIS Trajectory: Space plus Time. We’re probably going to experiment with routing, this can be priceless.
• PostGIS performance tips.
• OSM PostGIS Tuning.
• Virtual PostGIS Day 2020 videos by Crunchy Data.

React

• React Performance Optimization Tips.
• Use CSS Variables instead of React Context.

Distributed changes

• How Figma’s multiplayer technology works.
• Local-first.
• Porting a 100% local app to the web.

TinyBird

• How we processed 12 trillion rows during Black Friday.
• Investigating performance bottlenecks with SQL, simple statistics and Google Sheets.

Misc

• Sentry Performance Monitoring & Google’s Web Vitals.
• Anita Graser blog on GIS is truly impressive, check it out. Follow @underdarkGIS!
• Boost your Company Feedback Culture in 4 Weeks.
• Systems design explains the world: volume 1.
• Templates as Inspiration for Software Engineers and Engineering Managers.
• How to stop using your GraphQL API as a REST API.