DEV Community

Cover image for 8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

Trevor Fox on January 05, 2020

When it comes to working with SQL, we all want the same things: speed and scale. And on top of that we, want to be easy—maybe even fun. From data c...
Collapse
 
mike_seekwell profile image
Mike • Edited

Thanks for the mention Trevor! For anyone that'd like a sneak peak at what we're working on next or a demo of the current product, feel free to DM me on Twitter or email me at mike@seekwell.io. There's a 90 second demo fo the product here: loom.com/share/256e83c925744ad9977... (please pardon the background noise)

Collapse
 
elseagle profile image
Oluwasogo Oluwafemi

Nice article! On the Dataform section has a mistake "ELT" instead of "ETL"

Collapse
 
realtrevorfaux profile image
Trevor Fox

Good catch Oluwasogo! It was intentional. The article Mike mentions below shows the difference. The main difference with DBT and Dataform and previous ETL solutions is that they are built to manage the "Transformation" part of the pipeline after the data is in a data warehouse rather than before the data is loaded, thus ELT.

Collapse
 
mike_seekwell profile image
Mike

that's probably on purpose, see here blog.panoply.io/etl-vs-elt-the-dif...

Collapse
 
lofiderek profile image
Derek Xiao

Great post Trevor! Do you think you could do an update for 2021? 🎉

Collapse
 
fpolster profile image
Florian Polster

Thanks, Trevor for this article. Many new tools for my belt :)

I think there's one more tool that should be on that list: github.com/k1LoW/tbls

Collapse
 
realtrevorfaux profile image
Trevor Fox

I'll have to take a look!