Verwalten und Verwenden von MySQL-Datenbank-Triggern unter Ubuntu 18.04
Der Autor hat die Apache Software Foundation dazu ausgewählt, im Rahmen des Programms Write for DOnations eine Spende zu erhalten. In MySQL ist ein…
So verwalten Sie sortierte Sets in Redis
Redis ist ein Open-Source-, In-Memory-Datenspeicher mit Schlüsselwerte-Datenstruktur. Sortierte Sets in Redis sind ein Datentyp, der den Sets ähnelt. Beide sind…
How To Move a MySQL Data Directory to a New Location on Ubuntu 18.04
Whether you’re adding more space for data or evaluating ways to optimize database performance, this tutorial will guide you through relocating MySQL’s data directory on an Ubuntu 18.04 server.
How To Query the Database in Laravel with Eloquent (Select)
One of the biggest advantages of using an ORM system is the ability to manipulate rows in a database table as objects within your codebase. Eloquent provides several methods that can be accessed directly from models to query the database and filter results without having to write SQL statements. In this guide, you’ll learn more about how to make database queries using Eloquent models.
How To Set Up a Remote Database to Optimize Site Performance with MySQL on Ubuntu
This guide will walk you through the process of configuring a remote MySQL database server that your website or application can connect to. It uses WordPress as a working example of something that can connect to the MySQL backend remotely, but the technique is widely applicable to any application backed by MySQL.
How To Set Up Logical Replication with PostgreSQL 10 on Ubuntu 18.04
When setting up an application for production, it’s often useful to have multiple copies of your database in place. The process of keeping database copies in sync is called replication.
Como usar o Migrations de banco de dados e o Seeders para abstrair a configuração do banco de dados em Laravel
Migrations [Migrações] e seeders [Propagadores] são utilitários de banco de dados eficazes, fornecidos pela framework do Laravel para PHP, que permite que os desenvolvedores façam a…
How To Use Migrations to Create and Manage Database Tables in Laravel
In this guide, you’ll create a database migration to set up the table where you’ll save the application links. In order to do that, you’ll use the [Artisan](https://laravel.com/docs/8.x/artisan) command-line tool that comes with Laravel by default. At the end, you will be able to destroy and recreate your database tables as many times as you want, using only `artisan` commands.
Verwenden des MySQL BLOB-Datentyps zum Speichern von Bildern mit PHP unter Ubuntu 20.04
Der Autor hat Girls Who Code dazu ausgewählt, im Rahmen des Programms Write for DOnations eine Spende zu erhalten. Ein [Binary Large Object…
An Introduction to Queries in PostgreSQL
In this guide, we will discuss the basic syntax of SQL queries as well as some of the more commonly-employed functions and operators. We will also practice making SQL queries using some sample data in a PostgreSQL database.
