Tag: postgresql

All the articles with the tag "postgresql".

• Replacing Database LIKE Queries with Elasticsearch: Approaches and Implementation Details

  21 Apr, 2026

  For a large order dataset, Elasticsearch replaces database LIKE searches on contact information, followed by database lookups for orders. The article covers index design, historical and incremental synchronization, UTC handling, pagination, database fallback, and synchronization gaps.

• JDBC Streaming Reads and Correct Streaming Processing, with Examples

  9 Mar, 2024

  JDBC streaming reads.

• PostgreSQL (Part 2): Best Practices for Procedural Language Usage

  26 Nov, 2022

  Database server-side programming with PL/pgSQL.

• PostgreSQL (Part 1): Setting Up a Learning Environment

  23 Jul, 2022

  Sets up a PostgreSQL learning environment with Docker Compose, configures database options through an .env file, and persists data with a volume. It covers connecting with pgAdmin and basic operations inside the container, including creating a table, querying tables, and inserting data.