Hacker News: RedCrowbar

New comment by RedCrowbar in "Fedora Linux devs discuss dropping 32-bit packages – bad news for Steam gamers"

RedCrowbar — Tue, 24 Jun 2025 15:39:29 +0000

Wine supports WoW64 since recently [1]

[1] https://www.phoronix.com/news/Arch-Linux-WoW64-Wine

New comment by RedCrowbar in "EdgeDB is now Gel and Postgres is the future"

RedCrowbar — Wed, 26 Feb 2025 03:57:34 +0000

You can use access policies [1] to emulate temporal data. See an example in [2]

[1] https://docs.geldata.com/reference/datamodel/access_policies

[2] https://github.com/geldata/gel/issues/4228#issuecomment-1208...

New comment by RedCrowbar in "EdgeDB is now Gel and Postgres is the future"

RedCrowbar — Wed, 26 Feb 2025 01:39:36 +0000

Strictly speaking we charge for compute and storage. You can create variously-sized Gel instances and within those instances an arbitrary number of branches.

New comment by RedCrowbar in "EdgeDB is now Gel and Postgres is the future"

RedCrowbar — Wed, 26 Feb 2025 00:55:42 +0000

The paper seems to mostly focus on the quality of cardinality estimation (mostly driven by statistics) which is admittedly one of the frequent sore points in Postgres. There's been some progress in that area though (CREATE STATISTICS being a highlight).

New comment by RedCrowbar in "EdgeDB is now Gel and Postgres is the Future"

RedCrowbar — Wed, 26 Feb 2025 00:10:42 +0000

That's already supported, you just need to set the Postgres cluster URI in the `GEL_SERVER_BACKEND_DSN` env var ([1]).

[1] https://docs.geldata.com/reference/reference/environment#gel...

New comment by RedCrowbar in "EdgeDB is now Gel and Postgres is the future"

RedCrowbar — Wed, 26 Feb 2025 00:08:55 +0000

You can use Docker (and Docker Compose) with Gel for local development [1], but of course you'd miss out on most management features of the CLI, because it's not built to supplant the docker/docker-compose CLI. Are there any particular issues you have currently with the Docker image approach?

[1] https://docs.geldata.com/resources/guides/deployment/docker

New comment by RedCrowbar in "EdgeDB is now Gel and Postgres is the future"

RedCrowbar — Tue, 25 Feb 2025 23:58:03 +0000

(article author here)

> If I use some other extension like timescale is that compatible with gel [...] Postgres is so powerful partly because of its ecosystem, so I want to know how much of that ecosystem is still useable if I’m using gel on top of Postgres

Playing nice with the ecosystem is the goal. We started off with more of a walled garden, but with 6.0 a lot of those walls came down with direct SQL support and support for standalone extensions [1]. There is a blog post coming about this specifically tomorrow (I think).

> And is there a story for replication

Replication/failover works out of the box.

> subscribing to queries for real time updates?

Working on it.

> so can I add gel to an existing Postgres instance and get the benefits of the nicer query language or does it rely on special tables?

Gel is built around its schema, so you will need to import your SQL schema. After that you can query things with EdgeQL (or SQL/ORM as before).

[1] https://github.com/geldata/gel-postgis

New comment by RedCrowbar in "EdgeDB is now Gel and Postgres is the future"

RedCrowbar — Tue, 25 Feb 2025 23:45:16 +0000

Gel as in gif obviously! :-)

New comment by RedCrowbar in "Show HN: PRQL in PostgreSQL"

RedCrowbar — Mon, 19 Feb 2024 23:19:02 +0000

EdgeDB is NOT an object store. It is "relational model enhanced" instead where a set is a fundamental building block [1] so not just relations are sets, but attributes can be sets also.

[1] https://www.edgedb.com/docs/edgeql/sets#ref-eql-everything-i...

New comment by RedCrowbar in "Jepsen: MySQL 8.0.34"

RedCrowbar — Tue, 19 Dec 2023 16:32:58 +0000

If your database client is any good, it should do the retries for you. EdgeDB uses serializable isolation (as the only option), and all our bindings are coded to retry on transaction serialization errors by default.

Transaction deadlocks are another common issue that is triggered by concurrent transactions even at lower levels and should be retried also.

New comment by RedCrowbar in "Show HN: EdgeDB Cloud and 4.0 with FTS and Auth"

RedCrowbar — Thu, 02 Nov 2023 19:07:12 +0000

Yes. Apache 2.0 licensed with lots of focus on local-first development.

New comment by RedCrowbar in "Show HN: EdgeDB Cloud and 4.0 with FTS and Auth"

RedCrowbar — Thu, 02 Nov 2023 16:25:58 +0000

There is a work-in-progress query builder support for .NET: https://github.com/edgedb/edgedb-net/tree/feat/querybuilder-...

New comment by RedCrowbar in "Show HN: EdgeDB Cloud and 4.0 with FTS and Auth"

RedCrowbar — Wed, 01 Nov 2023 17:56:17 +0000

We wrote a blog post about this specifically: https://www.edgedb.com/blog/why-orms-are-slow-and-getting-sl...

New comment by RedCrowbar in "EdgeDB 3.0"

RedCrowbar — Fri, 23 Jun 2023 05:08:15 +0000

> Can EdgeDB solve the problems like `soft-delete`?

Yes, with access policy rules. E.g

   global hide_deleted: bool;

   type SoftDeletable {
     deleted: bool;

     access policy hide_deleted
       allow all
       when (global hide_deleted)
       using (not .deleted);
   }

The above will effectively "hide" objects with `.deleted` set to `true` from all queries when the `hide_deleted` global is set to true.

> How about hooks, for example, I want to trigger scripts after/before a record is added to the table.

EdgeDB supports triggers: https://www.edgedb.com/docs/changelog/3_x#triggers. Future versions will add support for causing effects outside of the database, e.g. call a WebHook or some such.

New comment by RedCrowbar in "EdgeDB 3.0"

RedCrowbar — Fri, 23 Jun 2023 04:28:53 +0000

The whole thing consists of these main parts:

1. SQL parser: https://github.com/edgedb/edgedb/tree/master/edb/pgsql/parse... 2. SQL transpiler: https://github.com/edgedb/edgedb/tree/master/edb/pgsql/parse... 3. Wire protocol handler: https://github.com/edgedb/edgedb/blob/master/edb/server/prot...

New comment by RedCrowbar in "EdgeDB 3.0"

RedCrowbar — Fri, 23 Jun 2023 03:36:28 +0000

No plans for that yet. We feel EdgeQL is a far superior choice for the intended use case of application development.

New comment by RedCrowbar in "EdgeDB 3.0"

RedCrowbar — Fri, 23 Jun 2023 03:32:13 +0000

Yes, although rewrites are fairly minimal. Mostly limited to name mangling.

New comment by RedCrowbar in "EdgeDB 3.0"

RedCrowbar — Thu, 22 Jun 2023 18:02:28 +0000

Yes, we are looking into possibly supporting in-place upgrades in future releases.

New comment by RedCrowbar in "EdgeDB 2.0"

RedCrowbar — Fri, 29 Jul 2022 03:44:17 +0000

Efficient transitive closure (aka link recursion) is something we plan to tackle soon (see https://github.com/edgedb/edgedb/discussions/2634 for some discussion on the topic).

New comment by RedCrowbar in "EdgeDB 2.0"

RedCrowbar — Thu, 28 Jul 2022 23:44:16 +0000

Yes: https://github.com/edgedb/edgedb-go/issues/182

Feel free to jump in with suggestions, we need feedback from experienced Go devs.