Life After SQL (EdgeDB Is Fascinating)

Sdílet
Vložit
  • čas přidán 7. 06. 2024
  • Disclaimer: I am an advisor for EdgeDB, I do not ship it in production (I still build my services on PlanetScale)
    EdgeDB is getting pretty dang exciting. The idea of a "more relational" db is something I hadn't thought about enough before. Excited to see what they cook!
    SOURCES
    / 1782485844814647402
    www.edgedb.com/blog/we-can-do...
    Check out my Twitch, Twitter, Discord more at t3.gg
    S/O Ph4se0n3 for the awesome edit 🙏
  • Věda a technologie

Komentáře • 420

  • @t3dotgg
    @t3dotgg  Před měsícem +31

    BTW I'M JUDGING THE EDGEDB HACKATHON. WINNER GETS $5k. hackathon.edgedb.com/

    • @ytlongbeach
      @ytlongbeach Před měsícem

      i'm a long time backend sql guy, so i was skeptical about anything said to replace sql, especially after the past decade of non-sql positive hype (typically presenting the benefits of something without the downsides). as you know, engineering decisions are almost always about trade-offs, rather than something is completely awesome/sucks. however, your excellent video here piqued my interest. i'm going to do diligence on EdgeDB for an upcoming project !

    • @Kane0123
      @Kane0123 Před měsícem +1

      To anyone who is in the know… How do these basic queries scale and what is the experience of tuning queries? Having loving syntax is great but I’m genuinely curious to see if this is just a “rapid prototype” database that you’d drop if you get any traction or advanced requirements

  • @reubence_
    @reubence_ Před měsícem +206

    the name is horrendous.
    clicked on this video wondering why would someone need an entire DB runnign on the edge....

    • @erenjeager1756
      @erenjeager1756 Před měsícem +17

      Lol, do you know that Edge also refers to edges in Graphs ?

    • @maximiliaanvandijk6111
      @maximiliaanvandijk6111 Před měsícem

      I didn't :') ​@@erenjeager1756

    • @BCRooke1
      @BCRooke1 Před měsícem +20

      Like a lot of things in our industry, these terms become horrendously overloaded. But I get what they meant: edge as in edges and vertices, i.e. graph theory.

    • @user-tz6nn8iw9m
      @user-tz6nn8iw9m Před měsícem +8

      It's not their fault that Guillermo Rauch spams the word edge too much on Twitter.

    • @pencilcheck
      @pencilcheck Před měsícem

      not 100% but some would be nice, replacing redis for me. in memory postgresql is cool

  • @benbowers3613
    @benbowers3613 Před měsícem +106

    THEY HAVE DOCS FOR RUNNING ON DOCKER OR BARE METAL LETS GO SELF HOST GANG

    • @Frostbytedigital
      @Frostbytedigital Před měsícem +2

      Been using self hosted dockered libsql with their client and had speeds surpassing drizzle but now I'm going to have to try this out so I don't have to write sql

    • @joe_ervin10
      @joe_ervin10 Před měsícem +2

      @@Frostbytedigital what’s the point of dockerizing libsql? i know it allows for network requests but isn’t the whole point of sqlite that its embeddable?

    • @GreatTaiwan
      @GreatTaiwan Před měsícem

      do i get all the GUI dashabord query builder and other stuff provided when i go with their cloud solution ? thou otherwise what's the point?

    • @TurtleKwitty
      @TurtleKwitty Před měsícem

      @@joe_ervin10 sqlite is embeddable libsql makes it shareable; you need a server to fetch the initial db to clone for an embedded user for example

    • @seanknowles9985
      @seanknowles9985 Před měsícem

      @@GreatTaiwanI also want to know if we we get a GUI dashboard while running a dockerised solution.

  • @kmfaessl
    @kmfaessl Před měsícem +34

    Gonna have to disagree about including its built on postgres on landing page. As a user experimenting with edgedb, that's a piece of info I'm glad to have. I know the core db engine is rock solid because postgres has been around so long. I can guess what features they might easily add by looking at postgres extensions and features. I know I might be able to make some existing tools interop with it.

    • @gfrewqpoiu
      @gfrewqpoiu Před měsícem +2

      They actually allow READ-ONLY access to the underlying Postgres Data, so that you can use your favorite Postgres tooling for some complex visuaization or other tasks.

  • @martinlesko1521
    @martinlesko1521 Před měsícem +51

    It's Like GraphQL without the GraphQL burden

    • @LtdJorge
      @LtdJorge Před měsícem +4

      And with GraphQL 😂

    • @user-tz6nn8iw9m
      @user-tz6nn8iw9m Před měsícem

      the dgraph query language is limited like graphql, this looks more powerful.

    • @weathercontrol0
      @weathercontrol0 Před měsícem +3

      It's like graphQL, but with edging

  • @BlackMan614
    @BlackMan614 Před měsícem +36

    SQL 1989?!? I was using it when I was in college in the early 80s and using Informix and Oracle SQL in '87 when I had my first job. Pretty sure SQL had been around a while before that.

    • @precumming
      @precumming Před měsícem

      Yeah it's from 1974. I can't think of what he's confusing with that was introduced in 1989

    • @joaothomazini
      @joaothomazini Před měsícem +9

      Theo in the impet to pump-up his friend's DB made a poo-poo.

    • @maacpiash
      @maacpiash Před měsícem +2

      Theo makes a lot of mistakes in his videos. I keep that in mind when watching these.

    • @haulin
      @haulin Před měsícem

      According to Wikipedia, it first appeared in 1974, so 50 years ago!

  • @GameDesignerJDG
    @GameDesignerJDG Před měsícem +9

    I don't really get why people don't like SQL. Personally, I find it fine to work with. What I do get is that there are different kinds of people out there than me, so I'm happy this is a product people can try out and use if they like it. I'll probably be stuck with SQL for a long time cause of my job, but I'm also happy to say that I don't really mind that at all.
    One thing that does get frustrating is, as in the example Theo points out at 13:41, different implementations of SQL have different ways of writing it, so you can't just write SQL, you *have* to write MySQL or PostgreSQL or Oracle SQL or SQL Server SQL, etc.

  • @kefpull6676
    @kefpull6676 Před měsícem +24

    Truly the best Edge(ing) experience (tm)

  • @NoelmineZockt
    @NoelmineZockt Před měsícem +50

    No neo4j mentioned?

    • @MattJoyce01
      @MattJoyce01 Před měsícem +2

      would have been nice to see the movie example in Cypher

    • @brookerose1312
      @brookerose1312 Před měsícem

      ikr? this is basically just an aura db with a graphql layer on top (but obviously, is handled a bit nicer)

    • @Rebel101
      @Rebel101 Před měsícem +2

      Perhaps because Neo4j is not a relational DB? It's a graph DB. 😊

  • @teddyfulk
    @teddyfulk Před měsícem +5

    I've used edgedb since I saw it on one of fireships top 10 dbs videos way back and have absolutely loved how they've keep making it better and better. 10/10

  • @dealloc
    @dealloc Před měsícem +11

    I used EdgeDB when it was quite new, and it was already amazing back then, albeit with some caveats in the query language. Glad to see it grow and becoming better!

  • @joe_ervin10
    @joe_ervin10 Před měsícem +4

    the fact that they have sdks for almost every language is so cool. I have been wanting to write my backend in go for a while now but there’s just not enough auth libraries that support it. I’ll definitely have to check this out

  • @gnorts_mr_alien
    @gnorts_mr_alien Před měsícem +8

    edgedb is AMAZING, solves all the problems old SQL systems have, even have integrated migrations system. the language is very comfortable and modern. the documentation is amazing. and it is a front to postgresql which itself is obviously amazing. I have no idea why it isn't all the rage.

    • @boscodomingo
      @boscodomingo Před měsícem

      Because it was still in beta last time I checked a few months ago

    • @paulholsters7932
      @paulholsters7932 Před 10 dny

      @@boscodomingo how long ago was that? It’s on version 1.5 already and has a cloud version.

  • @HamishWHC
    @HamishWHC Před měsícem +8

    Self hosting it is super simple, which I very much appreciate. Main gripe with it is the lack of a language server for .esdl files. It has syntax highlighting, but no autocomplete or formatting, which is very annoying.

    • @YurySelivanov
      @YurySelivanov Před měsícem +8

      Working on that.

    • @HamishWHC
      @HamishWHC Před měsícem

      @@YurySelivanov I’ve been waiting eagerly since the Rust parser blog post. Good to hear it’s still being worked on. Looking forward to it.

    • @ZeroRegretz
      @ZeroRegretz Před měsícem

      Same. And there is one specific bug with their eqdeql js lib. But that's about it

  • @aakarshan4644
    @aakarshan4644 Před měsícem +111

    andy said sql ain't going anywhere no matter whatever new gimmick comes around.

    • @joshuaborseth
      @joshuaborseth Před měsícem +13

      I mean of course it’s not, but that doesn’t mean this isn’t cool

    • @DavidLindes
      @DavidLindes Před měsícem +6

      It'll go away some number of decades after something else has high enough acceptance that people aren't choosing it anymore. Whether that's two decades after next year, or 10 decades after 200 years from now, it'll probably happen eventually.

    • @anonymousalexander6005
      @anonymousalexander6005 Před měsícem +5

      @@DavidLindes“There was 10 competing standards.”
      “We remade the 5th as the 15th praise us.”

    • @Leonhart_93
      @Leonhart_93 Před měsícem +3

      Of course. It's way too big and integrated into everything. But why not build the new stuff in the new thing, assuming it's all upsides?
      But I guess time and trial will tell if it really doesn't have significant downsides.

    • @user-tz6nn8iw9m
      @user-tz6nn8iw9m Před měsícem +1

      SQL will continue to exist for a long time, just like Cobol.

  • @dstick14
    @dstick14 Před měsícem +4

    Finally we can edge in peace

  • @forderdrek8757
    @forderdrek8757 Před měsícem +3

    As much as I love SurrealDB, I must say, this shit is HOT

  • @gotxe
    @gotxe Před měsícem +6

    I'm a big fan of EdgeDB(just have a glance and their Book in the docs, it's amazing 🤩), i truly hope they would get much more traction over the coming months
    The only thing that i'm really not happy about is the polymorphism implementation. Unfortunately folks went the abstract\extends\inheritance way instead of union types, i think this was a mistake. Yes, i know that i can model union types, they got so many things right, but not that "feature", imho.

  • @GoldenretriverYT
    @GoldenretriverYT Před měsícem +89

    "they are not a sponsor" [...] "if they suceed, i get a bit of a payday" ah yes

    • @Spiker985Studios
      @Spiker985Studios Před měsícem +20

      He said upfront that he has been advising them, so yes, presumably if they do well as a company, then he'll continue advising them - getting a payday.
      Rather than the video itself being the source of the funds, his advice is the source

    • @TheBswan
      @TheBswan Před měsícem +8

      This isn't the dunk you think it is

    • @GoldenretriverYT
      @GoldenretriverYT Před měsícem +4

      @@Spiker985Studios Doesn't change that he first intended to make it seem like the video isn't biased by saying it isnt sponsored, even though it is obviously is biased considering that.

    • @Spiker985Studios
      @Spiker985Studios Před měsícem +4

      The first line of the description is a disclosure. A verbal disclosure is at 45 seconds, just after the "hook"
      How much more disclosed does it need to be?

    • @nikolatomic384
      @nikolatomic384 Před měsícem +1

      @@GoldenretriverYT He never said that the video isn't biased, it is. He just said that it wasn't sponsored since it isn't.

  • @XceptionalBro
    @XceptionalBro Před měsícem +7

    So, if it's based in Postgres... It's just a wrapper over sql?

  • @Mirislomovmirjalol
    @Mirislomovmirjalol Před měsícem +5

    what about surrealDB?

    • @user-tz6nn8iw9m
      @user-tz6nn8iw9m Před 22 dny

      Surreal is too new, tries to cover a LOT. and to implement features, they must build it almost from scratch.

  • @gardnmi
    @gardnmi Před měsícem +8

    The whole market is regressing back to the SQL api. This is a bold move cotton.

    • @EduardoEscarez
      @EduardoEscarez Před měsícem +1

      Is not a bad idea having new alternatives, the catch is that SQL has decades of development and it's availability is unparalleled.
      Also another channel, Asianometry, is covering the history of SQL in a series of videos, and how its ideas are the response to the hierarchical databases of the time.

  • @user-ht6tu6ks3u
    @user-ht6tu6ks3u Před měsícem +3

    I've tried it for a while and IMHO it's awesome! especially integrated DB migration, and query language looks good too.

  • @Oler-yx7xj
    @Oler-yx7xj Před měsícem +1

    The beginning has that feeling of watching a movie with somebody, who have seen it and they constantly pause to explain some little stuff

  • @MethodOverRide
    @MethodOverRide Před měsícem +8

    SQL 1989... you may want to check with your video editor on that one...

  • @CloakedC
    @CloakedC Před měsícem +4

    I appreciate the disclaimers, thanks Theo

  • @shiroi2971
    @shiroi2971 Před měsícem +4

    So it is just an abstraction over plain SQL? And what is stopping them from doing a redis?

    • @sarabwt
      @sarabwt Před měsícem +2

      Pretty much seems like it. It is a language neutral set (or more likely, a subset) of SQL, that is a bit more convenient to write. I would hate to be the one to hit the capability wall... With ORM you can at least fall back to raw dogging SQL.
      Someone doing a redis sometime in a distant future should not really stop you from using it. Nothing is stopping noone from pulling a redis.

  • @paulholsters7932
    @paulholsters7932 Před měsícem +1

    I am building a developer tool that uses EdgeDB as a core feature. Glad it’s getting attention.

  • @ny1stclass
    @ny1stclass Před měsícem +2

    am i wrong in thinking query vectorization, columnar storage, distributed query engine are the future for sql. what's the problem with sql that we always see ppl asking what's next for sql... lol a more improved sql

  • @Manchuwook
    @Manchuwook Před měsícem +1

    The big use cases that I always have to keep an eye out for are:
    * DIstribution - can I have this in pods across multiple datacenters?
    * Stored Procedures - can I wrap my queries in sprocs to satisfy security requirements?
    * OpenAPI (Swagger) - Can I generate my types against a JSON schema for interoperability with my ReactJS UI?
    * Driver Resource Footprint - How much of a hog is this? ODB uses 4gigs for our biggest queries in spikes, otherwise it just sips at memory

  • @2penry2
    @2penry2 Před měsícem +4

    Looks pretty sweet, assuming the Edge in the name is for edges on a graph?

  • @maso4u
    @maso4u Před měsícem +1

    can one migrate from sql to edgedb and the other way around too

  • @MethodOverRide
    @MethodOverRide Před měsícem +23

    12:22 null is a fundamental set in set theory. SQL should provide support for null since relational databases are based on sets and set theory. Why is everyone up*set*? 😊

    • @himanshutripathi7441
      @himanshutripathi7441 Před měsícem +2

      Exactly

    • @Mig440
      @Mig440 Před měsícem +3

      Null is not fundamental to set theory. Unless you mean the empty set Ø. But that is just the initial object in the category of sets. Most of the time null is problematic since having it means you are no longer in a boolean world but need to acommodate three logical values: true, false and null.

    • @gencade2504
      @gencade2504 Před měsícem +3

      There is no null in set theory. Null is a design 'mistake' in computer science.

    • @YurySelivanov
      @YurySelivanov Před měsícem +2

      @@gencade2504 Read the linked in description article. It talks about the creators of SQL themselves saying that NULL was a mistake and breaks the relational model. It was a mistake that was too late to fix though so it stuck.

  • @jordanmancini
    @jordanmancini Před měsícem +1

    It honestly looks pretty cool, and if I had a project that I needed to use a DB for that didn't already have a ton of documents/values put in I'd definitely try it out. I've never really used a relational DB since I got started with Mongo and my couple forays into MySQL didn't go far. Even my attempts at using Prisma weren't too great because it doesn't seem to be as plug and play with Mongo as it is with relational databases, although it could also just be the implementation that's the issue

  • @todd.mitchell
    @todd.mitchell Před měsícem +2

    And here I'm writing almost all my SQL in stored procs and functions in MySQL Workbench. I feel old.

  • @Spiker985Studios
    @Spiker985Studios Před měsícem +5

    I would rewrite "based on PostgreSQL" to be "powered by PostgreSQL"
    "Based on", to me, implies that the source is "based on" that thing

    • @aislanarislou
      @aislanarislou Před měsícem +2

      "written on top a PostgreSQL foundation"

  • @zwanz0r
    @zwanz0r Před měsícem

    How does it build on top of PostgreSQL? Is it a hard fork and changed the actual source code? or a layer on top. What do they get from PostgreSQL that they couldn't get anywhere else?

  • @ReinPetersen
    @ReinPetersen Před měsícem +3

    orm is a footgun - if you're going to use postgresql then just make functions (you can return json) - also that SQL example on edgedb website is (purposely?) needlessly obscure with subqueries and could more easily/legibly/compactly be written using common table expression

    • @thewiirocks
      @thewiirocks Před měsícem

      Alas, I doubt you'll get too much support for the idea that ORM is a footgun. I've been apologizing for my colleagues and I accidentally unleashing that nonsense on the world for a decade and a half. Nobody listens because they don't know what else to do.

  • @Duconi
    @Duconi Před 8 hodinami

    So, what I get from this, is that EdgeDB is a different query and definition language for PostgreSQL, right? At least I didn't saw any fundamental difference in how data is stored or modeled. It looks that just the way one writes queries and the way one defines the tables is a bit difference and fixes some issues SQL had, but it's not fundamentally capable of different things, right?

  • @peteranderson7144
    @peteranderson7144 Před měsícem

    I’m really excited about EdgeDB. My biggest hold up right now to using it is that it is new and I’m worried about running into edge cases.
    Also, I wish I knew a little bit more about the deployment story. Can it be backed by a postgre instance in RDS?

  • @erenjeager1756
    @erenjeager1756 Před měsícem +4

    Prisma frustated me soo much that I love EdgeDB since day 1 I started using it

  • @be1tube
    @be1tube Před měsícem

    How would it handle very large sets? For example, 1B objects that are related to smaller groups of objects. E.g, (Measurement (billions), Measured Variable (hundreds of thousands), variable tag (thousands))

  • @paulholsters7932
    @paulholsters7932 Před měsícem

    What I like about EdgeDB is that it’s very accessible and easy to learn.

  • @mortjac
    @mortjac Před měsícem

    Great story about SQL and what may come next. Please lead us further down the path!

  •  Před měsícem +1

    I am sold already
    Can it be supabase alternative?

  • @mathesonstep
    @mathesonstep Před měsícem

    Now I'm lost, do I try to use EdgeDB for my new side project or do I stick to drizzle/mariadb?

    • @paulholsters7932
      @paulholsters7932 Před 10 dny

      EdgeDB for sure. I use it. It works great, the dox are great too as well as the community on discord.

  • @br3nto
    @br3nto Před měsícem

    10:20 how do you snapshot your schema changes and manage migrations??

  • @skapator
    @skapator Před měsícem +2

    This is going to have huge success on junior devs and some companies that will buy the pitch or ripe some bens. sql is not good enough ....

  • @ciarancurley5482
    @ciarancurley5482 Před měsícem +1

    Between NULL and timezones, also feeling making sand think was a mistake

  • @m12652
    @m12652 Před měsícem

    I spent most of the last couple of days playing with edgedb and it's api etc. Brilliant! haven't seen something this interesting since I first discovered Svelte 👍

  • @Ekce
    @Ekce Před měsícem

    I guess, my concern, when considering switching to a different database is that I'd have to learn how to write queries safely. Like, with SQL you have the potential for SQL injections and there are techniques to mitigate it like prepared statements and such. Is there documentation on how to write EdgeDB queries safely?

    • @YurySelivanov
      @YurySelivanov Před měsícem

      Unless you concatenate EdgeQL queries with data there's 0 chance of any injections.

  • @JakobRossner-qj1wo
    @JakobRossner-qj1wo Před měsícem +2

    What do you think about Convex?

    • @noahwinslow3252
      @noahwinslow3252 Před měsícem

      Convex is really good if you need websocket-like speed from updated data (like a chat app) but it falters in writing complex queries

  • @yapet
    @yapet Před měsícem +1

    So first the vercel stopped edging, just for my database to do so instead

  • @zuma206
    @zuma206 Před měsícem +1

    Looks cool! I love that it will probably be easier to master than SQL, given all of SQL's edge cases (pun intended), and it's awesome docs. I doubt it'll eclipse SQL cause SQL is SQL, but I can imagine it being the sorta popular alternative people thought Mongo would be.

  • @canadiannomad2330
    @canadiannomad2330 Před měsícem

    Unfortunately edgedb docs just give me "Application error: a client-side exception has occurred (see the browser console for more information)." on mobile... Can't see what I want to see.

  • @nervetattoo
    @nervetattoo Před měsícem +2

    Very satisfied with edgedb after using it for 17 months.
    It's a force multiplier. Never been this fast in my 20 years in the biz, and never written so few bugs with any other db.
    Name is fine, its graph edges but now that word is pretty much hijacked by the edge so yeah.

  • @oso1248
    @oso1248 Před měsícem

    Is it faster than raw SQL? I’ve tried ORMs and query builders… they’re severely limited and slower than raw SQL.

    • @erenjeager1756
      @erenjeager1756 Před měsícem +1

      It is faster than ORMs but can't be faster than SQL since it compiles to SQL

  • @TylerJBrown192
    @TylerJBrown192 Před měsícem +7

    I would have liked to know more about the implementation details of EdgeDB itself - is it just a wrapper around a Postgres DB with some additional functionality? Is it just a different API that abstracts standard DB behavior? I'll look at the docs of course, but I would have enjoyed for this video to explain it for me, since you have had such intimate knowledge of the project!
    Edit: found it - though unfortunately the docs were no help at all. Look up the talk "The architecture of EdgeDB" given by Fantix King, very helpful! TL;DR: EdgeDB runs their own middleman server in between the Client and the Postgres DB which provides the added functionality

    • @sofianikiforova7790
      @sofianikiforova7790 Před měsícem

      Yes.
      Edit: saw your edit

    • @jon1867
      @jon1867 Před měsícem

      Pardon if this is a bad question because I don't really understand how the architecture of databases work, but does edgedb's query language build SQL queries under the hood, or is there some sort low level functions / Machine code that edgedb calls directly?

    • @TylerJBrown192
      @TylerJBrown192 Před měsícem +1

      ​ @jon1867 No it's not a bad question at all! Never be afraid to ask about things. For what it's worth, both this video (sorry Theo) and the EdgeDB docs itself don't explain the mechanisms of the technology at all unfortunately.
      You've basically got it down. As far as I understood the video "The architecture of EdgeDB", EdgeDB's query language compiles into EdgeDB-proprietary binary that gets sent to their custom architected middleman server, that then interprets that binary as SQL, then massages it to the native Postgres binary protocol, then after all of that, it communicates to just a standard Postgres instance.
      The main time saves that EdgeDB achieves is from a caching layer within that middleman server to store general queries + prepared statements, their own binary implementations + using native Postgres binaries which save data over the wire at every touch point in the stack, writing part of their EdgeDB server with Cython and Rust bindings for the most intensive processes, as well as utilizing a more efficient communication protocol to their own server + to the Postgres instance via uvloop
      The biggest gap in my current knowledge of the technology is that I don't know _how_ the Postgres database is architected after compile / migration time - there are methods of simulating a Graph database e.g. neo4j within Postgres, but I'm just guessing this based on how frequently they use the term 'graph' in the docs. I'll probably spend some time tomorrow getting something up and running to see actually how the database schema looks after the DB has been instantiated

    • @jon1867
      @jon1867 Před měsícem

      @@TylerJBrown192 One of the questions that raises is, could edgeQL be used on an existing postgres DB with relational tables? Or would it only work on a database built with edgeDB specifically?
      If so I think adoption for a tool like this could actually be pretty massively viable. And with performance benefits like that, even if people don't wholly drink edgeQL koolaide they could sprinkle it into important parts of their application.

    • @TylerJBrown192
      @TylerJBrown192 Před měsícem

      @@jon1867 Damn, good question, I actually had a very similar thought! But it came from me worrying that if I ever brought in EdgeDB to anything I was working on, I just signed myself / my team up for an insane amount of technology / vendor lock-in haha
      There's been tons of "it's coming" comments I can see from the team since even 2019, but I wasn't able to find anything concrete about how to generate an EdgeDB schema from an existing Postgres database. All of their Migration / EdgeDB CLI functionality seems to only build upon an existing EdgeDB schema, not to be able to generate a schema like many standard SQL ORM-esque libraries can

  • @MrMudbill
    @MrMudbill Před měsícem

    The iceberg graphic alone had me to go the website just to see it for myself

  • @seanknowles9985
    @seanknowles9985 Před měsícem

    I don't understand it, if I have a postgress instance running can I just use Edgedb?

  • @marko1395
    @marko1395 Před měsícem

    The SQL code in the comparison wouldn't pass code review 😕 What happened to steelmanning?

  • @xali2008
    @xali2008 Před měsícem

    So this is basically an ORM for Postgres with extra steps?

  • @MikeyHogarth
    @MikeyHogarth Před měsícem

    Awesome content as always, although there's something I don't really understand (and the EdgeDB site itself doesn't really clarify) - the "N+1 problem" is presented here as being a *syntax* problem - as in, it's a pain in the arse to keep having to do sub-queries to get the data you need across multiple tables.
    But isn't n+1 actually a *performance* concern rather than syntax? e.g. the classic example, if I have a blog posts table, and an authors table, and I want a query that returns some data from each, a single query will need to run a sub query against the authors table once for every blog post that comes back. I don't understand how edgeDB solves that part?

    • @alexlapins533
      @alexlapins533 Před 8 dny

      N+1 is an ORM performance problem, usually due to the ORM lazy loading individual values from child tables (ex. load all blog posts, then iterate the posts and get the author name for each post as a separate query). Since EdgeDBs ORM expresses the query as a whole thing, rather the schema being a graph of objects, so it can transform the query into a join executed in the DB itself, so "no N+1" is a function of knowing the totality of the data requested at request time. That said, the subselect in the select statement in the SQL example, for some engines, an N+1 operation, since some engines don't optimize subselects in the select statement into a join at runtime. I need to look at the docs -- the quality of their execution planner and whether they're converting the query to sql first, or using the primitives the execution planner is using under the covers directly could make a big difference. If it's just transforming to SQL, then I'm not sure why it couldn't be a plugin/layer on top, rather than a full DB.

  • @tmbarral664
    @tmbarral664 Před měsícem

    I'm guessing Drizzle use functions rather than a big class holding all the possible methods for Tree Shaking

  • @Malix_off
    @Malix_off Před měsícem +1

    2:10 I've also been confused with its name suggesting it has a relation to the edge before

  • @sevos
    @sevos Před měsícem

    But how does it work? Is it just a transpiler to SQL?

  • @user-ik7rp8qz5g
    @user-ik7rp8qz5g Před měsícem +1

    I would definitely try it for some project - but only if it had support for webstorm editor. Otherwise not much interest dealing with plaintext schemas

  • @7th_CAV_Trooper
    @7th_CAV_Trooper Před měsícem

    Building on top of postgres is a good idea. Storage engines are hard to write. It can always be swapped out later.

  • @realbigsquid
    @realbigsquid Před měsícem +1

    I just spent so much time learning drizzle after learning prisma after learning graphql.... I still just want to write my own sql lol

  • @CarlosEstebanLopezJaramillo
    @CarlosEstebanLopezJaramillo Před měsícem +2

    Hmm? do you mean Graph Databases? I think Graph DBs like Neo4j are indeed challenging the norm, especially with Cypher language that is being adopted by other Graph DBs, it's just not going mainstream fast enough...

  • @nikensss
    @nikensss Před měsícem +1

    Why can’t we have an orm that lets you write your table definitions in SQL and parse the types from that? Every new orm comes with a new schema definition language 😅

    • @thewiirocks
      @thewiirocks Před měsícem

      Because ORMs are a fundamentally bad idea. Ted Neward called this out in his 2006 article on "The Vietnam of Computer Science". Neward's arguments on the impedance mismatch are quite good, and my experience bolsters his arguments much, much further. For example, ORMs fundamentally thrash the CPU cache making efficient performance nearly impossible. They also eat memory like candy, which isn't great in a scalable system. You ideally want the path from disk to the client to be as short as possible. Finally, they generate ridiculous amounts of unnecessary code that drastically slows the production of applications that use them.
      I've been doing something much slimmer and more effective for over a decade now. I've rewritten the platform multiple times for numerous employers. Results are a 20-100x impact on productivity, measured in comparable lines of code metrics. I've finally gotten sick of doing it again and again and am founding my own organization to release it to the world as OSS. Keep an eye out for this alternative later this year.

  • @nevokrien95
    @nevokrien95 Před měsícem

    If its open source based on postgress you c extensions to it can use postgress extensions for stuff like vector math

  • @m12652
    @m12652 Před měsícem +1

    13:37 i may be wrong, but after more than 20 years coding mostly for accountants I think they might be responsible for Null. Several have told me they must have null to indicate unknown as zero could be a valid known amount while it might also indicate "amount unknown" so null makes sense to them... so an outstanding balance on a customer account for example could be zero coz they just paid, or zero because the invoice hasn't been raised yet. I've tried explaining there are alternatives etc. but they think everything is a spreadsheet and get stressed out if there more than 2 dimensions.

    • @Spiker985Studios
      @Spiker985Studios Před měsícem +2

      I feel like a single bit (boolean), for an "IsInvoiceRaised" value would be infinitely more helpful
      Inclusion of data instead of the absence of data, every time

    • @aislanarislou
      @aislanarislou Před měsícem +1

      If that reason is true, so maybe a valid type UNKNOWN should have created back then......

    • @alexlapins533
      @alexlapins533 Před 8 dny

      @@aislanarislou They did, they just named it NULL. NULL in SQL means unknown, null in programming languages means "uninitialized pointer" or "nothing".

  • @kyonru
    @kyonru Před měsícem

    I’m building a personal project, I’ll give it a try since they offer a free tier!

  • @ChaseFreedomMusician
    @ChaseFreedomMusician Před měsícem

    Thank you for introducing me to Edging...

  • @WillDelish
    @WillDelish Před měsícem

    I’m trying it out! Wished there was more tutorials on it

  • @modolief
    @modolief Před měsícem

    Great video. Simply superb.

  • @pettymanny6487
    @pettymanny6487 Před měsícem

    What is the difference between this EdgerDB and any ORM? Looks like it's an ORM

  • @drndn
    @drndn Před měsícem

    EdgeDB seems to respect and implement aspects of The Third Manifesto, which talks about doing relational more properly in a DBMS than SQL does.

  • @covle9180
    @covle9180 Před měsícem +3

    What I hate about SQL is that it only returns flat data rather than nested objects. What I hate about ORMs is that I feel I don't have enough control over what query is being built, and that it's usually harder and very library specific to do complex things.
    So I just want to write some version of SQL so I can optimize the f out of that myself, but I want the results to already be nested on the joins I make (or FKs that exist).

  • @sup_nim
    @sup_nim Před měsícem

    finally a video that youre not just whining but artually sharing information

  • @isaacweingarten
    @isaacweingarten Před měsícem

    What about performance? I see edgeDB is writing in python why didn’t the use rust or go etc.?

  • @mohitkumar-jv2bx
    @mohitkumar-jv2bx Před měsícem +22

    #Ad

    • @21tired88
      @21tired88 Před měsícem +5

      "if they succeed, I get bit of a payday" lmao

    • @GoldenretriverYT
      @GoldenretriverYT Před měsícem +6

      "they are not a sponsor" [...] "if they suceed, i get a bit of a payday" ah yes

    • @7th_CAV_Trooper
      @7th_CAV_Trooper Před měsícem

      Pro tip: almost everything on CZcams is an ad or promotion. People like to earn money so they can buy food, you know.

    • @mohitkumar-jv2bx
      @mohitkumar-jv2bx Před měsícem

      @@7th_CAV_Trooper and honest people preface it with letting their watchers know.
      Those who don't, are hmmmm. I don't wanna take names here. 😂

  • @oscarhagman8247
    @oscarhagman8247 Před měsícem

    At first I thought it was a postgres fork that runs on the edge lol

  • @marlopainter8246
    @marlopainter8246 Před měsícem

    10:06 - Does that mean if I switch from Mongo and mongoose, I have half the work? Writing a mongoose schema and then writing a type for it (unless it's my ignorance as a student) is getting nutty.

  • @geoffreygordonashbrook1683
    @geoffreygordonashbrook1683 Před měsícem

    vector databases for ai-ml-ds (and you maybe mentioned graph-database) are key interests

  • @zammea
    @zammea Před měsícem +7

    I'm a DBD(Database developer) for close to 2 years now. One of my understanding is this is practically an ORM?
    One of the things that I dislike ORMs is the fact that when using ORMs is that they do no understand the data you store and how the Engine will interpret it and create the best execution plan there is. This can cause to performance issues. Some of them are easy to solve with indexes other require you to rewrite the query in a way to make the engine go to the execution plan it will be best for performance. No one like slow responses from a DB. Your app can be written Rust and be connected to a badly maintained DB. It does not matter how fast your App is if your DB provides you data slowly or in some cases a bad data.
    My biggest question here is how do I do my perf tuning in the PostgreSQL or in the EdgeDB platform?

    • @trapfethen
      @trapfethen Před měsícem

      EdeDB has a fully functional Query Analyzer just like conventional SQL databases. Just put "Analyze" is front of your query like you would for most SQL databases.

    • @sarabwt
      @sarabwt Před měsícem +1

      It is not an orm. My best guess is that it is pretty much a syntactic sugar on top of SQL. What do you mean by "they do not understand the data you store"?

    • @trapfethen
      @trapfethen Před měsícem +2

      It's not an ORM. It is a Set-based DB implemented on top of an underlying Postgres database. The distinguishing factor is that EdgeDB Normalizes the data on the backend to better support their set fundamentals and optimize for their performance. It allows Postgres to handle efficiently allocating the page files for quick access while more directly controlling the query planning (something ORMs don't typically do outside of bare query splitting for related models).
      The cool part is since it's 100% open source, you can dig in and see exactly how far they have taken this concept and the implementation details of it.

    • @pencilcheck
      @pencilcheck Před měsícem

      Same questions here, having tables with millions of rows and some queries will make it very slow, not a fan of those surpises as well, not sure how this is fixed.

    • @2547techno
      @2547techno Před měsícem +1

      @@trapfethen it is not at all a db implementation on top of psql, psql IS the db itself. It does not touch anything related to page files, psql does that. It does not more directly control query planning over normal sql, it uses the exact same interface. Whether typical orms are smart enough to not send multiple queries over the network is beside the point entirely

  • @Fanaro
    @Fanaro Před měsícem

    Their code runners are so dope indeed.

  • @radek9616
    @radek9616 Před měsícem

    This is interesting, would there be EdgeDBlite? Just like there is SQLite to SQL?

    • @benbowers3613
      @benbowers3613 Před měsícem

      Isn't the point of SQLite just to be easier SQL, and doesn't EdgeDB already accomplish that? Or do you mean like having a really small install footprint? If so you are probably looking for Turso.

    • @erenjeager1756
      @erenjeager1756 Před měsícem

      ​@@benbowers3613this isn't the same application for SQLite you are forgetting mobile apps and countless other platforms that leverage SQLite

    • @erenjeager1756
      @erenjeager1756 Před měsícem

      ​@@benbowers3613that isn't the only utility of SQLite you are forgetting mobile apps and other platforms relying heavily on SQLite for its portability not because of easier sql

  • @hack_nug
    @hack_nug Před měsícem

    similar syntax to sanity's groq. might have to try this soon

  • @hellowill
    @hellowill Před měsícem +1

    So its just a wrapper for SQL... meaning you are still using SQL.
    Also (slightly related) I am sick of people saying NoSQL is better because of performance/scalability. You can scale SQL lol. You pick NoSQL if it fits your data model better.

  • @inferzard
    @inferzard Před měsícem

    Why not Postgres + JSONB columns?

  • @p99chan99
    @p99chan99 Před měsícem +1

    No... keep the name, I can finally say that I'm 'edging my database' (gen z brainrot is catching up to me fr 🗣)

  • @brennan123
    @brennan123 Před měsícem

    So is this actually a database, maybe I'm missing something but it just seems like a language that compiles to SQL? Why is it not communicated that way? Seems like neither edge nor a database. BTW, PostgreSQL has hierarchical queries already via recursive common table expressions (CTEs). Even if it is just a language on top of SQL this looks very promising and I'm excited to see where it goes.

    • @erenjeager1756
      @erenjeager1756 Před měsícem +1

      It is exactly a language that compiles to SQL and its set of tools, it uses Postgres under the hood

    • @rapzid3536
      @rapzid3536 Před měsícem

      @@erenjeager1756 Wait, is it really not customizing the storage or anything?

  • @VinayKumar-vu3en
    @VinayKumar-vu3en Před měsícem +1

    The iceburg is coolest thing ever

  • @user-kt1iz4vc3x
    @user-kt1iz4vc3x Před měsícem

    this is not an advertisement trust me bro 100% legit pinky promise they are all my friends but this is for real you know me i mean you don't know me irl but whatever, suscribe!

  • @RasmusSchultz
    @RasmusSchultz Před měsícem +1

    so it's not a database and it does not run on the edge - Edge DB is the perfect name! 😂
    this is more a "backend in a box" and less a DB, isn't it? you can't even access the PostgreSQL underlying. (which would worry me. 🤨)

  • @M-Wulff
    @M-Wulff Před měsícem

    Get that first sql sharpened using “with” syntax.

  • @0x00official
    @0x00official Před měsícem

    thank you. I edge to this database

  • @denisblack9897
    @denisblack9897 Před měsícem

    Guys I got it! Nobel prize moment: THE MOAT IS IN THE FONT!😅