ZhangZhihui's Blog  
上一页 1 ··· 31 32 33 34 35 36 37 38 39 ··· 102 下一页

2024年12月9日

摘要: CTEs (Common Table Expressions): Not materialized, because it is used only once. Explicitly creating the CTE as not materialized looks having better p 阅读全文
posted @ 2024-12-09 08:07 ZhangZhihuiAAA 阅读(8) 评论(0) 推荐(0)

2024年12月8日

摘要: Cross join: Cross join is the default for an unqualified join. chr() Grouping: any_value() array_agg() json_agg(), jsonb_agg() bool_and() bool_or() fi 阅读全文
posted @ 2024-12-08 18:57 ZhangZhihuiAAA 阅读(10) 评论(0) 推荐(0)
 
摘要: Inner join is the default join. Outter join has three categories: left join, right join and full join. starts_with() Lateral join: lateral Lateral joi 阅读全文
posted @ 2024-12-08 10:13 ZhangZhihuiAAA 阅读(13) 评论(0) 推荐(0)

2024年12月6日

摘要: Introduction In this article, we are going to see how Index Selectivity works in relational database systems and why the database Optimizer might choo 阅读全文
posted @ 2024-12-06 10:06 ZhangZhihuiAAA 阅读(35) 评论(0) 推荐(0)

2024年12月5日

摘要: ctid What data type should you use for your primary keys? Integers or UUIDs? In 98% of use cases, you should favor integer types. When we are over int 阅读全文
posted @ 2024-12-05 22:33 ZhangZhihuiAAA 阅读(9) 评论(0) 推荐(0)

2024年12月4日

摘要: inet The essential difference between inet and cidr data types is that inet accepts values with nonzero bits to the right of the netmask, whereas cidr 阅读全文
posted @ 2024-12-04 09:20 ZhangZhihuiAAA 阅读(16) 评论(0) 推荐(0)

2024年12月2日

摘要: Fraction is precise, but slow. Floating point is fast, but imprecise. Two floating point: types real (float4) and double precision (float8). Domain is 阅读全文
posted @ 2024-12-02 18:24 ZhangZhihuiAAA 阅读(19) 评论(0) 推荐(0)

2024年11月29日

摘要: zzh@ZZHPC:/zdata/Github/greenlight$ go install honnef.co/go/tools/cmd/staticcheck no required module provides package honnef.co/go/tools/cmd/staticche 阅读全文
posted @ 2024-11-29 18:49 ZhangZhihuiAAA 阅读(18) 评论(0) 推荐(0)
 
摘要: Makefile: ## help: print this help message help: @echo 'Usage:' @sed -n 's/^##//p' ${MAKEFILE_LIST} | column -t -s ':' | sed -e 's/^/ /' confirm: @ech 阅读全文
posted @ 2024-11-29 17:58 ZhangZhihuiAAA 阅读(11) 评论(0) 推荐(0)
 
摘要: $ make migration name=create_example_table run: go run ./cmd/api psql: psql ${GREENLIGHT_DB_DSN} migration: @echo 'Creating migration files for ${name 阅读全文
posted @ 2024-11-29 17:02 ZhangZhihuiAAA 阅读(10) 评论(0) 推荐(0)
上一页 1 ··· 31 32 33 34 35 36 37 38 39 ··· 102 下一页