Databases Resources

A Handbook to Implement Fuzzy Search in PostgreSQL

How to use PostgreSQL fuzzy search methods like trigrams, Levenshtein matching, phonetic matching, and pattern ops for LIKE and Regex queries.

September 4, 2021

by Everett Berry

· 7,794 Views · 2 Likes

Nextcloud and Kubernetes in the Cloud With Kuma Service Mesh

Want a powerful, self-hosted personal cloud? Then look no further than Nextcloud running on Kubernetes with a service mesh to add all the help and features you need.

Updated September 4, 2021

by Chris Ward

CORE

· 7,859 Views · 3 Likes

Clean Up Your Outbox Tables With Programmatic TTL

The goal of this post is to show how you can programmatically remove records from an Outbox table that have been flushed to its sink (e.g., Kafka).

September 1, 2021

by Chris Casano

· 4,930 Views · 2 Likes

Soft Deletion in Hibernate: Things You May Miss

The article explains some details that stay hidden by most of the articles about soft deletion implementation using Hibernate.

Updated August 31, 2021

by Aleksey Stukalov

· 10,698 Views · 11 Likes

Exploring Spring Cloud Configuration Server  in Microservices

In this article, we'll learn how to use the Spring Cloud Configuration server to centralize managing the configuration of our microservices.

Updated August 31, 2021

by Magnus Larsson

· 11,422 Views · 4 Likes

Advanced PostgreSQL Features: A Guide

Take advantage of advanced PostgreSQL features such as inheritance, nonatomic columns, and more in order to get the most out of your data.

August 31, 2021

by Igor Bobriakov

· 8,803 Views · 10 Likes

An Introduction to Type Safety in JavaScript With Prisma

In this article, we walk you through an example app built with Prisma, Fastify, and MySQL that implements automated checks for increased type safety.

Updated August 30, 2021

by Oleksii Klochai

· 10,083 Views · 4 Likes

Building Zero Trust with an API Gateway and Service Mesh

In this post, we’ll take a close look at how Kong Gateway and the Kuma service mesh fit into a Zero Trust architecture security design.

August 30, 2021

by Michael Bogan

CORE

· 11,520 Views · 4 Likes

How Kafka Can Make Microservice Planet a Better Place

In this article, we want to focus on using Kafka in the microservice architecture, and we need an important concept named Kafka Topic for that.

August 28, 2021

by Reza Ganji

CORE

· 19,256 Views · 13 Likes

Partitioning MySQL: Why, When, How?

This article will provide you with a basic overview of MySQL partitions to help you understand why they are so important.

August 28, 2021

by Everett Berry

· 6,314 Views · 2 Likes

Top 8 PostgreSQL GUI Software in 2021

What is PostgreSQL GUI? Why do you need it? How can it help you manage your PostgreSQL database? Learn about the best Postgre GUI software to try in 2021.

Updated August 27, 2021

by Ilon Adams

· 15,109 Views · 9 Likes

Testcontainers: From Zero To Hero [Video]

Do you want to make the most out of your integration tests by using the popular Testcontainers library? Learn how to use it from the ground up.

August 27, 2021

by Marco Behler

· 8,211 Views · 4 Likes

Token-Based Security, OAuth 2.0, OIDC and IdentityServer4

We'll learn the basics of token-based security, OAuth, OIDC basics, and set up an ASP .NET Core Web Application with IdentityServer4 package.

August 27, 2021

by Jawad Hasan Shani

CORE

· 6,636 Views · 2 Likes

Kafka Connect: Strategies To Handle Updates and Deletes

Get tips on managing updates and deletes using Kafka Connect, which allows you to set up a continuous flow of data from one data source to a target database.

August 26, 2021

by Gabriel Solano

· 10,503 Views · 2 Likes