Posts by Jhonny • 97 points
5 posts
-
0
votes1
answer42
viewsQ: Empty processes in the queue - Postgresql
Hello. This week we started to have a problem of empty processes in the Postgresql queue, but unlike other processes, these are locked. This is causing quite slowness in the system. I would like to…
-
3
votes2
answers42
viewsQ: I can’t find which Style is separating my elements
Hello, I have a website that’s on the air. I know this doubt seems really silly, but I’m not finding what is causing a gap between Google Maps and my banner. Website link:…
-
0
votes1
answer88
viewsQ: Laravel + Postgres - Return’t' or 'f' instead of true or false
Hello, When performing a query in a field booleano in the Postgres we have a return of 't' or 'f'. I’m having a problem trying to migrate an API made in Codeigniter for an API I am developing in…
-
0
votes1
answer454
viewsQ: Very time consuming query depending on query ID
Hello, I have a fairly large query that is running in the bank, follows. SELECT "p"."id", "fr"."apelido", "fr"."compra_minima", "fr"."desconto", "fr"."aplicavel_todocarrinho" FROM "basket" "b" JOIN…
postgresqlasked Jhonny 97 -
6
votes1
answer279
viewsQ: Object-oriented PHP encapsulation
I have two models User and Post. When editing a post, I want to know if the user is the author of post (the post has an attribute user_id) to authorize the edition. If I have a method within the…