Adam
Explore posts from serversTTCTheo's Typesafe Cult
•Created by jamiedubs on 5/1/2023 in #questions
Best practices for data migrations/historical data changes?
Ah I see. Thanks for the info :) Yeah, this whole situation is real bummer
5 replies
TTCTheo's Typesafe Cult
•Created by Adam on 1/2/2024 in #questions
What options are there to perform data migrations?
Yeah, that is what my questions was about, I updated it to make it more clear. I wanna know whether there should be some script files (and where to put them), or rather direct terminal operations, or another method. For updating the schema there is no need to create script or migration files, one just changes the schema and calls
push, then the schema changes get automatically updated and pushed to planetscale. But then the data is not synced with the schema, it needs to be backfilled, etc. I am wondering how to proceed on from there, maybe create script files that migrates the data as you said (and where should these files be stored, in version control? Seems odd if data migrations scripts would be stored there but not the schema migration scripts), maybe do it through some other means12 replies
TTCTheo's Typesafe Cult
•Created by Adam on 1/2/2024 in #questions
What options are there to perform data migrations?
Deploy requests I am also using myself already
12 replies
TTCTheo's Typesafe Cult
•Created by Adam on 1/2/2024 in #questions
What options are there to perform data migrations?
That is exactly what I am trying to do :)
12 replies
TTCTheo's Typesafe Cult
•Created by Adam on 1/2/2024 in #questions
What options are there to perform data migrations?
12 replies
TTCTheo's Typesafe Cult
•Created by Adam on 1/2/2024 in #questions
What options are there to perform data migrations?
Thanks for answering. Renaming columns is not allowed by planetscale, because this would produce down time. See here: https://www.youtube.com/watch?v=jeWrbAiA1D0&pp=ygUPdGhlbyBtaWdyYXRpb25z
12 replies
TTCTheo's Typesafe Cult
•Created by jamiedubs on 5/1/2023 in #questions
Best practices for data migrations/historical data changes?
Hey, did you find a solution for this?
5 replies
DTDrizzle Team
•Created by Adam on 12/21/2023 in #help
Drizzle with MySQL - most optimal way to insert row and immediately retrieve inserted row
I see. Ok, thanks :)
6 replies
DTDrizzle Team
•Created by Adam on 12/21/2023 in #help
Drizzle with MySQL - most optimal way to insert row and immediately retrieve inserted row
Ah I see. Thanks for answering. Just a question about that, what about database generated values (such as created time, updated time, etc) or default values? Is there a good solution for that as well?
6 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/16/2023 in #questions
Refreshing Stale UI After Deployment - Seeking Insights
I will keep this open, maybe someone might have something to say. If not, then I will mark your answer as the solution
8 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/16/2023 in #questions
Refreshing Stale UI After Deployment - Seeking Insights
Hm, yeah. I will continue thinking about it, thanks for the input :)
8 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/16/2023 in #questions
Refreshing Stale UI After Deployment - Seeking Insights
Thanks for answering. I also had kind of the same thoughts. I was just wondering if there are more simple solutions out there, because it seems kind of wasteful to add this kind of complexity (maintaining endpoints, etc) just to make the user refresh the page once. Feels like there should be some simpler solution to this 🤔
8 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
Ah, I take the slightly rash statement back then 😬 😄 . I marked it again and it works now, thanks!
22 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
22 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
I will mark your answer as the solution, whenever this thing finally starts working 🤷♂️
22 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
I see. My question is answered, thank you a ton for you help :)
22 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
___
So, if I understand you correctly:
Axiom goes to the direction of: used for things that are logged from the backend to be then analysed (more low leve)
PostHog goes to the direction of: high level analytics, like page views, etc
Is that about right?
22 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
(that is to say that there are maybe things I would not even consider that would be extremely useful to have)
22 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
Right now, I would want backend and frontend logging and analytics such as page visits, etc. But the thing is, I am not really sure what I want myself until I see it (I come from a very restricted background of having to use old technology on an old stack with a lack of features, right now I am trying to find better solutions). I would not even know whats out there and what things I would like to have, until I see them.
22 replies
TTCTheo's Typesafe Cult
•Created by Adam on 12/15/2023 in #questions
T3 stack analytics and logging - Axiom or PostHog?
Hm, I see
22 replies