joewils
Joined 14 years ago
Karma
72
Submissions
32
Member since
May 16
Joe Wilson
Data Janitor
Seattle, WA
View on Hacker NewsRecent submissions
Comment · 19 days ago
Two things I do to slow down malicious bot traffic:
1. Setup a blackhole for bad bots. I don't use WordPress, but I stole the idea from this plugin: https://wordpress.org/plugins/blackhole-bad-bots/
2. Setup a Geo-IP allow list using MaxMind's country DB (https://github.com/P3TERX/GeoLite.mmdb). I only allow visitors from countries I do business with.
Comment · 2 months ago
I'll take "things you should never do" for $1000 Alex.
https://www.joelonsoftware.com/2000/04/06/things-you-should-...
Comment · 2 months ago
Same, I posted some corrections to Dr. Bauer's article: https://joecode.com/2026-08-19-sqlite3/
Comment · 3 months ago
Interesting to see the original NYTimes article title at Archive.is: https://archive.is/uYj2f
"The Kabbalah Teaching That Changed How I See A.I."
Comment · 9 months ago
Comment · 1 year ago
I've found most spam comes from bots operating from certain countries. Filtering traffic by IP address will stop a lot of spammy traffic. I've used a combination of GeoIP and IP address catagorization to limit the impact of bots on my side-projects.
Bot Protection: https://github.com/growlfm/ipcat
GeoIP Evaluation: https://dev.maxmind.com/geoip/geolite2-free-geolocation-data...
You can dig deeper using dedicated services for URL and image inspection.
Image Evaluation: https://cloud.google.com/vision/docs/detecting-safe-search
URL Evaluation: https://cloud.google.com/web-risk/docs/overview
Comment · 2 years ago
Comment · 2 years ago
Location: Seattle, WA
Remote: Yes
Willing to relocate: Yes
Technologies: Ruby, Python, SQL, HTML, CSS, Javascript
Résumé/CV: https://joecode.com/resume/
Email: [email protected]
I'm a data janitor who prefers writing boring software using boring technologies. I'm particularly good at turning piles of spreadsheets into data-driven dashboards.
Comment · 2 years ago
If print friendly reports are a requirement, I'd go with QuickChart (https://quickchart.io.)
Static charts similar to chart.js, but without all the javascript. I've found static charts are much easier to work with once print CSS layout becomes a requirement.
Comment · 2 years ago
My favorite web-based SQL editor and browser: https://www.adminer.org
Single PHP file. Super simple setup and configuration.
Comment · 2 years ago
Comment · 2 years ago
How does this library compare to Turbo/Stimulus?
Happy to see competition in the world of "minimal JS" frameworks. Have you done a comparison with Turbo/Stimulus from DHH and company?
Comment · 3 years ago
This is really clever and fun. I'm curious how the results compare to something "old school" like AWStats?
Comment · 3 years ago
https://joecode.com
Mostly links to various articles and noise I find interesting along with a photo journal of my school bus conversion project.
Not a lot of words. "Why waste time say lot word when few word do trick?"