explore alternatives to strings or Decimal for the the postgres fixed point representation

delvtech / agent0

Analysis & simulation repo for Delv

https://agent0.readthedocs.io/en/latest/

Apache License 2.0

52 stars 21 forks source link

explore alternatives to strings or Decimal for the the postgres fixed point representation #1457

Open dpaiton opened 6 months ago

dpaiton commented 6 months ago

strings suck bc they stay strings in the DB and decimal sucks because it is slow

dpaiton commented 5 months ago

We motivate this by ease of use (code under the hood would be much cleaner) and performance. To assess performance, we would really want to dig deeper into profiling to make sure this is a significantly big bottleneck.

I'm going to reduce priority on this; we should pick it back up once we decide to profile the database pipeline.