I am designing a basic ERP (nodejs/express/postgresql-vue3/quasar), in which several businesses of different clients will be managed, some of these clients have several businesses with some branches, I should implement a server/database instance per customer or should I look to…
When I run select now() - pg_last_xact_replay_timestamp() AS replication_delay directly on the database, the output is replication_delay ------------------- -00:00:00.55072 (1 row) When I put the same query in a python script import psycopg2 try: connection = psycopg2.connect(user="postgres", host="x.x.x.x", port="5432", database="postgres")…
My query goes over three entities, so I have two left joins. I want to restrict the result of the first join. For example we have customers and order evaluations. In the first join I want only the youngest order…
Im new to the Golang language and im coming from Nodejs, where it was quite simple to access database and manipulate db within a http request handler.Now i want to do the same in Golang and i cant access the…
In my PostgreSQL table I have a parts column of type json. I want to check if the given argument is contained in my json column. This query works in the database: select * from elements we where parts::text like…
I have a file that contains multiple select queries. I run these on a weekly basis to generate internal company reports For example (these are not the actual queries): -- Select number of users SELECT count(id) from users; -- Select…
I am making a mvc project and I am trying to do post the data but when I tried the post decimal number it isn't sent right like this (I am writing 10.50 I am getting 1050 or writing 10,50…
I am using pgAdmin 4 to create and update stored procedures. I want to add more arguments to one existing procedure but the add option is not available: What I expect to see is the "+" option, as it appears…
I've got 'autovacuum_freeze_max_age' which is 200 000 000 by default. And in theory I found a rule that autovacuum wraparound starts when: If age(relfrozenxid) > autovacuum_freeze_max_age But when then usual autovacuum is started? How can I count a moment: When…
I am trying to get the column cumulative_point like below. date point reset_date cumulative_point 2019-01-01 00:00:00 1 true 1 2019-01-02 00:00:00 3 false 4 2019-01-03 00:00:00 1 false 5 2019-01-04 00:00:00 2 false 7 2019-01-05 00:00:00 1 true 1 2019-01-06…