自我学习极客时间《Android开发高手课》的笔记总结
文中链接:
微信的WCDB
https://github.com/Tencent/wcdb
Matrix的SQLiteLint
https://github.com/Tencent/matrix/tree/master/matrix/matrix-android/matrix-sqlite-lint
Cursor实现优化
https://mp.weixin.qq.com/s?__biz=MzAwNDY1ODY2OQ==&mid=2649286603&idx=1&sn=d243dd27f2c6614631241cd00570e853&chksm=8334c349b4434a5fd81809d656bfad6072f075d098cb5663a85823e94fc2363edd28758ab882&mpshare=1&scene=1&srcid=0609GLAeaGGmI4zCHTc2U9ZX#rd
Android WCDB 使用 Room ORM 与数据绑定
https://github.com/Tencent/wcdb/wiki/Android-WCDB-%E4%BD%BF%E7%94%A8-Room-ORM-%E4%B8%8E%E6%95%B0%E6%8D%AE%E7%BB%91%E5%AE%9A
SQLite locking
https://www.sqlite.org/lockingv3.html
SQLite锁机制简介
https://huili.github.io/lockandimplement/machining.html
SQLite封锁机制
https://www.cnblogs.com/cchust/p/4761814.html
微信iOS SQLite源码优化实践
https://mp.weixin.qq.com/s/8FjDqPtXWWqOInsiV79Chg
sqlite索引的原理
https://www.cnblogs.com/huahuahu/p/sqlite-suo-yin-de-yuan-li-ji-ying-yong.html
MySQL索引背后的数据结构及算法原理
https://blog.codinglabs.org/articles/theory-of-mysql-index.html
How To Corrupt An SQLite Database File
https://sqlite.org/howtocorrupt.html
微信 SQLite 数据库修复实践
https://mp.weixin.qq.com/s/N1tuHTyg3xVfbaSd4du-tw
微信移动端数据库组件WCDB系列(二) — 数据库修复三板斧
https://mp.weixin.qq.com/s/Ln7kNOn3zx589ACmn5ESQA
Android数据库修复
https://github.com/Tencent/wcdb/wiki/Android%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BF%AE%E5%A4%8D
微信移动数据库组件WCDB(四) — Android 特性篇
https://mp.weixin.qq.com/s/NFnYEXSxAaHBqpi7WofSPQ
SQLite FTS3 and FTS4 Extensions
https://sqlite.org/fts3.html
微信全文搜索优化之路
https://mp.weixin.qq.com/s/AhYECT3HVyn1ikB0YQ-UVg
移动客户端多音字搜索
https://mp.weixin.qq.com/s/GCznwCtjJ2XUszyMcbNz8Q
Matrix SQLiteLint -- SQLite 使用质量检测
https://mp.weixin.qq.com/s/laUgOmAcMiZIOfM2sWrQgw
SQL解析在美团的应用
https://tech.meituan.com/2018/05/20/sql-parser-used-in-mtdp.html
美团点评SQL优化工具SQLAdvisor开源
https://tech.meituan.com/2017/03/09/sqladvisor-pr.html