3 ms·
Supporting Postgres is a good goal but honestly the real challenge is extensions. Would supporting Postgres wire compatibility guarantee any Postgres extension
by SOLAR_FIELDS 3mo 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
- lmz 3mo ago> Would supporting Postgres wire compatibility guarantee any Postgres extension would also work? It would not, for obvious reasons.
- SOLAR_FIELDS 3mo agoCare to elaborate? The reasons are not obvious
- dumah 3mo agoWire 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.
- SOLAR_FIELDS 3mo agocurious 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?
- amluto 3mo agoThere’s a section about extensions in the FAQ.