--- title: Best SQL posts of 2021 | daily.dev description: The most upvoted SQL posts of 2021, curated by the daily.dev community. canonical: https://daily.dev/tags/sql/best-of/2021 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/sql/best-of/2021 og:type: website og:site_name: daily.dev og:title: Best SQL posts of 2021 | daily.dev og:description: The most upvoted SQL posts of 2021, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of SQL — 2021 1. 1 [](/posts/the-missing-sql-basics-crash-course-jkzkf9ye3 "🚀 The Missing SQL Basics Crash Course") Article DevDojo · 5y 🚀 The Missing SQL Basics Crash Course This guide is suitable for anyone working as a developer, system administrator, or a DevOps engineer and wants to learn the basics of SQL. We will first learn how to install the free, open-source, and widely used database service, MySQL. Then we will create our first database using the command line. 63 11 2. 2 [](/posts/top-10-sql-commands-everyone-should-know-uoo-kolyh "Top 10 SQL Commands Everyone Should Know") Article Sweetcode · 6y Top 10 SQL Commands Everyone Should Know Theo Despoudis is a Senior Software Engineer and an experienced mentor. He has a keen interest in Open Source Architectures, Cloud Computing, best practices and functional programming. He occasionally blogs on several publishing platforms and enjoys creating projects from inspiration. He is a member of the Linux Foundation and the Apache Software Foundation. 63 4 3. 3 [](/posts/complete-web-development-roadmap-for-newbies-mb-yofvss "Complete web development roadmap for newbies") Article Hashnode · 6y Complete web development roadmap for newbies This list consists of beginner languages and tools. Advanced topics are not covered. HTML is by far the easiest to learn. JavaScript is a multi-paradigm, high-level language which has evolved to become one of the most popular languages not just in web development but in many other fields. 40 2 4. 4 [](/posts/9-best-javascript-and-typescript-orms-for-2021-yqpiiadp "9 Best JavaScript and TypeScript ORMs for 2021") Article SitePoint · 6y 9 Best JavaScript and TypeScript ORMs for 2021 Object relational mapping (ORM) makes it possible for you to write queries in the language of your choice. An ORM is beneficial for medium- to large-scale projects that source data from hundreds of database tables. Using an ORM library to build your data layer helps ensure that the database will always remain in a consistent state. 36 4 5. 5 [](/posts/use-sql-query-builder-knex-js-with-node-js-and-express-js-og3q-m5jb "Use SQL Query Builder Knex.js with Node.js and Express.js") Article JavaScript in Plain English · 6y Use SQL Query Builder Knex.js with Node.js and Express.js Knex.js is a thin abstraction that sits on top of the database driver for relational databases. It supports transactions, connection pooling, streaming queries, a thorough test suite, and the ability to run in the browser. Knex can be used in both Node.Js and the browser, limited only by WebSQL’s constraints. 36 2 6. 6 [](/posts/should-i-use-mongodb-or-postgresql--oq5s6wmzf "Should I Use MongoDB or PostgreSQL?") Article Geek Culture · 5y Should I Use MongoDB or PostgreSQL? MongoDB and Postgres are two of the most popular databases. We are going to cover their key features, functionality, performance, and their use cases. MongoDB is a schema-free document-oriented store. Postgres is ideal for transactional workflows that make it reliable in production. 30 3 7. 7 [](/posts/arctype---supercharged-sql-client-for-developers-and-teams-8wo0slzfi "Arctype - Supercharged SQL client for developers and teams") Article Product Hunt · 5y Arctype - Supercharged SQL client for developers and teams Arctype is a fast, beautiful database GUI for developers and teams. With SQL autocomplete, spreadsheet-style editing, one-click visualizations, collaboration, and the best support for Postgres, MySQL, and PlanetScale - you'll finally love working with your DB. 27 2 8. 8 [](/posts/sql-cheat-sheet-xrq51p9oe "SQL Cheat Sheet") Article JRebel · 5y SQL Cheat Sheet In this article, we'll give a basic overview of SQL, how it's used, and useful SQL shortcuts for developers. We'll also go over basic SQL queries, functions, joins, and subqueries. Then, at the end of the article, you can grab a copy of our handy SQL cheat sheet. 18 9. 9 [](/posts/what-s-hot-in-web-development-weekly-picks-164-m6oyhvrnw "🔥 What's Hot in Web Development? — Weekly Picks #164") Article daily.dev · 6y 🔥 What's Hot in Web Development? — Weekly Picks #164 We also cover the upcoming Ubuntu 21.04 release, a React roadmap, and a few more interesting articles. If you are not familiar with ReScript yet, we have two articles this week that will help you with your first steps. We will come back with another list of interesting development posts next week. 17 10. 10 [](/posts/db-lens---explore-data-execute-sql-metrics-disk-usage-more-isl28ztil "DB Lens - Explore data, execute SQL, metrics, disk usage & more") Article Product Hunt · 5y DB Lens - Explore data, execute SQL, metrics, disk usage & more DB Lens is an opensource database client for Mac, Linux & Windows. It helps developers to explore, observe & understand the database in a better way. DB Lens is available in English, French, German, Italian, Spanish, Portuguese, Italian and Spanish. It is available as a free download or as a paid version. 16 11. 11 [](/posts/nosql-does-not-mean-relational--dchiw3vc "NoSQL does not mean !Relational") Article ITNEXT · 5y NoSQL does not mean !Relational Most data that we use has relationships of some sort. Let’s see how we create and reference relational data in MySQL vs something like Google Cloud Firestore. I’ll use a food ordering app that has users , restaurants , dishes and orders. In Firestore, they store documents in collections rather than tables. 16 12. 12 [](/posts/sql-playground---free-private-sample-postgresql-databases-grvchdl-9 "SQL playground - Free private sample PostgreSQL databases") Article Product Hunt · 5y SQL playground - Free private sample PostgreSQL databases No local installations or spinning up cloud instances. Choose a database type, and get a unique connection string right away. Create a private Postgres database with a predefined structure & test data in the shortest time. No database installation, no local installations, and no cloud instances to spin up. 15 2 13. 13 [](/posts/how-we-built-a-forever-free-serverless-sql-database-o4zdulod "How we built a forever-free serverless SQL database") Article Changelog · 5y How we built a forever-free serverless SQL database After 18 months of challenging work, we’ve launched the first truly scalable Serverless SQL database. CockroachDB Serverless is “forever free,” with a generous (and never-ending) monthly credit for requests and storage. It automatically and transparently scales to meet your needs, no matter how big or small, with no changes to your application. It supports online schema migrations, Postgres compatibility, and gives you access to Enterprise features. 15 14. 14 [](/posts/best-postgresql-guis-in-2020-gjyl0q1bq "Best PostgreSQL GUIs in 2020") Article Pointer · 5y Best PostgreSQL GUIs in 2020 Postgres is the second most popular database among web developers. Postgres has a built-in command line tool called psql. Navicat is not as popular as PgAdmin but definitely comes with many features you would expect from software that is open-source. 14 1 15. 15 [](/posts/how-to-use-sql-subqueries-eh8iqlzqf "How To Use SQL Subqueries") Article DZone · 5y How To Use SQL Subqueries 14 1 16. 16 [](/posts/ubuntu-21-04-is-here-m2puapily "Ubuntu 21.04 is here") Article Ubuntu · 5y Ubuntu 21.04 is here Ubuntu 21.04 is here Canonical on 22 April 2021\. It includes native Microsoft Active Directory integration, Wayland graphics by default, and a Flutter application development SDK. Separately, Canonical and Microsoft announced performance optimization and joint support for Microsoft SQL Server on Ubuntu. 13 17. 17 [](/posts/slashbase-slashbase-the-open-source-collaborative-ide-for-your-databases--j9feqdsc3 "slashbase/slashbase: The open-source collaborative IDE for your databases.") Article Changelog · 5y slashbase/slashbase: The open-source collaborative IDE for your databases. Slashbase is an open-source collaborative IDE for your databases in your browser. Connect to your database, browse data, run a bunch of SQL commands or share queries with your team, right from your browser! It's written in Golang and Nextjs React Framework (SPA) and runs as a single Linux binary with Postgres. 12 18. 18 [](/posts/dbizzy-an-intuitive-vscode-extension-for-database-development-dzuawjefv "dBizzy: An Intuitive VSCode Extension for Database Development") Article Medium · 5y dBizzy: An Intuitive VSCode Extension for Database Development dBizzy is an intuitive VSCode extension for early-stage database development. It gives you the ability to visualize your ER diagrams and test queries on local instances of your databases. It's lightweight, supports real-time rendering and exporting of ER diagrams, and the local database instances only persist in memory for the duration of your tab’s session. The other half ofdBizzy streamlines the query testing aspects of constructing a database. 12 1 19. 19 [](/posts/write-faster-and-more-efficient-sql-queries-nukny3cnnt "Write Faster and More Efficient SQL Queries") Article DZone · 5y Write Faster and More Efficient SQL Queries 12 20. 20 [](/posts/databases-in-2021-a-year-in-review-w67a-565g "Databases in 2021: A Year in Review") Article Hacker News · 5y Databases in 2021: A Year in Review It was a wild year for the database industry, with newcomers overtaking the old guard and vendors fighting over benchmark numbers. We also had to say goodbye to some of our database friends through acquisitions, bankruptcies, or retractions. Here are some of the highlights and a few of my thoughts on what they might mean for the field of databases. 11 1 21. 21 [](/posts/what-technologies-should-i-learn--copmugpn2 "What technologies should I learn?") Article thoughbot · 5y What technologies should I learn? The advice below is targeted to an early career teammate at thoughtbot. Many newcomers to the industry flit from one language to another but don’t master any of them and stay stuck with a shallow skill set. There are some evergreen skills that will help you throughout a career in web development regardless of what languages come and go. 11 22. 22 [](/posts/the-power-of-sql-exvosniuw "The Power of SQL") Article Towards Dev · 5y The Power of SQL Structured Query Language or SQL was created by Edgard Codd in 1970 at IBM in order to deal with the large amounts of data that was coming to the world on a regular basis. It has been over 50 years since SQL has come to be and yet it still one of the most widely utilized programming languages today. A recent analysis from dataquest.io showed that out of 32,000 jobs that mention the key word ‘data’ in it, SQL is one of. the top programming languages to have as a skill set when applying to jobs. 10 23. 23 [](/posts/crud-with-golang-and-cockroachdb-4ipngguvn "CRUD with Golang and CockroachDB") Article LogRocket · 5y CRUD with Golang and CockroachDB CockroachDB is a fast database that’s easy to set up. It scales easily (without the manual complexity of sharding), rebalances and repairs itself automatically. The app we will be building is a full-stack web app that allows us to get, add, update, and delete names. 10 24. 24 [](/posts/take-your-sql-from-good-to-great-part-3-w7kot5q6 "Take your SQL from Good to Great: Part 3") Article Towards Data Science · 5y Take your SQL from Good to Great: Part 3 Inner JOIN is a way to join two tables based on some time logic. Range JOINs are a more refined way to merge two tables together. Lateral joins allow you to access columns after the FROM statement. BigQuery uses implicit Lateral Joins via a UNNEST tool. 10 2 [See all SQL archives](/tags/sql/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/sql/best-of/2021#page","url":"https://daily.dev/tags/sql/best-of/2021","name":"Best SQL Posts of 2021","description":"The most upvoted SQL posts of 2021, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/sql/best-of/2021#items","numberOfItems":24,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/the-missing-sql-basics-crash-course-jkzkf9ye3","name":"🚀 The Missing SQL Basics Crash Course"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/top-10-sql-commands-everyone-should-know-uoo-kolyh","name":"Top 10 SQL Commands Everyone Should Know"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/complete-web-development-roadmap-for-newbies-mb-yofvss","name":"Complete web development roadmap for newbies"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/9-best-javascript-and-typescript-orms-for-2021-yqpiiadp","name":"9 Best JavaScript and TypeScript ORMs for 2021"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/use-sql-query-builder-knex-js-with-node-js-and-express-js-og3q-m5jb","name":"Use SQL Query Builder Knex.js with Node.js and Express.js"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/should-i-use-mongodb-or-postgresql--oq5s6wmzf","name":"Should I Use MongoDB or PostgreSQL?"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/arctype---supercharged-sql-client-for-developers-and-teams-8wo0slzfi","name":"Arctype - Supercharged SQL client for developers and teams"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/sql-cheat-sheet-xrq51p9oe","name":"SQL Cheat Sheet"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/what-s-hot-in-web-development-weekly-picks-164-m6oyhvrnw","name":"🔥 What's Hot in Web Development? — Weekly Picks #164"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/db-lens---explore-data-execute-sql-metrics-disk-usage-more-isl28ztil","name":"DB Lens - Explore data, execute SQL, metrics, disk usage & more"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/nosql-does-not-mean-relational--dchiw3vc","name":"NoSQL does not mean !Relational"},{"@type":"ListItem","position":12,"url":"https://daily.dev/posts/sql-playground---free-private-sample-postgresql-databases-grvchdl-9","name":"SQL playground - Free private sample PostgreSQL databases"},{"@type":"ListItem","position":13,"url":"https://daily.dev/posts/how-we-built-a-forever-free-serverless-sql-database-o4zdulod","name":"How we built a forever-free serverless SQL database"},{"@type":"ListItem","position":14,"url":"https://daily.dev/posts/best-postgresql-guis-in-2020-gjyl0q1bq","name":"Best PostgreSQL GUIs in 2020"},{"@type":"ListItem","position":15,"url":"https://daily.dev/posts/how-to-use-sql-subqueries-eh8iqlzqf","name":"How To Use SQL Subqueries"},{"@type":"ListItem","position":16,"url":"https://daily.dev/posts/ubuntu-21-04-is-here-m2puapily","name":"Ubuntu 21.04 is here"},{"@type":"ListItem","position":17,"url":"https://daily.dev/posts/slashbase-slashbase-the-open-source-collaborative-ide-for-your-databases--j9feqdsc3","name":"slashbase/slashbase: The open-source collaborative IDE for your databases."},{"@type":"ListItem","position":18,"url":"https://daily.dev/posts/dbizzy-an-intuitive-vscode-extension-for-database-development-dzuawjefv","name":"dBizzy: An Intuitive VSCode Extension for Database Development"},{"@type":"ListItem","position":19,"url":"https://daily.dev/posts/write-faster-and-more-efficient-sql-queries-nukny3cnnt","name":"Write Faster and More Efficient SQL Queries"},{"@type":"ListItem","position":20,"url":"https://daily.dev/posts/databases-in-2021-a-year-in-review-w67a-565g","name":"Databases in 2021: A Year in Review"},{"@type":"ListItem","position":21,"url":"https://daily.dev/posts/what-technologies-should-i-learn--copmugpn2","name":"What technologies should I learn?"},{"@type":"ListItem","position":22,"url":"https://daily.dev/posts/the-power-of-sql-exvosniuw","name":"The Power of SQL"},{"@type":"ListItem","position":23,"url":"https://daily.dev/posts/crud-with-golang-and-cockroachdb-4ipngguvn","name":"CRUD with Golang and CockroachDB"},{"@type":"ListItem","position":24,"url":"https://daily.dev/posts/take-your-sql-from-good-to-great-part-3-w7kot5q6","name":"Take your SQL from Good to Great: Part 3"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"SQL","item":"https://daily.dev/tags/sql"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/sql/best-of"},{"@type":"ListItem","position":5,"name":"2021"}]}]} ```