Postgres Query Plan Visualization —
Understanding query plans and EXPLAIN output can be tricky, even for an experienced user. This is a great tool to help better understand how a query is operating.
Alex Tatiyants tools
KeRF: A Next-generation Time-Series and Tick Database —
A columnar tick database and time-series language for Linux/OSX/BSD/iOS/Android. Natively speaks JSON and SQL. Ideal for trading platforms, low-latency networking, high-volume analysis of realtime and historical data, etc.
Binomial Options Pricing in SQL —
How to set up a discrete binomial tree using the binomial options pricing model to value derivatives in SQL, and apply this in an example of pricing a 3-period call option.