6 ms·
EdgeDB 3.0
- deleted 3y ago[deleted]
- abdellah123 3y agoCongratulations on the launch. Fascinating set of features!!
- 1st1 3y agoThanks!
- abdellah123 3y agoBI and analytics tools often require writing SQL (so 90's) ... Is there a way to write EdgeQL and generate the corresponding SQL? That would be so much better!
- aerzen 3y agoAnalytic queries are not the primary intended use of EdgeQL. It would be doable, since EgdeQL is compiled SQL within the edgedb server, but this compilation depends on the schema of the database - quite heavily actually. It expects specific table and column names, so it would not work for an arbitrary database that you have. It would be possible however, to take an empty postgres instance, hook edgedb server to it, apply your schema and insert all the data.
- 1st1 3y ago> Analytic queries are not the primary intended use of EdgeQL You can write analytic queries with EdgeQL now, albeit we do need to add support of windowing. While we certainly prioritize usefulness of EdgeQL for the kind of efficient data fetch operations you need when you build apps and services, the language itself was designed with a goal of becoming equally good for analytics too. We'll get there.
- CoolCold 3y ago> but for non-DBAs, explaining that SQL would be overwhelming Is it sort of sarcasm or it's cruel new reality, Team behind EdgeDB observes?
- 1st1 3y agoIt's a reality, Posgres' analyze output wasn't designed for the plans that EdgeQL commands can have, given the composable nature of our language. You can just do much more in one op and that balloons the plan. Not in a bad way, but you have to know how to read those things to make good understanding of it. Our goal is to streamline this for EdgeQL as much as we can.
- 698969 3y agoLast time I looked at EdgeDB, it needed a separate process/server from the Postgres database. Has that changed since then? Would it be possible to turn EdgeDB into an extension of sorts rather than running it in a separate process?
- 1st1 3y agoEdgeDB is designed on the assumption that it fully controls and manages the underlying Postgres instance. This is why we can have a better/faster binary protocol, proper connection pooling on both client and server, and many many other perks. Making it an extension would drastically limit what you can do with it, and besides, it will take years to make this extension available on AWS and others anyways. All in all, it's not worth it, even though on a surface it sounds like a good idea.
- sp33der89 3y agoI found the developer experience of EdgeDB to be really great. A CLI tool that does all the work, a very declarative schema language that is easy to learn, migrations built in. Helpful error messages The dotnet and TypeScript libraries were great as well. All around a fun DB to use, and it builds on PostgreSQL instead of reinventing the wheel. It's really hard to get people to not-use SQL and one should always look what tool is right for the problem. But I hope a lot of more tools/libraries aim for this kind of enjoyable experience.
- 1st1 3y agoHuge thanks for the great feedback, I'm glad you're enjoying EdgeDB!
- aitchnyu 3y agoMy wishlist is postgis (my fave sideproject theme) and typesafe python query builder. With the latter, Edgedb could exceed the boosts Django offers.
- 1st1 3y agoBoth are on our list to start working on soon.
- andersrs 3y agoMight be time to update the roadmap here. Good to see triggers. I need window queries and subscriptions and then it might become my goto DB for small projects.
- 1st1 3y ago> I need window queries and subscriptions We'll get there.
- scottmas 3y agoThis is one project I’m rooting for. The world needs better than SQL
- 1st1 3y agoYes it does :)
- sgu999 3y agoI was enthusiastic about the name and it looks neat, but it doesn't seem like it's made to compete with SQLite for use cases on the "edge" of the network.
- 1st1 3y agoWe might support SQLite one day (not working on that right now, but there's some foundational work on that going on).
- 1st1 3y agoHey, I'm Yury, CEO and co-founder here, eager to chat with you about EdgeDB.
- maximilianroos 3y agoCongrats on the release! Really excited to see EdgeDB continue to grow.
- 1st1 3y agoThank you!
- FrustratedMonky 3y agoDoes it, or will it, support Cypher query language?
- RedCrowbar 3y agoNo plans for that yet. We feel EdgeQL is a far superior choice for the intended use case of application development.
- gavinray 3y agoI find the support of plain SQL over the Postgres wire protocol (intended for BI usecases) really interesting. The article mentions a "SQL-to-SQL" compiler -- how exactly does this work? Are you intercepting plain SQL queries over the wire, analyzing them, and then rewriting them into the form of queries that EdgeDB internally generates?
- RedCrowbar 3y agoYes, although rewrites are fairly minimal. Mostly limited to name mangling.
- gavinray 3y agoThat's really cool. Any chance you'd be able to link the relevant parts of the code? I had a look through the "/pg" directory but there was a lot there and it wasn't immediately clear which parts did what
- nikivi 3y agoWill EdgeDB Cloud be fully replicated similar to https://neon.tech https://neon.tech? I want to use EdgeDB Cloud but I want the latency to be that of Grafbase for example. benchmark here: https://edge-data-latency.vercel.app https://edge-data-latency.vercel.app I know EdgeDB exposes GraphQL as part of plugin. I assume EdgeDB Cloud lets you setup production GraphQL setup without any effort? 3.0 looks very exciting, well done.
- 1st1 3y ago> Will EdgeDB Cloud be fully replicated similar to https://neon.tech https://neon.tech? Eventually yes. Our client libraries APIs are designed in such a way that it's easy for us to automatically route read queries to the nearest replicas and do other magic. > I want to use EdgeDB Cloud but I want the latency to be that of Grafbase for example. We'll be working on lowering the latency as much as we can. But you also have to keep in mind another aspect - which is the composability of EdgeQL, which allows you to pipeline multiple operations in one query. That query will get you all of your data in one round trip, something that doesn't typically happen with ORM libraries and SQL in general. > 3.0 looks very exciting, well done. Thank you!