db-experiments

Trying some stuff out interfacing with a database in fsharp

database setup

Create the local database with:

psql -d postgres -U [username] -f sql/create_db.sql

Set an environment variable named "CONNSTRING_GAMES_LOCAL".

TryHydra

Project to try out (new features of) sqlhydra with a Postgres database. Specifically, I am interested in using Postgres enum types and materialized views.

We use SqlHydra to automatically generate a "database types" module tryHydra/DbTypes.fs (in the repo). Regenerate the hydra file by running:

dotnet sqlhydra npgsql --project tryHydra/TryHydra.fsproj

The first time you do this, you will be promted for some input parameters. These parameters are then saved in a file called sqlhydra-npgsql.toml so you don't have to give the input every time. If you want to change the params, such as which database is being used, you can edit the .toml file directly.

Choose/fill in the following parameters when prompted:

> Enter a database Connection String: Server=localhost;Database=games;Username=<username>;Password=<password>
> Enter an Output Filename (...): tryHydra/DbTypes.fs
> Enter a Namespace (...): Games.DbTypes
> Select a use case: Sqlhydra.Query integration (default)

TryNpgsql

Trying to query the metadata on Postgres materialized views with Npgsql (used in the hydra code).