From Node.js to SQL Server: the mssql Package, Connection Pools, Parameterized Queries and Transactions
Connecting Node.js to SQL Server with mssql means opening the pool once at startup, sending every value as a parameter, writing the order and the stock in one transaction and converting decimal columns to kuruş in SQL. With real output: the float error that turns 19.99 into 1998 cents, 16.6 s vs 0.16 s for 100 queries, SQL injection and LIKE wildcards, the race for the last copy, EREQINPROG and an export streaming a million rows in 139 MB.
14 Nov 2026
·
19 min
·
14
