Arctype is a free, collaborative SQL editor for developers. Join our newsletter to receive unique stories from developers about programing and databases.
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.
This guide will show you how to set up a MySQL 8 Master-Slave replication on Ubuntu 20.04.
This article will demonstrate why database backups are crucial and how to back up your PostgreSQL database using pg_dump and pg_dumpall.
Explore Key-Value store features which augments the already fantastic NoSQL tool set that PostgreSQL offers.
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.
Learn how to leverage the power of full-text search in PostgreSQL to search through large text content in a fast and accurate way.
This blog post will go over some of the things you can do to optimize your MySQL (or MariaDB) instances for TEXT-type data.
This article will demonstrate the differences between LOAD DATA INFILE and INSERT and explain when you should use both for data entry in MySQL.
