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 Full-Text Search in MySQL?
How does the Full-Text Search in MySQL work?
LIKE vs Full-Text Search operators in MySQL
Advantages and disadvantages of Full Text Search and LIKE operator in MySQL
Full-text Search Restrictions
Example of Using the Full-text Search in MySQL
Conclusion

You can have Google-like superpowers to find words and phrases across your entire database. Search engines use Full-Text Search to find results in databases. These databases often contain a lot of textual data. For example, news websites contain lots of news articles and may want to find a specific phrase. …


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

Sessions are an important part of any HTTP-based web framework. They allow web servers to keep track of the identities of repeat HTTP clients without requiring them to re-authenticate for each request. There are several different ways to keep track of sessions. Some do not require the server to persist session data (like JSON Web Tokens), while others do.

Django, a popular Python-based web framework, ships with a default session backend that does store persistent session data. There are several storage and caching options; you can elect to simply store sessions in the SQL database and look them up each…


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

Table of Contents

  • Introduction
  • Acknowledging Risk
  • Understanding the principal of low hanging fruit
  • Creating a security policy
  • Server Security
  • Email attackers
  • User Roles and Permissions
  • Data Sanitizing
  • Request Throttling
  • Physical Security to Augment Digital Steps
  • Self Reflection

Get the Checklist here!

Hi, my name is Kirk. I’m a full stack software developer working on the .NET ecosystem and managing a large SQL Server database. I wrote this post to try to answer some of my own questions about what modern database security in 2021 looks like, especially if you’re in the tech field and looking into creating or supporting your…


The first thing to look at before optimizing a query is the Query Planner

Exclusive, rows x, rows, loops, and node data in a table
Exclusive, rows x, rows, loops, and node data in a table

Understanding the PostgreSQL query plan is a critical skill set for developers and database administrators alike. It is probably the first thing we would look at to start optimizing a query, and also the first thing to verify and validate if our optimized query is indeed optimized the way we expect it to be.

Before we attempt to read a query plan, it is important to ask some very basic questions:

  • Why do we even need a query plan?
  • What exactly is represented in the plan?
  • Is PostgreSQL not smart enough to optimize my queries automatically? …


12 PostgreSQL Interview Questions
12 PostgreSQL Interview Questions
Photo by Christina @ wocintechchat.com on Unsplash

If you’re interviewing for a position in which you’ll have to work with a PostgreSQL database; there are some fundamental things that you should know. In this article, I have prepared some important PostgreSQL interview questions and answers which will help you succeed in your interview.

See if you can read through the list below and answer every question. If you can — you are going to crush this interview! If not, read on below for the answers and explanations.

  1. What are the languages which PostgreSQL supports?
  2. What are the main features of PostgreSQL?
  3. What is a non-clustered index?
  4. How…


A Powerful Addition to Your Postgres Toolbelt: Table Inheritance
A Powerful Addition to Your Postgres Toolbelt: Table Inheritance

Save time with both data retrieval and database management by using Table Inheritance, a lesser known but extremely useful feature.

In this article, I’ll cover how inheritance works in Postgres and provide some examples of when to use inheritance.

To follow along with the examples in this article, try Arctype’s free SQL editor to quickly connect to a Postgres database:


The relationship between the customer and the business is an integral part of every successful business model. Suffice to say, without loyal customers; the business can and will not succeed. Consequently, it is vital to develop and deploy a customer relationship management (CRM) system. In order to achieve this goal, let’s dive into a step-by-step guide to building a simple CRM data model as an indispensable part of the overall CRM application development process.

Note: Customer relationship management systems are complex. The relationship between the customer and the business encompasses a wide range of aspects, covering the need to know…


In this tutorial, I’m going to show how to make the web app and database shown in the gif above, and how to deploy it to Heroku so it can be used by anyone.

This guide is divided in 3 sections:

  1. Creating a Flask app (web application for submitting the form)
  2. Setting up a Postgres database with Python (store the data from the submitted forms)
  3. Deploying the application to Heroku (hosting the application in the cloud so anyone can use it)

If this is your first time working with any of these technologies, I provide a brief explanation at the…


How Do the Top 20 Words in Biden's Inauguration Speech Compare to Trump's?
How Do the Top 20 Words in Biden's Inauguration Speech Compare to Trump's?

Can Python unite the nation?

Yesterday we saw our country’s 45th successful transfer of the presidency.

This marked the end of a highly contested election during which our nation at times felt more divided than ever.

But as I sat in my living room today with my parents and watched Biden’s inaugural address, I felt hopeful.

“Some days you need a hand. There are other days when we’re called to lend a hand. That’s how it has to be, that’s what we do for one another. And if we are that way our country will be stronger, more prosperous, more…


Reimagining the SQL Curriculum: Change How SQL is Taught
Reimagining the SQL Curriculum: Change How SQL is Taught

After looking at SQL’s impressive 50 year reign and what we could learn from it, let us now focus how we can learn it.

Not only is SQL everywhere, it is also in high demand. A quick search of job boards easily reveals not only that virtually all of the S&P 500 companies are hiring for SQL skills, but that the demand for them is even higher then more “high-tech” languages like R and Python.

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