Questions tagged [sequelize]
The sequelize tag has no usage guidance.
6
questions
0
votes
1answer
42 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
0answers
18 views
sequelize query to get different columns in for different row depending on a column value
I have a following schema
module.exports = (sequelize, DataTypes) => {
const Photo = sequelize.define(
"Photo",
{
photoURL: {
type: DataTypes.STRING,
allowNull: ...
0
votes
3answers
42 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 ...
0
votes
0answers
11 views
Referencing multiple user id's in a single field
I'm creating a system where a user can make a prediction about an event, and if they get all the predictions correct they win.
I have three tables: users, games and predictions. The structure of each:...
0
votes
0answers
27 views
Search path for DMS postgres 10 wrapper functions
I'm setting up DMS to perform replication from a non-RDS database.
After running the suggested code to create wrapper functions, I'm finding our migrations are breaking with errors that indicate ...
1
vote
1answer
1k 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 ...
