Community Picks·2yMastering Relational Database Design: A Comprehensive Guide
Learn the fundamentals of relational databases, their management systems, and principles of effective database design. Understand the importance of naming conventions, data integrity, keys, indexes, and cardinality. Explore different types of joins and the benefits of using aliases. Plus, get an introduction to the Database Modeling Language (DBML).
DEV·2yGuide To Choose A Database For Your Next Design
Guide to choosing the right database for your next design. Discusses the differences between relational and non-relational databases, their features and drawbacks, and provides guidance on choosing the appropriate database for specific requirements.
Community Picks·2yMastering SQL: Comprehensive Guide To Structured Query Language
This post provides a comprehensive guide to SQL, covering topics such as basic queries, filtering data, sorting data, aggregate functions, grouping data, joins, subqueries, views, indexing, transactions, stored procedures, backup and recovery, and SQL dialects.
The New Stack·2yDrizzle ORM Is SQL in a JavaScript Hat — and Wears It Well
Drizzle ORM is a JavaScript solution for writing SQL in TypeScript environments. It allows developers to interact with relational databases using method-based syntax. Drizzle ORM aims to be as SQL-like as possible, closely following the goals of SQL. With Drizzle ORM, developers can preserve type safety and access TypeScript types without needing additional tooling.
Real Python·2yWhat Are CRUD Operations? – Real Python
CRUD operations are fundamental in software development and play a crucial role in creating, reading, updating, and deleting data. They are essential for effective data management and are closely related to SQL commands and HTTP request methods. FastAPI is a powerful tool for implementing CRUD operations in a REST API.
Daily Dose of Data Science | Avi Chawla | Substack·2yGrouping Sets, Rollup and Cube in SQL
This post discusses three lesser-known grouping operations in SQL: Grouping Sets, Rollup, and Cube. These operations allow for efficient multiple aggregations on the same table, generating subtotals, grand totals, and all possible combinations of aggregations. The order is important in ROLLUP, and CUBE creates a result set with all possible combinations.
Community Picks·2yHow To Write Better SQL Queries: The Definitive Guide – Part 2
This post provides insights into evaluating and optimizing SQL query performance. It discusses time complexity, the big O notation, and the estimation of query plan complexity. It also suggests various SQL tuning techniques.
Medium·2yMy First Billion (of Rows) in DuckDB
The post describes the author's experience with DuckDB, a database for processing large volumes of data locally. It covers the problem of processing logs of Brazilian electronic ballot boxes and the challenges involved. The post explains the features and advantages of DuckDB and provides a step-by-step implementation of data processing. It concludes with the author's evaluation of DuckDB's performance and usability.
Hacker News·2yquarylabs/quary: Open-source BI for engineers
Quary is an open-source BI tool for engineers that allows you to connect to databases, write SQL queries to transform and organize data, create charts and dashboards, and deploy the model back to the database. It can be installed as a VSCode extension or a Rust-based CLI.
Milan Jovanović·2yEF Core Migrations: A Detailed Guide
This post provides a detailed guide on Entity Framework (EF) Migrations. It covers topics such as creating migrations, migration SQL scripts, applying migrations, customizing migrations, and additional database migration tools. The post also includes some best practices for EF Core migrations.
