Interacting with databases

Hello everyone,

I am back developping with OCaml after an 8 years hiatus, and i see the tremendous improvement with the ecosystem!

I am looking to setup an ETL pipeline, where I would execute queries on a postgresql database, perform some work on the data and write to another postgresql database. I have seen caqti, for database interaction, should I know of any other related projects before I start diving into code ?

See also https://github.com/andrenth/sequoia

In fact you may find a lot of useful libraries at Awesome OCaml list.

The ocamlverse page has a little (but not much) more.

Thank you for your quick replies!

What about migrations? Is there anything popular or should I implement my own ?

This appears to be one of the most featureful and currently-maintained https://github.com/paurkedal/ocaml-caqti

I haven’t found anything great for migrations yet, though.