So I am able to connect to my psql database through the command prompt using the prompt (psql -h localhost -p 5432 -U postgres -d Luxe-Hotel) and putting in the password but I am unable to connect through node.js. import…
My data looks like: ID Year Volume1 Volume2 AAA 2023 10 20 AAA 2024 5 10 BBB 2023 20 40 BBB 2024 30 60 I would like to have the volumes per ID all on one row, where ideally the…
I need some help to optimize my filtering/pagination system under Symfony/PostgreSQL. I have a table "link" with ~5M rows and this query used for the pagination system with https://github.com/KnpLabs/KnpPaginatorBundle. SELECT * FROM link l0_ WHERE l0_.team_id = 21 AND l0_.folder_id…
I have an unusual index, which is consists of: some_field, COALESCE(other_field, 0) So I'm trying to use it in description of my entity #[ORMUniqueConstraint( name: 'some_index', columns: ['some_field', 'COALESCE(other_field, 0)'] )] Of course, doctrine cannot find such column and returns…
I have been trying to build a docker-compose container for my back-end service using Fastapi.The issue is docker-compose container logs keep returning that my database engine fails. I am using asyncpg for async connection in postgresql. ╰─λ sudo docker-compose logs…
I would like to count the waves available (LEFT OUT JOIN). My problem is that I also have another LEFT OUTER JOIN on invitations. The idea is to have all the stats from the same SQL request. Stats from invitations…
If I execute query: SELECT '10' AS a_name; it gives 10 AS text type. In case of query: SELECT 10::text AS a_name; it gives again 10 as text. So one could expect that following two queries gave the same result:…
I'm trying to figure out how to insert new data into a database while explicitly setting the ID. However, when I use nextval('user_seq'), it doesn't retrieve the next value from the sequence as expected; instead, it increments it based on…
I'm trying to change the format of time_discrep (below) into a fraction of days. Code: select time1, time2, (time1-time2) as time_discrep from main_file order by time1; Screenshot of results: I've tried dividing, etc, but it just formats it like 00:00:32…
I want to join columns from several tables. For one table join works fine select org.catalog_truck.plate_number as "Госномер грузовика", shift_id as "ID смены", trip_id as "ID рейса", * from core.monitoring_stages join org.catalog_truck on vehicle_id = org.catalog_truck.catalog_truck_id where gen_id = (SELECT…