News for hackers. Stuff that matters.

Ask HN: Is there a NoSQL database with SQL-like queries?

I like using NoSQL databases for side projects because they're cheaper to use. I can set up a Firestore database on Firebase and spend literally $0 while trying out a new project.

However, the lack of more powerful queries and hardness to do data migrations gets a little bit annoying over time.

So, I wonder if is there a NoSQL database out there which you can easily set up in the cloud, spend $0 as a side project, but it provides you more powerful query capabilities (e.g. JOINS, LIKE, NOT, SUM, COUNT, etc.)?

The requirements:

1. Easy to set up in the cloud; 2. Free tier enough for handling hundreds of users; 3. Auto scalable (no maintenance required);

Why not using something like Digital Ocean? Yes, it's cheap but if you have like 10, 20 side projects it becomes really expensive - especially if you don't like the US and have to pay in a different currency. It can easily eat up like 15% of your salary. Besides, I really don't want to spend time managing a VM with eventual spikes of traffic.

Is there something you would recommend for those cases?

( 5 comments | 3 points | on HN )
Re:Ask HN: Is there a NoSQL database with SQL-like queries? by tqh on Tuesday March 03, 2020 @02:46AM (#22472629)
Foundation DB might fit the bill: https://www.foundationdb.org/
Re:Ask HN: Is there a NoSQL database with SQL-like queries? by vanusa on Monday March 02, 2020 @06:40PM (#22470326)
Once you start asking yourself whether you can do SQL "on top of" a non-SQL database... pretty soon you realize that what you really need is a SQL database.
Re:Ask HN: Is there a NoSQL database with SQL-like queries? by patrickdevivo on Monday March 02, 2020 @05:36PM (#22469805)
IIRC, https://harperdb.io/ might be somewhere up that alley?
Re:Ask HN: Is there a NoSQL database with SQL-like queries? by beamatronic on Monday March 02, 2020 @08:38PM (#22471047)
Couchbase N1QL
Re:Ask HN: Is there a NoSQL database with SQL-like queries? by PaulHoule on Monday March 02, 2020 @05:40PM (#22469835)
Arangodb