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 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

Published in Better Programming

·Jul 7

How to Build a Fullstack App With Next.js, Prisma, Postgres, and Fastify

Build an attendance management app — In this article, we’ll learn how to build a Full-stack application using Next.js, Prisma, Postgres, and Fastify. We will build an attendance management demo application that manages employees’ attendance. The flow of the app is simple: an administrative user logs in, creates an attendance sheet for the day, then every…

Nextjs

14 min read

Published in Database Dive

·Jul 5

Security vs. Performance in the SQL World

If you found yourself inside the world of databases in one way or another, you already know a little about database security and performance. Database management systems certainly do come with benefits to your databases, but have you thought about what options you need to weigh from the security and…

Technology

7 min read

Security vs. Performance in the SQL World