This is a simple table, but students can have a lot of fun with a challenge like "Be the worst possible travel agent you can be. My favorite is a list of pairs of airport codes and the distances between them. I did not see anything when I started putting it together, but I already had a number of datasets that I put together for illustrating specific points. It has almost everything other than enterprise level features ( clustering/replication/etc ) that most people don't need.
#Linqpad machine learning windows
That is a great starting RDBMs to learn databases on windows environment.
#Linqpad machine learning free
SQL Server Developer Edition is free now.
#Linqpad machine learning install
> A local install of SQL Server Express can be linked to remote servers, allowing you to join local tables to remote ones. net code/functions which you can run on the sql server via T-SQL so there isn't really much you can't do with T-SQL. NET code/CRUD libraries/etc for dealing with data, but if you want to work with data, T-SQL is where it is at.ĭeveloping expertise in T-SQL ( it's not as easy as people think ) will open up a new way of understand data/programming/thinking. If you are a front-end developer, then LINQpad is great in building. But for messing around with data, you can't really do any better than T-SQL. C#/LINQ/EF/etc are great for business layer/presentation layer. T-SQL is as close to the data as you can get. > Using C# in LINQpad is a more pleasant experience for experimentally messing around with data. T-SQL ( I'm assuming the microsoft variant ) is not a procedural language, it's a declarative language. > T-SQL, the procedural language I chose to implement atop SQLite, is not a great general-purpose programming language. 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. LINQpad is also very convenient for a lot of use cases.
That setup serves nearly all of SQL Notebook's use cases better than SQL Notebook does. A local install of SQL Server Express can be linked to remote servers, allowing you to join local tables to remote ones. I think several good solutions in this problem space exist. R Studio is a good option if you need statistical functions. Using C# in LINQpad is a more pleasant experience for experimentally messing around with data. T-SQL, the procedural language I chose to implement atop SQLite, is not a great general-purpose programming language. Many "ALTER" features are not implemented in SQLite which is a tough sell for experimental data manipulation. 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. Poor performance of joins is a serious problem that I couldn't solve.
SQLite is not a great general-purpose SQL engine. This project is inactive for two main reasons: I didn't expect anyone to find this repo, much less post it on Hacker News!
0 kommentar(er)
