Where does MariaDB save output from SELECT INTO OUTFILE on CentOS 8?
SELECT INTO OUTFILE is used to export query results to file and can be formatted
using additional export options. By default, columns are separated by tabs ( \t )
while rows are separated by newlines ( \n ).
From the MariaDB documentation, [https://mariadb.com/kb/en/select-into-outfile/](https://mariadb.com/kb/en/select-into-outfile/)
sql
SELECT ... INTO OUTFILE 'file_name'
CHARACTER SET charset_name]
export_options]
export_options:
FIELDS | COLUMNS}
TERMINATED BY 'string']
OPTIONALLY]…
Read More →
Using UUIDs with Laravel
A UUID, short for Universally Unique Identifier, is a 128-bit number often used as
a database primary key. It's often notated as a 32 character, hexadecimal string
seperated in to five groups with hyphens. It has been widely adopted in a variety
of applications since the chance of duplicating another of the same value is infinitesimally
small.
UUIDs come with both pros and cons and your application should dictate whether or
not to use them.
They're unique. UUIDs can be generated prior to a database …
Read More →
Install MySQL Community Server on CentOS 8
CentOS distributes MariaDB 10.3, a drop-in replacement for MySQL Server 5.7. If
you require MySQL 8, there are a few new steps on CentOS 8 that differ from past
versions.
All steps should be performed as the root user.
bash
sudo su
Code snippets that start with a # prompt contain sample output and should not be
copied verbatim.
Start by downloading the GPG key and saving it in /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
bash
wget -O /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql…
Read More →
Run a Tkinter app in kiosk mode on a Raspberry Pi
Tkinter (tk interface) is a Python binding to the Tk GUI toolkit. It's Python's
most popular package for building GUI applications and is available on both Windows
and Unix systems.
In this example, we'll build a fullscreen application that loads when booting a Raspberry
Pi running Raspbian Buster. The application is simple: load a random quote of the
day and display it on screen. The full source code is available here:
…
Read More →
How to enable HAProxy logs on CentOS 8
HAProxy is an open-source, high availability load balancer that quietly sits in front
of any TCP/HTTP service. It's well-known for its efficiency and reliability, and
often used to manage the traffic of high-volume and distributed systems.
If you're using HAProxy, you may have come across a situation where you're looking
through application logs only to realize that you can't find the information you're
looking for. For example, maybe you're looking in apache logs trying to isolate
the IP of a web…
Read More →