It is basically white-label Tiktok/Instagram native apps, but written all in web- including camera, native-like mobile feature/gestures/animations…
PWAs enable the same native full screen experience while bypassing appstore tax/rules.
For native apps, I have a React Native shell app that embeds a webview so I can create native Appstore/Googleplay binaries ready for publishing. With the new Expo CNG architecture, I can automatically create native apps binaries from console. https://apps.apple.com/us/app/copo-st/id6737266643?platform=...
You can embed apps/feeds/posts/profiles in web pages and native mobile apps(webview). So this creates a distributed social network on open web with various distribution/monetization/aggregation/commerce models.
-storing timestamp for each field (user:name) by default seems costly, timestamp can be stored on main key(e.g. user), curious on the thinking..
-is timestamp 64bit? do we need miliseconds?
-what is your sharding architecture, in terms of rage queries
-are your global search indexes on this architecture
Instantly create your Tiktok/Instagram-like app for your community or brand