Su San Talks Tech

Dec 5, 2025 · Databases

How to Store IP Addresses Efficiently in PostgreSQL and MySQL

This guide explains how to store IPv4 and IPv6 addresses in PostgreSQL using the INET type and in MySQL using INT UNSIGNED, VARBINARY, and built‑in conversion functions, providing examples of table creation, insertion, and subnet queries.