Arctype is a free, collaborative SQL editor for developers. Join our newsletter to receive unique stories from developers about programing and databases.
How To Secure MySQL 8 with SSL/TLS on Ubuntu 20.04
By default, MySQL is configured to only allow connections from the local system. If you want to connect to a MySQL server from a remote system, it is recommended to secure it with SSL/TLS. Enabling SSL/TLS will encrypt the data being sent to and from the database.
Set Up MySQL 8 Master-Slave Replication on Ubuntu 20.04
This guide will show you how to set up a MySQL 8 Master-Slave replication on Ubuntu 20.04.
Why You Need To Backup Your Postgres Database and How To Do It
This article will demonstrate why database backups are crucial and how to back up your PostgreSQL database using pg_dump and pg_dumpall.
How to Partition MySQL Tables
Would it be strange to eat a whole pizza, starting from the crust and working your way inward? Similar to slicing a pizza before eating it, table partitioning is the process of dividing huge tables into smaller tables so that data can be more easily and efficiently queried.
Probing Text Data Using PostgreSQL Full-Text Search
Learn how to leverage the power of full-text search in PostgreSQL to search through large text content in a fast and accurate way.