Skip to main content

Questions tagged [sequelize]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
6 views

Defining hasMany self-associations in sequelize v7

export default class Folder extends Model<InferAttributes<Folder>, InferCreationAttributes<Folder>> { @Attribute(DataTypes.INTEGER) @PrimaryKey @AutoIncrement declare id: ...
Narayan Waraich's user avatar
1 vote
0 answers
71 views

''No database selected'' error in Render

I created a project on Node js(Express js) with sequelize ORM and earlier, I used sequelize-cli to create and migrate database and tables respectively. this is my package.json: { "name": &...
suborno das's user avatar
0 votes
0 answers
3k views

Sequelize and Mysql throw connect ETIMEDOUT error

Hello everyone this is my first time here but I'm a quite desperate with this situation, I hope you can help me. I have a nodejs server with express and sequelize. When I was in development enviroment ...
Gamaliel Castro's user avatar
0 votes
1 answer
80 views

Problem seeding Heroku database

I'm trying to seed my Heroku production database and got the following error message: ERROR: insert or update on table "Posts" violate foreign key constraint "Posts_userId_fkey The ...
skyeNoLimit's user avatar
0 votes
1 answer
4k 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 ...
savagemechanic's user avatar
9 votes
1 answer
21k 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 ...
Karthik T's user avatar
  • 203
1 vote
3 answers
1k 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 ...
David's user avatar
  • 11
2 votes
1 answer
8k 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 ...
wheresmycookie's user avatar