Tag: PostgreSQL

SQL knowledge is essential for anyone who works with data. In this article, we discuss what SQL is, its importance, and how to get started.

Learn how Hasura and PostgreSQL can help you speed up app development and launch backends quickly with minimal effort.

MySQL 5.7+ InnoDB databases and PostgreSQL 9.2+ support JSON document types in a single field. We explore the MySQL 8.0 JSON implementation in more detail.

Here's everything you need to know about building microservices with Deno, Reno (a thin routing library for Deno), and PostgreSQL.

Scott explains how we can have a secure, encrypted, and hack-proof database, but still use normal SELECT and search queries on it. Interesting stuff!

David Bush discusses the importance of understanding core functionality in Rails, showing how indexes work and how to implement a database by yourself.

Vinoth shows you how to make autocompletion awesome using trigram search functionality in Rails and PostgreSQL.

Vinoth Kumar shows you how to speed up your expensive SQL queries using materialized views with PostgreSQL and Rails.

Taylor Ren looks at a relatively new suite of DB tools - Valentina - and gives you his opinion on it.

A short tutorial of two powerful database features: triggers and events. When should and shouldn't they be used?