LLM vs SQLite
For anyone using AI tools, here is something for you to try. Imagine you have SQLite database with a following schema & data: create table addresses (ipv4 blob not null); insert into addresses (ipv4) values (x'c0ae1337'); The task is pretty simple: Return IP v4 address in a human readable format. Answers: IP v4 address in a dotted-decimal format 192.174.19.55 SQL query https://sqlite.org/json1.html#jptr select printf('%s.%s.%s.%s', '0x'||substr(hex(ipv4), 1, 2) ->>'$', '0x'||substr(hex(ipv4), 3, 2) ->>'$', '0x'||substr(hex(ipv4), 5, 2) ->>'$', '0x'||substr(hex(ipv4), 7, 2) ->>'$' ) as ipv4 from addresses; ...