Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

It is surely a great calamity for a human being to have no obsessions. -- Robert Bly

devel / comp.lang.mumps / YDBSyslog; Using YottaDB from Lua

SubjectAuthor
o YDBSyslog; Using YottaDB from LuaK.S. Bhaskar

1
YDBSyslog; Using YottaDB from Lua

<7a4e46b8-dac8-47a5-9140-03c407620a86n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=549&group=comp.lang.mumps#549

  copy link   Newsgroups: comp.lang.mumps
X-Received: by 2002:a37:b4c7:0:b0:763:ce7e:f280 with SMTP id d190-20020a37b4c7000000b00763ce7ef280mr7362qkf.11.1690397284329;
Wed, 26 Jul 2023 11:48:04 -0700 (PDT)
X-Received: by 2002:a05:6808:2010:b0:3a3:7eca:3022 with SMTP id
q16-20020a056808201000b003a37eca3022mr496704oiw.2.1690397284023; Wed, 26 Jul
2023 11:48:04 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.mumps
Date: Wed, 26 Jul 2023 11:48:03 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=71.162.243.192; posting-account=zTPg1AoAAABx_LtAQ3dW6FBnU1dwmSvl
NNTP-Posting-Host: 71.162.243.192
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <7a4e46b8-dac8-47a5-9140-03c407620a86n@googlegroups.com>
Subject: YDBSyslog; Using YottaDB from Lua
From: ksbhaskar@gmail.com (K.S. Bhaskar)
Injection-Date: Wed, 26 Jul 2023 18:48:04 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 5156
 by: K.S. Bhaskar - Wed, 26 Jul 2023 18:48 UTC

Two recent items of interest are YDBSyslog and significant updates to using YottaDB from Lua.

YDBSyslog is a YottaDB plugin that uses journalctl to export syslog records and load them into a database. You can also run it as a daemon that follows the syslog and loads records in real-time. It produces an Octo DDL, which then allows you to run SQL queries on syslog records. By combining the data from multiple systems in a single database, you can run queries across systems. The README at https://gitlab.com/YottaDB/Util/YDBSyslog/ tells you what you need to know to get started. We will also document YDBSyslog in the Plugins manual (https://docs.yottadb.com/Plugins/). For example:

OCTO> select "_HOSTNAME", "_UID", "MESSAGE" from SYSLOG_DATA where "_COMM" = 'mupip' and ( "_UID" = 349 or "_UID" = 752 ) and "MESSAGE" like '%DBFILEXT%' limit 10;
_HOSTNAME|_UID|MESSAGE
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/nars/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000001F5 blocks to 0x000000000000025A at transaction 0x04000000000001E9 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x000000000000025A blocks to 0x00000000000002BE at transaction 0x040000000000024C -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000002BE blocks to 0x0000000000000322 at transaction 0x04000000000002B0 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x0000000000000322 blocks to 0x0000000000000386 at transaction 0x0400000000000313 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x0000000000000386 blocks to 0x00000000000003EA at transaction 0x0400000000000377 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000003EA blocks to 0x000000000000044F at transaction 0x04000000000003DA -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x000000000000044F blocks to 0x00000000000004B3 at transaction 0x040000000000043E -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x00000000000004B3 blocks to 0x0000000000000517 at transaction 0x04000000000004A1 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x0000000000000517 blocks to 0x000000000000057B at transaction 0x0400000000000505 -- generated from 0x00007F81088A5EC7.
trappist|349|%YDB-I-DBFILEXT, Database file /extra3/testarea3/usr1/V998/tst_V998_R139_dbg_17_230717_165721/tp_1_21/per/mumps.dat extended from 0x000000000000057B blocks to 0x00000000000005DF at transaction 0x0400000000000568 -- generated from 0x00007F81088A5EC7.
(10 rows)
OCTO>

Following up the recent guest blog post by Berwyn Hoyt on speeding up lua-yottadb, the Programming in Lua documentation (https://docs.yottadb.com/MultiLangProgGuide/luaprogram.html) has been significantly updated with new content. We would like to thank Berwyn for his contributions, and the University of Antwerp Library for sponsoring his work.

Regards
– Bhaskar

--
YottaDB - Rock solid. Lightning fast. Secure. Pick any three.

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor