Prisma

quick question here (not sure if it’s the right place), but I’m having some issues using Decimals in Sqlite. I basically want to store percentage values with 2 digits behind the comma max.

image.png

Hi <@U03T1U4QAGM> :wave:

To store Decimals in SQLite, you would use the Decimal datatype. An example is shown in this sample schema.
```model products {
  id  Int @id @default(autoincrement())
  price Decimal
}```
From the client, you can do something like
```const product = await prisma.products.create({
      data: {
        price: 5.47
      }
    })```
Logging the result, we get
```{ id: 2, price: 5.47 }```
Viewing the Sqlite table in Vscode,

Hi there, so, I’m using this approach, however, when I seed data (that’s formatted to 2 digits behind the comma), I still get very long numbers

Prisma shows me `8.800000000000001` for a  number `8.80` I seeded

I create the decimal like this: `const number = new Number(decimal.toFixed(2));`

the output I get in a console log is, `8.80`  but the value stored is very long

I can’t reproduce this consistently, is just sometimes “happen”

it’s funny, when this happens, it’s usually with values around certain numbers

but Sqlite doesn’t allow me to set a formatter on my schema

Floating point cannot store arbitrary decimals, it gets as close as it possibly can

See <https://en.wikipedia.org/wiki/Floating-point_arithmetic#Accuracy_problems>

Also <https://www.sqlite.org/floatingpoint.html>

so you are storing 8.80000000000000198951966012828052043914794921875

Hmm I see, what would be the best way to store percentage values?