4 ms·
Hi all, I'm the author of SQL Notebook. This open source app provides a Jupyter-style notebook interface atop a local SQLite database. The SQLite engine is exte
by electroly 5y ago
Hi all, I'm the author of SQL Notebook. This open source app provides a Jupyter-style notebook interface atop a local SQLite database. The SQLite engine is extended to support procedural programming (inspired by Microsoft's T-SQL) and a library of additional import, export, and analysis commands. Unlike Excel, the default import settings in SQL Notebook will not butcher your CSV files.
I wrote this to help me wrap my head around new external data sources at work before writing production ETL processes for them. I can use a throwaway notebook to quickly answer questions about the data and test out how it will integrate with other tables in our database.
In future versions I plan to support additional file formats, add a command line interface for unattended script execution, and flesh out the standard library. If any of this sounds interesting, please give SQL Notebook a try! Thanks!