• 1 Post
  • 1.77K Comments
Joined 3 years ago
cake
Cake day: June 20th, 2023

help-circle
  • I’m personally playing with the idea of putting together a POC to transition our “foundation” data warehouse from PSQL to a graphDB, because the extensibility and maintainability of our current system is fucking awful. Like, some upstream entity gets a version bump and there’s like 5 systems we have to go through and add columns to various tables (usually 2-4 such modifications in each workflow - and it doesn’t help how my manager fucking loves to slice work up so much that it becomes a massive pain to integrate, instead of telling one Eng “integrate this new data element” and have it done, soup to nuts, in a week or two across the whole ecosystem) and occasionally fuck around with joins and so on every single time there’s a new piece of data we want to integrate. And we have no capability to scan back historically and evaluate our holistic state at some particular time index, which can be really helpful for some applications.

    Anyways, I’m fucking swamped at work so haven’t touched that at all, but I’ve wanted to explore that idea for well over a year and a half at this point.