1. Forum
  2. Usenet
  3. COMP.LANG.MUMPS

  • YDBSyslog; Using YottaDB from Lua

    From K.S. Bhaskar@21:1/5 to All on Wed Jul 26 11:48:03 2023
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)