DbVisualizerforThe Tablethetable.hashnode.dev·7 hours agoIn-Depth Guide to MySQL Numeric Data TypesMySQL numeric data types are fundamental for structuring databases that manage a wide range of values, from small integers to large floating-point numbers. Choosing the correct data type not only affects storage requirements but also impacts the spee...DiscussMySQL
Hansraj Deghunpythondevop.hashnode.dev·a day agoZero Downtime MySQL MigrationMigrating a massive MySQL table with over a billion rows while ensuring zero downtime can be a complex task. However, using a shadow tables and triggers, you can perform this migration seamlessly. In this blog post, we’ll walk you through the process...Discuss·3 likesMySQL
Danny Crastoblog.danwald.me·Oct 30, 2024CONCAT to update db text fieldI needed to collect messages from different processes which was triggered by a record insertion. To keep things simple and denormalized, this stack overflow gem allows for that. from django.db import models class DBModel(models.Model): @classmet...DiscussMySQL
Ogunuyo Ogheneruemu Biruemu.hashnode.dev·Oct 29, 2024Building a Comprehensive User Authentication Flow with React and Node.jsIn this blog post, we will explore how to build a full-featured user authentication flow using React for the frontend and Node.js with MySQL for the backend. This guide will cover: User Registration: Letting users sign up. Login: Providing secure a...DiscussNode.js
JIMOH Mofoluwasho Kolawolekorlahwarleh.hashnode.dev·Oct 29, 2024Install and run Laravel application on a remote server (Part C)This is the final part of our three-part tutorial on installing your Laravel application on a remote server. In Part A, we covered setting up a Linux server using a DigitalOcean droplet (you can also use an AWS EC2 instance for this). Part B focused ...DiscussLaravel
JIMOH Mofoluwasho Kolawolekorlahwarleh.hashnode.dev·Oct 29, 2024Install and run Laravel application on a remote server (Part B)This tutorial is a continuation of part A (Part A). In Part A, I demonstrated how to set up your server. In this part, I'll guide you through installing the Laravel application on the server. Note: Because of the time gap between the two tutorials, t...DiscussLaravel
DbVisualizerforThe Tablethetable.hashnode.dev·Oct 28, 2024MySQL Daemon: Essential ToolsThe MySQL daemon (mysqld) is a fundamental part of MySQL database management, offering command-line access to powerful tools for maintaining and optimizing databases. This guide outlines the core utilities available through mysqld. Core tools offered...Discussdaemon
Shreyansh Guptashreyanshgupta.hashnode.dev·Oct 27, 2024gh-ost - an Online Schema Change toolOnline Schema Change (OSC) tools are tools that allow us to change the schema of databases in production in a non-blocking manner. i.e. in such a manner that the changes have a minimal impact on the availability of the database. gh-ost is one such to...DiscussDatabases
Shreyansh Guptashreyanshgupta.hashnode.dev·Oct 26, 2024Replication formats in databasesIn this article, we are going to understand the different replication formats. Problem statement We have 2 database nodes. The first one is a source node. This node is directly communicating with the application. All the writes are applied to this no...DiscussDatabases
Thirdy Gayaressoftware-engineer.thirdygayares.com·Oct 25, 2024How to Create MYSQL Table with Foreign Key Constraint and add sample dataERD: ERD Credit from Group OnlineQuizPlatformSVFC 💡 SHOW DATABASES 💡 CREATE quiz_db database 💡 Show database again as you can see, we are successfully created the quiz_db 💡 use quiz_db; 💡 SHOW TABLES; Step 1: MySQL Table...DiscussMySql Databaseinsert data mysql
