Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
-
比如在 LEFT JOIN 中过滤条件写在 ON 和 WHERE 的区别。
-
Table-value function 和 scalar-valued function 的区别.
-
char、varchar、nvarchar之间的区别(包括 …
General Tips on SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Performance
-
Avoid implicit data convertion! This might cause full table scan which hurts performance badly. For more discussions, please refer to 一条垃圾SQL，把 64 核 CPU 快 …
Extract Identifier Names from a SQL Query Using Sqlfluff
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Tips on Sqlfluff
Installation¶
Data Types in Different Programming Languages
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
| Data Type | C | C++ | Rust | Java | Python | numpy | pyarrow | Spark SQL | SQL |
|---|---|---|---|---|---|---|---|---|---|
| 8 bit integer | short (16-bit) | int8_t | i8 | short (16-bit) | int (arbitrary precision) | int8 | TinyInt … |
IDE for SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
dbeaver
The best universal IDE for (almost all versions of) database.
DataGrip
DataGrip (from JetBrains) looks like a good one
DbVisualizer
Both free and pro editions are available. Functionalities of the …