SQL Notebook
Hello everyone! Author here. I didn't expect anyone to find this repo, much less post it on Hacker News!<p>This project is inactive for two main reasons:<p>- SQLite is not a great general-purpose SQL engine. Poor performance of joins is a serious problem that I couldn't solve. The virtual table support is good but not quite good enough; not enough parts of the query are pushed down into the virtual table interface to permit efficient querying of remote tables. Many "ALTER" features are not implemented in SQLite which is a tough sell for experimental data manipulation.<p>- T-SQL, the procedural language I chose to implement atop SQLite, is not a great general-purpose programming language. Using C# in LINQpad is a more pleasant experience for experimentally messing around with data.  R Studio is a good option if you need statistical functions.<p>I think several good solutions in this problem space exist.  A local install of SQL Server Express can be linked to remote servers, allowing you to join local tables to remote ones.  That setup serves nearly all of SQL Notebook's use cases better than SQL Notebook does.  LINQpad is also very convenient for a lot of use cases.<p>I appreciate the interest!  I may spin off the import/export functionality into its own app someday, as I had a lot of plans in that area, but I think SQL Notebook as it stands is a bit too flawed to develop fully.