{"repo":"bytefish/PostgreSQLCopyHelper","free":true,"listed":false,"github":"https://github.com/bytefish/PostgreSQLCopyHelper","clone":"git clone https://github.com/bytefish/PostgreSQLCopyHelper.git","description":"Simple Wrapper around Npgsql for using PostgreSQL COPY functions.","language":"C#","stars":179,"topics":["postgresql","npgsql","bulkimport","bulkcopy","postgres"],"license":"MIT","category":"databases-storage","readme_excerpt":"PostgreSQLCopyHelper # PostgreSQLCopyHelper is a high-performance .NET library for Bulk Inserts to PostgreSQL using the Binary COPY Protocol. It provides an elegant, highly optimized wrapper around the PostgreSQL COPY command: The COPY command is a PostgreSQL specific feature, which allows efficient bulk import or export of data to and from a table. This is a much faster way of getting data in and out of a table than using INSERT and SELECT . This project wouldn't be possible without the great Npgsql library, which handles the underlying Postgres wire protocol. Setup ## PostgreSQLCopyHelper is available on NuGet. You can add the following dependency to your .csproj to include it in your project: PostgreSQLCopyHelper 3.0.0 ### The newest major release of PostgreSQLCopyHelper comes with a completely redesigned API. The new API strictly separates the What (Structure and Mapping) from the How (Execution and I/O). It flips the mental model by having a Database-first API, which solves a lot of problem with the previous API and allows for composing complex types more easily. Quick Start ## 1. Define your Data Model ### The library works perfectly with modern C# record types, structs, or traditional classes. 2. Define your Mapping (Stateless & Thread-Safe) ### The PgMapper is the heart of the library. It is completely stateless after configuration and should be instantiated only once (e.g., as a static readonly field or Singleton). 3. Execute the Bulk Insert ### The PgBulkWriter is a","default_branch":null,"files":null,"tree":[],"storefront":"/r/bytefish","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/bytefish/PostgreSQLCopyHelper/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}