Postgres has its own primitives for things that forges currently build custom infrastructure around. A trigger on the refs table firing NOTIFY means any connected client learns about a push the moment it happens, which is how forges normally end up building a custom webhook polling layer. Multi-tenant repo isolation becomes a database concern through row-level security on the objects and refs tables, and logical replication lets you selectively stream repositories across Postgres instances, a kind of partial mirroring that filesystem-based git can’t do. Commit graph traversal for ancestry queries and merge-base computation falls to recursive CTEs, and pg_trgm indexes on blob content give you substring search across all repositories without standing up a separate search index.
Loading of code
。关于这个话题，爱思助手下载最新版本提供了深入分析
（八）提供数据调用接口服务的，应当建立身份认证、权限鉴别等技术措施，采取监测发现、防范、阻断、处置违法违规调用数据的措施；，更多细节参见爱思助手下载最新版本
self.conn.close()，更多细节参见Line官方版本下载