I want to delete 2 models from a postgreSQL production database that are no longer used but have data on them. I am a bit afraid of removing them from the schema and running prisma migrate dev and then having…
I found an issue in my query: SELECT * FROM stocks_historic WHERE ticker = x ORDER BY YEAR ASC LIMIT 10 Current table is this one: stocks_historic ( historic_id SMALLSERIAL UNIQUE, ticker VARCHAR(10) NOT NULL, year VARCHAR(5) NOT NULL, eps…
I'm using postgres with my spring boot app and I want to make a specific table not delete able by anyone. Is there a way to implement this on spring boot side. Revoking delete grant does the job on postgres…
I am trying to build query that gets data from 3 different tables using sqlalchemy I tried select( models.Animals.id, models.Animals.description, models.AnimalTypes.name.label('type'), func.coalesce( func.array_agg( func.jsonb_build_object( 'id', models.Animals.id ) ), None ).label('animals') ) .join(models.FamilyTypes, models.Family.id == models.Family.family_type_id) .outerjoin(models.Animals, models.Animals.campaign_id == models.Animals.id) .group_by(models.Family.id,…
I have a nextjs project that's using prismaDB for the ORM. I'm able to connect just fine to my local postgres db but I'm getting this error when running npx prisma migrate. Error: P1001: Can't reach database server at db-name.*.us-west-2.rds.amazonaws.com:5432.…
So I have three databases - an Oracle one, SQL Server one, and a Postgres one. I have a table that has two columns: name, and value, both are texts. The value is a stringified JSON object. I need to…
There's a simple table with columns a,b,c,d. I want value in d to be a+b if c>0 and a-b if c<=0. How can I do this? I tried this code and it doesn't work. How can I dynamically insert data…
I have the following table: create table foo (id serial primary key, ts date, value int); Populated with 10k records already. Now I'm trying to find a way to efficiently update multiple rows in one go, so I wrote this…
I am using this code to see the unique results of concated/joined columns 'a,b' from table1 and is working perfectly WITH tt as ( SELECT concat(a,',',b) AS concated FROM table1 GROUP BY concated ) select concated from tt; But, instead…
I want to expose 5432 port to be accessible externally, but before doing that I want to limit it to only specific IPs, so I want to do that via pg_hba.conf If I use docker default settings, communication between containers,…