Mysql

Mysql posts, videos, courses, and more

DevDojo bobbyiliev Avatar

Bobby Iliev · 1 year ago

Difference between scaling horizontally and vertically for databases?

Introduction When your application or website starts to receive more traffic, you'll need to think about how to scale your database to handle the additional load. There are two main ways to...
5
DevDojo ragabekov Avatar

Roman Agabekov · 2 years ago

How we simplified MySQL Tuning to improve Laravel Performance

Hi there, My name is Roman, and I'm an engineer with ten years of experience in MySQL. I started the side project in 2020 to solve the problem around MySQL Performance Tuning to improve the...
1
DevDojo omarthedev Avatar

Omar Moustafa · 2 years ago

Manage Prisma records from Discord

Hello buddy 😊! Today we will use a Discord bot powered by Discord.py to manage our Prisma records, but in this article, we will pretend that we got a shop and we use the Discord.py bot to m...
2
DevDojo techvblogs Avatar

TechvBlogs · 2 years ago

How to Get Random Records from Database in Laravel

In the project development sometimes we need to display random data on Frontend that time we need to fetch random records from the database to display random records on the frontend. In Lara...
DevDojo techvblogs Avatar

TechvBlogs · 2 years ago

How to Install MySQL on Ubuntu 22.04

What is MySQL? MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQ...
3
DevDojo omarthedev Avatar

Omar Moustafa · 2 years ago

How to setup authentication with Node.js CLI and Prisma

Hello there! Today we will be integrating user authentication with your Node.js CLI, we will also cover how to create one, and we will make an API to authenticate user details! Without wasti...
2
DevDojo techvblogs Avatar

TechvBlogs · 2 years ago

How to use multiple database in Laravel

Laravel is a free, open-source PHP framework, created by Taylor Otwell. It follows a Model-View-Controller (MVC) design pattern. Laravel reuses the existing components of different framewor...
7
DevDojo bobbyiliev Avatar

Bobby Iliev · 2 years ago

Using Materialize and Airbyte with MySQL and Redpanda/Kafka

Introduction ❗️ This demo includes examples for an unsupported version of Materialize (0.26.x) ❗️ This is a self-contained demo using Materialize. This demo would show you how to use Mat...
5
DevDojo bobbyiliev Avatar

Bobby Iliev · 2 years ago

How to use 'IF' in 'SELECT' SQL statements?

Introduction In some cases, you might want to choose the output value based on column values directly in your SQL statement. In this article, we will explain how to use the CASE expression i...
11
DevDojo techvblogs Avatar

TechvBlogs · 2 years ago

How To Install WordPress with LAMP on Ubuntu 20.04

For those who cannot afford the hustles of developing websites from scratch, there are now several content management systems (CMSs) such as WordPress that you can take advantage of to set u...
6
DevDojo geektechpub Avatar

GeekTech · 2 years ago

Flask Blog Tutorial #2: User Registration and Interacting with MySQL

Howdy Geeks! 👋 I am back again. Previous version In this article, we will create a database to save user information for registration and create forms for registration. We will use MySQL...
2
DevDojo bobbyiliev Avatar

Bobby Iliev · 2 years ago

10 simple tips for optimizing your Laravel application

Introduction Laravel was created by Taylor Otwell and was initially released in June 2011. It is an open-source PHP framework that is used to build web applications. It is without a doubt th...
5
DevDojo techvblogs Avatar

TechvBlogs · 2 years ago

How to Reset MySQL root password in Ubuntu

Passwords are hard to remember, so if you have forgotten the MySQL root password, luckily, there is a way to change it. This post has been written for you, and by the end of this post, you w...
4
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

How to join MySQL and Postgres in a live materialized view

Introduction [!WARNING] This demo includes examples for an unsupported version of Materialize (0.26.x). This is a self-contained demo using Materialize. This demo would show you how to use...
4
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

Introduction If you have ever worked with MySQL and had to create your table structure, you have probably noticed that the DATETIME and TIMESTAMP data types are quite similar at a first glan...
4
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

How to import an SQL file using the command line in MySQL?

Introduction In some cases if you have a really large .sql file, it is best to import it via the command line. You might need to do this in case that you are using a tool like PHPmyAdmin, wh...
6
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

How to Add a Default Value to an Existing Column in MySQL

Introduction In this quick tutorial, you will learn how to add a default value to an existing column in MySQL. Prerequisites You always need to be careful, when changing the structure of an...
5
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

The Data Engineer Roadmap 🗺

Introduction With the ever growing data volumes and demands, the data engineering career has been one of the fastest growing jobs for the past few years. According to the 2021 Stack Overflow...
7
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

🚀 The Missing SQL Basics Crash Course

Introduction No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career. The guide is suitable fo...
8
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu

In this video you will learn how to Install Apache, MySQL, PHP (LAMP) stack on Ubuntu server.If you are new to DigitalOcean, you could use my referral code and you would get a free $100 cred...
3
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

How to optimize MySQL to speed up your Laravel application with Releem?

Introduction Optimizing your MySQL service is a great way to improve your Laravel application's overall performance. Of course, it is important to follow Laravel Eloquent's best performance...
8
DevDojo bo-iliev Avatar

Boyan Iliev · 3 years ago

How to Install MySQL on MacOS

Introduction MySQL is a database management system based on SQL. like other relational databases, MySQL stores data in tables made up of rows and columns. If you are doing backend web develo...
8
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

Opensource Introduction to SQL eBook 💡

This is an open-source introduction to SQL guide that will help you learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you a...
11
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

How to Rollback Database Migrations in Laravel?

Introduction Laravel comes with many convenient tools out of the box, which makes your life as a developer much more enjoyable. One of the best Laravel features is the database migrations wh...
7
DevDojo ruanbekker Avatar

Ruan Bekker · 3 years ago

Improve MySQL Write Performance Using Batch Writes

I am no DBA, but I got curious when I noticed sluggish write performance on a mysql database, and I remembered somewhere that you should always use batch writes over sequential writes. So I...
2
DevDojo ppopescu Avatar

Petre Popescu · 3 years ago

How to use String UUID in Hibernate with MySQL

When creating the database structure it is important to make sure that each row in a table has a unique ID so that it can be easily indexed, retrieved, and manipulated when needed. The most...
DevDojo bobbyiliev Avatar

Bobby Iliev · 4 years ago

How to securely login to MySQL without providing password each time?

Introduction Using a long and secure MySQL password is necessary, however having to type that long password every time you run mysql -u root -p could be a bit frustrating especially if you w...
6
DevDojo bobbyiliev Avatar

Bobby Iliev · 4 years ago

How to export/backup a MySQL/MariaDB database with mysqldump

IntroductionThere are many ways and tools on how to export or backup your MySQL databases. In my opinion, mysqldump is a great tool to accomplish this task.The mysqldump tool can be use...
4
DevDojo tnylea Avatar

Tony Lea · 4 years ago

Connecting to a MySQL database in NodeJS

Connecting to a MySQL database in NodeJS is actually quite simple. First off, you'll need to make sure you have a local MySQL server on your machine and then you can follow these steps.To st...
7
DevDojo bahaaeddine-chennouf Avatar

Bahaaeddine Chennouf · 5 years ago

MySQL Workbench schema to Laravel Migration

MySQL Workbench is visual tool for databases modelling, sql queries and database administration, we will learn today how to create a database, and export it to laravel migration.First, You n...
2

Loading More Content