© 2023 Hashnode
#sql
I've been a tennis player and fan of the pro tour my whole life. Since sports betting in the US was legalized, I've seen some friends of mine make ridiculous bets on tennis matches. Even with my knowl…
Introduction: In my previous blog, I discussed the applications of SQL by solving the case study- Danny's Dinner. Now in this blog, we will learn the concepts of SQL, which will boost your understand…
Introduction: Visual Studio Code (VS Code) is a popular code editor known for its extensibility and versatility. If you're an EdgeDB user and want to leverage the power of VS Code for your EdgeDB deve…
Structured Query Language (SQL) databases are some of the most widely deployed pieces of software around the world. One of the most popular database engines is SQLite. Unlike others, SQLite does not i…
Introduction: EdgeDB is a modern, high-performance database designed for efficient and scalable data storage. If you're a Windows user and interested in exploring the capabilities of EdgeDB, you've co…
When it comes to handling complex queries, one concept stands above the rest: composite indexing. By combining multiple columns into a single index, composite indexing unlocks the potential for faster…
Let's explore the relevance of database indexing in a Relational Database Management System. This article aims to answer the What, How, and Why of database indexing. What is Database Indexing? In simple terms, database indexing is a concept…
Query optimization is the overall process of choosing the most efficient means of executing a SQL statement. Why is it needed? First, it provides the user with faster results, which makes the application seem faster to the user. Secondly…
When working with Alembic, the database migration tool for Python, there is an important aspect to consider regarding Enum types. Alembic does not automatically create an enum type when altering a tab…
What SQL database library to use for your Golang projects ? There are several popular options : database/sql package ORM, for example gorm sqlx library Each of the above options has tradeoff, bec…