Category Archives: Open Source

Open Source-related

Perl Sample Code for Geolocation Lookups with MaxMind GeoLite2

There’s been a lot of changes with MaxMind’s GeoIP database: You must register for an account to download databases. The database format was changed from GeoIP to GeoIP2. The free databases are called GeoLite2. Older lookup APIs no longer work, … Continue reading

Posted in Open Source, Perl, Tech | Leave a comment

Meetup: New Security Features in Redis 6

Redis Labs Security Product Manager Jamie Scott talked at the Redis Meetup today about “New Security Features in Redis 6 Open Source.” Because of the Corona virus, the lecture was streamed on Youtube instead of presented to a live audience … Continue reading

Posted in Open Source, Tech, User Groups | Leave a comment

tcpdump Tips

I tend to use tcpdump when working on remote servers with multiple services running. Thus it’s important to specify exactly which hosts and ports I want to see, or end up buried in output. Here’s a canonical example of looking … Continue reading

Posted in Open Source, Tech | Leave a comment

Migrating SQLite Databases to MySQL

Recently I had to migrate a relatively simple (no FKs or views) Grafana 4 database of about 20 tables and 80,000 rows from sqlite3 to mysql5.6. Below are some notes I made on the 3 methods I tried. First up … Continue reading

Posted in MySQL, Open Source, Tech | Leave a comment

Hadoop Has No Business Model

I had a chance to talk to a Big Data sales manager 5 years ago. He said, “Hadoop is a tough sale on the East Coast. Hoping Spark will help.” Now, MapR is facing insolvency and Cloudera/Hortonworks isn’t doing great. … Continue reading

Posted in Hadoop, Java, Open Source, Tech | Leave a comment