How to use full text search and the match keyword to find a string in every table in a MySQL database.

Search MySQL Like Google Using Match and Full-Text Search
Search MySQL Like Google Using Match and Full-Text Search

What is a Full-Text Search in MySQL?


When solving a problem that requires you to link a user’s session data to their actual user object, Postgres comes in handy.

Decoding Django Sessions in PostgreSQL
Decoding Django Sessions in PostgreSQL

Database Security Checklist  for Small Teams
Database Security Checklist  for Small Teams

Introduction


Visualizing Sales Data with Arctype Dashboards
Visualizing Sales Data with Arctype Dashboards

Introduction

What is Arctype?


ORMs don’t always help. Find out why and what you can do instead

graphic of a database and its connections to users
graphic of a database and its connections to users
Image source: Author


How to index MySQL for high performance

Blurry image of woman
Blurry image of woman
Photo by Ahmad Odeh on Unsplash.


What is The Difference between 2NF and 3NF?
What is The Difference between 2NF and 3NF?

Introduction

Why is Database Normalization important?


A complete data replication solution

Replicator figure on table
Replicator figure on table
Photo from GateWorld. Edited by the author.

Introduction to Data Replication


Utilizing BigQuery as a Data Warehouse in a distributed application
Utilizing BigQuery as a Data Warehouse in a distributed application

Introduction


Introduction

Prerequisites

Install Required Packages

Arctype

The modern SQL editor built for collaboration www.arctype.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store