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
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. …
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…
Table of Contents
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…
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:
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.
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:
If this is your first time working with any of these technologies, I provide a brief explanation at the…
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.
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.