FS#72063 - [sqlite] loadable extensions not compiled/packaged
Attached to Project:
Arch Linux
Opened by Tomas Mudrunka (harvie) - Tuesday, 07 September 2021, 13:55 GMT
Last edited by Andreas Radke (AndyRTR) - Sunday, 19 September 2021, 08:46 GMT
Opened by Tomas Mudrunka (harvie) - Tuesday, 07 September 2021, 13:55 GMT
Last edited by Andreas Radke (AndyRTR) - Sunday, 19 September 2021, 08:46 GMT
|
Details
Hello, i have sqlite 3.36.0-1 installed.
I've found that sqlite source code is distributed with number of loadable extensions: https://github.com/sqlite/sqlite/tree/master/ext https://github.com/sqlite/sqlite/tree/master/ext/misc These are not currently built into the sqlite package in archlinux. For example when i want to use virtual CSV table, it cannot be loaded as you can see here: sqlite> .load csv Error: csv.so: cannot open shared object file: No such file or directory Can you please build and include these extensions to the package? |
This task depends upon
Closed by Andreas Radke (AndyRTR)
Sunday, 19 September 2021, 08:46 GMT
Reason for closing: Won't implement
Sunday, 19 September 2021, 08:46 GMT
Reason for closing: Won't implement
+ --enable-session \
+ --enable-load-extension \
Each of these extension is meant to be compiled into .so file, so it can be loaded and used.
For example:
https://github.com/sqlite/sqlite/blob/master/ext/misc/zipfile.c
Should be compiled to /usr/lib/sqlite/zipfile.so or some similar path.
So that i can do .load sqlite/zipfile without having to compile and install that module manualy.
There's also no simple compile switch to include them all in one step. Feel free to do a custom build.