Add node_compatibility option?

[felpsio]

Hi,

Very often, I struggle with using non-trivial libraries for my project in Hydrogen. The latest library I'm trying to integrate is pg (postgres).

Hydrogen seems to use Cloudflare, and I noticed that the library does work on Cloudflare. But you need to activate the node_compatibility mode. I was wondering if we could add this option to projects deployed on oxygen as well.

We could have something like this in the route component:

export const config = {
  node_compatibility: true
}

This would indicate to use node_compatibility when processing the related route. In the future, the configuration object could be extended to support more options.

Why do I need postgres?
I'm adding some AI features to my store and a relational database makes it easier to handle some data cleaning necessary for my custom model. So I was hoping to use a combination of Shopify database with the SQL one.

[juanpprieto]

cc @frandiox

[frandiox]

Unfortunately, this is not something we can support at the moment because it's not an API available as of today in Oxygen, the platform where you deploy your production apps by default when using Hydrogen.

This might change in the future but, for now, an option would be relying on some HTTP service to connect to your Postgres DB. For example, Supabase provides a Postgres instance that should be compatible with Hydrogen/Oxygen because you'd just use HTTP connections to query your DB. They also support pgvector, which might be useful for your AI features.

[felpsio]

Thanks for the feedback :).

Yep, I've been using Supabase but they're not reliable at all. I'm getting a high rate of read/write errors even after paying for dedicated resources.

So I'm having to change to a more traditional database :(.