Step 1: Install Necessary Tools and Dependencies 1.1 Install Homebrew Homebrew is the package manager for macOS, and we will use it to install the required tools. If you have already installed it, you can skip this step. Open the terminal and execute: /bin/bash -c “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)” Due to network issues in China, downloading … Read more
Practical Implementation of Database Connection Pooling with Rust and PostgreSQL: deadpool and diesel (Part 4) The idea behind developing RTMate in Rust is to create a platform that provides WebSocket connection services, eliminating the need for users to set up their own WebSocket services. In this process, it is essential to manage different tenants and … Read more
Huge pages are a Linux kernel feature that allocates larger memory pages (typically 2 MB or 1 GB instead of the normal 4 KB). PostgreSQL’s shared buffer pool and dynamic shared memory segments are often tens of gigabytes, and using huge pages reduces the number of pages the processor must manage. Fewer page‑table entries mean … Read more
Introduction As the Rust language becomes increasingly popular in backend development, Axum, a high-performance and type-safe web framework, is gaining favor among developers. This article will guide you on how to integrate Docker and PostgreSQL database into an Axum project, and provide an in-depth understanding of how database connection pools work, which are fundamental elements … Read more
Open Source IoT Management System! It includes a user authentication system, location monitoring, distance calculation, and service health monitoring. The system adopts a front-end and back-end separation architecture, with the back-end based on the Go language’s Gin/Fiber framework (high-performance web framework), the front-end built using Vue3 (reactive framework), and PostgreSQL (supporting complex queries and JSON … Read more
1. MySQL/MariaDB Connection 1. Command Line Connection mysql -u username -p -h host_address -P port Example: mysql -u root -p -h 127.0.0.1 -P 3306 Parameter Description: <span><span>-u</span></span>: Username <span><span>-p</span></span>: Interactive password input (no space after password) <span><span>-h</span></span>: Database server IP (default is localhost) <span><span>-P</span></span>: Port (default is 3306) 2. Operations After Connection SHOW DATABASES; — … Read more
Click on the “Kernel Path“, select “Top/Star Public Account“ Valuable Benefits, Delivered First-Hand! 1. GDB Debugging Postgres Kernel GDB debugging of the Postgres kernel can generally be divided into three main categories. Debugging the initialization process of the Postgres kernel postmaster daemon Debugging the initialization implementation of the Postgres kernel backend process Debugging the implementation … Read more
Introduction To lower the usage threshold for community users and enhance the user experience, the IvorySQL community has specially launched the IvorySQL-WASM project to help users quickly demo online. IvorySQL-WASM is developed based on the open-source Postgres-WASM framework. It allows users to experience IvorySQL directly in their web browsers without local installation or complex deployment. … Read more
Installation of the Plugin Program on PostgreSQL Server in Debian Linux Execute the following command on the PostgreSQL database server running Debian system to install the plugin pldebugger: sudo apt install postgresql-15-pldebugger # After running this command, it seems that the pgsql service automatically restarted. According to the logs, it appears that there is no … Read more
GDB (GNU Debugger) – A Powerful Tool for Database Kernel Developers Welcome to the world of database kernel development! Today, we will learn about a very important tool that acts like a doctor’s stethoscope or a detective’s magnifying glass, helping us delve into the internal workings of programs and uncover hidden bugs. This tool is … Read more