Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

193
Views
Sequelize rounding id

I'm using Sequelize with SQLite on NodeJS. I have a User table in which I store IDs (16 chars long. Example: 795051544012783646). Whenever I query the DB for a specific user, it does something weird with it's ID:

user {
  dataValues: {
    id: 218062175636291600,
    name: 'Raki',
    balance: 0,
    ap: 0,
    objCount: 0
  },
  _previousDataValues: {
    id: 218062175636291600,
    name: 'Raki',
    balance: 0,
    ap: 0,
    objCount: 0
  },
  uniqno: 1,
  _changed: Set(0) {},
  _options: {
    isNewRecord: false,
    _schema: null,
    _schemaDelimiter: '',
    raw: true,
    attributes: [ 'id', 'name', 'balance', 'ap', 'objCount' ]
  },
  isNewRecord: false
}

The ID should be 218062175636291586, but it shows 218062175636291600. It's worth noting that the DB itself stores it as it is (it works perfectly).

What I tried

My User model declares IDs as INTEGERs, so I switched them to BIGINTs. Didn't work.

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!