ByteByteGo·3yUnderstanding 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.
Machine Learning News·2yBest 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.
DEV·2yWhy 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.
Materialize·3yMaterialize 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.
KDnuggets·3yWhy 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.
ByteByteGo·3yEP63: 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.
DBconvert·3yMySQL 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.
ByteByteGo·3yEP60: 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.
Amplication·3ySQL 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.
ByteByteGo·3yEP50: 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.
Community Picks·3yWe 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.
freeCodeCamp·3yThe 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.
ITNEXT·3ySQL 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.
KDnuggets·3yUsing 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.
freeCodeCamp·3yLearn 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.
KDnuggets·3yDatabase 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.
