{"topic":{"id":14824,"title":"建一个数据库学习交流楼","slug":"topic","userId":812,"categoryId":54,"createdAt":"2025-06-27 05:14:54.014776","bumpedAt":"2025-06-27 11:47:27.584901","views":310,"postsCount":5,"highestPostNumber":5,"likeCount":5,"closed":false,"pinned":false,"pinnedGlobally":false,"pinnedAt":null,"pinnedUntil":null,"isBanner":false,"excerpt":"最近深入去了解 MySQL 之后，发现上周是 11472 号 bug 的 20 周岁生日，一想到数据库实验给老师提的建议是允许使用 MySQL 同时保留触发器实验，感觉还是太 Naive 了。所以 MySQL 依然被普遍使用只是历史惯性而不是它足够优秀吗？各位又有哪些数据库学习方面的经验与趣闻呢？","deletedAt":null,"isAnonymous":false,"isPrivate":false,"isMembersOnly":false,"category":{"id":54,"name":"学术专区","slug":"academic","color":"9EB83B"},"author":{"id":812,"username":"Ecoli","name":null,"avatarUrl":"/uploads/image/6c/84/6c843b7f0f0ffff1f5a680a16522e16068085c4fea19d1c651c8512a26b92c7e.avif"},"realAuthor":{"id":812,"username":"Ecoli","name":null,"avatarUrl":"/uploads/image/6c/84/6c843b7f0f0ffff1f5a680a16522e16068085c4fea19d1c651c8512a26b92c7e.avif"},"tags":[]},"posts":[{"id":58416,"postNumber":1,"raw":"最近深入去了解 MySQL 之后，发现上周是 11472 号 bug 的 20 周岁生日，一想到数据库实验给老师提的建议是允许使用 MySQL 同时保留触发器实验，感觉还是太 Naive 了。\n\n所以 MySQL 依然被普遍使用只是历史惯性而不是它足够优秀吗？各位又有哪些数据库学习方面的经验与趣闻呢？","cooked":"

最近深入去了解 MySQL 之后，发现上周是 11472 号 bug 的 20 周岁生日，一想到数据库实验给老师提的建议是允许使用 MySQL 同时保留触发器实验，感觉还是太 Naive 了。

所以 MySQL 依然被普遍使用只是历史惯性而不是它足够优秀吗？各位又有哪些数据库学习方面的经验与趣闻呢？

\n","createdAt":"2025-06-27 05:14:54.09407","updatedAt":"2025-06-27 05:14:54.09407","replyToPostNumber":null,"replyCount":0,"likeCount":2,"wordCount":112,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":2,"users":[{"id":7014,"username":"兴庆宫第一迷路幽灵","name":"post deleted by author"},{"id":7550,"username":"sumire","name":"アイラちゃん"}],"hasReacted":false}],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":812,"username":"Ecoli","name":null,"avatarUrl":"/uploads/image/6c/84/6c843b7f0f0ffff1f5a680a16522e16068085c4fea19d1c651c8512a26b92c7e.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":58421,"postNumber":2,"raw":"mysql mariadb percona 分裂的太乱\n\n有公司用 PostgreSQL 替换 Oracle","cooked":"

mysql mariadb percona 分裂的太乱

有公司用 PostgreSQL 替换 Oracle

\n","createdAt":"2025-06-27 05:55:26.353279","updatedAt":"2025-06-27 05:55:26.353279","replyToPostNumber":null,"replyCount":0,"likeCount":1,"wordCount":16,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":1,"users":[{"id":4148,"username":"sad-dharma-vipralopa","name":"Echo est ubi sum"}],"hasReacted":false}],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":4668,"username":"IO","name":null,"avatarUrl":null,"admin":true,"moderator":false,"signatureRaw":"","signatureCooked":null}},{"id":58425,"postNumber":3,"raw":"感觉这两年 NoSQL 的热度比前几年低了\n可能在某些分布式场景下关系型还是很有优势","cooked":"

感觉这两年 NoSQL 的热度比前几年低了
\n可能在某些分布式场景下关系型还是很有优势

\n","createdAt":"2025-06-27 06:21:59.429441","updatedAt":"2025-06-27 06:21:59.429441","replyToPostNumber":null,"replyCount":0,"likeCount":0,"wordCount":35,"liked":false,"bookmarked":false,"polls":[],"reactions":[],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":2877,"username":"Zerick","name":null,"avatarUrl":"/uploads/image/a7/a3/a7a3f86ac04b30a3177766813966fa48ce68b0e1cc009a8d274e34ab13a43ce9.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":58462,"postNumber":4,"raw":"https://www.bilibili.com/video/BV1M1Koz6EW1","cooked":"","createdAt":"2025-06-27 11:30:27.427271","updatedAt":"2025-06-27 11:30:27.427271","replyToPostNumber":null,"replyCount":0,"likeCount":0,"wordCount":1,"liked":false,"bookmarked":false,"polls":[],"reactions":[],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":4668,"username":"IO","name":null,"avatarUrl":null,"admin":true,"moderator":false,"signatureRaw":"","signatureCooked":null}},{"id":58464,"postNumber":5,"raw":"可以关注一下 snowflake 和 rocksdb，还有 Tidb，这三个都有分布式数据库的贡献\n我数据库学的不好，打算等到大四闲的时候再认真学一学，也只会了部分数据库的知识，对于 levelDB 也只是简单地看了一点点代码","cooked":"

可以关注一下 snowflake 和 rocksdb，还有 Tidb，这三个都有分布式数据库的贡献
\n我数据库学的不好，打算等到大四闲的时候再认真学一学，也只会了部分数据库的知识，对于 levelDB 也只是简单地看了一点点代码

\n","createdAt":"2025-06-27 11:47:27.584901","updatedAt":"2025-06-27 11:50:16.535188","replyToPostNumber":null,"replyCount":0,"likeCount":2,"wordCount":81,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":2,"users":[{"id":1628,"username":"Lorange","name":"主治医师李大华"},{"id":7014,"username":"兴庆宫第一迷路幽灵","name":"post deleted by author"}],"hasReacted":false}],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":7550,"username":"sumire","name":"アイラちゃん","avatarUrl":"/uploads/image/7a/48/7a483b9b45d50681361e6da6c04657d008e906eb104592b0e7b421c1e4e1a9ad.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}}],"hasMore":false,"lastReadPostNumber":2,"hasUrlPostNumber":true}