News for hackers. Stuff that matters.
Re:FoundationDB: A distributed unbundled transactional key v... by eatonphil on Friday March 11, 2022 @03:15PM (#30645437)
> They both actually have an SQL layer - foundationdb's is the record layer.

Can you show me their SQL layer? I was looking for it.

Re:FoundationDB: A distributed unbundled transactional key v... by tonyhb on Friday March 11, 2022 @03:16PM (#30645464)
https://github.com/FoundationDB/fdb-record-layer is the SQL/orm like interface. This handles things in a DB like way - joins, indexes. I misspoke when I said SQL regarding this - sorry.

There's a go and rust library floating around that's not as good. I've tried em :)

Re:FoundationDB: A distributed unbundled transactional key v... by eatonphil on Friday March 11, 2022 @03:18PM (#30645483)
The readme says

> Queries - The Record Layer does not provide a query language, however it provides query APIs with the ability to scan, filter, and sort across one or more record types, and a query planner capable of automatic selection of indexes.

So I'm not sure how you can call that a SQL layer when SQL is a query language and FDB Record Layer says it doesn't have a query language?

Re:FoundationDB: A distributed unbundled transactional key v... by tonyhb on Friday March 11, 2022 @04:44PM (#30646402)
Yeah, I did say "I misspoke when I said SQL regarding this - sorry.". I should have said "SQL-like", or at least relation-like.

There were a couple SQL-ish things I found in other languages and got them mixed up. Sorry about that :)

Re:FoundationDB: A distributed unbundled transactional key v... by AlphaSite on Friday March 11, 2022 @03:47PM (#30645798)
I don’t think it ever got open sourced, although I do remember reading about it years back.