Downloads 68this week

GitHub stars 0

Extension repository on GitHub

Extension descriptor (YAML)

DuckDB C extension for in-process JIT compiled C UDFs via TinyCC

Installing and Loading

INSTALL ducktinycc FROM community;
LOAD ducktinycc;

Example

-- Load the extension
LOAD ducktinycc;

-- Compile and register a simple C function as a SQL UDF
SELECT ok, mode, code
FROM tcc_module(
  mode := 'quick_compile',
  source := 'const char *hello_from_c(void){ return "hello from C"; }',
  symbol := 'hello_from_c',
  sql_name := 'hello_from_c',
  return_type := 'cstring',
  arg_types := []
);

-- Call the registered C UDF 
SELECT hello_from_c() AS msg;

About ducktinycc

DuckTinyCC compiles and registers C scalar UDFs from SQL using TinyCC (libtcc), in-process.

Main SQL entrypoints:

Compile/codegen and C-type helper modes (via tcc_module):

Generated helper naming:

Type signature support (return_type / arg_types):

SQL <-> C bridge correspondences:

Function result schemas:

Codegen/runtime model:

• wrappers are generated from return_type/arg_types and registered through ducktinycc_register_signature(…)
• wrapper_mode supports row and batch execution paths
• code is compiled + relocated in-memory (no separate shared-library artifact)

Compile/runtime assets:

• compile/quick_compile use a TinyCC runtime path (headers + libraries)
• libtcc1.a is not strictly required for every compiled function; it is needed when generated code references TinyCC runtime helper symbols
• extern/system-library bindings can work without libtcc1.a when those helper symbols are not required and libraries are resolvable

Project details and examples: https://github.com/sounkou-bioinfo/DuckTinyCC

Community package excludes WASM and Windows targets.

Added Functions