christianchristensen

Goal: take flat tabular/structured data and process it with SQL like commands. Use case: wget/curl API data then "work on it" with SQL; low-fidelity/quick prototyping.

• https://github.com/dinedal/textql
• https://github.com/harelba/q

---

https://www.google.com/search?q=SQL+flat+text+file&aq=f&oq=SQL+flat+text+file&aqs=chrome.0.57j0l3.6639j0&sourceid=chrome&ie=UTF-8#q=SQL+with+flat+text+file&ei=uR6NUbeDKsf50gH8voG4DA&start=10&sa=N&bav=on.2,or.r_cp.r_qf.&bvm=bv.46340616,d.dmQ&fp=fbe88cae94ae6796&biw=1600&bih=814 | sql with flat text file - Google Search http://fsql.sourceforge.net/docs/php_tutorial.html | Flat-File SQL :: Documentation :: Tutorial

christianchristensen

FreeBSD Chromebook

https://wiki.freebsd.org/Chromebook

C720 (Arch wiki)

http://blog.grem.de/pages/c720.html

• D1741: Improve memory detection in biosmem.c

christianchristensen

/vendor

christianchristensen

https://eater.net -> Build an 8-bit Computer from Scratch

Create in Verilog? https://en.wikipedia.org/wiki/Verilog --> https://github.com/google/bbcpu

Run with Verilator? https://www.veripool.org/wiki/verilator

• http://www.jk-quantized.com/blog/2017/10/20/tutorial-simulating-ben-eaters-cpu
• https://github.com/JetStarBlues/BenEater_CPU
• https://github.com/XarkLabs/BenEaterVHDL

christianchristensen

Model: GFLT100 HW: 2.0 Date: Dec. 8th 2013

UART / Serial connection (pinouts next to fiber I/O, C45, C46, J5):

WG
RB

christianchristensen

http://ampl.com/try-ampl/download-a-free-demo/#linux -> http://ampl.com/demo/ampl.linux64.tgz
https://www.freebsd.org/doc/handbook/linuxemu-lbc-install.html -> 
$ uname -a
FreeBSD d630 11.1-RELEASE FreeBSD 11.1-RELEASE #0 r321309: Fri Jul 21 02:08:28 UTC 2017     root@releng2.nyi.freebsd.org:/usr/obj/usr/src/sys/GENERIC  amd64
# pkg install linux_base-c7
# kldload linux64
# kldstat
Id Refs Address            Size     Name
 1    8 0xffffffff80200000 1f67a88  kernel
 2    1 0xffffffff82221000 3c93f    linux64.ko

christianchristensen

Configuration

NOTE: ultimately configuring the device directly caused instability; I had to use the UniFi controller to provision with the option of SNMP enabled to actually get this to work...

BZ.v3.7.58# grep -i snmp /tmp/system.cfg
snmp.community=public
snmp.status=enabled

christianchristensen

FreeBSD/arm/BeagleBoneBlack

These notes pertain to booting FreeBSD on the BeagleBone Black without an eMMC chip (a.k.a. ANTMINER stripped down version)

From FreeBSD-11.0-RELEASE-arm-armv6-BEAGLEBONE.img

No output...

christianchristensen

<?xml version="1.0" encoding="UTF-8"?>
<zabbix_export>
    <version>3.2</version>
    <date>2017-02-26T04:08:53Z</date>
    <groups>
        <group>
            <name>Templates</name>
        </group>
    </groups>
    <templates>

christianchristensen

.jenkins.yml

Build configuration(s) closer to code; inspired by .travis.yml

• Default yaml file to define a build that runs make test
• Preserves No State Between Builds (runs all commands over SSH in isolated virtual machines)
• The standard Unix exit code of "0" means the build passed; everything else is treated as failure.
• Specify branches to build (whitelist, blacklist)
• Secure environment variables (keys, configuration, ...)