Hacker News Reader

andreashaon SQLiteStudio: Create, edit, browse SQLite databases

There's Dbvisualizer if you want to try an alternative. Though I moved from the company provided dbvis pro version to DBeaver Community when I discovered it.

andreashaon My company has banned the use of Jetbrains IDEs internally

>pipe cli output directly to VSCode in the shell and then it opens a tab displaying that output

Example from VSCode Terminal: $ echo hello | code -

andreashaon Hotel Hotspot Hijinks

Haven't tried it but sounds like it should, it already have a few shell scripts for some captive portals.

"captive portal auto-login hook (configured via uci/LuCI), you are able to reference an external script for captive portal auto-logins (see example below)"

https://github.com/openwrt/packages/blob/master/net/travelma...

It can also auto join open networks "automatically add open uplinks to your wireless config, e.g. hotel captive portals (disabled by default)"

andreashaon Hotel Hotspot Hijinks

For travel routers there’s travelmate for OpenWrt https://github.com/openwrt/packages/blob/master/net/travelma...

andreashaon OpenWrt One/AP-24.XY: new open source router board by OpenWrt and Banana Pi

Afaik it hasn’t reached OpenWrt stable yet

andreashaon OpenWRT turns 20; wants to launch their "first upstream supported" design

I'm happy with the RT3200 based on Filogic 800 but now you could get Flint 2 or BPi-R3 based on Filogic 830.

https://store-eu.gl-inet.com/en-jp/products/flint-2-gl-mt600...

andreashaon Understanding Percentiles (2021)

With the median being the same thing as p50

andreashaon Understanding Percentiles (2021)

https://webcache.googleusercontent.com/search?q=cache:k3QOar...

archive.is WIP https://archive.is/wip/vLSWG

andreashaon Tor is not just for anonymity (2022)

But not Brave apparently

andreashaon Google has a secret browser hidden inside the settings

TIL mobile JavaScript console https://eruda.liriliri.io/

andreashaon An open-source alternative to QuickBooks

Seems to be still available for "Workspace Owners/Admins and Org Owners/Admins" https://slack.com/help/articles/201658943-Export-your-worksp...

andreashaon An open-source alternative to QuickBooks

I think they retain it but you can't access it. One Slack I'm in activated the trial and everything was there and searchable.

andreashaon DIY Raspberry / Orange Pi NAS That Looks Like a NAS – 2023 Edition

You can clone it while running as well [0]. For speed make sure the adapter is USB3.0 and plugs into one of the USB3.0 ports on the pi and also that it supports UASP and enable trim on the drive [1].

[0] https://github.com/billw2/rpi-clone

[1] https://www.jeffgeerling.com/blog/2020/raspberry-pi-usb-boot...

andreashaon Germany extends lifetime of all 3 remaining nuclear plants

Well after Unipers bailout by Germany (99% ownership) and Unipers majority ownership of one nuclear power plant in Sweden (minority in the other two).

andreashaon Germany extends lifetime of all 3 remaining nuclear plants

Denmark doesn't have any and five of eight reactors on that map of south of Sweden has closed, some soon almost two decades ago.

andreashaon Why do domain names sometimes end with a dot?

Sweden https://sverigesradio.se/artikel/3164044

andreashaon Serverless DNS: Self-hosted DNS resolver at the edge

No it just tunnels your DNS traffic and traffic to the 10.6.0.* IPs. Could also add with a comma 192.168.1.0/24 for other local IPs you want to route through WG.

andreashaon Serverless DNS: Self-hosted DNS resolver at the edge

Or just don't route all traffic through your WG tunnel. Change allowed ip from 0.0.0.0/24 to the local ranges you want to reach fx 10.6.0.0/24

andreashaon Car Quality Is Slipping

https://archive.ph/alVjI

andreashaon Show HN: KittenDNS – Easy to setup, rule engine, LetsEncrypt compatible

Using pivpn with Wireguard instead of Tailscale and pihole. With on-demand split VPN on the phone with DNS pointed to pihole it resolve the remote IP set in /etc/pivpn/hosts.wireguard while on VPN otherwise just the local IP while on the home network.

andreashaon Setting Up Cloudflare Argo and Access on a Raspberry Pi

There are free DynDNS services for example DuckDNS https://www.duckdns.org/

Could also get a domain name and make a simple cron job and update your DNS. Works with many DNS registrars like Cloudflare.

andreashaon SSH alternatives for mobile, low-latency or unreliable connections

you can auto re-attach the tmux session or create new one with something like this in your bash_alias or bashrc.

# tmux auto attach or create new session [ -z "$TMUX" ] && { tmux attach || exec tmux new-session && exit;}

andreashaon Once an Addict, Always an Addict?

What's the name of the medical textbook?

andreashaon SQLBolt – Interactive lessons and exercises to learn SQL

Lesson 14.3 accepts update without any where clause (set all rows) https://sqlbolt.com/lesson/updating_rows

andreashaon SQLBolt – Interactive lessons and exercises to learn SQL

Fun tutorial! Some form of autocomplete would be nice.

andreashaon Brave Search beta

That works horribly on the results page, around 10 tabs to get to the first result.

andreashaon Brave Search beta

Tip it lacks keyboard shortcuts to navigate search results (up/down, enter).