Hacker News new | ask | show | jobs
by SOLAR_FIELDS 16 days ago
Supporting Postgres is a good goal but honestly the real challenge is extensions. Would supporting Postgres wire compatibility guarantee any Postgres extension would also work? This is one of the problems with Aurora - it’s all well and good until you need an extension that isn’t on the blessed list
2 comments

There’s a section about extensions in the FAQ.
> Would supporting Postgres wire compatibility guarantee any Postgres extension would also work?

It would not, for obvious reasons.

Care to elaborate? The reasons are not obvious
Wire protocol applies to external interaction with the db.

Internal ABI/API is used by extensions to directly interact with core subsystems and depends on internal models for things like storage.

It might be analogous to HTTP versus an nginx plugin.

curious how hard it is to implement wire protocol compatibility vs the internal api surface. Are we talking like, an order of magnitude more work here? I wonder if, for example, Aurora team are literally maintaining forks of extensions for their implementation and that's why only a subset of all possible extensions are supported?