« Changelog History


Tortuga Chain v3.1 Release Notes

Release Date: 2019-12-24 // over 4 years ago

  • Chain 3.1 focuses on batch and bulk insert options for SQL Server, PostgreSQL, MySQL, and SQLite.
    👍 • Batch inserts use a normal INSERT statement with multiple rows being inserted atomically. The number of rows in one batch is limited by the max number of parameters supported by the database.
    • Multi-batch performs a series of batch inserts. Each sub-batch is atomic, but the operation as a whole is not unless a transaction is used.
    🐎 • Bulk inserts use the database-specific alternative. This usually offers the best performance, but as limitations such as in inability to return newly created keys.

    🔋 Features

    • Partial Object Loads #286: Only load specific properties OR exclude specific properties from being loaded
    • ➕ Add Max Parameters to Metadata #297: This is used by batch inserts to ensure we don’t use too many properties in a single statement
    • ➕ Add ValueNonNullLink appender
    • Core functionality for batch and multi-batch inserts #303
    • Batch insert for SQL Server #299: Single-statement and multi-statement batch inserts in SQL Server without the need for a table parameter.
    • Batch insert for SQLite #235: Single-statement and multi-statement batch inserts for SQLite
    • Batch insert for PostgreSQL #300: Single-statement and multi-statement batch inserts for PostgreSQL
    • Batch Insert for MySQL #308: Single-statement and multi-statement batch inserts for MySQL
    • Bulk Insert for MySQL #229
    • Bulk Insert for PostgreSQL #232
    • WithUser should accept nulls #317: This makes it easier for scenarios where the 'user' object is null because the user isn’t logged in.

    🐛 Bugs

    • 🐛 Bug in NonNullLink #301: Stack overflow in the NonNullLink appender.

    📦 Packages

    Tortuga.Chain.Access.3.1.7296.34685
    Tortuga.Chain.CompiledMaterializers.3.1.7296.34522
    Tortuga.Chain.Core.3.1.7296.34418
    Tortuga.Chain.Core.Odbc.3.1.7296.34522
    Tortuga.Chain.Core.OleDb.3.1.7296.34523
    Tortuga.Chain.MySql.3.1.7296.34684
    Tortuga.Chain.PostgreSql.3.1.7296.34685
    Tortuga.Chain.SQLite.3.1.7296.34684
    Tortuga.Chain.SqlServer.3.1.7296.34683
    Tortuga.Chain.SqlServer.MDS.3.1.7296.34685
    Tortuga.Chain.SqlServer.OleDb.3.1.7296.34684