Questions tagged [sequelize]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
120 views

Posgres database requires a group by clause. (column \“candidates.id\” must appear in the GROUP BY clause or be used in an aggregate function",)

I have 2 tables, agents and candidates. The candidates table has a foreign key "agent_id". I want to get all agents and aggregate the candidate counts on each agent object; the different ...
0
votes
0answers
21 views

Designing associations where no obvious relationship

I hope this question is in the appropriate place. I'm trying to work out the best way to design associations between two tables with no common id's at present. I have them referencing table names and ...
1
vote
1answer
2k views

Query hanging in ClientRead and blocking all others

This is related to Debugging a hanging session/lock Every so often (~1-2 times a month) we have our database lock up because there is one query that doesnt finish, and that has requested locks that ...
0
votes
3answers
327 views

Database design for monthly leaderboards

I have a system where users can make predictions on events. There are about two events a week. When the event ends the system scores all the predictions and updates this in the database. Here is an ...
1
vote
1answer
4k views

Postgres support for UUID [closed]

My understanding is that Postgres supports UUID data type out-of-the-box. I'm running Postgres on Amazon RDS with Engine version 10.6 and am scratching my head as to why the following commands are not ...