News for hackers. Stuff that matters.
Re:JSON and Virtual Columns in SQLite by jpcapdevila on Monday May 16, 2022 @10:21AM (#31397652)
Fair, but for objects like in the OP sample? Is there any advantage that justifies the extra steps?
Re:JSON and Virtual Columns in SQLite by zrail on Monday May 16, 2022 @10:43AM (#31398130)
I think the advantage for simple objects is just that you can refer to the columns directly vs having to go through a function. It's only really a big win if you're manually writing a lot of sql or if you're using something like Rails and you want to write queries against values in the JSON blob without going through a bunch of hoops.