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…
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.
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:
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!
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…
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…
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
ContactNumber and an alternate contact number. This table has a few mandatory value columns like
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:
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.