March 5, 2026
SQL Window Functions and PARTITION BY in Practice
Sharing our experience with window functions in a recent client project involving historical data management
#SQL
March 7, 2025
Write SQL Queries in...Obsidian?
Did you know you can write queries to join data across all your data sources from within Obsidian.md?I
This one is interesting. I didn’t even know you can run Python scripts in Obsidian?! Now it’s a whole new world for me.
January 28, 2025
SQLook - SQLite Database Viewer and Generator
SQLook - A free online SQLite database manager with visual query builder. Create, view, and query SQLite databases directly in your browser. Features include visual table generation, sample data population, query assistance, and database visualization.
SQLook is a powerful web-based SQLite database manager that runs entirely in your browser. No installation or server required - just open your SQLite databases and start working with them immediately.
January 3, 2025
Obsidian SQLSeal
SQLSeal allows to transform your CSV files located in your vault into fully-fledged SQL database. You can use SQL statements to query this data however you like.
Time to learn SQL. This will be very helpful in my future endeavor. I can probably make csv files using python.