IreneKnapp / IreneKnapp/direct-sqlite

Add a flag for compiling sqlite in Multi-thread mode

Open
#83 3 comments 1 reaction 1 assignee View on GitHub

@sigrlami is already working on this.

Since Oct 27, 2020.

enhancement
Dominant language
C
Stars
41
Forks
59
PR merge metrics
No merged PRs in 30d

Description

According to the official SQLite documentation, one needs to pass the -DSQLITE_THREADSAFE=2 flag, when compiling SQLite, to run it in multi-thread mode. The multi-thread mode improves performance slightly, when each connection is used only by a single thread. This is often a case when using sqlite with some Pool (e.g. from the resource-pool library).

I propose to add a Cabal flag that passes enables multithreading by passing a proper option to cc-options.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.