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.
By
Zach Naimon
Articles
By
Zach Naimon
Optimizing MySQL and MariaDB for TEXT: A Guide
This blog post will go over some of the things you can do to optimize your MySQL (or MariaDB) instances for TEXT-type data.
2 years ago
MySQL
public
LOAD DATA INFILE vs. INSERT in MySQL: Why, How, When?
This article will demonstrate the differences between LOAD DATA INFILE and INSERT and explain when you should use both for data entry in MySQL.
2 years ago
Performance
public
The Basics of MySQL Query Caching
MySQL's Query Cache is incredibly versatile. It’s usually able to store a wide variety of values and return them from the memory (rather than the disk) to improve query execution times. This guide will explore the usages and limitations of query caching.
2 years ago
A Guide to Transparent Data Encryption in PostgreSQL
Transparent Data Encryption, or TDE, is used to secure the data at rest. In other words, it encrypts the data in a database to prevent an attacker from reading the data if they break the first line of defense.
2 years ago
Featured
public
Performance
Slow Query Basics: Why Are Queries Slow?
Slow query performance is a huge thing—so much so that modern database performance optimization techniques are in large part targeted at mitigating slow queries. Surprising? We think not.
2 years ago
Unused Indexes in MySQL: A Basic Guide
Indexes are frequent friends for SELECT queries; however, if we want to use indexes, we must ensure that our database instances use them first. Indexes that are not utilized by our database instances are useless – they waste space and make INSERT, UPDATE, and DELETE queries slower.
2 years ago
MySQL
public
A Guide to MySQL JOINS
Large quantities of data are often stored in MySQL databases. Analysts and DBAs are constantly required to extract records from two or more tables based on specific requirements in order to evaluate that data quickly. This is when JOINS come in handy.
2 years ago
