3 ms·
> I suppose using functions defined by the host with SQLite is cheaper than using similarly defined functions in databases that are separated by a network. “In
by masklinn 2y ago
> I suppose using functions defined by the host with SQLite is cheaper than using similarly defined functions in databases that are separated by a network.
“Infeasible” is very fast. sqlite runs in process so you can register a function pointer or five, with a trampoline back into the runtime.
Can’t do that over the network, you can create functions but only using the database’s procedural langage(s in the case of Postgres).
- anarazel 2y agoFWIW, the set of procedural languages in postgres is runtime extensible: https://www.postgresql.org/docs/current/sql-createlanguage.html https://www.postgresql.org/docs/current/sql-createlanguage.h...