EdgeDB 2.0

Post by benwoodward » Fri, Jul 29, 2022, 4:46 AM UTC

1st1 wrote: post #130

benwoodward wrote: post #128

Earlier quoted context omitted.

congrats on this milestone. I’m currently using a graph database (dgraph) mostly so I can easily query complex relationships), and I’m wondering whether EdgeDB has similar performance due to how it stores data? my understanding of EdgeDb is that it stores everything in a single table, and there’s an underlying graph structure. does this give added performance on complex queries?in other words, does EdgeDB perform com…

EdgeDB stores data in a fairly normalized table layout, where every object type corresponds to a physical table. The performance of deep hierarchical queries with EdgeQL will be better than SQL with joins because with joins you'd have an unnecessarily wide denormalized set of rows. EdgeDB instead aggregates data in nested arrays via subqueries. The performance is great. https://github.com/edgedb/imdbench

Post by nikolay » Fri, Jul 29, 2022, 5:09 AM UTC

RedCrowbar wrote: post #79

nikolay wrote: post #78

It sounds great, but being in Python still gives me a bit of concern.

Only the query compiler is in pure Python and you only hit that once per query, as the compilation result is trivially cached. The hot path is a combination of Cython, C and Rust. We have a suite of benchmarks [1] that show relative overhead of EdgeDB compared to raw Postgres is quite low. [1] https://github.com/edgedb/imdbench

Post by fithisux » Fri, Jul 29, 2022, 5:43 AM UTC

RedCrowbar wrote: post #84

fithisux wrote: post #62

Is EdgeDB suitable for OLAP or is it focused on OLTP queries?

With the addition of `GROUP` in 2.0, EdgeDB is as suitable for OLAP as vanilla Postgres is (unless you absolutely need window functions, which we don't implement yet).

Post by yewenjie » Fri, Jul 29, 2022, 6:15 AM UTC

1st1 wrote: post #2

EdgeDB co-founder and CEO here. Ask me anything. We are streaming EdgeDB 2.0 launch event right now, join here: https://www.youtube.com/watch?v=1jloGHV31Ow

Post by EdgyMann » Fri, Jul 29, 2022, 8:28 AM UTC

rapnie wrote: post #132

kleingeld wrote: post #24

Earlier quoted context omitted.

EdgeQL is very nice. Will there be a Haskell client in the no-so-distant future?

General client question: Which ones do you intend to officially support? Interested in Elixir client that is now community maintained.

  - Python, Javascript/Typescript, HTTP are done

  - Go, Rust, Ruby, Java, and .NET are planned