4 ms·
> I really like the re-imagination of the type system, data model, and the user interface. This is an area where databases could be significantly better than th
by 1st1 8y ago
> I really like the re-imagination of the type system, data model, and the user interface. This is an area where databases could be significantly better than they currently are.
Thank you!
> Even on single machines, there is a performance cliff that arrives very quickly when doing these kinds of data model traversals unless you are using something exotic under the hood.
PostgreSQL is used under the hood. We compile EdgeQL to an efficient SQL behind the scenes, similarly to how you compile a high-level language to lower-level language. All our fancy data types fully utilize the relational model, so what's achievable with scaling Postgres will be achievable with EdgeDB. I know quite a few massive deployments of Postgres that work just fine, there's simply no reason why EdgeDB would be different.
- andyburke 8y agoCan you point an EdgeQL 'server' at, say, an Amazon RDS Postgres cluster?
- 1st1 8y agoNo. Some of the features required us to slightly modify Postgres, but we'll be trying to upstream the changes.
- webmaven 8y ago> Some of the features required us to slightly modify Postgres, but we'll be trying to upstream the changes. An occasional post tracking the status of that upstreaming effort would be very welcome.
- 1st1 8y ago> An occasional post tracking the status of that upstreaming effort would be very welcome. We've already found a few bugs in Postgres and upstreamed fixes for them. There is a patch or two from us in their review pipeline right now.
- webmaven 8y ago> We've already found a few bugs in Postgres and submitted fixes for them. There is a patch or two from us in their review pipeline right now. May I assume that the slight modifications you were required to make to postgres in order to support your features weren't just bug-fixes?
- 1st1 8y ago> May I assume that the slight modifications you were required to make to postgres in order to support your features weren't just bug-fixes? Yes. Some of them, like strict parsing of timezone-aware vs naïve datetimes can be upstreamed (as a configurable option) if the Postgres community accepts it. It's in our interest to upstream things like that :) We'll see how it goes.