Here is a summary of relevant statements from “Use the index, Luke”, pertaining to database indexing.

Preface

• The separation of concerns—what is needed versus how to get it—works remarkably well in SQL, but it is still not...

Lately, I’ve felt that I’m spending a lot of time on computer science and software development and not enough time on self-development. This is not aligned with my personal goal of becoming a more well-rounded person. Hence, I decided to...

There was a Postgres User Group meetup at Pivotal Labs today. The talk was about MVCC (Multi version concurrency control) in Postgres and why COUNT queries are slow. It seemed interesting enough, so I made my way towards King and...

The VP of Engineering at Loblaw Digital graciously offered me a corporate ticket to attend Elevate Toronto, a week-long tech conference that celebrates Toronto’s tech ecosystem. I have compiled a short summary of my key takeaways from the various presentations.

With the release of the 3rd Edition of “Effective Java” a few months back, I decided to re-read it and compile a few notes for future reference. These notes only represent points that are specifically useful to my development as...

I spent the past few months diving deep into 11 weeks worth of lectures on “Bitcoin and Cryptocurrency Technologies” offered by Princeton University on coursera.com. I have painstakingly compiled a summmary of my learnings from the course.

Week 1...

I attended my very first Java User Group meetup today held at Free Times Cafe near College and Spadina. The meetup room was packed, and most of the attendees were senior java devs. The presentation was about bridging the gap...

I’ve compiled a list of my learnings from the book “Intelligent Investor” by Benjamin Graham.

Commentary on the introduction

• Intelligent investor : Being patient, disciplined and eager to learn. Harness your emotions and think for yourself.
• Don’t let the...

Welcome to my blog. All of my older blog posts can be viewed here.