I don't know friend, SQL been undefeated for data pulling for a while ... At least in analytics 🫂
Discussion
Undefeated because Microsoft and Oracle forcibly killed all of their competition and forced everyone to use SQL. So that's where the majority of data is.
I'm also a graph data supremacist. So there's that 😂
Fair, I think there's something to the simplicity of it that keeps it around
But it's also impossible to use anything else if you're already committed to a SQL database. I think there are better ways to model real data than in tables.
Understood, ived used some mongo + unstructured data but most of my work at least has been in SQL. Mostly financial
Yeah, and if I had to pick some data that is great in a table, it's financial ledgers. They've been in tables for millenia. It works and it works really well.
But also, if I were writing a financial application, I'd use Neo4j. A database where the native data structure itself lets you literally "follow the money" anywhere it flows would be amazing.