Show HN: KSON Is JSON with SQL and Networking
gitlab.com
gitlab.com
{
"source": <<!https://raw.githubusercontent.com/datasets/gdp/master/data/gdp.csv>> as gdp,
"bot5GDPs": ```select \* from "$gdp"
where year in (select max(year) from "$gdp")
order by value desc
limit 5;```
}
https://media.giphy.com/media/vyTnNTrs3wqQ0UIvwE/giphy.gifIt would be better to convert the SQL request to JSON on the backend, already sorted, and return the table as just data. The raw query with variables in the string gives me bad PHP flashbacks.
If I already have a database with the necessary schema, I can just take the CSV file and populate it. What's the point of KSON in the middle?