Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Endatabas: A SQLite-inspired, SQL document database with full history. Parent comment
https://docs.endatabas.com/sql/path_navigation.html
I've just pushed a change mentioning that paths can be used in both SELECT and WHERE clauses. Sorry for the ambiguity.
For example:
`select * from stores where addresses[0].city = 'New Jersey';`
...can be used on the demo data, found here:
https://www.youtube.com/watch?v=oDHGjUMqPvI&t=140s - demo
https://github.com/endatabas/marketing/tree/main/2023-09-dem... - code
HTH!
There are no comments on this comment yet.
https://docs.endatabas.com/sql/path_navigation.html
I've just pushed a change mentioning that paths can be used in both SELECT and WHERE clauses. Sorry for the ambiguity.
For example:
`select * from stores where addresses[0].city = 'New Jersey';`
...can be used on the demo data, found here:
https://www.youtube.com/watch?v=oDHGjUMqPvI&t=140s - demo
https://github.com/endatabas/marketing/tree/main/2023-09-dem... - code
HTH!