SQL Providers

Portway supports SQL Server, PostgreSQL, MySQL/MariaDB and SQLite. The provider of an environment is detected from the ConnectionString in its settings.json. The parity suite runs against SQL Server 2025, PostgreSQL 18 and MySQL 8.0.

Detection ​

The first matching rule wins.

Connection strings ​

{
  "ConnectionString": "Server=SQLPROD01;Database=ProductionDB;User Id=svc_portway;Password=your-password;TrustServerCertificate=true;Encrypt=true;"
}

{
  "ConnectionString": "Host=db.example.com;Port=5432;Database=mydb;Username=portway;Password=your-password;"
}

{
  "ConnectionString": "Server=db.example.com;Port=3306;Database=mydb;Uid=portway;Pwd=your-password;SslMode=Preferred;"
}

{
  "ConnectionString": "Data Source=environments/WMS/demo.db;"
}

SQLite paths are relative to the working directory.

Capabilities ​

On PostgreSQL, write routines are functions. Only functions return the created row. They are called with named arguments; parameter names match the lowercased payload fields (e.g. method, id, name). On SQL Server and MySQL, a procedure ends with a SELECT of the affected row.

Schemas ​

Without DatabaseSchema, the provider default applies. A dbo on a non SQL Server environment maps to that provider's default; other schemas are used as written.

Related topics ​

• Environment Settings
• SQL Endpoints
• Expanding Related Data
• Health Checks