SQL Commenter with Postgrex
A few years ago, I discovered sqlcommenter, a tool that enables adding trace context to SQL queries. This feature makes it possible to match database calls visible in PostgreSQL logs or any observability tool. At the time, I found several questions about this topic scattered across the internet, but no concrete solutions. I attempted to solve this myself and experimented with various approaches, but none of them proved viable for implementation in Elixir, particularly with Ecto.
Read More
Reverse Engineer Unknown Data Format Using Elixir
I recently worked on porting the csv file converter for AdventureWorks database from ruby to elixir. This ended successful and I have all the data in my local postgresql to play with. By browsing the tables I found spatial_location column in person.address table and I wanted to decode it.
TIL: Non Standard Postgres Types in Livebook
Livebook has a new, nice feature that allows you to connect to a database. It works with basic data types.
Read More
Visualize Explain Results from PostgreSQL in PGCLI
Recently I wrote a visualizer for explain query responses from PostgreSQL. I also integrated it into pgcli and it got merged few days ago. You can install it currently with:
Read More