solarpunk.moe is one of the many independent Mastodon servers you can use to participate in the fediverse.
Moé for Solarpunk is a small, friendly server run by a group of optimistically-utopian LGBT+ individuals. Registration is by invite only!

Administered by:

Community stats:

59
active punks

Michael Lucas :flan_set_fire:
Global

I tell people to never run my code. I tell people that I am not a programmer.

Exhibit 1: my SNMP agent.

cdn.mwl.io/snmp/

agent-TWP.pl - the agent
TWP.mib - the definition

Database? Nah. The data changes 3-4 times a year, if I'm lucky -- why have the overhead? Of course, why do this at all?

This will be presented at my inevitable sanity hearing.

cdn.mwl.ioIndex of /snmp
Athena L.M.

@mwl ah, excellent. this code is comically evil. if you were interested in doing sensible things, which the available evidence very strongly suggests is not the case, I would suggest a SQLite file, or merely a CSV, which could then 1) be used as backing store for the SNMP agent for backwards compatibility, and 2) simply be copied to each location where it is needed on the occasional basis that the data does change

Athena L.M.
Global

@mwl not that the SNMP agent would be made simpler by the introduction of SQLite code.

Michael Lucas :flan_set_fire:
Global

@alilly

"comically evil"? :flan_blush: :flan_aww: :flan_hearts:

Yeah, any of those things *could* be done, but it's overwhelmingly static data. :flan_shrug:

Athena L.M.
Global

@mwl My biggest objection is the column-structured storage.

Michael Lucas :flan_set_fire:
Global

@alilly

Column-structured storage? Huh.

Well, I had to get some deliberate evil in there *somewhere*.

Aaron
Global

@alilly @mwl Been 15+ years since I was last knee deep in SNMP - however I recall it being largely column oriented, at least if you wanted to read an entire table.

So IMHO storing data in columns, as grotesque as that is, makes since for this one deranged application.

Michael Lucas :flan_set_fire:
Global

@aaron @alilly

An SNMP table is not what we would think of as a table. It is a collection of columns that happen to share an index.