Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

exotic-emerald

4/21/2024

npx prisma db push error after migrating from Planetscale to Neon

Hello guys! I've recently migrated my database from Planetscale to Neon, the migration was successful, and everything is okay. But once I tried to run npx prisma db push, I got the following output with warnings and this error, even If I change nothing in the schema: PS: This happened only after I did the migration. What should I do? Any hints please guys? Your help is much appreciated, and have a great day everyone!...

adverse-sapphire

4/21/2024

Postgres JSON field

Hi, is there a specific way to use JSON data in neon? I have a JSON field in one of my tables I can insert it to my local postgres database on my machine but when I send it to Neon I get a syntax error....

reduced-jade

4/21/2024

understand compute

Hello I want to know what mean 1 project in free tier. The compute is for each database, project or branch? Thanks

genetic-orange

4/20/2024

NeonDbError: Error connecting to database: fetch failed

Hi team, I was using Drizzle to migrate the database from the preview branch that was integrated with Vercel, but I got that error. Here are the code snippets:...

sensitive-blue

4/19/2024

I enrolled in the Scale plan through AWS marketplace, but it did not connect to my account

I navigated to the AWS Marketplace through my neon dashboard, I set everything up, but it didn't seem to make the connection back to my neon account, I'm still listed on the free tier. Thanks in advance!...

xenial-black

4/19/2024

endpoint is temporary unavailable. check your quotas and/or contact our support

Hello I am starting having this error but I don't see any resspource overuse...

future-harlequin

4/19/2024

Error passing query vector into Neon db

Sorry for a dumb question. It's my first time using PG / Neon so I apologize in advance. I'm building a Next.js web app which allows semantic search of my PG database. I've successfully set up embeddings, which are type "vector" in Neon (using extension pgvector). However, when I enter a query, something breaks once I send my SQL query from Javascript to PG. I know this because I can successfully hardcode my SQL query in Neon...

helpful-purple

4/18/2024

Error: No database connection string was provided to `neon()`

Hi guys, i'm trying to use neon db in a next js app, i've set my enviroment variables in a .env.local file but im getting this error.

foreign-sapphire

4/18/2024

JDBC: Connection problems

Hi guys! I'm having some troubles using Spring Boot and the PostgreSql database connection, could someone help me? The JPA Hibernate make this select: Hibernate: select c1_0.id,c1_0.cnpj,c1_0.firm_value,c1_0.foundation_year,c1_0.ipo,c1_0.market_segment,c1_0.name,c1_0.number_of_papers,c1_0.sector,c1_0.segment from public.companies c1_0 And I'm getting this Exception message:...

flat-fuchsia

4/18/2024

Error during migration: NeonDbError

Hello guys, I recently started learning drizzle and was implementing drizzle + neon database. So I built my schema, generated a migration file. All was good till then. But when I try to actually implement the migration into my neon database. I am getting this error: ``` Error during migration: NeonDbError: there is no unique constraint matching given keys for referenced table "tests" at execute (backend\node_modules@neondatabase\serverless\index.js:1546:39) at process.processTicksAndRejections (node:internal/process/task_queues:95:5)...

wise-white

4/18/2024

Compute hour discrepancy?

Why does my branch say 16.59 h compute time while my billing say 0.02/5 h (which feels much more accurate) ? Thanks in advance 😀...

multiple-amethyst

4/17/2024

Cannot connect to Neon database from local machine (Node)

Hi, I want to interact with my Neon database from my machine (that will make development easier) I'm using Node + Express as an API that communicates with Neon. I can connect to the database with pgadmin and psql from my machine. The deployed version of the API can connect to Neon as well, but I can't connect from local Node....

like-gold

4/17/2024

"Common name is not known" when connecting with psycopg2

Hello, I'm trying to get psycopg2 to connect to my database. This is what my call to psycopg2.connect looks like: connectstring = "postgresql://[USER]:[PASSWORD]@eu-central-1.aws.neon.tech/[DB]"
url = up.urlparse(connectstring)...

wise-white

4/17/2024

Startup Time

During the months of Preview, we put a special focus on improving our scale to zero and cold start behavior. Today, tens of thousands of Neon databases scale to zero every day, saving developers money. And we keep working hard on our cold start metrics: we are now at a P50 of 500 ms to start a database, and we’re working to reduce it further. https://neon.tech/blog/neon-ga

A) This is awesome....

extended-salmon

4/16/2024

History retention inconsistent across the console

On my dashboard, it's showing that I have a 7 day history retention. In my actual project settings, it's saying I have a 1 day retention. I'm on the free plan, so should I assume that "1 day" is correct?

rare-sapphire

4/16/2024

Preview Github Actions

Hello 🙂 In this video, we are creating a CI/CD preview with Github Actions : https://www.youtube.com/watch?v=jjRasfbeYHk ...

wise-white

4/15/2024

Neon and Migrations

My current node.js app uses Sequelize. When I update my schema in Sequelize, and call: myModel.sync() with alter == true ...Sequelize automatically updates my database tables to match the new schema. ...

stormy-gold

4/15/2024

pgbounder=true + prisma

Is pgbouncer=true needed when used with prisma? I saw recent changelog that maybe its not required from neon side (https://neon.tech/docs/changelog/2024-02-23-console), but doesnt prisma use this part of database url string to determine how to execute certain queries/close connections?

rival-black

4/15/2024

Can I change my email to a different one but remain linked on GitHub?

The email I'd like to switch to is my on GitHub already. I'm going to lose my school email soon when I graduate, and I don't want to lose access to my Neon account too, but I'd still like to keep using GitHub as my login method rather than password. Trying to change my email tells me I will be unlinking GitHub, but I'm not sure if this is reversable or if I would have to create a new account to have SSO.

deep-jade

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"...

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord