corpus.blog
56,966 blogs · 4,417,066 posts Claim your blog
Record · corpus.blog/posts/01a07df4-59be-72f7-bc5a-d4f614d613cd

How do databases execute expressions?

Phil Eaton · published 21 September 2023

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at notes.eatonphil.com Wayback capture
2blogs citing
First cited
12 Sept 2023
Most recent
1 Jan 2024
Rank this month
not ranked
Links from this post
66
Words captured
2,231

Cited by

Blog
In the post
Date
poorlydefinedbehaviour.github.io
Reading list 2023 Read at the source ↗
1 Jan 2024
poorlydefinedbehaviour.github.io
Reading list September 2023 Read at the source ↗
1 Oct 2023
noghartt.dev
My reading list - September 2023 Read at the source ↗
12 Sept 2023

Links from this post

Link
Host
https://www.webkit.org/blog/189/announcing-squirrelfish/
webkit.org
https://www.infoq.com/news/2007/12/ruby-19/
infoq.com
https://stefan-marr.de/downloads/oopsla23-larose-et-al-ast-vs-bytecode-interpreters-in-the-age-of-meta-compilation.pdf
stefan-marr.de
https://www.cs.cornell.edu/~asampson/blog/flattening.html
cs.cornell.edu
https://github.com/cockroachdb/cockroach
github.com
https://github.com/cockroachdb/cockroach/blob/master/pkg/sql/sem/eval/expr.go
github.com
https://www.cockroachlabs.com/docs/stable/vectorized-execution
cockroachlabs.com
https://github.com/cockroachdb/cockroach/blob/master/pkg/sql/colexec/colexecproj/proj_non_const_ops.eg.go
github.com
https://github.com/ClickHouse/clickhouse
github.com
https://github.com/ClickHouse/ClickHouse/blob/853e3f0aa789d5b6dcb251a403276d9fdc02902c/src/Functions/IFunction.h
github.com
https://github.com/ClickHouse/ClickHouse/blob/9af9b4a08542812694f171833a7afe08f5aaaafb/src/Interpreters/ExpressionActions.h
github.com
https://presentations.clickhouse.com/meetup24/5.%20Clickhouse%20query%20execution%20pipeline%20changes/
presentations.clickhouse.com
https://github.com/ClickHouse/ClickHouse/issues/34045
github.com
JIT in ClickHouse Read at the source ↗
clickhouse.com
https://github.com/ClickHouse/ClickHouse/blob/853e3f0aa789d5b6dcb251a403276d9fdc02902c/src/Functions/if.cpp
github.com
https://github.com/ClickHouse/ClickHouse/blob/master/src/Columns/ColumnFunction.cpp
github.com
https://twitter.com/ClickHouseDB/status/1705619463888900538
twitter.com
https://clickhousedb.slack.com/archives/CUDSPUJ68/p1695307656700889
clickhousedb.slack.com
https://github.com/duckdb/duckdb
github.com
https://github.com/duckdb/duckdb/blob/479c89e154f32012143d741c1a4f4d769f20044e/src/execution/expression_executor/execute_function.cpp
github.com
https://duckdb.org/internals/vector.html
duckdb.org
https://www.infoq.com/articles/analytical-data-management-duckdb/
infoq.com
https://github.com/influxdata/influxdb
github.com
https://github.com/influxdata/influxdb/blob/b3b982d746fdc34451ca44d262f83b483cd9ea33/storage/reads/influxql_eval.go
github.com
https://github.com/influxdata/flux
github.com
https://github.com/influxdata/flux/blob/master/docs/VirtualMachine.md
github.com
https://github.com/influxdata/flux/blob/master/interpreter/interpreter.go
github.com
https://www.influxdata.com/blog/the-plan-for-influxdb-3-0-open-source/
influxdata.com
https://github.com/MariaDB/server
github.com
https://github.com/mysql/mysql-server
github.com
https://github.com/MariaDB/server/blob/e9573c059656d9477c2176f102f7e79d0f1ca6b0/sql/item_cmpfunc.cc
github.com
https://github.com/MariaDB/server/blob/e9573c059656d9477c2176f102f7e79d0f1ca6b0/sql/item_func.cc
github.com
https://github.com/MariaDB/server/blob/e9573c059656d9477c2176f102f7e79d0f1ca6b0/sql/sp_instr.cc
github.com
https://dev.mysql.com/doc/dev/mysql-server/latest/stored_programs.html
dev.mysql.com
https://github.com/mongodb/mongo
github.com
Inside New Query Engine of MongoDB Read at the source ↗
laplab.me
https://github.com/mongodb/mongo/blob/master/src/mongo/db/exec/sbe/vm/vm.cpp
github.com
https://github.com/mongodb/mongo/blob/master/src/mongo/db/query/README.md
github.com
https://www.mongodb.com/docs/manual/reference/sbe/
mongodb.com
https://github.com/postgres/postgres/blob/cca97ce6a6653df7f4ec71ecd54944cc9a6c4c16/src/backend/executor/execExprInterp.c
github.com
https://github.com/postgres/postgres/blob/master/src/backend/jit/README
github.com
https://github.com/postgres/postgres/blob/cca97ce6a6653df7f4ec71ecd54944cc9a6c4c16/src/backend/executor/execExpr.c
github.com
https://github.com/questdb/questdb
github.com
https://questdb.io/blog/2022/01/12/jit-sql-compiler/
questdb.io
https://github.com/questdb/questdb/blob/11ac85510292596f0d21b10603e500f8edb5e486/core/src/main/java/io/questdb/griffin/SqlCodeGenerator.java
github.com
https://github.com/questdb/questdb/blob/11ac85510292596f0d21b10603e500f8edb5e486/core/src/main/java/io/questdb/griffin/engine/functions/bool/AndFunctionFactory.java
github.com
https://github.com/questdb/questdb/blob/11ac85510292596f0d21b10603e500f8edb5e486/core/src/main/java/io/questdb/griffin/engine/functions/BooleanFunction.java
github.com
https://github.com/scylladb/scylladb
github.com
https://github.com/scylladb/scylladb/blob/08197882074227edbd0a95f49914913e3124753d/cql3/expr/expression.cc
github.com
https://github.com/sqlite/sqlite
github.com
https://www.sqlite.org/opcode.html
sqlite.org
https://github.com/sqlite/sqlite/blob/8aaf63c6ac8b8292c0ecead0d2b04b68e9e6be78/src/vdbe.c
github.com
https://www.youtube.com/watch?v=_vloWsdPCDs&t=3810s
youtube.com
https://docs.singlestore.com/cloud/query-data/advanced-query-topics/code-generation/
docs.singlestore.com
https://github.com/pingcap/tidb
github.com
https://www.pingcap.com/blog/10x-performance-improvement-for-expression-evaluation-made-possible-by-vectorized-execution/
pingcap.com
https://github.com/pingcap/tidb/blob/3ccd09e63addddeb0d33b5b87594a2d61fffd1d8/expression/builtin_control.go
github.com
https://github.com/pingcap/tidb/blob/3ccd09e63addddeb0d33b5b87594a2d61fffd1d8/expression/builtin_control_vec_generated.go
github.com
https://duckdb.org/why_duckdb.html
duckdb.org
https://www.vldb.org/pvldb/vol11/p2209-kersten.pdf
vldb.org
https://webkit.org/blog/9329/a-new-bytecode-format-for-javascriptcore/
webkit.org
https://v8.dev/blog/sparkplug
v8.dev
https://eatonphil.com/discord.html
eatonphil.com
https://t.co/nmhe9HmYw7
t.co
https://twitter.com/eatonphil/status/1704936432412868725?ref_src=twsrc%5Etfw
twitter.com
https://t.co/BIGtHKh1X4
t.co