摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
$ 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)