Can't load SQLite extension (e.g asg017/regex) #34531
-
Description(I'm new to DBeaver, be warned) DBeaver VersionCommunity Edition Version 24.1.1.202406231636 Operating SystemUbuntu noble Database and driverFrom help / installation details: *** Platform Details: *** System properties: $ cat configuration.txt | grep sqlite org.jkiss.dbeaver.ext.sqlite (1.0.182.202406231636) "DBeaver SQLite Model" [Active] org.jkiss.dbeaver.ext.sqlite.ui (1.0.103.202406231636) "DBeaver SQLite UI" [Starting] Id: org.jkiss.dbeaver.ext.sqlite, Version: 1.0.182.202406231636, Location: reference:file:plugins/org.jkiss.dbeaver.ext.sqlite_1.0.182.202406231636.jar Id: org.jkiss.dbeaver.ext.sqlite.ui, Version: 1.0.103.202406231636, Location: reference:file:plugins/org.jkiss.dbeaver.ext.sqlite.ui_1.0.103.202406231636.jar Steps to reproduce
Additional contextI could easily be trying the wrong thing. Is there another way to get DBeaver to load this sqlite extension when I open the db connection? |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 3 replies
-
Hello @bobhy, Extension management is a commercial feature of all our PRO products. We will update the wiki to state it explicitly. You can get a trial version here: https://dbeaver.com/download/ Otherwise, you can do the following:
Remember that you need to have a 64-bit version of the extension library. Please let me know if it helps |
Beta Was this translation helpful? Give feedback.
-
Thanks! That worked for me, closing the issue. I would be happy to write up a blurb for the wiki describing this for users of the community edition... |
Beta Was this translation helpful? Give feedback.
Hello @bobhy,
Extension management is a commercial feature of all our PRO products. We will update the wiki to state it explicitly.
You can get a trial version here: https://dbeaver.com/download/
Otherwise, you can do the following:
enable_load_extension
property totrue
in Driver propertiesSELECT load_extension('extension-name.so')
either as a bootstrap query or in the SQL editorRemember that you need to have a 64-bit version of the extension library. Please let me know if it helps