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…
Tag: data
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…
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…
How to see traffic from your Android Device
GREEN: background processes for emulator and mitmproxy. RED: Running game (portrait but on side) with a pink banner ad at bottom. YELLOW: mitmproxy captured traffic with another example banner ad.
Is Someone Else Using Your Game’s Monetization IDs?
Looking around app-ads.txt files one of the first things I was excited to check was whether DIRECT publisher IDs show up on other unrelated apps. To do this I ignored any apps that shared the same developer contact URL or Developer IDs. This doesn’t catch 100% of the legitimate publishers I checked, as the examples…
What A Mobile Ad Monopoly Looks Like
Google’s market share in in-app advertising is unmistakably dominant. The data above was scraped from 100k+ Google Play Store & Apple App Store apps (with a slight emphasis on games) who use advertising for monetization. This public data is made possible by adoption of IAB’s app-ads.txt standard which allows buyers and sellers to cross verify…