A Hasura Bit - How to split timestamps to use as generated columns in Postgres & Hasura?
In this short Adron shows how to split timestamps based on year, month, and day using the date part function. Then the difference in how this is setup in Postgres SQL vs. Hasura Console. Then we take a look at the data being inserted. This is one scenario to provide preprocessed, grouping options around values like year, month, and day without needing to execute the function at reporting time. Great for denormalized tables!
-----
🚀 Hasura makes your data instantly accessible over a real-time GraphQL API, so you can build and ship modern apps and APIs faster. Hasura connects to your databases, REST servers, GraphQL servers and third party APIs (eg: Stripe, Salesforce) to provide a unified realtime GraphQL API across all your data sources instantly.
Check out our features: https://hasura.io
Find us on Twitter: / hasurahq
Join our community: https://hasura.io/discord
-----