Dec 2021 Digest | Go的七个代码模式, Postgres作为pubsub服务器, IPv6, 图灵完备 golang network postgres 2021-12-20 map[string]struct{}; IPv4 → IPv6: ARP → NDP, 4bytes → 16bytes; Event Loop: Wait call stack to be clear.
Dec 2021 Digest | postSQL索引最佳实践, solo开发者的营销 postgres db marketing 2021-12-19 数据量过滤很少的情况,index并不会有太大帮助 / pre-sort; 幂等性:Idempotence; Getting over the fear of exposure
Nov 2021 Digest | 怯场的科学, 接口函数与Go的优雅, 鲜为人知的PostgreSQL功能 database postgres golang biohacking 2021-11-12 在高压力下,大脑倾向于关闭涉及创造力、沉思、计划和抽象思维的皮质网络。Functional Interfaces (函数接口) → types and methods are orthogonal (decoupled) to one another 类型与方法正交(解藕); Upsert;
Nov 2021 Digest | Notion Posgres分片的经验教训, web图像优化:markup optimization postgres database 2021-11-12 Migrating to shards: Double-write. 图像优化:Dimention, Format, Quality, Markup
Jul 2021 Digest | 楔子:产品启动, postgres JSON, 如何写好文档, ex-Googler's tool postgres startup dev-tools 2021-07-26 Those that run and those that don't. Tackle big challenges: write down 20 ideas.
Jan 2017 Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads sql database performance 2017-01-09 Anastasia Raspopina and Sveta Smirnova | January 6, 2017 | Posted In: Benchmarks, InnoDB, MySQL, open source databases, OpenSource Databases on big machines, Percona Live