Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

other-emerald

10/13/2024

Possible type problem on the client

```typescript const neonDatabase = await neonApiClient.POST("/projects", { body: { project: { name: newBusinessId,...

like-gold

10/12/2024

Database branching VIA CLI & Organizations

Hello me & my team would like to create some database branches via the CLI for each team members local development environment. Is there a way to do this with the CLI? The project is hosted under an organization. We've tried many different ways to get it to branch via CLI but it doesn't seem to want to find the project in the org. ...

other-emerald

10/11/2024

Preview deployments on tenants?

Hi, I have being working for a while on migrating our current database into a database per tenant architecture on Vercel and I'm almost done. For preview deployment, we use the Vercel integration but what happend for tenant databases? I have a script for migrations very similar to this one: https://github.com/neondatabase/db-per-tenant/blob/main/migrate.ts ...

sensitive-blue

10/8/2024

Data-Level Diffing

Wanted to know if Data-level diffing will be supported instead of just schema level

correct-apricot

10/8/2024

The autoscaling seems a little too motivated

Hey friends, I activated autoscaling but it seems to want to go full throttle at any time. I'm happy for some hints as to how I can optimize my setup to be a little more efficient. I attached a metrics screenshot and am happy to provide more details....

wise-white

10/8/2024

Very slow external connections to PostgreSQL

Hi, Starting of today it takes forever to connect to my DB using PGadmin or any other way which is not the build it "SQL Editor". This already happened once, a several days ago, and after several hours was back to normal. Why does this happen? and how can it be fixed ?...

sensitive-blue

10/7/2024

Does a project's connection string changes value?

When a project is created and assigned a connection string, will this value ever change on its own? I read the code here: https://github.com/neondatabase/db-per-tenant And I thought of storing the connection uri per project in the db. Would like to clarify first that connection strings in neon don't change before I do this....

helpful-purple

10/6/2024

postGis on postgress 17

Hi, when will Neon support postGis on postgress 17. Would like to upgrade from postgress 16 to 17 but need postGis. thnx in advance...

dependent-tan

10/6/2024

Auto scale & pricing plan clarification

Hi, We are a nonprofit organization dedicated to engaging students through our online quiz and exam platform. Our platform plays a crucial role in enhancing learning opportunities for thousands of students nationwide. Currently, we are operating under a Microsoft Azure sponsorship, which has been instrumental in supporting our mission. As we evaluate PostgreSQL database options, Neon has caught our attention due to its promising features and scalability options. We are considering Neon for our online quiz and exam platform and would appreciate some clarifications regarding your pricing plans and autoscaling capabilities. ...

afraid-scarlet

10/4/2024

Inngest Replication

Hey i've been setting up logical replication and using the Neon replication integration with Inngest. It looks like it works after setting it up, then it suddenly disables itself? Am currently on the free plan, and can see the inngest role within the table, but its set to active = false when looking at pg_replication_slots...

jolly-crimson

10/3/2024

Help Needed: Error with Postgres Schema, OpenAI Embedding and Prisma

I'm currently working on saving OpenAI embeddings in a Postgres schema, and I'm encountering a TypeScript error. Below is the schema I'm using: model SentenceEmbedding { id String @id @default(cuid()) voiceNoteId String voiceNote VoiceNote @relation(fields: [voiceNoteId], references: [id], onDelete: Cascade)...

correct-apricot

10/3/2024

PostGIS extension not installed on Postgres 17

Message from Fix with AI: ``` -- Failed query: -- CREATE EXTENSION IF NOT EXISTS postgis; -- Query can't be composed effectively....

genetic-orange

10/2/2024

restoring root branch creates new root branch that can't be deleted

I had my main branch and a child branch. I restored the parent to match the child. It created a grandchild with name prefix main_old that I can't delete because it's considered a root branch. I can't delete the child (main-1) either because it has its own child (main_old).

wise-white

10/1/2024

Connection Issues psql: error: connection to server, port 5432 failed: Connection refused

Hi I'm using Prisma and Next.js and have managed to connect my app to my neon db instance before but now the connection is being refused. I have two instances pointing to the same db, one locally (broken) and one from vercel (working). I've tried connection pooling but that doesn't seem to work either....

absent-sapphire

9/30/2024

NEON P0 ERROR

We have a terrible data issue that is a P0 blocker for our business. I checked my main database tables today and saw that the data is all wrong. When I looked at the snapshot branches I took from the last 3 days, the data was correct. I don't have a way to see the audit trail of actions taken against the database so have no way of knowing what happened. I did not personally make any changes to my Neon DB over the last week....

absent-sapphire

9/30/2024

is there an ability to see the audit trail of changes?

would love to see when someone made some changes

quickest-silver

9/29/2024

Drizzle/Vercel/Neon CI Pipeline

Hello everyone, does anyone has a github actions pipeline for drizzle/vercel/neon ? I am mainly looking for running migrations on preview/pull request and push. The default integration with vercel and github from the dashboard don't run migrations

stormy-gold

9/28/2024

Using Transactions in a Script

I'm trying to run a transaction in a file using tsx (e.g., tsx index.ts), but I'm getting the following error: "Error: All attempts to open a WebSocket to connect to the database failed." Is it possible to run transactions in this setup? When I remove the transactions and switch to using Neon HTTP, everything works, but I'd prefer to keep the transactions in place....

foreign-sapphire

9/27/2024

Transactions with Drizzle

I am a developer working with Drizzle, Neon, and Vercel in an edge deployment environment. I am experiment with Neon db in a personal project after using Vercel PG for a while. Considering that Vercel PG uses Neon, I expected that there would be little issue with swapping out the drivers. However, I was a bit confused when my transaction I ran with the http driver failed. I did a bit of researching and looking through this forum and it seems that the http driver does not support transactions. While I think it is clear enough with how to change from http to websocket, I have a few questions I would like answered: 1. Why is it that http transactions are not supported? I am nowhere near a networks expert so I am genuinely interested in what the challenges / reason are for why it has not been added when it is such a popular functionality of sql. 2. Is there a current roadmap to add support for http transactions? 3. When working in my environment described above, what do I lose in terms of performance and DX when I make the change from http to websocket? ...

automatic-azure

9/26/2024

How to run migrations exactly once with Turborepo connected to multiple projects on Vercel?

I have a Turborepo with "web" and "api" apps, and a "db" package that's used by both apps. I also have 2 separate projects on Vercel, both are connected to this Turborepo. The "web" project is deploying the web app on "mysite.com", and the api project is deploying the api app on "api.mysite.com". The "db" package has the following npm script: ```...

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord