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

Allow using sqlite extensions during comptime verification #3330

Open
Suyashtnt opened this issue Jul 5, 2024 · 1 comment
Open

Allow using sqlite extensions during comptime verification #3330

Suyashtnt opened this issue Jul 5, 2024 · 1 comment
Labels
db:sqlite Related to SQLite enhancement New feature or request macros

Comments

@Suyashtnt
Copy link

Is your feature request related to a problem? Please describe.
I'm trying to use the uuid extension for the uuid_blob() function in sqlite. However, this errors out comptime verification since it doesn't load any extensions by default, nor is there a way to enable/add extensions at compile time.

Describe the solution you'd like
Some way to configure loading extensions during compile-time query checks. One way is to add query params to the DATABASE_URL (and also load the extensions at runtime as well), which would look something like sqlite://database.db?extension=uuid&extension=vsv

Describe alternatives you've considered
Compile sqlite with the extensions enabled by default

Additional context
seems that there were plans to do something like this in #1460 (comment)

@Suyashtnt Suyashtnt added the enhancement New feature or request label Jul 5, 2024
@abonander
Copy link
Collaborator

abonander commented Sep 20, 2024

This can be built on top of #3383 when it's merged. Something like:

[drivers.sqlite]
load-extensions = ["uuid", "vsv"]

@abonander abonander added db:sqlite Related to SQLite macros labels Sep 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
db:sqlite Related to SQLite enhancement New feature or request macros
Projects
None yet
Development

No branches or pull requests

2 participants