Mysql
Mysql posts, videos, courses, and more
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...
4
Select One:
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...
2
Select One:
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...
Select One:
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...
6
Select One:
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...
4
Select One:
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:
7
Select One:
1 year ago
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...
2
Select One:
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
2
Select One:
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...
4
Select One:
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...
Select One:
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
