Live data from Hacker News

Guide to data tools landscape for developers

sinja.io

21–30 of 38 posts

Re: Guide to data tools landscape for developers

#22

As a data engineering person I can say that this is a great write up! Some thoughts: A "bubbling" topic right now is conversational analytics (i.e. talk to your data). There has been an explosion of tools in the last 6 months. YC is backing one too: https://getnao.io/ I feel like pandas is also somewhat frowned upon, the industry has moved on from that. Most SQL tools can now do everything that we could only do with…

I love what I am hearing. I still see a lot of engineers using pandas, but it is such a horrible tools. You usually find an abandoned notebook with 100s of ”df_final_2” with sequential wrangling, making it impossible to understand what’s happening. Notebooks are also horrible for the same reason IMO.

With chat-your-data you have Hex, Claude + MCP, snowflake, Databricks etc… everyone’s in on it.

Re: Guide to data tools landscape for developers

#23

"Popular metadata catalog solutions are Hive Metastore, AWS Glue Data Catalog, and Unity Catalog from Databricks. For query engine you can use, for example, Apache Spark, Trino, or Amazon Athena." DuckDB is eating the query engines and catalogs. Really could use more coverage on how DuckDB is changing the data tools landscape.

Can you suggest any good resources for your statement? I know DuckDB is hyped, but didn’t know they’re eating engines and catalogs.

Re: Guide to data tools landscape for developers

#25
This is a fantastic primer.

A few suggestions:

- Add a "last updated" note, since this space changes often (see the prefect/dagster situation that just happened)

- Add a note about MCPs and other LLM-driven tools and features are becoming more and more important (e.g. hex.ai or the various MCPs shipped with some of the tools you mention, such as OpenMetadata)

- Maybe organize the various tools you mention briefly by their license/model (lots of them can be self hosted, some are SaaS only), since a fully self-hosted data platform is (at least for now...) very much feasible

I also wish more people would talk more about the "engineering" part of "data engineering". I've seen way too many people who claim a title like "data engineer" but lack the fundamentals of building software and are really just copy-paste scripts together.

What I'd love more DEs to think about are things like {unit,integration,e2e,performance} tests, deployments, infrastructure, networking, monitoring (you do touch on that), and all the other things a regular SWE is expected to have at least basic competency in at a certain level. For instance, tools like dbt natively support tests, but people need to write them. Or how you don't have to click-ops Airbyte, there's a terraform provider etc.

Re: Guide to data tools landscape for developers

#27
Interesting write up, but what it really needs is a nice task vs tools table at the end as a "conclusion".

Someone reading the blog the first time might well be willing to read through the large amount of text.

But returning to it at a later date ? A quick reference TL;DR table would not go amiss IMHO.

Re: Guide to data tools landscape for developers

#30

> A data warehouse on the other hand is an OLAP database and is optimized to work on columns A bit of a pedantic nit here: a data warehouse is a usage pattern. It’s not necessarily tied to any specific technology, however it is commonly implemented with OLAP systems like Snowflake, BigQuery, etc. But there’s nothing stopping you from building out your data warehouse in Postgres or MySQL. If you’re stitching together…

> But there’s nothing stopping you from building out your data warehouse in Postgres or MySQL.

Other than money and time.

Post reply on HN