Browsing Tag
sql
48 posts
ORM vs No ORM: Which to Choose?
ORM (Object-Relational Mapping) Choose to use an ORM, like Sequelize, Django ORM, Hibernate, or Entity Framework if: You…
SQL vs NoSQL: Which to Choose?
SQL Choose SQL databases, like MySQL, PostgreSQL, and SQLite, if: Your data is structured and relational. You need…
Functions in SQL
Functions are very similar to procedures in databases. In this article, I will try to break down functions…
Is SQL a declarative language
When learning SQL, we often hear the saying that SQL is a declarative language. You just need to…
🏁🐘Winning Race Conditions With PostgreSQL
Race conditions suck! They can be extremely difficult to debug, and often only occur naturally in production at…
18 GitHub Repositories You Need to Star Right Now! 🌟🔥
Let’s Get Started 🙌 GitHub, the popular online platform for software and web development collaboration, provides helpful tools…
SQL or Java: Which is Faster for Data Operation?
SQL has always been the main language to calculate and process structured data. However, as technology evolves, Java…
The Syntax of Discreteness – Using SQL as an Example
Discreteness refers to the feature that members are allowed to be broken off from a set to exist…
Set-oriented Syntax – Using SQL as an Example
SQL, the most commonly used language for structured data processing, is much more convenient in describing the basic…
SQL to Python Pandas: A SQL User’s Quick Guide
In this post, we will compare the implementation of Pandas and SQL for data queries. We’ll explore how…