Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for SQLite Virtual File System (VFS) Options #1392

Open
ancientjpeg opened this issue Jan 31, 2025 · 0 comments
Open

Add support for SQLite Virtual File System (VFS) Options #1392

ancientjpeg opened this issue Jan 31, 2025 · 0 comments

Comments

@ancientjpeg
Copy link

My team and I develop audio plugins, which are linked dynamically into plugin hosts. However, because there are multiple plugin formats which necessitates creating different dynamically linked libraries, our code immediately becomes vulnerable to this known issue with the default locking mechanism in SQLite. This linking approach is unavoidable as it is the industry standard, and we've determined the only way to address the issue is to use the unix-dotfile SQLite VFS. However, sqlite_orm does not provide any methodology for using the necessary sqlite_open_v2 API to allow for VFS selection.

I've already confirmed this fix works for us by modifying a fork of sqlite_orm and adding the changes myself. I am opening a PR shortly, and will un-draft it once I feel that the code is cleaned up and in line with the style of this library.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant