What is the secure_file_priv Variable in MySQL?
If you have ever dived deeper into the settings letting you unleash the full power of MySQL, you might already come across a couple of settings letting you perform a variety of different tasks –…
Category: Arctype
How to Use SQL to Analyze And Visualize Data?
The Arctype SQL ClientTo use Arctype, navigate to the Arctype homepage and download the Arctype app on your machine. The application is available on Windows, macOS, and Linux.Once the app has been installed, open it…
CHAR vs. VARCHAR: What’s the Difference?
If you’ve found yourself in the MySQL space even for a little while, you already know that MySQL and other flavors of it offer a couple of data types for developers to choose from. A…
MySQL’s UTF-8 Isn’t Real
If you are familiar with MySQL, you probably already know that it comes with multiple character encodings. One of the main encodings in the MySQL world and on the web in general is UTF-8 –…
Building REST Endpoints with Knex and PostgreSQL
In this blog, we will tell you how you should go about building REST-based services using Knex and PostgreSQL.What is Knex and PostgreSQL?Knex is a versatile, portable, and enjoyable SQL query builder for PostgreSQL, CockroachDB,…
Top 5 Google Cloud Database Services – Part 1 (SQL)
Google Cloud Platform offers various cloud database tools and services based on what a company needs to accomplish with them. Thus, the different tools have different purposes. In this article, we’ll be looking at the…
Handling File Uploads with NestJS and MySQL
IntroductionMany developers despise dealing with file uploads. This can be attributed to a lack of knowledge about the best approach to take or difficulties determining how to configure their Nest.js application to handle file uploads.…
Deriving Ideal Indexes For Your SQL Database: A Guide
Indexes are there to simplify our work when searching for data: they speed up SELECT queries at the expense of slowing down other kinds of queries like DELETEs, UPDATEs, and INSERTs instead. However, as awesome…
Use Django and the Dev.to API to Display Posts
Let us now install Django in our Blog Django project. To install Django, we will use a packaging tool for python called Pipenv. Pipenv is used to manage virtual environments in Django projects. You can…
When to Use JSON in Your Database
In this blog, you will learn when you should consider adding JSON data types to your tables and when you should avoid it.Most relational database technologies can now store JSON data and perform queries on…