How To Use SQL Subqueries
Learn how to filter query results with data from another table, run a query inside another query to merge results, and more in this basic guide to SQL subqueries.
2 months ago
SQL
Featured
MySQL
SQL Injection vs. Your Applications in the Modern Age
SQL injection attacks traditionally represent one of the largest threats to database security. This article explains what they are and how you can prevent them.
3 months ago
Utilizing BigQuery as a Data Warehouse in a Distributed Application
When it comes to storing data, a robust and reliable solution to store data from various sources is the most important factor. In this article, we will see how to centralize data collection in a distributed application with Google BigQuery.
4 months ago
Write Faster and More Efficient SQL Queries
As developers, we are aware of various best practices for SQL query optimization. While a few of these are specific to individual relational database management systems (RDBMSs), most can apply to virtually any database.
4 months ago
Too Good To Be True: Why NewSQL Failed
NewSQL was supposed to combine the best of SQL and NoSQL databases. 10 years after its inception, we are left wondering why it never saw broad adoption. What led to this failure? Lack of specialization and the cloud.
4 months ago
Featured
Databases
A Hitchhiker's Guide to SQLite3 with Python
To explore SQLite3 along with Python, which is a user-friendly and no-nonsense language, we are going to build a simple tic-tac-toe game. So buckle up and get your machines ready!
By
Zach Naimon
Getting Started with PostgreSQL Set Operators
Postgres offers set operators that make it easy to query and filter the results of searches from your database. Set operators are used to join the results of two or more SELECT statements.
6 months ago
Collaborative Filtering in MySQL: A Tutorial
Being able to view products and pages liked by other users is not only an interesting exercise, but also a nearly-ubiquitous marketing tool—and, it can be easily implemented with MySQL using Arctype.
6 months ago
No-Code: "It's a Trap!"
Low-Code/No-Code tools have been on the rise in recent years. However, a significant number of organizations have become trapped by them. What causes this and what can we do to avoid it?
6 months ago