Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

harsh-harlequin

3/10/2024

Microsoft Access/MY SQL How to Upload on Neon

I'm very new to Neon and SQL. I invited/shared people within the project but I'm not sure how to upload a Microsoft Access file/MY SQL file to Neon

wise-white

3/10/2024

Error in first migration (Prisma)

Hi, I used planetscale and i want to migrate my prisma schema. I run: npx prisma migrate dev --name init ...

like-gold

3/10/2024

Migrating From Planetscale

Hi, I am trying to migrate our MySQL database on PlanetScale to Neon (heard great things). I found this: https://neon.tech/docs/import/migrate-mysql When I run pgloader I get this ```...

sensitive-blue

3/8/2024

Sudden slowness querying from my local

I am having strange issues that happened overnight; in local only - the same queries that were running without a hitch suddenly timeout or are painfully slow. Both with Drizzle in Next.js and in TablePlus; something changed I see with HTTP/2 - could it be related ?

yappiest-sapphire

3/8/2024

Best column type for id field - Drizzle

Hi everyone. I am using Drizzle, Next.js 14 app router & Neon serverless. Could anyone help me sharing the best column type for id field in a table? I think a solution that is auto generating, random, yet not very large (like UUID) is best. Most tutorials show a type of either text or serial. But text does not automatically set the Id, so I can't use insert without providing an id field. Serial is auto incrementing, but I read that such auto incrementing id is bad for security (ids being predictable). UUID is another option but they take up a lot of space & have some other downsides (https://dev.to/harshhhdev/uuidguid-cuid-nanoid-whats-the-difference-5dj1) . So which one should I use? I would love if you could share a short example with your answer. Thank you....

fair-rose

3/8/2024

Manually add Products on Vercel DB.

Heello everyone. I have successfully deployed my clients webapp on vercel and hooked up vercel postgress db (I believe NEON powers it?). I need to manually enter my products in on of my models but can't seem to find a way to do that? Can anyone help with this?...

exotic-emerald

3/8/2024

How does connection limit works on the serverless driver?

hello, I am wondering when using the neon serverless driver, does it share the same connection limit with the "default connection limit", or Neon has an additional layer of pooling on top of it to automatically handle it?

sensitive-blue

3/7/2024

Can't get updated data after update data in production

hello, im using next js with prisma orm and SWR with axios for fetching from client and free tier neon database in my next js app, after updating the data and revalidate the data using swr, the data that i get is old data, this only happen in production mode even the database data is updated. but if in dev mode, its updated succesfully and always get new data...

dependent-tan

3/7/2024

Sudden error in an RO Replica

Dear Neon Team, we are currently switching from a self-hosted database to Neon and have been very pleased so far. I am personally performing the migration and have now encountered an error that occurs in a table, but only when I access it via the RO Replica....

hard-chocolate

3/6/2024

Slow replication with Neon CDC

Hey team, try to build a data pipeline with my neon db, and the replication process is super slow. I'm sinking CDC events from 2 tables in my Neon DB table to flink cluster on AWS in the same region. I increase the CPU to 7 and it doesn't seem to solve the problem. any idea what can cause this issue?...

wise-white

3/6/2024

OpenAPI Specification for the Neon API

Is there an OpenAPI schema available for the API at https://console.neon.tech/api/v2 ? We seem to have found one over a year ago, but I'm looking to have it updated....

metropolitan-bronze

3/5/2024

Encrypt columns

Is there a recommended way to ensure sensitive data is encrypted-at-rest when building on Neon ?

other-emerald

3/5/2024

Unstable connection with psql

The psql ssl connection drops all the time and then it's not possible to reconnect: ```bash psql: error: connection to server at "pg.neon.tech" (3.136.248.123), port 5432 failed: Operation timed out Is the server running on that host and accepting TCP/IP connections?...

sensitive-blue

3/5/2024

Unable to reset db

Hi, I needed to urgently reset my prod db due to a criticalissue. However neon is not letting me. Really quite disappointed in this service.

dependent-tan

3/4/2024

Speed issue with neondb connection?

I have created a simple Django app and made a connection with postgres in neondb . Currently, I am testing the application in localhost but after connecting with the hosted database instead of default sqlite the speed has reduced significantly(specifically the part where I access the components in admin panel but the default home http://127.0.0.1:8000/ loads normally maybe obv as no db connection required here ). Is there any way to fix it?

subsequent-cyan

3/4/2024

SNI workaround not working for PopSQL

I'm trying to set up PopSQL with my database. On neon docs it says that SNI workaround D is required, however, when I set the password field with the schema endpoint=<endpoint_id>;<password> or endpoint=<endpoint_id>$<password> both result in the error Uh oh :( password authentication failed for user <username>

flat-fuchsia

3/4/2024

2FA: Is Two Factor Authentication On The Road Map?

Locking down accounts with 2 Factor Authentication would be necessary for our adoption of the product (which otherwise looks awesome). Are there any plans to secure accounts? Thank you!...

mute-gold

3/3/2024

Does Neon support full text search for non-English languages?

Are Neon users able to access the filesystem (in order to implement custom dictionaries, stemmers, synonyms, etc).

vicious-gold

3/3/2024

Can't query my DB with SQL EDITOR

Hi everybody ! I'm so confused to not be able to query my DB with SQL EDITOR tool. Each time I try to query a table which exists in my DB (as you can see in the picture), I have the same error message "ERROR: relation "categorie" does not exist (SQLSTATE 42P01)"......

exotic-emerald

3/3/2024

Updates/Inserts transactions seems to be clogged every 500 records

Updates/Inserts transactions seems to be clogged for 30 seconds every 500 records. Am I missing something? Is this even scalable? We have to deal with hundreds of records every seconds.. Even if we have spare vCPU 8, the system only utilize 0.5 CPU.. Compare this with using dedicated VM, yeah, lack of branching, but performance is 100x better using dedicated VM

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord