oNddleo

Phân tích và Tối ưu Query

🔍 Phân tích vấn đề

Các điểm nghẽn chính:

1. ANY operator trên array columns (campaign_ids, tags)
   • Không thể sử dụng B-tree index hiệu quả
   • Full scan hoặc bitmap index scan tốn kém

oNddleo

Complete Guide: Configure Private S3 Bucket with CloudFront and Cloudflare

Overview

This guide walks through setting up a private S3 bucket with CloudFront as the content delivery layer and Cloudflare as the proxy/caching layer. This architecture provides security, performance, and cost optimization.

---

Phase 1: AWS S3 Configuration

oNddleo

-- ~/.config/nvim/init.lua
-- Neovim configuration with snacks.nvim terminal and transparent background

-- Basic settings
vim.opt.number = true
vim.opt.relativenumber = true
vim.opt.tabstop = 2
vim.opt.shiftwidth = 2
vim.opt.expandtab = true
vim.opt.smartindent = true

oNddleo

+-------------+        +------------+        +--------------+
| Client Apps | <----> | WebSockets | -----> | Chat Service |
+-------------+        +------------+        +--------------+
                                                 |
                                                 v
                                         +----------------+
                                         | Message Service|
                                         +----------------+
                                                 |

oNddleo

Architecture Overview

┌─────────────────┐     ┌──────────────┐     ┌─────────────────┐
│  Client Apps    │◄────┤  WebSockets  │────►│  Chat Service   │
└─────────────────┘     └──────────────┘     └────────┬────────┘
                                                      │
                                                      ▼
┌─────────────────┐     ┌──────────────┐     ┌─────────────────┐
│  Group Service  │◄────┤     NATS     │◄────┤ Message Service │

oNddleo

SELECT symbol, close, date
        FROM public.historical_data
        WHERE symbol IN ({placeholders})
          AND date BETWEEN %s::date AND %s::date
          AND close IS NOT NULL
        ORDER BY symbol, date

oNddleo

watch_stylesheet: true
watch_config: true
debug: false # Enable debug mode to see more logs

# This komorebi setting will be used for tray context menu.
# If you don't use komorebi, you can remove this section.
komorebi:
  start_command: "komorebic start --whkd"
  stop_command: "komorebic stop --whkd"
  reload_command: "komorebic reload-configuration"

oNddleo

Importing net/http/pprof adds HTTP endpoints to serve profile files that can be viewed or charted with a command line tool when the runtime.Set* functions are executed.

1. import pprof into the go program

import _ "net/http/pprof"

If your application is not already running an http or https server, add net/http to the program imports and the following code to the start of the main function:

go http.ListenAndServe(":8550", nil)

oNddleo

Technical summary Ultra Scale Kafka system

Core

1. Apache Kafka

   • Usage: Message broker infrastructure, topic management, partition replication
   • Key Components: Kafka Streams API for processing, AdminClient for topic management

2. Apache Avro

• Usage: Schema definition, binary serialization/deserialization

oNddleo

Kafka Event Definition for Order Management in Trading

Here's a comprehensive definition for Kafka events in an order management trading system with hash verification for message producers:

{
  "eventType": "ORDER_CREATED",
  "version": "1.0",
  "timestamp": "2025-03-10T08:45:32.215Z",
 "orderId": "ORD-12345678",