Mysql

Mysql posts, videos, courses, and more

Bobby Iliev

1 month ago

View Post

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 which essentially allow you to version control your database! In this tutorial, you will learn how to rollback your database migrations in Lar...
How to Rollback Database Migrations in Laravel?
4
Select One:

Ruan Bekker

2 months ago

View Post

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 decided to test it out, using a python script and a mysql server. What will we be doing I wrote a python script that writes 100,000 records...
Improve MySQL Write Performance Using Batch Writes
2
Select One:

Petre Popescu

2 months ago

View Post

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 common methods are to use an auto-incremented column or a generated UUID. I won’t be covering the auto-incremented method since it poses no...
How to use String UUID in Hibernate with MySQL
Select One:

Bobby Iliev

10 months ago

View Post

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 want to run some MySQL commands in a script without being prompted for a password. One way to login to MySQL is to append your password right...
How to securely login to MySQL without providing password each time?
6
Select One:

Bobby Iliev

1 year ago

View Post

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 used to dump a database or a collection of databases for backup or transfer to another database server (not necessarily MariaDB or MySQL). The...
How to export/backup a MySQL/MariaDB database with mysqldump
4
Select One:

Tony Lea

1 year ago

View Post

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 start off you'll want to create a new folder, navigate to that folder in a shell prompt, and then install the NodeJS Mysql package: 
Connecting to a MySQL database in NodeJS
7
Select One:
View Post

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 need to have MySQL Workbench already installed, if not, feel free to download it from official website: https://www.mysql.com/fr/products/wor...
MySQL Workbench schema to Laravel Migration
2
Select One:

Lord SpoWN

1 year ago

View Episode

Install nginx php-fpm and mysql on ubuntu 19.04

how to install nginx php-fpm and mysql on ubuntu 19.04
Install nginx php-fpm and mysql on ubuntu 19.04
2
Select One:

Bobby Iliev

1 year ago

View Post

Scaling Laravel App with Multiple Databases

In this tutorial I'll show you how you could horizontally scale up your Laravel application by adding multiple database instances.In case you are not familiar with the term 'horizontal scaling', it simply means that you scale up by adding more machines to your setup where 'vertical scaling' means that you scale by adding more po...
Scaling Laravel App with Multiple Databases
4
Select One:

Tony Lea

6 years ago

View Episode

What is Sequel Pro

If you've worked with databases in the past then it is probably certain that you have worked with PHPMyAdmin. PHPMyAdmin is a great web tool for interacting with your database; however, since it is web based tool it can be kind of slow and the interface a little outdated.And if you want to use a great desktop app for interacting...
What is Sequel Pro
Select One:

Tony Lea

10 years ago

View Post

SQL Replace String

Have you ever wanted to replace a particular part of a string in SQL and you don't want to go through the hassle of coding the query and using PHP functions to parse and replace that specific part of the string. Well, now you don't have to... There is a simple solution where you can replace and return the remainder of a string i...
Select One:

Loading More Content

Back to DevDojo