Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: EdgeDB 1.0

edgedb.com

Post reply on HN
Print view View original

41–50 of 332 posts

Re: Show HN: EdgeDB 1.0

#42

Post by nikhilsimha »

Won't the functional variant read better than the SQL dialect

  movie_reviews
   .filter(_.actor.name.lowercase() == "Zendaya")
   .groupBy(_.title, _.credit_order, avg(_.ratings))
   .sortBy(_.credit_order)
   .take(5)
vs.

  select
    Movie {
      title,
      rating := math::mean(.ratings.score)
      actors: {
        name
      } order by @credits_order
        limit 5,
    }
  filter
    "Zendaya" in .actors.name

Re: Show HN: EdgeDB 1.0

#43

Post by gfodor »

Congrats - this looks really interesting, and this is coming from a person who generally ignores new shiny database news. Def will be checking this out!

Re: Show HN: EdgeDB 1.0

#44

Post by samhw »

RedCrowbar wrote: post #39
samhw wrote: post #37

Earlier quoted context omitted.

Wait, it stores the data in Postgres? So this is essentially a data model on Postgres? FWIW, I do think there's a space in the market for a thin wrapper over Postgres (or MySQL) which would automate certain optimisations such as whether to index a particular table. It always struck me as perverse that that optimisation was delegated to the developer, when it's no more subjective or application-specific than a thousan…

It's built on Postgres, but it isn't a _thin_ wrapper. We lean hard into Postgres query machinery and type system in order to pull off EdgeQL and graph-relational efficiently.

Ah, OK, interesting! I don't have an immediate use case personally, but I wish you guys the very best. Honestly, database space needs way more competition than it has at present.

There are countless permutations of the choices that database designers face, so it's a shame there aren't mature products for more of them. I hope this particular permutation turns out to be a good one for lots of people :)

Re: Show HN: EdgeDB 1.0

#45

Post by pier25 »

1st1 wrote: post #33
say_it_as_it_is wrote: post #25

I think this work is absolutely commendable, but at the end of the day it's a database written in Python with Rust extensions sprinkled here and there. Is 1.0 your MVP?

EdgeDB is built on top of Postgres. The performance critical bits are either Python compiled to C with Cython or Rust, so there's almost no Python overhead. We perform quite favorably in benchmarks, see our old blog post with some: https://www.edgedb.com/blog/edgedb-1-0-alpha-2#results > Is 1.0 your MVP? EdgeDB is ready for production and is light years ahead of its first technical preview MVP release published a few…

Would be interesting to know how it fares against Prisma which is becoming pretty popular these days.

Re: Show HN: EdgeDB 1.0

#46

Post by likecarter »

I don't understand the benefit. It's just a query language on top of Postgres? It doesn't seem to have the performance characteristics of a graph database, while acting like it does. JOINS will still be expensive. You guys shouldn't use the word graph, misleading.

Re: Show HN: EdgeDB 1.0

#47

Post by 1st1 »

gfodor wrote: post #43

Congrats - this looks really interesting, and this is coming from a person who generally ignores new shiny database news. Def will be checking this out!

Thank you! Please do and feel free to connect with us to discuss your experience :)

Re: Show HN: EdgeDB 1.0

#50

Post by 1st1 »

waterbase wrote: post #38
1st1 wrote: post #27

Earlier quoted context omitted.

As far as I'm aware OrientDB don't call themselves "graph-relational". In fact, they're positioning themselves as a multi-model NoSQL database. Where's EdgeDB positions itself as a relational database and a successor of SQL.

Dgraph.io? How you guys compare yourself to dgraph database?

IIRC Dgraph is schemaless. EdgeDB is schema-first, which gives you type-safety and that amazing TypeScript query builder autocomplete experience :)
Post reply on HN