Daily Edition · Page 4

THE DAILY INDEX

Technology, AI, software, security, crypto and business

ARTICLES & TUTORIALS

TLDR Dev

100,000 TPS OVER A BILLION ROWS: THE UNREASONABLE EFFECTIVENESS OF SQLITE

SQLite's embedded nature and single-writer limitation are usually seen as drawbacks, but are actually important to its scalability. By removing network latency and enabling batching, SQLite can achieve much higher transactions per second (TPS) compared to networked databases like Postgres, especially when dealing with power-law distributed workloads and interactive transactions. This is shown by benchmarks of SQLite reaching over 100,000 TPS even with concurrent reads, while Postgres is much worse with added network latency.

CAN WE BUILD WECHAT MINI APPS USING OPEN WEB STANDARDS?

WeChat is ubiquitous in China. The app allows users to access a wide variety of services, including food delivery, ride hailing, and bike rentals, without leaving the app. WeChat Mini apps prove that it's sometimes a better customer experience to just scan a QR code rather than using a native app. This article looks at how to create a WeChat Mini app experience outside of WeChat using regular QR codes and open web standards.

TLDR IndexPage 4