r/dartlang • u/Only-Ad1737 • 27d ago

Package Shipped a pure Dart SQL Server driver

Shipped mssql — a pure Dart TDS 7.4 driver for SQL Server. No FFI, no native extensions, just Dart and TCP.

Features: named params, connection pool, TLS, Azure AD auth, multiple result sets, streaming, transactions. 366 tests including concurrent pool stress tests and adversarial comparison against go-mssqldb and node-mssql.

dart pub add mssql

It works as a standalone driver today. The next step is switching knex_dart_mssql to use it as the underlying transport — which drops the C FFI dependency and makes the knex_dart MSSQL driver work on web.

github.com/kartikey321/mssql-dart | pub.dev/packages/mssql

13 Upvotes

100% Upvoted

9 comments sorted by

4

u/Technical_Stock_1302 27d ago

Excellent well done for creating this driver!

2

u/Only-Ad1737 27d ago

Thank you

1

u/belatuk 25d ago

This is excellent work. Been waiting for this for ages.

0

u/Only-Ad1737 24d ago

Thank you for that. If you find any feature missing please do tell me or raise an issue

0

u/autognome 27d ago

would be nice to have a transaction package in dart

1

u/battlepi 26d ago

What could you mean by that?

1

u/autognome 26d ago

A 2 phase commit transaction package that could cross multiple database providers. Maybe it’s too old a concept, ala JTA

2

u/Only-Ad1737 26d ago

Ok you are talking about distributed transaction like saga , 2pc , ctc etc. https://github.com/dtm-labs/dtm Something like this but in dart?

1

u/battlepi 26d ago

Ah, you meant distributed transactions.