3 ms·
Ask HN: Are you using MSSQL at work, is it popular?
I was recently trying to figure out if MSSQL is still a widely used db and as a proxy i searched HN. It seems it's only mentioned in comments from time to time but very rarely an article specifically related to it (comparing to Postgres/mysql related articles). Is this specific to HN or is MSSQL just not that widely used outside big enterprises?
Are you are using it, what language do you use to develop applications against it? Is NodeJS/TS an option?
Asking because i was thinking of developing something like PostgREST/Hasura for MSSQL in TypeScript.
Do you think your company could need/use something like that?
- viraptor 3y agoYou won't find much on HN because historically MsSQL was windows-server only and that's a tiny fraction of small / start-up services using it. It's really common for windows-only shops. Almost any language can talk to it. And definitely any that supports odbc.
- taway1982345 3y agoso it's used mostly by windows-only shops (though i have no idea what they are typically building) i guess it follows that Node/Ts is not popular with them?
- viraptor 3y agoNot that often. They're more likely to be c#/java/native places. But there's no barrier really: https://www.npmjs.com/package/mssql https://www.npmjs.com/package/mssql
- taway1982345 3y agothanks for the idea of looking an npmjs stats https://npmtrends.com/mssql-vs-mysql-vs-mysql2-vs-pg https://npmtrends.com/mssql-vs-mysql-vs-mysql2-vs-pg I was kind of expecting pg usage to be higher compared to mssql in the node world but i did not expect mssql and mysql to be so relatively close.
- KingOfCoders 3y agoWe used MSSQL in one of my former CTO jobs for an data warehouse, but mostly because the finance department were Power Excel users, we used MySQL for the website. Currently I'm using Postgres for my next startup [0] [0] https://www.amazingcto.com/postgres-for-everything/ https://www.amazingcto.com/postgres-for-everything/