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

EdgeDB 2.0

edgedb.com

Post reply on HN
Print view View original

81–90 of 150 posts

Re: EdgeDB 2.0

#81

Post by jitl »

1st1 wrote: post #32
nikivi wrote: post #6

I want to build local first software backed by EdgeDB. Similar to these tools: - https://replicache.dev - https://github.com/tantaman/conflict-free-sqlite - https://aphrodite.sh I wonder if EdgeDB provides any utilities to make this already perhaps? Or community has to build some kind of CRDT software that builds on top of EdgeDB that will do local syncing? Maybe that's planned to be tackled for 3.0?

We don't have that yet. Maybe it will be possible to bootstrap EdgeDB to run on top of SQLite, but that will be a ton of work and limit the schema/language. Nothing prevents you from just running EdgeDB or even bundling in your app except packaging that can get a bit hairy.

Isn't EdgeDB a python program? I fear python packaging - especially inside a browser or Android device.

Re: EdgeDB 2.0

#82

Post by 1st1 »

jitl wrote: post #81
1st1 wrote: post #32

Earlier quoted context omitted.

We don't have that yet. Maybe it will be possible to bootstrap EdgeDB to run on top of SQLite, but that will be a ton of work and limit the schema/language. Nothing prevents you from just running EdgeDB or even bundling in your app except packaging that can get a bit hairy.

Isn't EdgeDB a python program? I fear python packaging - especially inside a browser or Android device.

It's a mix of Python, C, Rust, Cython, etc. It's fully safe-contained though, the fact that there's some Python inside is an implementation detail, you'll never know that as a user.

Re: EdgeDB 2.0

#83

Post by RedCrowbar »

btown wrote: post #75
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

If I have an existing Postgres database (on RDS) can I use EdgeDB to query it? Are there tools to generate a schema from an existing Postgres schema? Or is this mainly for green field projects without an existing database?

EdgeDB is very particular about how the underlying data is organized, so you can't put it in front of an existing database. Importing schemas and data is another story which we're working on.

Re: EdgeDB 2.0

#84

Post by RedCrowbar »

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).

Re: EdgeDB 2.0

#85

Post by topspin »

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

Have you considered cockroachdb as a backend database? I imagine that although the postgresql emulation of cockroachdb isn't 100% complete, the availability story of cockroachdb is miles ahead of postgresql, so perhaps it might be worth whatever adaptations are necessary.

Re: EdgeDB 2.0

#86

Post by RedCrowbar »

topspin wrote: post #85
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

Have you considered cockroachdb as a backend database? I imagine that although the postgresql emulation of cockroachdb isn't 100% complete, the availability story of cockroachdb is miles ahead of postgresql, so perhaps it might be worth whatever adaptations are necessary.

Alas, we have to wait until CockroachDB becomes a bit more capable SQL-wise. I gave a more elaborate answer in https://github.com/edgedb/edgedb/discussions/3403.

Re: EdgeDB 2.0

#88

Post by pdimitar »

I actually dig the declarative schema syntax. Is it something separate that one can use in various programming languages, or is it specific to EdgeDB?

Re: EdgeDB 2.0

#90

Post by pier25 »

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

I asked on Twitter but I'll ask again here :)

What's the current approach for triggers, subscriptions, etc?

Can you perform raw SQL queries through your client or do apps still need to use a separate PG client for that?

Post reply on HN