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…


Django’s versatility makes it the ideal framework for developers endeavoring to collect website analytics, which can then be visualized and analyzed using Arctype’s dashboard functionality — truly a perfect synergy.

Introduction

As Python’s premier web framework, Django provides the foundation upon which many web applications have been built, facilitating rapid development without sacrificing stability. Amongst other versatile functionalities, Django integrates seamlessly with SQL databases, so today, we’ll be using the framework to implement basic site analytics data recording. Then, we’ll use this data to create gorgeous visualizations in an Arctype dashboard, which will keep track of the following:

  • Registrations, logins, and…


To explore SQLite along with Python, which is a user-friendly and no-nonsense language, we are going to build a simple tic-tac-toe game. So buckle up and get your machines ready!

Introduction to SQLite and Embedded Databases

SQLite is a small, self-contained, client/embedded database written in the C Programming language and can be summarized using the following points:

In this article, we are going to see many of these features in action. Features such as data replication, network access, etc., are intentionally absent…


Postgres offers set operators that make it easy to query and filter the results of searches from your database. Set operators are used to join the results of two or more SELECT statements. These operators are UNION, UNION ALL, INTERSECT, and EXCEPT — each can be used to construct queries across multiple tables and filter for the specific data that you need.

To return the combined results of two SELECT statements, we use the UNION set operator. This operator removes all the duplicates from the queried results — only listing one row for each duplicated result. To examine this behavior…


No-Code:
No-Code:

Gartner predicts that by 2023, over 50% of medium to large enterprises will have adopted a Low-code/No-code application as part of their platform development.

The proliferation of Low-code/No-code tooling can be partially attributed to the COVID-19 pandemic, which has put pressure on businesses around the world to rapidly implement digital solutions. However, adoption of these tools — while indeed accelerated by the pandemic — would have occurred either way.

Even before the pandemic, the largest, richest companies had already formed an oligopsony around the best tech talent and most advanced development tools. Low-Code/No-code, therefore, is an attractive solution for small…


How I Learned to Stop Worrying and Love NULL in SQL
How I Learned to Stop Worrying and Love NULL in SQL

The NULL value is a data type that represents an unknown value. It is not equivalent to empty string or zero. Suppose you have an employee table containing columns such as EmployeeId, Name, ContactNumber and an alternate contact number. This table has a few mandatory value columns like EmployeeId, Name, and ContactNumber. However, an alternate contact number is not required and therefore has an unknown value. Therefore a NULL value in this table represents missing or inadequate information. Here are other meanings NULL can have:

  • Value Unknown
  • Value not available
  • Attribute not applicable

In this post we will consider how…


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…

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