4 ms·

I'm enjoying running a pi-hole on my local network that also has unbound running on it for resolving dns queries. Works like a charm, and it's nice and quick.

avgDev 5y ago
Pi-hole is awesome. It did give me some issues with a few streaming services that I think used google ads.
- samgranieri 5y ago
  Yeah, it borked paramount plus and I think hbo max on my apple tv. I just exempted that device and it's fine. Why'd I exempt my apple tv from the pi-hole? I don't want to screw things up when my wife or visitors are watching tv :)
  - FPGAhacker 5y ago
    > Why'd I exempt my apple tv from the pi-hole? I don't want to screw things up when my wife or visitors are watching tv :) Very wise. There are a lot of cool things I’d like to setup, but keeping things simple for guests and spouses matters.
JonathanBuchh 5y ago
I also use Pi-hole[1] and unbound[2]. You can even use tailscale[3] as a quick and easy way to use Pi-hole on all other networks through a WireGuard VPN tunnel. [1]: https://pi-hole.net https://pi-hole.net [2]: https://docs.pi-hole.net/guides/dns/unbound/ https://docs.pi-hole.net/guides/dns/unbound/ [3]: https://tailscale.com/kb/1114/pi-hole/ https://tailscale.com/kb/1114/pi-hole/
- shepherdjerred 5y ago
  Tailscale gives me some irrational sense of happiness because it *just works* and lets you do cool things like this without having to worry (too much) about security.
terrywang 5y ago
Running Pi-hole on the original Pi (1) model B for over a year and really happy with it. The original Pi running Raspbian has been very reliable and working tirelessly, the only problem is the I/O bottleneck - performance querying SQLite database is unbearable. Last Nov I spent half day installing Pi-hole on spare Pi 2 and Pi 3 (Ubuntu LTS) serving as two internal DNS Servers for home network), router (AsusWrt-Merlin) as its upstream doing DoT (DNS over HTTPS). Really happy with the performance and cost (quite, low power consumption, no heating issue, no dust collection issue, etc.)
- withinboredom 5y ago
  I'm surprised application devs haven't done this, but you can "backup" a sqlite db to an in-memory sqlite db, then just "backup" the in-memory db every so often in the background.
  - terrywang 5y ago
    The problem with running Pi-hole on the Pi 1 (original) is that it does not have enough physical memory after installing pi-hole stack (I used Nginx + php-fpm for the web UI), otherwise there is way to use utils like `vmtouch` to read the sqlite database file and keep it in page cache, even "lock" it. On Pi 2 and 3 it's no longer an issue (even if you don't do anything about it) to a memory buff and better I/O (using faster micro SD). Pi-hole provides a mechanism to backup and rotate the database from time to time, one can do that whatever way suits their use cases.
- samus 5y ago
  Does Pi-Hole also work with other SQL databases? If yes, you could host PostgreSQL on another Pi (or something beefier). Or maybe there is an adapter library that makes it possible to access another SQLite database via the network (not talking about NFS, as SQLite developers discourage from that).

avgDev 5y ago

Pi-hole is awesome. It did give me some issues with a few streaming services that I think used google ads.

samgranieri 5y ago
Yeah, it borked paramount plus and I think hbo max on my apple tv. I just exempted that device and it's fine. Why'd I exempt my apple tv from the pi-hole? I don't want to screw things up when my wife or visitors are watching tv :)
- FPGAhacker 5y ago
  > Why'd I exempt my apple tv from the pi-hole? I don't want to screw things up when my wife or visitors are watching tv :) Very wise. There are a lot of cool things I’d like to setup, but keeping things simple for guests and spouses matters.

JonathanBuchh 5y ago

I also use Pi-hole[1] and unbound[2]. You can even use tailscale[3] as a quick and easy way to use Pi-hole on all other networks through a WireGuard VPN tunnel. [1]: https://pi-hole.net https://pi-hole.net [2]: https://docs.pi-hole.net/guides/dns/unbound/ https://docs.pi-hole.net/guides/dns/unbound/ [3]: https://tailscale.com/kb/1114/pi-hole/ https://tailscale.com/kb/1114/pi-hole/

shepherdjerred 5y ago
Tailscale gives me some irrational sense of happiness because it *just works* and lets you do cool things like this without having to worry (too much) about security.

terrywang 5y ago

Running Pi-hole on the original Pi (1) model B for over a year and really happy with it. The original Pi running Raspbian has been very reliable and working tirelessly, the only problem is the I/O bottleneck - performance querying SQLite database is unbearable. Last Nov I spent half day installing Pi-hole on spare Pi 2 and Pi 3 (Ubuntu LTS) serving as two internal DNS Servers for home network), router (AsusWrt-Merlin) as its upstream doing DoT (DNS over HTTPS). Really happy with the performance and cost (quite, low power consumption, no heating issue, no dust collection issue, etc.)

withinboredom 5y ago
I'm surprised application devs haven't done this, but you can "backup" a sqlite db to an in-memory sqlite db, then just "backup" the in-memory db every so often in the background.
- terrywang 5y ago
  The problem with running Pi-hole on the Pi 1 (original) is that it does not have enough physical memory after installing pi-hole stack (I used Nginx + php-fpm for the web UI), otherwise there is way to use utils like `vmtouch` to read the sqlite database file and keep it in page cache, even "lock" it. On Pi 2 and 3 it's no longer an issue (even if you don't do anything about it) to a memory buff and better I/O (using faster micro SD). Pi-hole provides a mechanism to backup and rotate the database from time to time, one can do that whatever way suits their use cases.
samus 5y ago
Does Pi-Hole also work with other SQL databases? If yes, you could host PostgreSQL on another Pi (or something beefier). Or maybe there is an adapter library that makes it possible to access another SQLite database via the network (not talking about NFS, as SQLite developers discourage from that).