Can't use URI

[domenkozar]

{-# LANGUAGE OverloadedStrings #-}
module Main where

import Database.SQLite3

main = do
  db <- open2 "file:/nix/var/nix/db/db.sqlite?immutable=1" [SQLOpenURI] SQLVFSDefault
  close db

nix-shell -p "haskellPackages.ghcWithPackages (pkgs: [pkgs.direct-sqlite])" -I ~/dev --run "runghc Main.hs"
Main.hs: SQLite3 returned ErrorMisuse while attempting to perform open2 "file:/nix/var/nix/db/db.sqlite?immutable=1": bad parameter or other API misuse

[domenkozar]

@jchia let me know if you have any ideas how to fix this.

[domenkozar]

  db <- open2 "file:/nix/var/nix/db/db.sqlite?immutable=1" [SQLOpenReadOnly, SQLOpenURI] SQLVFSDefault

this works

[IreneKnapp]

glad you figured it out :)