2 ms·
We're in the process of adding MSSQL support to our product. We've been using Sybase SQLAnywhere but we'll likely end up moving as SAP, who bought Sybase, seems
by magicalhippo 5y ago
We're in the process of adding MSSQL support to our product. We've been using Sybase SQLAnywhere but we'll likely end up moving as SAP, who bought Sybase, seems to be interested in moving the product in a different direction to what we need.
While MSSQL has some nice operational features over SQLAnywhere, it feels like going back to the stone age in terms of writing queries.
Most annoyingly are the silly limitations w.r.t. aliases, there's no regexp matching, no nice list() function only annoying string_agg()...
Especially the aliases will be super-painful. Just going through a few non-trivial ones, I'm looking at turning them into 5+ levels of nesting due to that.
Alas, our customers wants to manage their own MSSQL instance, so that's what we gotta cater for. If I had anything to say, we'd most definitely would move to PostgreSQL.
- chasil 5y agoDid you know there is now a TDS interface for Postgres, so SQL Server clients can use Postgres natively? https://babelfishpg.org/docs/internals/software-architecture/ https://babelfishpg.org/docs/internals/software-architecture... If you must use Microsoft SQL Server, at least deploy it on Linux. Microsoft's published TPC-H scores are all higher on Linux than Windows, and Patch Tuesday is agony for those who need an available database. Oracle's Ksplice is also free on Ubuntu. Try to use XFS, as all the top TPC scores seem to be using this filesystem. http://tpc.org/tpch/results/tpch_perf_results5.asp?resulttype=all&version=3 http://tpc.org/tpch/results/tpch_perf_results5.asp?resulttyp...
- magicalhippo 5y ago> Did you know there is now a TDS interface for Postgres I did not, that's really interesting thanks! > If you must use Microsoft SQL Server, at least deploy it on Linux For customers where we'll still be managing the DB, that's definitely an option I'll push for checking out. That said, management can trump peak performance. We've been a Windows shop for 20+ years, if support judges it too hard to learn the idea is DOA.