Posts by Jfé • 140 points
9 posts
-
3
votes0
answers79
viewsQ: Can the use of UUID as a document identifier and public query be considered a valid use case?
I am developing an academic level project. The system consists of the creation of documents by the user. This document is registered so that the user can view it/print it whenever he wants, but…
-
1
votes0
answers301
viewsQ: How do I set the path (URL) of a Java web application correctly so there are no 404 (Not Found) errors when the project is in production?
I have a Java web project in which I use the Jersey framework. When I deploy to my localhost (use Tomcat 9) everything works, when I take it to Heroku the app works too. However, when I request a…
-
3
votes1
answer37
viewsQ: Count twice the number of records from one column to different values using the COUNT(*) function in a single query
I need to count the number of hits and likes per user for different types of content. SCHEMA: secao +--+--------+ |id| nome | +-----------+ |01| Vídeo | |02| Audio | |03| Imagem | |04| Leitura|…
-
0
votes2
answers493
viewsQ: Count number of rows of different tables doing LEFT JOIN using the Count() function
I need to count the number of tables records cliques and curtidas and show these numbers to the media type Video table tipo_midia and the specific media, that is, the video that the person liked or…
-
0
votes1
answer123
viewsQ: POSTGRES: INNER JOIN 1:N with multiple tables. Need to count and display records that were accessed as a list
I need to count table records acesso_registro and show in a list. Schema: acesso_registro +--------------+--------+------------+ |id_tipo_midia |id_midia| data_acesso|…
-
1
votes2
answers146
viewsQ: Scroll through an array of dates to pick up the amount of monthly records from the last 12 months
I have an array with dates, each date means a new record in the users table, in this case, a new user account created. I need to go through this array to get the amount of accounts created over the…
-
5
votes2
answers121
views -
1
votes1
answer75
viewsQ: How to set only one row of the column in which all values in this column are equal?
I’m trying to set the column ocupado just one line at a time, something like: update suite set ocupado = 'S' where tipo = 'i'; But this instruction changes all rows in the column ocupado where tipo…
-
-2
votes1
answer125
viewsQ: Do I need to download JVM to run a java program on my PC since I’m not a developer?
Do I need to download JVM to run a java program on my PC since I’m not a developer, that is, I will only need JVM to run this program? Better yet, how do programs made in java run on people’s…