I’ve had great success with ClickHouse on a 4GB RAM server (shared with other things, full load) but not so on my small server with only 2GB RAM and 2GB swap. I’m having some trouble lately with running ClickHouse, along with 5 or so other services like Kafka, Zookeeper, two python backends and a Node/Svelte…
Category: Development
Open Source & Paid Alternatives to Firebase Dynamic Links
Dynamic deep links hosted by Google Firebase are on their way out, so it’s time to look for the alternatives. I’ll cover the few open source projects I’ve seen as well as the top paid options. Open Source & Free Really, all this work just to provide a link to your app? Yeah, it’s really…
GitHub Large File Storage (git lfs) is basically paid only
2 GB Maximum file size sounds great for GitHub LFS. When I saw that I thought, perfect, it’s small but it’ll do. Time to push! “Git LFS disabled for ddxv” Wait what? Git LFS has been disabled on your personal account ddxv because you’ve exceeded your data plan by at least 150%. Please purchase additional…
How to get Geo Location Info for IP Addresses
Just want to cover the recent steps I took in learning about how to get Geo Location information for OpenAttribution. The first step I took was to look into two existing open source analytics platforms that are alternatives to Google Analytics: Umami and Matomo. Umami I love using umami.is! It’s definitely the smaller of the…
WIP: Sharing the Monetization channels for mobile apps
For a week or two I’ve been working on updating the appgoblin.info top ad networks and MMPs. Currently both are still up, which should change but I’ll give an overview of the process of changing and what might be next up. Goal: Display the top clients I’ve long wanted to have a way to view…
Svelte 5 Data Table Comparisons
While working on a new analytics dashboard I wanted to find a good table tool manage my table like data from the backend. My main goal is to have dynamic group by for the table’s dimensions. While this has been something that I’ve always liked about Python based backends, it definitely wasn’t something I found…
Is this a TikTok security vulnerablity for ad fraud?
I de-compiled TikTok (“com.zhiliaoapp.musically” v33.3.3 from Feb 2nd, 2024) from ApkPure.net and noticed that the way it called AppsFlyer looked a bit different than what I expected and quickly led me to a GitHub issue which makes it seem like they are using an outdated way to collect install information from Google Play which may…
Before You Agree: What data does TikTok collect before Terms of Service?
Would you like to see what data is coming out of TikTok when you first open it up? Let’s get to it. Didn’t this used to be easy to do? As security for iPhones and Androids increased it continually made viewing the traffic leaving your own device more difficult. This is in stark contrast to…
ClickHouse: Refreshing Take on Materialized Views
Working on my Open Source MMP I have been seeing how much of it will work with ClickHouse. Unfortunately combining multiple streaming data sources in ClickHouse was proving difficult as data would semi randomly not join correctly. This led to a potential fix by using the very recent ClickHouse refreshable materialized views. These refreshable views…
Stay up to date with the latest tech new with Hacker News Widget & App
Hacker News is one of my go to sites to read the best takes on the latest tech news. Probably the reason I keep going back to it is the honest discussions and supportive community. But you probably already know this, since Hacker News is one of the most popular tech news sources out there….