PLATFORM

  • Tails

    Create websites with TailwindCSS

  • Wave

    Start building the next great SAAS

  • Pines

    Alpine & Tailwind UI Library

  • Auth

    Plug'n Play Authentication for Laravel

  • Designer comingsoon

    Create website designs with AI

  • DevBlog comingsoon

    Blog platform for developers

  • Static

    Build a simple static website

  • SaaS Adventure

    21-day program to build a SAAS

COMMUNITY
MORE

Mysql

Mysql posts, videos, courses, and more

DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 2 years ago

5
DevDojo ragabekov Avatar

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

Roman Agabekov ยท 2 years ago

1
DevDojo omarthedev Avatar

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

Omar Moustafa ยท 2 years ago

2
DevDojo techvblogs Avatar

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

TechvBlogs ยท 2 years ago

DevDojo techvblogs Avatar

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

TechvBlogs ยท 2 years ago

3
DevDojo omarthedev Avatar

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

Omar Moustafa ยท 2 years ago

2
DevDojo techvblogs Avatar

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

TechvBlogs ยท 2 years ago

7
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

11
DevDojo techvblogs Avatar

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

TechvBlogs ยท 3 years ago

6
DevDojo geektechpub Avatar

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

GeekTech ยท 3 years ago

2
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo techvblogs Avatar

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

TechvBlogs ยท 3 years ago

4
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

4
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

4
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

6
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

7
DevDojo bobbyiliev Avatar

๐Ÿš€ 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...

Bobby Iliev ยท 3 years ago

8
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

3
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

8
DevDojo bo-iliev Avatar

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

Boyan Iliev ยท 4 years ago

8
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 4 years ago

11
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 4 years ago

7
DevDojo ruanbekker Avatar

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

Ruan Bekker ยท 4 years ago

2
DevDojo ppopescu Avatar

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

Petre Popescu ยท 4 years ago

DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 5 years ago

6
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 5 years ago

4
DevDojo tnylea Avatar

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

Tony Lea ยท 5 years ago

7
DevDojo bahaaeddine-chennouf Avatar

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

Bahaaeddine Chennouf ยท 5 years ago

2

Loading More Content