| ▲ | gwbas1c a day ago | |
Question: How easy / hard is it to replace a SQL query with a join, to a SQL query that returns a JSON object? (IE, a foreign key relationship is turned into a JSON array.) | ||
| ▲ | marcobambini a day ago | parent | next [-] | |
SQLite has built-in JSON support: https://www.sqlite.org/json1.html | ||
| ▲ | datadrivenangel a day ago | parent | prev [-] | |
As in return the relation behind the join or return the results of that as a json object? The latter is easy with SQLites JSON support. | ||