Arctype – Medium

Published in Database Dive

·Pinned

Less Memory and More Data with IndexedDB

Memory usage is an important metric for Arctype. Developers expect their tools — especially UIs — to be fast and smooth. Recently we improved our memory management algorithms using IndexedDB, Socket.IO, and Typescript. This post takes you inside our reason for the changes, design considerations, implementation, and impact. Prior to…

Software Development

11 min read

Less Memory and More Data with IndexedDB

Published in Database Dive

·Aug 23

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 — one of such settings is the secure_file_priv variable. What is the secure_file_priv Variable and How Does it Work? The secure_file_priv variable is heavily associated with…

My SQL

3 min read

Published in Database Dive

·Aug 16

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 wide majority of the most popular data types offered by MySQL are related to text…

My SQL

6 min read

CHAR vs. VARCHAR: What’s the Difference?

Published in Better Programming

·Aug 3

Handling File Uploads With NestJS and MySQL

Connect to a MySQL database using TypeORM, create an entity, and upload images to the Nestjs application. — Introduction Many 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. Many people may want to save their files directly to a MySQL database, or save…

Programming

7 min read

Handling File Uploads With NestJS and MySQL

Published in Database Dive

·Jul 28

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 as indexes might be, they also need a lot of work to get right –…

Database

7 min read

Published in CodeX

·Jul 27

Use Django and the Dev.to API to Display Posts

As a developer, you may be wondering if you need a blog. To be honest, I have been blogging for a while, and all I can tell you is that having a blog on your website has immense benefits. Let’s just say that you have a website where you have…

Django

10 min read

Published in Database Dive

·Jul 26

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 it. The introduction of the JSON data type to relational databases represented a turning…

Technology

6 min read

Published in Database Dive

·Jul 26

How To Design a Multi-Language Database

Today we look at three best-practice database designs to store data in multiple languages and easily scale to new markets. Reaching millions of users with an application is every developer's dream. Achieving this goal becomes easier if users from all over the world can use your application. Since not all…

6 min read

Published in Database Dive

·Jul 14

The Darker Side of ALTER TABLE: A Guide

If you frequently find yourself immersed into the MySQL world, there’s probably no need to explain to you what SQL queries are and what they do. Chances are, you know them like your five fingers. SELECT queries allow us to read data, INSERT queries allow us to insert data into…

Sql

6 min read

Published in Database Dive

·Jul 12

How Does MySQL Configuration Work?

If you’ve found yourself in the MySQL space at least for a little while, chances are that you have heard about one of its well-known files: my.cnf. my.cnf is a configuration file exclusive to MySQL and all of its flavors and it’s widely regarded as the “go-to” file whenever MySQL…

Sql

5 min read