SQL Notebook
Hello everyone! Author here. I didn&#x27;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&#x27;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 &quot;ALTER&quot; 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&#x27;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&#x2F;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.