medium.com
Things I Wished More Developers Knew About Databases
20+ min · · A large majority of computer systems have some state and are likely to depend on a storage system. My knowledge on databases accumulated… · Shared by 458, including Mike Tamir, PhD, Dr. Ganapathi Pulipaka 🇺🇸, Matthias Lampe, Jaana Dogan ヤナ ドガン, Bryan Onel, Stefan Weber, Eliska Hutnikova, Balda, @brianleroux@indieweb.social 💙, Fabrizio Bianchi, Clemens
Towards Data Science
9 Comprehensive Cheat Sheets For Data Science
16+ min · · Sometimes we need a short and to-the-point resource. · Shared by 263, including Carla Gentry 🎶, Evan (he/him), Dr. Ganapathi Pulipaka 🇺🇸, Fabrizio Bianchi
Towards Data Science
21 amazing Youtube channels for you to learn AI, Machine Learning, and Data Science for free
16+ min · · This is the perfect moment to start learning something new, and why not start with AI? · Shared by 253, including Tom Connor, Pranav Soni, Fabrizio Bianchi, Memen Isimo, Carla Gentry 🎶
Towards Data Science
6 SQL Tricks Every Data Scientist Should Know
16+ min · · SQL tricks to make your analytics work more efficient · Shared by 219, including Dr. Ganapathi Pulipaka 🇺🇸, Carla Gentry 🎶, Fabrizio Bianchi
blog.timescale.com
Why SQL is beating NoSQL, and what this means for the future of data
12+ min · · After years of being left for dead, SQL today is making a comeback. How come? And what effect will this have on the data community? · Shared by 201, including Patric Fornasier, Florian Hanke 🍎, Alberto, Dez S. Papp, John Hues, Matthew Turland, Fabrizio Bianchi, Rezha Julio, melbic, Pinei, Markus Merz, DON’T PANIC, Weiting Chen, Nils Hitze, Jakub Ferenc, Mattia Fregola 🤔, Howard Getson
mockaroo.com
Mockaroo - Random Data Generator and API Mocking Tool
2 min · · A free test data generator and API mocking tool - Mockaroo lets you create custom CSV, JSON, SQL, and Excel datasets to test and demo your software. · Shared by 129, including Nando 💪🇦🇺🇦🇷, Dayyan Smith, Fabrizio Bianchi, Christopher Möller, Niklaus Gerber, Mohamed JEBLI, Mike Taylor, Vikram Dutt, Francis DB, Chris Messina, Moritz Klack, Matt, Thomas Kaul, César Suárez, René Clausen Nielsen, Alexander Seifert, Robin Breman, Matthias Sala, Icefox, Dominik Grolimund
popsql.io
Modern, collaborative SQL editor for your team
1 min · · Write queries, visualize data, and share your results. · Shared by 118, including Nando 💪🇦🇺🇦🇷, @AlgoCompSynth@ravenation.club by znmeb, Clemens, Jon Thompson, Philippe Gauvin, Vašek, blinch, Balda, mebmc, Oleg Baskov, Stephen C Sanders, Fabrizio Bianchi, Kohei Asai, Tibor Martini 🇺🇦 @tibor@mastodon.social, Jakub Ferenc
Towards Data Science
How I’d Learn Data Science if I Could Start Over (2 years in)
11+ min · · My guide to learning data science as efficiently as possible · Shared by 115, including luis antónio santos, Sagun Shrestha, Fabrizio Bianchi, Dean of Big Data 🎓 #DOBD
evanjones.ca
Why databases use ordered indexes but programming uses hash tables (evanjones.ca)
5 min · · I think it is safe to state that hash tables (e.g. maps in Go, dicts in Python, HashMap in Java, etc.) are far more common than ordered data structures such as trees for in-memory data structures. One… · Shared by 115, including Chris {he, they} , Matthias Lampe, Fabrizio Bianchi
Towards Data Science
Machine Learning With SQL — It’s Easier Than You Think
10 min · · What to do when Python is not an option. Code included. · Shared by 110, including Fabrizio Bianchi
metabase.com
Metabase
1 min · · The fastest, easiest way to share data and analytics inside your company. An open source Business Intelligence server you can install in 5 minutes that connects to MySQL, PostgreSQL, MongoDB and more! Anyone can use it to build charts, dashboards and nightly email reports. · Shared by 106, including Mike Ivars, Mattia Fregola 🤔, Clemens, Balda, Fabrizio Bianchi, Moritz Klack, Lukas, Florian Hanke 🍎, Chris Messina, Stephen C Sanders, 梁原 立寛, Claudio Perez Gamayo, Philipp Laurim, Dom Zuend, Philippe Gauvin, Klaus Eck
mystery.knightlab.com
SQL Murder Mystery
· Use SQL queries to solve the murder mystery. Suitable for beginners or experienced SQL sleuths. · Shared by 97, including @AlgoCompSynth@ravenation.club by znmeb, Matthew Turland, Esther Schindler, Data Science Renee, 𝚛𝚘𝚐𝚎𝚛, Randy Olson, Fabrizio Bianchi, Chris Heilmann codepo8@toot.cafe, Mara Averick, Ben Jones, Bryan Onel
wozniak.ca
What ORMs have taught me: just learn SQL
1 min · · Perhaps the most subversive issue I’ve had with ORMs is “attribute creep” or “wide tables”, that is, tables that just keep accruing attributes. As much as I’d like to avoid it, sometimes it becomes… · Shared by 78, including Massimiliano Aroffo, Fabrizio Bianchi, mastodon.social/@renestalder, Matthias Lampe
crate.io
Scalable SQL Database with the NoSQL Goodies
4 min · · Put data to work. Simply. · Shared by 76, including ⓜⓡⓕⓘⓓⓖⓔ, Malik El Bay 🕊🔰🇲🇦, Thomas Power, Ludovic Claude, Francis DB, yawniek 📯, Nico Müller 🇺🇦, Fabrizio Bianchi, William El Kaim, Brian, Icefox, Florian Hanke 🍎, Balda, Nando 💪🇦🇺🇦🇷, Ahmad Ragab
helenanderson.co.nz
10 Ways to Tweak Slow SQL Queries
5 min · · Before you rage quit or call in your DBA, check these things aren't causing slow SQL queries. A few tweaks could be all you need. · Shared by 73, including Fabrizio Bianchi, Michael Weibel, Esther Schindler
edgedb.com
We Can Do Better Than SQL
12+ min · · The questions we often hear are “Why create a new query language?” and “What’s wrong with SQL?”. This post contains answers to both. Before we begin, let’s overview some of the history of how the rela · Shared by 63, including Matthew Turland, Cameron Yick ~ @hydrosquall@vis.social on mastodon, Jacob du Toit, Fabrizio Bianchi, rohit, Nico Müller 🇺🇦