👁 Image
BitBadger.Npgsql.FSharp.Documents 2.0.0

This package provides a set of functions that provide a document database interface to a data store backed by PostgreSQL. This library is targeted toward F# usage; for C#, see BitBadger.Npgsql.Documents.

Features

• Select, insert, update, save (upsert), delete, count, and check existence of documents, and create tables and indexes for these documents
• Addresses documents via ID; via equality on any property by using JSON containment queries; or via condition on any property using JSON Path queries
• Accesses documents as your domain models (<abbr title="Plain Old CLR Objects">POCO</abbr>s)
• Uses Task-based async for all data access functions
• Uses building blocks for more complex queries

Getting Started

The main step is to set the data source with which the library will create connections. Construct an NpgsqlDataSource instance, and provide it to the library:

open BitBadger.Npgsql.FSharp.Documents

// ...
let dataSource = // ....

Configuration.useDataSource dataSource
// ...

By default, the library uses a System.Text.Json-based serializer configured to use the FSharp.SystemTextJson converter. To provide a different serializer (different options, more converters, etc.), construct it to implement IDocumentSerializer and provide it via Configuration.useSerializer. If custom serialization makes the serialized Id field not be Id, that will also need to be configured.

Using

Retrieve all customers:

// parameter is table name
// returns Task<Customer list>
let! customers = all<Customer> "customer"

Select a customer by ID:

// parameters are table name and ID
// returns Task<Customer option>
let! customer = Find.byId<Customer> "customer" "123"

Count customers in Atlanta:

// parameters are table name and object used for JSON containment query
// return Task<int>
let! customerCount = Count.byContains "customer" {| City = "Atlanta" |}

Delete customers in Chicago: (no offense, Second City; just an example...)

// parameters are table name and JSON Path expression
do! Delete.byJsonPath "customer" """$.City ? (@ == "Chicago")"""

More Information

The project site has full details on how to use this library.