EdgeDB 2.0 • Hacker News Board

Re: EdgeDB 2.0

#41

Post by jimbost » Thu, Jul 28, 2022, 7:12 PM UTC

I like being "close to the metal" when it comes to database queries. I don't want to learn an ORM api, and neither EdgeQL; I just want to do the thing I already know how to do.

PureORM[0] is this right balance of write SQL, get properly structured data.

[0] https://github.com/craigmichaelmartin/pure-orm

Re: EdgeDB 2.0

#42

Post by RedCrowbar » Thu, Jul 28, 2022, 7:17 PM UTC

Rochus wrote: post #30

1st1 wrote: post #29

Earlier quoted context omitted.

Just a side note: EdgeDB doesn't implement OOP persistence, so it's not an classical object database.

Sure, but I recognize concepts we were dealing with in the nineties; I assume you are aware of ODMG and OQL.

Yes, you can easily put OQL in the list of prior art EdgeQL was inspired by.

Re: EdgeDB 2.0

#43

Post by melony » Thu, Jul 28, 2022, 7:22 PM UTC

Can you improve the deployment story for wireguard to match the native PostgreSQL experience? Currently deploying EdgeDB requires setting up multiple VPN connections and environmental variables. Ideally it should be one click, zero-config just like Postgres.

Re: EdgeDB 2.0

#44

Post by 1st1 » Thu, Jul 28, 2022, 7:24 PM UTC

melony wrote: post #43

Can you improve the deployment story for wireguard to match the native PostgreSQL experience? Currently deploying EdgeDB requires setting up multiple VPN connections and environmental variables. Ideally it should be one click, zero-config just like Postgres.

Yeah, that will all be simplified when we launch our cloud. Our goal is to make it possible to deploy to cloud with one short cli command. We'll have it soon.

Re: EdgeDB 2.0

#45

Post by fghjp » Thu, Jul 28, 2022, 7:30 PM UTC

Conceptually it sounds a bit like Semmle's CodeQL? Except a general purpose database rather than one optimised for storing program code.

Re: EdgeDB 2.0

#46

Post by 1st1 » Thu, Jul 28, 2022, 7:32 PM UTC

fghjp wrote: post #45

Conceptually it sounds a bit like Semmle's CodeQL? Except a general purpose database rather than one optimised for storing program code.

I'll check CodeQL out, thanks!

Re: EdgeDB 2.0

#47

Post by canadiantim » Thu, Jul 28, 2022, 7:33 PM UTC

1st1 wrote: post #25

canadiantim wrote: post #9

Earlier quoted context omitted.

Yeah I really want to use EdgeDB, but I need full text search somehow. Options would be: 1. Somehow being able to query underlying postgresql database using traditional postgres FTS queries 2. Something like ZomboDB to bring the data into ElasticSearch or other like PGroonga 3. Ideally there would be some kind of FTS within EdgeDB so no need for another service

We'll be working on (3) soon and maybe (2) shortly after.

That’s great to hear. Option 3 is the best choice too as it allows for the FTS results to also be constrained by the object level security access logic. Thanks for the great work and replies!

Re: EdgeDB 2.0

#48

Post by colinmcd » Thu, Jul 28, 2022, 7:37 PM UTC

jimbost wrote: post #41

I like being "close to the metal" when it comes to database queries. I don't want to learn an ORM api, and neither EdgeQL; I just want to do the thing I already know how to do. PureORM[0] is this right balance of write SQL, get properly structured data. [0] https://github.com/craigmichaelmartin/pure-orm

EdgeDB is a long-term effort for a DB/query language that's as intuitive as possible for the greatest number of people. The early adopters are primarily those who are frustrated by ORMs and/or SQL, as you'd expect. But you should pick whatever makes you most productive—if you're already productive and happy with SQL, then that's definitely the right choice! Good luck with PureORM, looks very cool.

Re: EdgeDB 2.0

#49

Post by turtlebits » Thu, Jul 28, 2022, 7:38 PM UTC

Been using EdgeDB for ~6 months and it's great. I do wish the documentation was better (more examples please!). I spent more time than should be necessary trying to figure out simple things like NOT NULL, or how to get a backref for a linked table.

Re: EdgeDB 2.0

#50

Post by gz5 » Thu, Jul 28, 2022, 7:43 PM UTC

very nice.

you may want to check out openziti (open source) to eliminate vpn (while closing EdgeDB server and Postgres server link listeners and open IB FW ports). can be done agentless via sdk, or modified jdbc driver. basic postgres example video here: https://youtu.be/s-skpw7bUfI

disclosure: i run a company that built saas on top of the openziti open source.