Hacker News new | ask | show | jobs
by yencabulator 881 days ago
It's still so weird to me that SQLite returns it's internal format to callers.

    create table foo (bar);
    insert into foo (bar) values ('{"answers": [42]}');
    select jsonb_extract(bar, '$.answers') from foo;

    ;#42