News for hackers. Stuff that matters.
Re:Endatabas: A SQLite-inspired, SQL document database with ... by matlin on Friday December 01, 2023 @06:46PM (#38494184)
This is cool. I like that it makes it super easy to get data into the database rather than having to meddle with schemas in advance.

Looked through the documentation briefly but couldn't figured out how selecting nested properties or filtering on nested properties works?

Re:Endatabas: A SQLite-inspired, SQL document database with ... by deobald on Friday December 01, 2023 @09:37PM (#38495345)
I think the documentation you're looking for is here:

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!