Sqlean extension

[ilyapl82]

Hi,

I'm a newbie trying to get sqlean (a statistics package for sqlite ) to work on a dbeaver.

I don't understand what steps I need to take to get it installed on my windows PC and running on my sql code.

I was hoping you could help me with some step by step instructions or a video.

This sqlean extension is on github not marketplace....

https://github.com/nalgeon/sqlean/

Thanks

[bobromeo]

I can answer this if it still wanted?

[ericbf]

Yes, it is still wanted.

[mkgrgis]

@ilyapl82, try to execute standard SQLite command to load extension and work in context with needed functions.

[bobromeo]

@ericbf, hi Eric, btw SQLean is not a statistics package :-)

select * from artist where name like 'AC%';
select load_extension('D:\Programs\SQLean\text.dll');
select name, text_reverse(name) revname
from artist where name like 'AC%';

[ericbf]

I understand it's not 🤪, just looking for a way to auto load it for all SQLite connections automatically.