Fixing a 2-year-old Bug: A Journey with Debugging SSL Handshake
Nobody said building the world’s fastest distributed OLAP database would be easy. However, speed is not everything we aim for. One of the current hot topics at Oxla is external tools support.
Together with my team, we're responsible for supporting major data analytics tools compatible with PostgreSQL standards, such as QuickSight, Looker, PowerBI, and more.
Working with something new requires a thoughtful approach. We usually start by understanding how the tool communicates with PostgreSQL, which queries are executed, what functions are called, etc.
Since Oxla’s network protocol and SQL dialect are mostly compatible with PostgreSQL, usually it’s only a matter of providing missing DB functionalities support. We thoroughly analyse what happens within PostgreSQL and once we identify missing features, the development process for adding tool support in Oxla begins.
During the last sprint, we made some significant progress in our work on the Google PostgreSQL Connector for Looker Studio. We were finalizing the implementation of some missing features, and it was time to put our work to the test. Our goal was to test Looker not only with stand-alone Oxla (without SSL) but also with Oxla Cloud.
