Store Historic Values

So I'm currently working on a project where I want to display the changes of floor prices of NFT collections in the past 24h, 7days, 1 month. I'm tracking the current floor price in realtime and updates the floor field for that collection. Now I was wondering what the best way would be to store the historic values, since having a field that updates everyday at 0:00 doesn't seem quite like a good solution. Every help is appreciated : )
6 Replies
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
NotLuksus
NotLuksus2y ago
Like making the floor price its own table with a connection to the collection? And in that table have a field for dateTime & the price at that point? I thought about that and thought that aswell, but wasn't sure if that is the effective / correct way todo it
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
NotLuksus
NotLuksus2y ago
Prisma with prostgres But thank you!
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
Gaurang
Gaurang2y ago
dayjs or date-fns are both valid moment substitutes. Dayjs def. has a smaller footprint.
Want results from more Discord servers?
Add your server
More Posts
is it fine to store the server state in the forked process? (PM2 cluster)so my server keeps a user session in memory... and I want to introduce clustering using PM2. I obviAre there any differences between these two pieces of code performance or bug wise?I don't believe they do, but I found the second snippet in my codebase, so I wanted to be sure that Help - session type in _app.tsx is missingI recently opened my `_app.tsx` and noticed that there was an error with the `session` object being T3 Stack NextAuth How to get Provider access tokenI have one question I have T3 Stack, PrismaAdapter, GithubProvider How can I get access token from GSimple postgreSQL question (or maybe its generic sql idk)any postgres gigachads in here? or maybe this is in plain sql too. but what is the different betweenCan you (or should you I suppose) put a type inside of a component?Primarily asking in relation to performance. I know that putting a type inside of a component is somtRPC Query being called client side even with dehydrated stateI have a trpc v10 prefetch in gssp, it's being passed in correctly and hydrated properly, but the quTypescript behaving strangely when inferring function return typeToday I stumbled across a thing in typescript, where it was inferring the return type of a function cron job for sending user a email or notification?Hello, I m making a scheduling app using t3 stack and I want to send the user an email or maybe pushNext Future Image Rounded?Using `next/future/image` with tailwindcss and can't get an image to round ```ts <div className="fl