There is both OR and AND support here. If you specify your function parameter as an ARRAY then it operates as an AND, otherwise each argument is an OR.
For instance, to see posts that are remote and python OR remote and ruby, you can do
query(['remote','python'],['remote','ruby']);
The return of the function shows how many jobs were shown versus in total. For instance, as of this writing, I get the following result when running the above function:
{ shown: 56, total: 827 }
It's worth noting that some people have turned this into various "web apps" ... and a few people have forked it and added more sophisticated queries ... search HN news stories for links.
Hasura by far, lets you point-and-click build your database and table relationships with a web dashboard and autogenerates a full GraphQL CRUD API with permissions you can configure and JWT/webhook auth baked-in.
I've been able to build in a weekend no-code what would've taken my team weeks or months to build by hand, even with something as productive as Rails. It automates the boring stuff and you just have to write single endpoints for custom business logic, like "send a welcome email on sign-up" or "process a payment".
It has a database viewer, but it's not the core of the product, so I use Forest Admin to autogenerate an Admin Dashboard that non-technical team members can use:
For interacting with Hasura from a client, you can autogenerate fully-typed & documented query components in your framework of choice using GraphQL Code Generator:
Then I usually throw Metabase in there as a self-hosted Business Intelligence platform for non-technical people to use as well, and PostHog for analytics:
I wrote a way to search these recently ... just paste this in your console: https://gist.github.com/kristopolous/19260ae54967c2219da8
There is both OR and AND support here. If you specify your function parameter as an ARRAY then it operates as an AND, otherwise each argument is an OR.
For instance, to see posts that are remote and python OR remote and ruby, you can do
query(['remote','python'],['remote','ruby']);
The return of the function shows how many jobs were shown versus in total. For instance, as of this writing, I get the following result when running the above function:
{ shown: 56, total: 827 }
It's worth noting that some people have turned this into various "web apps" ... and a few people have forked it and added more sophisticated queries ... search HN news stories for links.