duckdb-spongebob

A DuckDB extension that transforms text into SpongeBob mocking case.

SELECT spongebob_case('stop that right now');

┌─────────────────────┐
│       result        │
│       varchar       │
├─────────────────────┤
│ stOp tHAT RIGHT nOW │
└─────────────────────┘

Building

Requirements: Zig 0.14+, Python 3, DuckDB 1.2+

zig build build-all

Usage

LOAD 'zig-out/lib/extension.duckdb_extension';
SELECT spongebob_case('mocking spongebob squarepants text');

┌────────────────────────────────────┐
│               result               │
│              varchar               │
├────────────────────────────────────┤
│ mOcKing sPOngebOB sqUAREPants tExT │
└────────────────────────────────────┘

Note: requires -unsigned flag when running DuckDB since this isn't a signed extension:

duckdb -unsigned

How it works

The extension is written in Zig and uses the C DuckDB extension API. Each letter has a 50% chance of being upper or lower case.

• src/lib.zig - the transformation logic
• src/extension.c - registers the extension via DuckDB

Acknowledgements

Based on habedi/template-duckdb-extension-zig.

License

MIT