Using External Lua Modules

Pardon me, I still don’t fully understand this. I would like to use sqlite within a Renoise tool, but the usual approaches in LUA using sqlite require a compiled dynlib/dll inside the tool.

So first I would compile such a luasqlite dynlib for all the three platforms, then put those 3(?) dynlib/dll/so into my tool dir, and include that using a require?

Also I am quite a bit lost which lib would be the best choice. There seem to be a lot of very old sqlite-lua libs… Any tips for me?

Thanks for help :slightly_smiling_face:

P.S: SQL inside a tool would make a lot of neat tools possible, which would be a lot of more work without SQL. e.g. a plugin manager with tags, categories, ratings etc. There also is such stuff like “LuaRocks”, which makes it possible to install additional funcitonality to lua? Could luarocks be intergrated instead? LuaSQL: Database connectivity for the Lua programming language I guess that would also ensure system stability…

Or ulua? As it was suggested in my other thread by lowph, this indeed seems to be the most recent approach: GitHub - stepelu/lua-ljsqlite3: LJSQLite3: SQlite3 Interface

There also are LUA ORMs, like this one: GitHub - wesen1/LuaORM: An Object-Relational Mapping (ORM) for Lua based on 4DaysORM
It seems to be also based on LuaSQL, like the most recent other projects, too. EDIT: Ah, damn LuaORM does not seem to support sqlite yet. But it looks tasty.