search

supabase-community / postgres-new

In-browser Postgres sandbox with AI assistance
https://database.build
Apache License 2.0
2.34k stars 183 forks source link

Support for ltree and other extensions #82

Open mnahkies opened 2 months ago

mnahkies commented 2 months ago

Feature request

Support more postgres extensions, particularly ltree, but ideally all that pglite supports.

Is your feature request related to a problem? Please describe.

Unable to experiment with schemas relying on the ltree extension in https://postgres.new

create a table using the ltree extension

> The ltree extension is not available in this environment

Describe the solution you'd like

It looks like the extension is already supported by pglite https://pglite.dev/extensions/#ltree

Ideally I'd like all extensions supported by pglite to be available in https://postgres.new

Describe alternatives you've considered

I've worked around by executing the SQL on my local database instead, and tbh I'm pretty blown away by how accurate / helpful the AI chat assistant has been. Saved me a lot of typing, especially coming up with decent sample data to experiment with different schema designs.

Additional context

image