Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

unwilling-turquoise

4/15/2024

How to use Neon WSProxy with Prisma and Vercel Edge Functions.

I'm currently having trouble Neon's WS Proxy (Here) with Prisma, especially how I should fill out the variables and what URIs I should put in. My .env currently: ```env DATABASE_URL="postgresql://coolperson:<private>@example.com:1234/postgres"...

modern-teal

4/15/2024

How can I see what consumes the storage in my database?

A few hours ago I saw that I had exceeded +/- 14MB of NeonDB's storage limit (512MB), so I decided to delete some unused data from old versions, which are no longer used, around ~26,000 rows were deleted, so I went to lunch So I went back now and saw that my storage usage did not decrease, but increased from 526/512MB to 617/512MB, and the query I use does not reflect this entire size, I wanted to know if there is any query where I can better see the usage of storage for these tables, I wanted to know where these 600MB+ are allocated, or if there are any tools in Neon for this... The query I usually use:...

broad-brown

4/15/2024

Neon and Sequelize?

I have an existing node.js web app that uses Sequelize (https://www.npmjs.com/package/sequelize) to interface with my postGres db. Is Sequelize compatible with Neon?...

broad-brown

4/15/2024

Import an Existing PostGres DB?

Is it possible to import an existing postGres database to Neon?

genetic-orange

4/15/2024

Use Prisma

Hello 🙂 I am trying to use Prisma and Neon and it is working but... I want to know the best practices : I have the production on main. ...

genetic-orange

4/14/2024

Determinsitic Connection Strings

Hi All! I am investigating using Neon as a source for pull preview DBs combined with ArgoCD. I saw the blog post about how to do it with ArgoCD but I’m wondering if there may be a more deterministic way. Is there anyway to guess what the connection string will be if we know the branch name ahead of time? That way we could inject the url in the app set vs needing to connect to argocd from GitHub actions.

exotic-emerald

4/14/2024

Very high latency when connecting to neon

Hi, I'm facing an issue when connecting to neon, it take too much time. I'm using CodeIgniter 4 & cloudflare. Btw the latency in local is around 300ms and on production it reach 3000ms. Anyone know why this is happening? Btw I'm from Indonesia & I choose Singapore for the region, not really that far right?

automatic-azure

4/14/2024

How can I see the exact SQL statement that Drizzle is sending to Neon?

I am trying to execute an upsert on Neon table with a unique constraint. The upsert fails with an error message citing the unique constraint. I was expecting the upsert to succeed because I am using the same value. In other words, I am not inserting a new row with a duplicate value in the column with the unique constraint. In a situation like this, I want to understand how I would troubleshoot using a combination of Drizzle and Neon....

wise-white

4/13/2024

Restore database returning a 500

I'm trying to restore my database to a time but I'm getting a 500 error. It works in another project but this project doesn't seem to want to work. Not too much more info to share the error has no message.

plain-purple

4/13/2024

Diagnosing PGVector query variance

I'm running into a huge variance in response times (250ms -8000ms with an average case latency is fine at ~400ms.) in a Postgres query and trying to understand the source of the issue. We have a Neon Postgres instance with a few tables that use pgvector for embeddings and OpenAI text-embedding-3-small embeddings. We're hosted on Vercel and using Neon through their integration. We use this for is a query that's a hybrid embedding and popularity search. The table isn't very big, it's about 35k records. The order by can't use the HSNW index because we're doing some math with it. Basically cosine distance + custom popularity score so we're in for some trouble. ...

afraid-scarlet

4/12/2024

Github integration add button not doing anything

When pressing the highlighted button nothing is happening. shouldn't a dialog popup like with other integrations?...

rare-sapphire

4/12/2024

how to force ipv4?

I'm using a postgres tool written in Erlang (ElectricSQL) that's apparently struggling to connect via ipv6 — I'm not entirely sure how this works but is there a way / address that for sure is ipv4?

correct-apricot

4/12/2024

Unable to `CREATE EXTENSION postgres_fdw`

Hello! I'm trying the postgres_fdw feature on my free-trial cluster with my automatically created user. However, the feature requires superuser to create the extension first, so it failed. Is this expected or any suggestion for this? ``` CREATE EXTENSION postgres_fdw;...

xenial-black

4/12/2024

Error: node_modules\.pnpm\ws@8.16.0\node_modules\ws\lib\buffer-util.js

Hey! Im developing an app using - Neon (serverless) - Prisma...

absent-sapphire

4/12/2024

Neon vs Turso - Multitenant & scale to 0

Looking for a multitenant, "scale to 0" DB solution What kind of trade-offs am I looking at by choosing Neon over Turso? (I don't have much interest in turso "edge" stuff atm)...

flat-fuchsia

4/12/2024

PSQL CLI Help Needed

I have connected my neon db using psql cli. Now when I try to access the contents of any table it shows relation does not exist. However on my neon db, I can see all the table data. Can someone explain what the problem is?

fascinating-indigo

4/12/2024

MultiFactor Authentication for neon portal

Hi, I am currently migrating from msSQL to postgres and I want to use Neon, im trialling it on the free tier but im curious is there no MFA for the portal?

adverse-sapphire

4/10/2024

Help using transactions with Drizzle

Hello! I am a little confused on how to set up and use Neon to enable transactions. I can see in the docs here (https://github.com/neondatabase/serverless?tab=readme-ov-file#pool-and-client) that Pool and Client need to be used, but unsure of how this would look exactly / impact my app. I am using Drizzle in a Remix app. Are there any examples anyone can share on how to migrate this type of config to use Pool & Client?...

fair-rose

4/10/2024

ERROR: get data with Prisma and Neon database

Hi, i got this error when i'm trying to call prismadb to get data. I'm using Neon database, Prisma and Next.js

deep-jade

4/9/2024

Using a non-primary branch when cloning for previews in Vercel integration

Hey! I’m working on migrating to using Neon for our already launched Vercel project. I’m very excited that the Vercel Integration is GA and I’m eager to start using it once the transition PRs go to production. One thing I’m hung up on: Can I use a branch for cloning for previews that is not the primary branch? I want to keep the production branch set to primary, but use a different branch, say, preview-template, when generating preview branches....

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord