News for hackers. Stuff that matters.

A comment on SQL Notebook. Parent comment

Re:SQL Notebook by jimktrains2 on Tuesday May 09, 2017 @02:02PM (#14302428)
> I feel like rewriting this on top of SQL Server Express

Why choose a proprietary engine? Why not use PostgreSQL or even MySQL?

[ Parent | on HN ]
Re:SQL Notebook by frik on Tuesday May 09, 2017 @02:50PM (#14302828)
I can recommend HeidiSQL, a useful GUI for MySQL, MariaDB, MSSQL and Postgres. https://en.wikipedia.org/wiki/HeidiSQL

They probably meant SQL Server Compact, which is a smaller package and comparable to SQLite. It was meant to power WinFS back in 2006. But it's closed source and now legacy.

https://en.wikipedia.org/wiki/SQL_Server_Compact

[ Parent | on HN ]
Re:SQL Notebook by krylon on Tuesday May 09, 2017 @02:44PM (#14302790)
There are many business applications that target SQL Server exclusively.

On the one hand, I find that highly annoying. On the other hand, even if you don't like Microsoft, SQL Server is fairly awesome, performance-wise and stability-wise.

But still, there are many applications where you cannot really choose what database engine you want to use.

[ Parent | on HN ]
Re:SQL Notebook by infogulch on Tuesday May 09, 2017 @03:07PM (#14302958)
I suppose PostgreSQL+FDW would be just as good as SQL Server Express+Linked Servers technically. You end up trading users' MSSQL experience for pgsql.

I wonder if it would be easy to support both backends and be able to switch between them depending on the query and which features and integrations you want.

[ Parent | on HN ]