How to create candlestick charts with PostgreSQL
I’ve been exploring databases for the whole of my career, and yet every day I find something that amazes me. PostgreSQL introduced window functions in the 8.4 version (6 years ago!) but I still think it’s a feature not many people are aware of.