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…
Author: James O'Claire
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…
AppGoblin New Features, Mobile Stats and Breakdowns
Theme & Svelte updates First off, new theme courtesy of the upcoming v3 for skeleton.dev, a great UI library for Svelte. The new Skeleton v3 is pretty awesome and was quite easy to update along with moving from Svelte 4 to 5. Svelte 5 was a bit trickier with all the new runes, but overall…
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…
What does DIRECT mean for App-Ads.txt?
Recently I started working on a project on appgoblin to estimate the number of client apps for all mobile advertising and data collection companies. In doing this there are currently two sources of data: decompiled SDKs of which I have only done ~20k apps and app-ads.txt which I have scraped closer to ~200k apps’ app-ads.txt…
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…
How to figure out which 3rd Parties might be integrated with an iOS App?
In the past couple months I built out scraping for Android apps which downloads, decompiles, scrapes the `AndroidManifest.xml` then analyzes the Android app for known 3rd party ad networks or trackers. I enjoyed this a lot, but the other half of the equation, iOS remained elusive. I was surprised how much more difficult this turned…
See which MMPs and Networks Apps and Games are Using
I recently added a free feature to AppGoblin to see which advertising/monetization ad networks and MMP partners apps are using. You can break down the results by category and and group by parent companies. The data is pulled from the top ~10k Android apps, which I downloaded, de-compiled and examined their AndroidManifest.xml to determine which…