Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

eastern-cyan

10/24/2024

Grant "pg_read_all_data"

Hello, is it possible to grant pg_read_all_data/pg_write_all_data to a user created via sql? ``` grant pg_read_all_data to ${ownerCredential.user}; grant pg_write_all_data to ${ownerCredential.user};...

extended-salmon

10/23/2024

The database when it becomes idle and turns off

I need to keep my bank online at all times. However, when I make the first query of the day, it is turned off and takes twice as long. I already have a paid plan, how do I configure this option?

cloudy-cyan

10/23/2024

Connecting from Rust/Diesel-async times out. I've grabbed someone's sample code https://github.com/yasamoka/axum-diesel-async-example. If I update the .env with a local running postgres on 5432, the async connection works. If I update the .env to my Neon db URL, it times out. What am I missing?

harsh-harlequin

10/23/2024

best practice of Psycopg

@app.post("/update_error_collection") async def update_error_collection(request: ErrorUpdateRequest): conn = get_db_connection() cur = conn.cursor() ...

genetic-orange

10/22/2024

DuckDB extension support

Hi there, are there any plans to support the official DuckDB Postgres extension? https://github.com/duckdb/pg_duckdb

xenial-black

10/21/2024

Storage on free tier

In the dashboard it says I have 0.86 gib storage used, but my total databases size is much lower than that, and my only branch is also much lower than this number. I also have no other projects. My project id is soft-voice-87325806...

rare-sapphire

10/21/2024

New to NeonDB

I'm not sure how to fix this error. Anyone happen to know?

rare-sapphire

10/20/2024

Db connection issue?

this is my schema file and its a NextJS project, the database URL i have copied straight from the Neon project prisma connection and when it run prisma db push it generates this error i even resetted the password but still no luck.

absent-sapphire

10/20/2024

DB does not wake up when accessed from Thailand.

Hi there, I live in Thailand. I am evaluating Neon Postgres on the free tier. When I try to access the DB, when running locally, it doesn't wake up....

absent-sapphire

10/19/2024

storage issues for free tier

I hit the storage limit for my project, checked usage, seems like "All databases" accounts for a large account of storage. My actual databases don't have that much data. How can I check "All database" to clear this out? Project ID: tight-feather-63843647...

conventional-tan

10/19/2024

Turbo monorepo <> Vercel <> Neon setup

I have a very similar setup as what's described in this thread. The thread is a bit old so I wanted to check if this is still the path forward? I am specifically looking to see how can I achieve or come close to achieve the following:...

plain-purple

10/18/2024

problema em rodar o migration no Postgres

I am running dotnet ef database --project .\Infrastructure --startup-project .\MinhasPrioridades update noin neon tech and show it: (tested the connection with table and the worked, but when running migration not!) ...

foreign-sapphire

10/18/2024

Inngest integration

Does Neon send all db changes to Inngest, or is there a way to configure Neon which db changes should trigger an event to Inngest? Also, how could I make sure that Neon sets the correct x-inngest-env header in the request to Inngest? I have development/test/production branches in Neon and similarly 3 custom environments in Inngest. db changes in the development branch should triggest events to Inngest with x-inngest-env set to "development", etc....

fair-rose

10/17/2024

How to configure db suspense for Keycloak server

Since Neon showcases Keycloak https://neon.tech/blog/auth-setup-with-neon-keycloak-and-koyeb, I have a question regarding Keycloak configuration. I have set up a keycloak server (not koyeb though) after seeing this post, but there is a problem: Keycloak seems to maintain DB connection at least 1, which doesn't make use of Neon's most useful feature (idling). Does anyone knows how to configure Keycloak to set minimum DB connection pool size to 0?...

wise-white

10/16/2024

How to optimize vector similarity search

I use prisma as ORM and execute a raw query. In my table I have these rows : titleEmbedded Unsupported("vector")?...

absent-sapphire

10/15/2024

Need Help | Data Transfer at max on Free Tier, can't see my tables

Is there someway to check the data on my table since my data transfer just reached 5GB?

provincial-silver

10/15/2024

Space not reclaiming?

I deleted a bunch of rows from my table, but the space doesn't appear to be reallocation on my free tier., how can I get that space back?

like-gold

10/14/2024

Computes not going to idle

I have an Elixir app using Ecto (which runs it's own connection pool). My compute doesn't seem to ever go to idle while the app is running. Ecto's internal connection pool stays connected but shows as idle in the dashboard. I've tried both the pooled and unpooled connection options on the Neon side. From what I understand in the compute lifecycle and Elixir doc it seems that idle database connections should allow the compute to go to idle as well. ...

extended-salmon

10/14/2024

Bank shutting down

Good morning, I'm migrating to Neon but there's a behavior I'd like to change. I'm using the free plan but my bank "shuts down" when I don't make a query for a long time. Is there a way to keep it always on, or would I have to purchase a plan?

passive-yellow

10/14/2024

Applying drizzle migrations with Hono

Hi, I'm trying to apply that migrations on the directory like this: ```typescript await migrate(drizzleDb, { migrationsFolder: "./src/databases/tenants/migrations", })...

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord