Arctype Team

If you have ever dived deeper into the settings letting you unleash the full power of MySQL, you...

The goal of every business is to perform efficiently, maximize profit and make strategically-guided...

If you’ve found yourself in the MySQL space even for a little while, you already know that MySQL and...

If you are familiar with MySQL, you probably already know that it comes with multiple character...

What is Knex and PostgreSQL? Knex is a versatile, portable, and enjoyable SQL query...

Google Cloud Platform offers various cloud database tools and services based on what a company needs...

Introduction Many developers despise dealing with file uploads. This can be attributed to...

Indexes are there to simplify our work when searching for data: they speed up SELECT queries at the...

As a developer, you may be wondering if you need a blog. To be honest, I have been blogging for a...

In this blog, you will learn when you should consider adding JSON data types to your tables and when...

Today we look at three best-practice database designs to store data in multiple languages and easily...

If you frequently find yourself immersed into the MySQL world, there’s probably no need to explain to...

If you’ve found yourself in the MySQL space at least for a little while, chances are that you have...

In this article, we’ll learn how to build a Full-stack application using Next.js, Prisma, Postgres,...

If you found yourself inside of the world of databases in one way or another, you already know a...

Until now, we’ve been looking at tools from a specific developer or platform. We covered ApexSQL,...

MySQL generated columns pose as a powerful, easy-to-use, and advanced tool for anyone who wants to...

One of the primary issues in the database world is SQL injection – it’s prevalent to such an extent...

Previously we looked at some of the most common native Azure tools for SQL databases. These included...

In the previous article, we discussed the top ApexSQL tools used in the Azure SQL database. In this...

If you are already familiar with other SQL databases but new to PostgreSQL, then this article is...

Vercel is one of the best hosting services because of its simplicity and adaptability. It allows you...

If you find yourself reading this post, there are very good chances that you find yourself in the...

Microsoft Azure has a robust set of SQL database tools to cover you for every operation you may need....

This article will show how column propagation can represent an easy approach to improving query...

The code for this tutorial is available on my Github repository. Feel free to clone it as you follow...

Real-world data is messy and chaotic. Unlike the well-curated academic datasets available online, it...

Count queries are probably the most-used aggregate queries in a relational database. Counting is a...

Working with SQL through the command line can be tedious and difficult. But interacting with your...

"Offline first" is an application development paradigm in which developers ensure that an app's...