rln
install lineageOS on blueline (pixel 3)
copy of https://lineageosroms.com/blueline/ for posterity Install LineageOS on blueline Basic requirements Important: Please read through the instructions at least once before actually following them, so as to avoid any problems due to any missed steps! Make sure your computer has Read more
rln
backup/install android app from adb
search elsewhere for how to enable developer mode, and how to enable usb debugging. #then find the fullname of the app $adb shell ‘pm list packages’ |grep i foo package:com.bar.android.foo #Then find the path to the app $ adb shell Read more
rln
psql restore from pg_dump file – invalid command \N
when searching for this error ‘invalid command \N’ when trying to restore my database from a backup I made with the following: $ pg_dump -d foo -t bar > bar.psql I got lots of suggestions but what I needed was Read more
rln
postgres 12 create new cluster on different filesystem/port
pg_createcluster -d /var2/lib/postgresql/12/two -l /var/log/postgresql/postgresql-12-two.log -p 5433 12 two
rln
multiple variable looping bash
If you want to loop through something with more than one variable in bash this is your ticket to ride: #!/usr/bin/env bash while read -r x y z; do echo “$x $y $z” done <<‘_____HERE a b c 1 2 Read more
rln
julia postgres libpq update example
The Julia community seems shy about posting examples of database things… use LibPQ, Tables db=”db” server=”localhost” usr=”psql” passwd=”nope” conn = LibPQ.Connection(“host=$server dbname=$db user=$usr password=$passwd”) sql = “””select char from foo””” conn2 = LibPQ.Connection(“host=$server dbname=$db user=$usr password=$passwd”) sql2 = prepare(conn2, “””update Read more
rln
Goodbye linksys
So the last time I purchased a new wireless router – I tried to find a wireless router that had a future – something where I could replace the stock firmware once the software updates stopped coming from the manufacture. Read more
rln
julia mysql mariadb dbinterface update
https://github.com/JuliaDatabases/DBInterface.jl mariadb — mysql while doing a query on “conn”, I opended second connection “conn2”, and updated the table while stepping through the results of the first query conn = DBInterface.connect(MySQL.Connection,”localhost”,”user”,”pass”,db=”foo”) sql = “””select char from foo””” response = DBInterface.execute(conn,sql) Read more
rln
load csv into mysql
LOAD DATA LOCAL INFILE ‘/var/tmp/foo.csv’ INTO TABLE foo FIELDS TERMINATED BY ‘,’ ENCLOSED by ‘”‘ LINES TERMINATED BY ‘\n’;