Replace Selda with something else

[dhess]

It's clear that Selda is unmaintained now. There's at least one community fork, but I'd prefer something where upstream has control over the Hackage story.

Given the future of this project is focused on running most things in-browser, including at least some level of persistence, SQLite support is still attractive, because there's been some success running SQLite in the browser via Wasm. In any case, I think our SQL needs may be quite a bit simpler than we originally anticipated. Therefore, something like https://hackage.haskell.org/package/sqlite-simple might be a good enough replacement for Selda.

Relevant links:

• https://thenitinprakash.com/2021-10-20/Using-Sqlite-with-Haskell

[dhess]

I'm inclined to punt on this for now. We've found a reasonably-maintained Selda fork, and it even builds for Wasm, so perhaps we should kick the can down the road until we run into a Selda-related showstopper.

[dhess]

See also #1312.

[dhess]

As mentioned in #1312, it's likely we'll have to implement database init/migration in Haskell now, if we want Sqlite support in Wasm. Selda's migration support is known to be not very robust, so perhaps we should look more seriously at Beam: https://haskell-beam.github.io/beam/schema-guide/migrations/

edit: unfortunately, beam-sqlite doesn't currently build for Wasm:

Failed to build beam-sqlite-0.5.3.0.
Build log (
/Users/dhess/.ghc-wasm/.cabal/logs/ghc-9.10.1.20241209/bm-sqlt-0.5.3.0-67fa3b91.log
):
Configuring library for beam-sqlite-0.5.3.0...
Preprocessing library for beam-sqlite-0.5.3.0...
Building library for beam-sqlite-0.5.3.0...
Database/Beam/Sqlite/Connection.hs:97:2: error:
     error: Need either POSIX or Win32 API for MonadBeamInsertReturning
       97 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
          |  ^
   |
97 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
   |  ^

Database/Beam/Sqlite/Connection.hs:397:2: error:
     error: Need either POSIX or Win32 API for MonadBeamInsertReturning
      397 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
          |  ^
    |
397 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
    |  ^

2 errors generated.
Database/Beam/Sqlite/Connection.hs:97:2: error:
     error: Need either POSIX or Win32 API for MonadBeamInsertReturning
       97 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
          |  ^
   |
97 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
   |  ^

Database/Beam/Sqlite/Connection.hs:397:2: error:
     error: Need either POSIX or Win32 API for MonadBeamInsertReturning
      397 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
          |  ^
    |
397 | #error Need either POSIX or Win32 API for MonadBeamInsertReturning
    |  ^

2 errors generated.
Database/Beam/Sqlite/Connection.hs:1:1: error:
    `wasm32-wasi-clang' failed in phase `Haskell C pre-processor'. (Exit code: 1)
  |
1 | {-# OPTIONS_GHC -fno-warn-orphans #-}
  | ^

Error: [Cabal-7125]
Failed to build beam-sqlite-0.5.3.0 (which is required by test:primer-selda-test from primer-selda-0.7.2.0, exe:primer-miso from primer-miso-0.8.0.0 and others). See the build log above for details.

make: *** [Makefile.wasm32:11: build] Error 1

Upstream issue:

• Wasm support haskell-beam/beam#738

[dhess]

Creating databases (and checked migrations?) with Beam:

• createSchema from an instance Database Postgres MyDatabase haskell-beam/beam#242
• Cannot create a CheckedDatabaseSettings be db with Postgres haskell-beam/beam#454
• https://github.com/Znack/beam-demoblog/tree/master/src/Schema