MSSQL IO #

Flutter plugin for Microsoft SQL Server. Works on Android, iOS, Windows, macOS, Linux, and Web.

Installation #

dependencies:
  mssql_io: ^0.0.6

Quick Setup #

FreeTDS is automatically downloaded and built during package installation for Android and iOS. The plugin will build without FreeTDS (stub implementation) if FreeTDS cannot be built, but you need FreeTDS for actual database connections.

Android Setup #

FreeTDS builds automatically when you run flutter build or flutter pub get. First build may take 15-20 minutes.

Requirements:

• Android NDK (set ANDROID_NDK_HOME or install via Android Studio)

Manual build (optional):

cd android
chmod +x build_freetds.sh
./build_freetds.sh

iOS Setup #

FreeTDS builds automatically when you run pod install. First build may take 10-15 minutes.

Requirements:

• macOS with Xcode
• CMake (brew install cmake)

Setup:

cd ios
pod install
cd ..
flutter clean
flutter pub get
flutter run

Desktop Setup #

brew install freetds              # macOS
sudo apt-get install freetds-dev  # Linux
vcpkg install freetds:x64-windows # Windows

Web Setup #

Requires backend API proxy. See Web Platform section.

Usage #

import 'package:mssql_io/mssql_io.dart';

final request = MssqlConnection.getInstance();

// Connect
await request.connect(
  host: '192.168.1.100',
  databaseName: 'MyDB',
  username: 'sa',
  password: 'Password123',
);

// Query
final result = await request.getData('SELECT * FROM Users');

// Parameterized query (prevents SQL injection)
final users = await request.getDataWithParams(
  'SELECT * FROM Users WHERE Age > @age',
  [SqlParameter(name: 'age', value: 18)],
);

// Insert with parameters
await request.writeDataWithParams(
  'INSERT INTO Users (Name, Email) VALUES (@name, @email)',
  [SqlParameter(name: 'name', value: 'Alice'),
   SqlParameter(name: 'email', value: '[email protected]')],
);

// Transaction
await request.beginTransaction();
try {
  await request.writeData('INSERT INTO Orders VALUES (1, 99.99)');
  await request.commit();
} catch (e) {
  await request.rollback();
}

await request.disconnect();

API #

• connect() / disconnect() - Connection
• getData() / getDataWithParams() - Queries
• writeData() / writeDataWithParams() - Insert/Update/Delete
• beginTransaction() / commit() / rollback() - Transactions
• bulkInsert() - Batch operations

Security #

Always use parameterized queries:

// Safe
await request.getDataWithParams('SELECT * FROM Users WHERE Name = @name',
  [SqlParameter(name: 'name', value: userInput)]);

// Unsafe!
await request.getData("SELECT * FROM Users WHERE Name = '$userInput'");

Troubleshooting #

Can't connect?

• Check SQL Server is running on port 1433
• Test: telnet your-server 1433

Library not found?

• Mobile: Run ./build_freetds.sh in android/ or ios/
• Desktop: Install FreeTDS

Author #

Farhan Sadik Galib