ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
Managing database connectivity in a containerized environment requires balancing application-level pool sizes against the global limits of the managed database instance. In a Scalingo deployment, each container maintains its own independent connection pool, meaning the total number of concurrent sessions is the product of the pool size per container and the
Not sure which option is latest best practice? I read on on this tutorial that: https://www.postgresqltutorial.com/postgresql-identity-column/ PostgreSQL version 10 introduced a new constraint GENERATED AS IDENTITY that allows you to automatically assign a unique number to a column. The GENERATED AS IDENTITY constraint is the SQL standard-conforming variant
I was trying to embed some documents on postgresql with the help of pgvector extension and langchain . Unfortunately I'm having trouble with the following error: (psycopg2.errors.UndefinedObject) type "vector" does not exist LINE 4: embedding VECTOR(1536), ^ [SQL: CREATE TABLE langchain_pg_embedding ( collection_id UUID, embedding VECTOR(1536), document VARC
Recovery needs to recreate the working service and its required data after a machine or process is lost. Which artifacts and state need protection, and how should the restore be checked?
I often just want to test out a function, or see what a variable might look like. This could be done by creating a temporary table, but I suspect that there is an easier way. Basically, WITH cte1 AS ( SELECT VALUES(1,2,3) AS temp_var1 , VALUES(4,5,6) AS temp_var2 ) SELECT temp_var1 , temp_var2 , (temp_var1 + temp_var2) AS temp_var3 FROM cte1 This would retur
I am getting an error after moving the project to production. The error is as follows while running with production server pg_connect(): Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above. Here is my PostgreSQL version: Development Version : PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150
I understand that explain in postgresql just estimates the cost of a query and explain analyze does the same and also executes a query and gives the actual results. But I can't figure out in which cases I should use explain and explain analyze.
I am having some issues performing a nested find query with TypeORM. Here's the basic code: const { completionId } = req?.params; const user = req.user; const retrievedCompletion = await getRepository( CompletionGoogleSearch ).findOne({ relations: ['run', 'run.user'], where: { id: completionId, // run: { user: { id: user.id } }, // This is the code that brea
I've tried to connect Prisma with postgreSQL several times. prisma show this error message : "Error: undefined: invalid port number in "postgresql://postgres:password@localhost:5432/linker")". -error -prisma/.env DATABASE_URL=postgresql://postgres:password@localhost:5432/linker -schema.prisma datasource db { provider = "postgresql" url = env("DATABASE_URL")
scalingo
python
javascript
prisma