From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on inbox.vuxu.org X-Spam-Level: X-Spam-Status: No, score=-0.8 required=5.0 tests=DKIM_SIGNED,DKIM_VALID, DKIM_VALID_EF,FREEMAIL_FORGED_FROMDOMAIN,FREEMAIL_FROM, HEADER_FROM_DIFFERENT_DOMAINS,MAILING_LIST_MULTI autolearn=ham autolearn_force=no version=3.4.4 Received: from cgl.ntg.nl (Cgl.ntg.nl [5.39.185.202]) by inbox.vuxu.org (Postfix) with ESMTP id 6028B24037 for ; Thu, 23 Jan 2025 19:29:46 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by cgl.ntg.nl (Postfix) with ESMTP id 455BC48539E for ; Thu, 23 Jan 2025 19:27:44 +0100 (CET) Authentication-Results: cgl.ntg.nl (amavisd-new); dkim=pass (1024-bit key) reason="pass (just generated, assumed good)" header.d=ntg.nl DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=ntg.nl; h= content-transfer-encoding:content-type:content-type :list-unsubscribe:list-subscribe:list-post:list-owner:list-help :list-archive:archived-at:list-id:subject:subject:reply-to :precedence:user-agent:message-id:date:date:from:from :mime-version:received:received:received:received:received; s= cgl; t=1737656863; x=1740248864; bh=agGgp40swpIJqNa4fnE4xfL2cc5U H16XOIvsygN0vnM=; b=TEyAGtl72WE+P5pbQlajjk58uFfUP2ool4IAzW4Ai6pt XHUTwzJHqDCyqOivKDQbYqjCaUGHS8Evgb6RdI/VglvKt1nGiuG7Voah9MTt0ydn pv3NKb/gvAv/eZXEydlEum5LxAWNKNZg9DQ05f/lhhikIVL+TGVayXlcNVAliU8= X-Virus-Scanned: Debian amavisd-new at cgl.ntg.nl Received: from cgl.ntg.nl ([127.0.0.1]) by localhost (cgl.ntg.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id iiXGzlcfxs1H for ; Thu, 23 Jan 2025 19:27:43 +0100 (CET) Received: from cgl.ntg.nl (localhost [127.0.0.1]) by cgl.ntg.nl (Postfix) with ESMTP id F132B485039 for ; Thu, 23 Jan 2025 19:26:31 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by cgl.ntg.nl (Postfix) with ESMTP id 3B85F48501F for ; Thu, 23 Jan 2025 19:25:49 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at cgl.ntg.nl Received: from cgl.ntg.nl ([127.0.0.1]) by localhost (cgl.ntg.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id a0gHjx0nCQ3Y for ; Thu, 23 Jan 2025 19:25:48 +0100 (CET) Received: from cgl.ntg.nl (localhost [127.0.0.1]) by cgl.ntg.nl (Postfix) with ESMTP id BD0B148501E for ; Thu, 23 Jan 2025 19:25:48 +0100 (CET) MIME-Version: 1.0 From: krulis.tomas@seznam.cz To: ntg-context@ntg.nl Date: Thu, 23 Jan 2025 18:25:48 -0000 Message-ID: <173765674875.3183020.18290724436829452253@cgl.ntg.nl> User-Agent: HyperKitty on http://mailman.ntg.nl/ Message-ID-Hash: 55ORGGKVMSIONOZEYHAKA77DI66YB76H X-Message-ID-Hash: 55ORGGKVMSIONOZEYHAKA77DI66YB76H X-MailFrom: krulis.tomas@seznam.cz X-Mailman-Rule-Misses: dmarc-mitigation; no-senders; approved; emergency; loop; banned-address; member-moderation; nonmember-moderation; administrivia; implicit-dest; max-recipients; max-size; news-moderation; no-subject; digests; suspicious-header X-Mailman-Version: 3.3.9 Precedence: list Reply-To: mailing list for ConTeXt users Subject: [NTG-context] How to load external lua library List-Id: mailing list for ConTeXt users Archived-At: List-Archive: List-Help: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Dear ConTeXt mailing list, I've been struggling with loading the sqlite external lua library. I tried the following: 1. Instaling the system package and running ConTeXt with the `--permitloadlib` option (I am running Manjaro, an arch-linux derivative: https://archlinux.org/packages/core/x86_64/sqlite/) 2. Installing the luarocks package (https://luarocks.org/modules/dougcurrie/lsqlite3) for the 5.1, 5.3 and 5.4 lua versions. I also tried to symlink the files in $HOME/.luarocks/lib/lua/{version}/lsqlite3.so to the project directory 3. I tried also setting the relevant lua paths with `eval $(luarocks path)`. The compilation always fails with an error that context can't locate the sqlite3 library. How can I load data from sqlite database during context compilation? As an MWE, I am adding the example in the documentation for the interaction with sqlite from the context garden (https://www.pragma-ade.nl/general/manuals/sql-mkiv.pdf): ```tex \starttext \startluacode require("util-sql") utilities.sql.setmethod("sqlite") require("util-sql-loggers") local loggers = utilities.sql.loggers local presets = { -- method = "sqlite", database = "loggertest", datatable = "loggers", id = "loggers", } os.remove("loggertest.db") -- start fresh local db = loggers.createdb(presets) loggers.save(db, { -- variant 1: data subtable type = "error", action = "process", data = { filename = "test-1", message = "whatever a" } } ) loggers.save(db, { -- variant 2: flat table type = "warning", action = "process", filename = "test-2", message = "whatever b" } ) local result = loggers.collect(db, { start = { day = 1, month = 1, year = 2016, }, stop = { day = 31, month = 12, year = 2116, }, limit = 1000000, -- type = "error", action = "process" }) context.starttabulate { "||||||" } for i=1,#result do local r = result[i] context.NC() context(r.time) context.NC() context(r.type) context.NC() context(r.action) if r.data then context.NC() context(r.data.filename) context.NC() context(r.data.message) else context.NC() context.NC() end context.NC() context.NR() end context.stoptabulate() -- local result = loggers.cleanup(db, { -- before = { -- day = 1, -- month = 1, -- year = 2117, -- }, -- }) \stopluacode \stoptext ``` I am sorry for the poor quality of the example, but I don't know how to add an attachment to a message in a mailing list. I have found a few references on the web and on this mailing list (https://mailman.ntg.nl/archives/list/ntg-context@ntg.nl/message/IDZBJQIXG3JIG5O5CNUNXUIPGR4UFTWE/), but I wasn't able to figure out what I could be doing wrong. I found a reference that the issue might be a version mismatch, so I tested multiple lua versions. My project is about using multiple data sources in multiple formats and creating reports from them. I know I will definitely need to load YAML as well (with the `lyaml` luarocks package I guess). There's always the alternative of trying to use other programs to get the data, but I was wondering if I could leverage ConTeXt to do that directly. Thank you for any guidance on this, and I hope this message is not too long ... ___________________________________________________________________________________ If your question is of interest to others as well, please add an entry to the Wiki! maillist : ntg-context@ntg.nl / https://mailman.ntg.nl/mailman3/lists/ntg-context.ntg.nl webpage : https://www.pragma-ade.nl / https://context.aanhet.net (mirror) archive : https://github.com/contextgarden/context wiki : https://wiki.contextgarden.net ___________________________________________________________________________________