--- title: Best SQL posts of 2023 | daily.dev description: The most upvoted SQL posts of 2023, curated by the daily.dev community. canonical: https://daily.dev/tags/sql/best-of/2023 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/sql/best-of/2023 og:type: website og:site_name: daily.dev og:title: Best SQL posts of 2023 | daily.dev og:description: The most upvoted SQL posts of 2023, 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 — 2023 1. 1 [](/posts/understanding-database-types-iyyyurcpc "Understanding Database Types") Article ByteByteGo · 3y Understanding Database Types A complex application usually uses several different databases, each catering to a specific aspect of the application’s needs. In this comprehensive three-part series, we’ll explore the art of database selection. To make the best decision for our projects, it is essential to understand the various types of databases available in the market. 240 9 2. 2 [](/posts/sql-formatter-qetylyj7x "SQL Formatter") Article Community Picks · 3y SQL Formatter A tool called SQL Formatter that helps developers format SQL code for readability and consistency. 199 9 3. 3 [](/posts/best-platforms-to-practice-sql-xocn3ypba "Best Platforms to Practice SQL") Article Machine Learning News · 3y Best Platforms to Practice SQL SQL is a must-know skill in the tech world. This article explores the best platforms to practice SQL, ranging from beginner-friendly platforms to comprehensive learning resources with real-world interview questions. Each platform offers unique features to enhance SQL skills for various data roles. 179 2 4. 4 [](/posts/why-you-should-never-use-an-uuid-as-the-primary-key-in-sql-databases-lqrr30rj1 "Why you should never use an UUID as the primary key in SQL Databases") Article DEV · 3y Why you should never use an UUID as the primary key in SQL Databases Using a UUID as a primary key in SQL databases has advantages and disadvantages. UUIDs have larger storage requirements and decreased performance compared to integers. They are not human-readable, making debugging and manual inspection challenging. UUIDs may result in suboptimal disk I/O patterns and higher levels of index fragmentation. Storing UUIDs increases storage requirements. Managing UUIDs adds complexity to application logic. 158 9 5. 5 [](/posts/materialize-extension-for-vs-code-hzmdys8c5 "Materialize extension for VS Code") Article Materialize · 3y Materialize extension for VS Code The Materialize VS Code extension allows developers to explore, query, and enhance their development experience. It is compatible with various IDEs and provides features such as schema exploration, profile configuration, query execution, and syntax validation. 151 3 6. 6 [](/posts/16-sql-techniques-every-beginner-needs-to-know-rowxlf3md "16 SQL Techniques Every Beginner Needs to Know") Article Hacker Noon · 4y 16 SQL Techniques Every Beginner Needs to Know Learn SQL techniques for data warehousing, including handling incremental tables, using MERGE statements, and converting tables to JSON objects. 102 5 7. 7 [](/posts/master-sql-uv59agmjb "Master SQL") Article Community Picks · 3y Master SQL SQL is a powerful language used for data retrieval and manipulation. Learning SQL is important for data-driven careers and offers universal applicability. There are various resources and platforms available for hands-on SQL practice. 89 15 8. 8 [](/posts/introducing-storage-on-vercel-vercel-qtded2cdb "Introducing storage on Vercel – Vercel") Article Community Picks · 3y Introducing storage on Vercel – Vercel Vercel has introduced storage solutions including Vercel KV, Vercel Postgres, and Vercel Blob, making it easier to manage frontend storage needs without worrying about infrastructure. 90 13 9. 9 [](/posts/why-is-duckdb-getting-popular--vsptbmslg "Why is DuckDB Getting Popular?") Article KDnuggets · 3y Why is DuckDB Getting Popular? DuckDB combines the simplicity and ease of use of SQLite with the analytical performance of specialized columnar databases. DuckDB is free and open-source software, so anyone can use and modify the code. It's embedded, meaning the DBMS ( database management system) runs in the same process as the application that uses it. 84 9 10. 10 [](/posts/ep63-linux-file-system-explained-kcdvdfrjq "EP63: Linux file system explained") Article ByteByteGo · 3y EP63: Linux file system explained The Filesystem Hierarchy Standard (FHS) was introduced to bring order to the Linux file system. By implementing a standard like the FHS, the software can ensure a consistent layout across various Linux distributions. To become proficient in this standard, you can begin by exploring. Utilize commands like "cd" for navigation and "ls" for listing directory contents. 84 2 11. 11 [](/posts/build-a-real-time-dashboard-step-by-step-guide-z0wx2lr35 "Build a Real-time Dashboard: Step-by-Step Guide") Article Tinybird · 3y Build a Real-time Dashboard: Step-by-Step Guide Build a real-time dashboard from scratch using Tinybird, Tremor, and Next.js. 82 2 12. 12 [](/posts/mysql-vs-postgresql-in-2023--yustl36rk "MySQL vs PostgreSQL in 2023.") Article DBconvert · 4y MySQL vs PostgreSQL in 2023. PostgreSQL and MySQL are both reliable, secure and scalable databases that have been around for decades. They each have different strengths and weaknesses that make one more suitable for certain use cases than the other. This article will compare them to aid in making an informed decision in 2023. 73 7 13. 13 [](/posts/upsert-in-sql-pwuw73xan "Upsert in SQL") Article Pointer · 3y Upsert in SQL This article discusses the concept of upsert in SQL and explains how it works in different database management systems (DBMS) like MySQL, SQLite, and PostgreSQL. It provides examples and code snippets for each DBMS to demonstrate the various ways to perform upsert operations. 70 14. 14 [](/posts/ep60-netflix-tech-stack---databases-f1o0z9fch "EP60: Netflix Tech Stack - Databases") Article ByteByteGo · 3y EP60: Netflix Tech Stack - Databases This week’s system design refresher: SQL Query Execution Order (Youtube video) Netflix Tech Stack - Databases The 10 Algorithms That Dominate Our World ‘Pull’ and ‘Push’ Payments ByteByteGo Talent Collective Retool is the fast way to build internal tools. 69 15. 15 [](/posts/sql-versus-nosql-databases-which-to-use-when-and-why-im6siz5et "SQL Versus NoSQL Databases: Which to Use, When, and Why") Article Amplication · 3y SQL Versus NoSQL Databases: Which to Use, When, and Why The right choice means we can scale up an application quickly and handle increasing user requests without encountering problems. Choosing the right database for your application is no mean feat, given the number of available databases. There are many differences between SQL and NoSQL databases, such as how they handle relational data, their query languages. 67 6 16. 16 [](/posts/text2sql-ai---generate-sql-with-ai-x6aotsk9j "Text2SQL.AI - Generate SQL with AI") Article Product Hunt · 4y Text2SQL.AI - Generate SQL with AI The best of Product Hunt, everyday Web3 Keep up to date with the latest in web3 New here? Learn more about navigating Product Hunt. Discover the best products by month. 65 5 17. 17 [](/posts/ep50-visualizing-a-sql-query-wqhoqarua "EP50: Visualizing a SQL Query") Article ByteByteGo · 4y EP50: Visualizing a SQL Query The most useful engineering conversation you’ll hear each week (Sponsored) Dev Interrupted is the No. 1 source for what the smartest minds in development are thinking about. Hear career-changing wisdom by leaders from companies like Slack, Stripe, and Shopify delivered to your inbox every week. 51 18. 18 [](/posts/5-free-books-to-master-sql-1igvf5m8x "5 Free Books to Master SQL") Article KDnuggets · 3y 5 Free Books to Master SQL Discover five free books to improve your SQL skills, covering everything from beginner to advanced levels. Learn SQL fundamentals, data manipulation, database management, and more. 49 19. 19 [](/posts/crud-operations-in-sql-database-gbdl1wfql "CRUD Operations In SQL Database") Article Towards Dev · 3y CRUD Operations In SQL Database Learn about CRUD operations in SQL, which stands for Create, Read, Update, and Delete. Understand how to apply these operations and their importance in managing data effectively in relational databases. 47 1 20. 20 [](/posts/we-migrated-to-sql-our-biggest-learning-don-t-use-prisma-5ybbgmmt6 "We migrated to SQL. Our biggest learning? Don’t use Prisma") Article Community Picks · 3y We migrated to SQL. Our biggest learning? Don’t use Prisma A developer shares their experience migrating from MongoDB to Postgres and using Prisma for their backend. They highlight problems with Prisma's deployment, low performance, and lack of SQL-level joins. They ultimately recommend avoiding Prisma for production workloads. 47 6 21. 21 [](/posts/the-sql-handbook-a-free-course-for-web-developers-mtr8xhzl3 "The SQL Handbook – A Free Course for Web Developers") Article freeCodeCamp · 3y The SQL Handbook – A Free Course for Web Developers The SQL Handbook is a free and open text-based handbook for Web Developers. Try the interactive version of this SQL course on Boot.dev, complete with coding challenges and projects. Watch the video walkthrough of this course on FreeCodeCamp's YouTube channel. 44 1 22. 22 [](/posts/sql-performance-tuning-ru2uw2brf "SQL performance tuning") Article ITNEXT · 3y SQL performance tuning Northwind is a simple database often used by people who want to learn SQL and that’s what we are going to use. The dataset consists of 13 tables that can be seen below: Later in this article, I’ll show how you can install this database on your local machine, using SQL Management Studio. 44 1 23. 23 [](/posts/using-chatgpt-to-learn-sql-fwqd77vxn "Using ChatGPT to Learn SQL") Article KDnuggets · 3y Using ChatGPT to Learn SQL ChatGPT is a large language model trained by OpenAI. It is capable of generating human-like text based on the input it receives. It can be used to answer questions and engage in conversations with people. In this article, I will outline how you can useChatGPT to learn SQL and become proficient in this valuable skill. 39 3 24. 24 [](/posts/learn-mysql-beginner-s-course-bu8jaloxo "Learn MySQL – Beginner's Course") Article freeCodeCamp · 3y Learn MySQL – Beginner's Course Learn MySQL with a comprehensive and practical course on the freeCodeCamp.org YouTube channel. The course covers topics from the basics to advanced functionalities, including installation, database creation, querying, joins, and more. Taught by Josh, a Sql Server Database Administrator. 33 25. 25 [](/posts/database-optimization-exploring-indexes-in-sql-kkwhsfhgk "Database Optimization: Exploring Indexes in SQL") Article KDnuggets · 3y Database Optimization: Exploring Indexes in SQL A similar issue also occurs in SQL Server when it retrieves data from the database. To overcome this, SQL server also uses indexing which speeds up the data retrieval process. We will cover why indexing is needed and how we can effectively create and delete indexes. 33 [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/2023#page","url":"https://daily.dev/tags/sql/best-of/2023","name":"Best SQL Posts of 2023","description":"The most upvoted SQL posts of 2023, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/sql/best-of/2023#items","numberOfItems":25,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/understanding-database-types-iyyyurcpc","name":"Understanding Database Types"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/sql-formatter-qetylyj7x","name":"SQL Formatter"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/best-platforms-to-practice-sql-xocn3ypba","name":"Best Platforms to Practice SQL"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/why-you-should-never-use-an-uuid-as-the-primary-key-in-sql-databases-lqrr30rj1","name":"Why you should never use an UUID as the primary key in SQL Databases"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/materialize-extension-for-vs-code-hzmdys8c5","name":"Materialize extension for VS Code"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/16-sql-techniques-every-beginner-needs-to-know-rowxlf3md","name":"16 SQL Techniques Every Beginner Needs to Know"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/master-sql-uv59agmjb","name":"Master SQL"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/introducing-storage-on-vercel-vercel-qtded2cdb","name":"Introducing storage on Vercel – Vercel"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/why-is-duckdb-getting-popular--vsptbmslg","name":"Why is DuckDB Getting Popular?"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/ep63-linux-file-system-explained-kcdvdfrjq","name":"EP63: Linux file system explained"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/build-a-real-time-dashboard-step-by-step-guide-z0wx2lr35","name":"Build a Real-time Dashboard: Step-by-Step Guide"},{"@type":"ListItem","position":12,"url":"https://daily.dev/posts/mysql-vs-postgresql-in-2023--yustl36rk","name":"MySQL vs PostgreSQL in 2023."},{"@type":"ListItem","position":13,"url":"https://daily.dev/posts/upsert-in-sql-pwuw73xan","name":"Upsert in SQL"},{"@type":"ListItem","position":14,"url":"https://daily.dev/posts/ep60-netflix-tech-stack---databases-f1o0z9fch","name":"EP60: Netflix Tech Stack - Databases"},{"@type":"ListItem","position":15,"url":"https://daily.dev/posts/sql-versus-nosql-databases-which-to-use-when-and-why-im6siz5et","name":"SQL Versus NoSQL Databases: Which to Use, When, and Why"},{"@type":"ListItem","position":16,"url":"https://daily.dev/posts/text2sql-ai---generate-sql-with-ai-x6aotsk9j","name":"Text2SQL.AI - Generate SQL with AI"},{"@type":"ListItem","position":17,"url":"https://daily.dev/posts/ep50-visualizing-a-sql-query-wqhoqarua","name":"EP50: Visualizing a SQL Query"},{"@type":"ListItem","position":18,"url":"https://daily.dev/posts/5-free-books-to-master-sql-1igvf5m8x","name":"5 Free Books to Master SQL"},{"@type":"ListItem","position":19,"url":"https://daily.dev/posts/crud-operations-in-sql-database-gbdl1wfql","name":"CRUD Operations In SQL Database"},{"@type":"ListItem","position":20,"url":"https://daily.dev/posts/we-migrated-to-sql-our-biggest-learning-don-t-use-prisma-5ybbgmmt6","name":"We migrated to SQL. Our biggest learning? Don’t use Prisma"},{"@type":"ListItem","position":21,"url":"https://daily.dev/posts/the-sql-handbook-a-free-course-for-web-developers-mtr8xhzl3","name":"The SQL Handbook – A Free Course for Web Developers"},{"@type":"ListItem","position":22,"url":"https://daily.dev/posts/sql-performance-tuning-ru2uw2brf","name":"SQL performance tuning"},{"@type":"ListItem","position":23,"url":"https://daily.dev/posts/using-chatgpt-to-learn-sql-fwqd77vxn","name":"Using ChatGPT to Learn SQL"},{"@type":"ListItem","position":24,"url":"https://daily.dev/posts/learn-mysql-beginner-s-course-bu8jaloxo","name":"Learn MySQL – Beginner's Course"},{"@type":"ListItem","position":25,"url":"https://daily.dev/posts/database-optimization-exploring-indexes-in-sql-kkwhsfhgk","name":"Database Optimization: Exploring Indexes in SQL"}]},{"@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":"2023"}]}]} ```