Merge branch '362-dev-sqlite-performance-improvement' into 'dev'

[sqlite] improve performance of sqlite generation by proper PRAGMA

See merge request !431
4 jobs for dev in 39 minutes and 42 seconds (queued for 3 seconds)
Status Job ID Name Coverage
  Cabal
passed #18844
cabal

00:17:48

 
  Stack
passed #18845
stack

00:02:29

 
  Bench
manual #18846
allowed to fail manual
bench
 
  Test
failed #18847
test

00:19:24

 
Name Stage Failure
failed
test Test
Test suite garg-test: FAIL
Test suite logged to:
/builds/gargantext/haskell-gargantext/dist-newstyle/build/x86_64-linux/ghc-9.6.6/gargantext-0.0.7.4.7/t/garg-test/opt/test/gargantext-0.0.7.4.7-garg-test.log
0 of 1 test suites (0 of 1 test cases) passed.
Error: [Cabal-7125]
Tests failed for test:garg-test from gargantext-0.0.7.4.7.

Cleaning up project directory and file based variables
ERROR: Job failed: exit code 1