Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

variable-lime

5/18/2024

Cloudflare integration defaults to using non-pooler connection url

Just want to double check if this is wrong or not

unwilling-turquoise

5/18/2024

Manage role permissions

Good evening! I'm currently working on a project for a client and decided to use PostgreSQL in conjunction with Neon DB. I've already created a database, but I'm running into an issue. Three services/microservices need to communicate with the database, but I want to restrict access to only what each service needs to do. I created a role for each service and noticed that all of them have the CREATEDATABASE, CREATEROLE, and many other high-level permissions. However, they shouldn't have permission for these, so I tried to disable them. When I tried to disable them, I received an error:...

multiple-amethyst

5/17/2024

Database Size not getting decreased even after removed all the rows from table ?

Inserted thousands of rows in database and now dropped all rows, Still database size in not getting decreased, VACUUM not working, What can I do to recover database space ?

evolutionary-blush

5/16/2024

What is this SSL_do_handshake = -1

Why I have this response when I try to connect (SSL_do_handshake = -1) I am Using Delphi and Unidac

conscious-sapphire

5/16/2024

Lots of "SSL connection has been closed unexpectedly" errors

Hey there, we're using Neon as a DB for a control plane for batch processing jobs. We're on the Launch plan. Execution of batch processes have multiple k8s workers connecting to the DB to report the status of their job runs. This ends up creating a lot of concurrent connections. We've recently been seeing this error

qlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL connection has been closed unexpectedly
[SQL: UPDATE block_run SET updated_at=now(), status=%(status)s, completed_at=%(completed_at)s WHERE block_run.id = %(block_run_id)s]
[parameters: {'status': 'COMPLETED', 'completed_at': datetime.datetime(2024, 5, 16, 19, 12, 57, 459853, tzinfo=<UTC>), 'block_run_id': 32907}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

qlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL connection has been closed unexpectedly
[SQL: UPDATE block_run SET updated_at=now(), status=%(status)s, completed_at=%(completed_at)s WHERE block_run.id = %(block_run_id)s]
[parameters: {'status': 'COMPLETED', 'completed_at': datetime.datetime(2024, 5, 16, 19, 12, 57, 459853, tzinfo=<UTC>), 'block_run_id': 32907}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

...

national-gold

5/16/2024

cant' delete branch that is using lots of storage

I have a main/primary branch which we use but it seems to be the child of an old branch. There doesnt seem to be anyway to delete the old branch which we no longer need and is quite expensive given it is 50GB. Looked through all the options and there does not seem to be a way to detach and then delete....

foreign-sapphire

5/16/2024

got charged after canceling

I downgraded my account to free and still got charged I haven’t used my database at all, yet i still got charged what do I do. I couldn’t contact support because I downgraded but I still got charged.

metropolitan-bronze

5/15/2024

Local Neon for Development

Hi - I'm building a platform where I programmatically create (Neon) projects for my users. Obviously, I want to test this locally for development without creating real neon projects. What's the recommended way to do this? There seem to be a few ways to get Neon running locally: - Directly through cargo: https://github.com/neondatabase/neon?tab=readme-ov-file#running-local-installation - Via docker compose: https://github.com/neondatabase/neon/blob/main/docker-compose/docker-compose.yml...

foreign-sapphire

5/14/2024

Run Neon DB locally

I am loving using Neon DB however finding I am quickly using up my compute hours (free tier). I am not ready yet to pay for the service, so looking for a way that I can either mock our the DB (using something like MSW) or run a copy of the database locally. Does anyone have any tips or suggestions?

conscious-sapphire

5/14/2024

Migrating from Supabase due to Prisma connection mishandling?

Hello Neon Community, I’m exploring NeonDB as a potential solution for an application currently facing challenges with high traffic loads and extensive database connection usage via Prisma. Our main concerns revolve around effectively managing and scaling database connections during peak times. Given NeonDB’s serverless architecture and PostgreSQL compatibility, I’m curious about its performance under such conditions. How does NeonDB handle scenarios with high concurrent connections and intense read/write operations?...

optimistic-gold

5/13/2024

Knex with Neon Serverless Driver

I am using Knex.js as my query builder. I want to use it alongside Neon's serverless driver. I'm using this repo as an example (https://github.com/neondatabase/neon-vercel-knex/tree/main) However it is not working, I am getting the following error. Would really appreciate some help with I'm on "knex": "^3.1.0" and "neonctl": "^1.29.3" ...

dependent-tan

5/13/2024

Grant pg_read_all_data to roles

Hi! I'm trying to set up my neondb instance. Part of my migration files is grant pg_read_all_data to <role>. This doesn't seem to work because: DETAIL: Only roles with the ADMIN option on role "pg_read_all_data" may grant this role. I'm using my neondb_owner role to run the migrations. Is there something that needs to be done to enable the owner role to be admin on pg_read_all_data ? Thank you...

xenial-black

5/13/2024

Troubleshooting WebSocket Package Error in Next.js App with Clerk.dev Auth

Hello, I'm facing an issue in my Next.js application (version 14.2.3) with App Router, where I've implemented a protected route at /agency using Clerk.dev for authentication. Upon executing a Server Action, which is the initial operation in my /agency file, I encounter a TypeError related to the WebSocket package. Below are pictures of the error messages from both the server console and the client browser. Here are the relevant code snippets and package versions:...

other-emerald

5/13/2024

Resetting the root branch?

I have two branches. I no longer need the main_old branch but I'm unable to delete it because it's the root branch (no parent). Is there a way to reset the root branch to main or otherwise some other way to delete and free up the space currently used by the dead branch? Thanks.

sunny-green

5/12/2024

working in desktop but not in mobile

Hello, I’m using neon to host my db also. My hosted website works, db and all in desktop but in phone, it’s ui only. Not showing data. I don’t think it’s ui related because the design is responsive

xenial-black

5/12/2024

Neon.tech with Budibase - ETIMEDOUT

Has anyone been able to connect these two without issue? Im trying to use Budibase a front went and Neon.tech as the database, but so far i've had no luck with Neon.Tech (or even Supabase), no matter what configuration i try. I've asked in the Budibase discord, but curious if anyone has had any luck connecting the two with the datasource without this error: "Error creating datasource: Unable to connect: ETIMEDOUT"...

magic-amber

5/11/2024

/sql endpoint transactions

Hi I was reading this post: https://discord.com/channels/1176467419317940276/1193786856215687238/1194217845056348200 Is there doco available for the /sql API endpoint?...

protestant-coral

5/11/2024

unable to to run query

i have created table and inserted data by following : https://github.com/neondatabase/guide-neon-sequelize my also Author.findAll() work properly . but in neon console https://console.neon.tech/app/projects/**/query error come which in picture. i am able to see my data and table at neon but "select * from tableName" not work why??? #❓｜questions-and-answers...

sensitive-blue

5/8/2024

pgx_ulid update

Hi friends, could you please update pgx_ulid to the latest version which is 0.1.4? Also could you please enable the monotonic functionality? https://github.com/pksunkara/pgx_ulid?tab=readme-ov-file#monotonicity Thank you for making Neon!

unwilling-turquoise

5/8/2024

How do I get the connection string for a database through the API?

Hey there! I am testing out using Neon and my usecase requires using the API To create a database which is all good. I am struggling to find how to generate/get the connection string required to connect to the created database. Is there an endpoint to fetch it?...

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord