[DGD] Two things

[bart at wotf.org]

On Tue, 21 Jul 2015 04:35:38 -0500, Blain wrote

> Everyone:  How is everyone?  Is anyone working on any exciting DGD projects?
> 

No idea if its exciting, but I'm having a lot of fun with an rdbm in lpc,
including an sql parser and interpreter.

It advanced enough by now that many of the typical 'unsanitized user input'
exploits for sql also work :-)

Writing an interpreter in LPC was kinda fun, the parser a bit less so. 

Anyway, having something similar to javadb but running on dgd turns out to be
useful.

Below is an example from a command called showlog, which (obviously) shows log
data, but uses the sql interpreter and rdbm interface for storing, retrieving
and filtering that data:

[Aidil at BR]channeldb:/sys/obj> [Aidil at BR]channeldb:/sys/obj> showlog
--oldest=24h -s arguments runtime
[SHOWLOG]: query: select log,sec,level,message from syslog where log =
'runtime' and sec >= 1438024636 and
    message like '%arguments%';
[SHOWLOG]: 1 messages.
Showing log entries for 'runtime' since Mon Jul 27 21:17:16 2015
Jul 27 23:40:39 [runtime:1] Insufficient arguments for function select
Object: /sys/cmds/admin/emaillist, program: /sys/cmds/admin/emaillist, line 21
 210 receive_message   /sys/obj/user (#13516)
 205 _receive_message  /sys/obj/user (#13516)
 126 receive_message   /sys/lib/libsh (/sys/obj/shell/sqsh#13517)
 156 command           /sys/lib/modules/m_cmds (/sys/obj/shell/sqsh#13517)
 141 exec_command      /sys/daemons/command_d
  14 _main             /sys/lib/modules/m_command (/sys/cmds/admin/emaillist)
  32 main              /sys/cmds/admin/emaillist
  17 unguarded         /kernel/lib/auto (/sys/cmds/admin/emaillist)
  21 do_list_email     /sys/cmds/admin/emaillist

[Aidil at BR]channeldb:/sys/obj>

(and yes, the lib this runs on is related to Gurbalib (or actually, uses a
modified version of Gurbalib's kernel and some bits of /sys) as may be obvious
from the runtime trace to those familiar with that lib.

Anyway, its good fun and a good distraction from some things from which I need
some distraction :-)

Oh, the code is currently not public, this started out as an accident really..
It has a lot of rough edges still and without a bit of cleanup its probably
not easy to follow.

Bart.
--
http://www.flickr.com/photos/mrobjective/
http://www.om-d.org/