Tag

IPv4

1 views collected around this technical thread.

Architect's Guide
Architect's Guide
Jan 21, 2025 · Databases

Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Techniques

The article explains that using a 32‑bit UNSIGNED INT to store IPv4 addresses in MySQL saves space and improves index and range‑query performance, outlines the storage savings compared to VARCHAR, mentions the need for manual conversion, and provides MySQL and Java code examples for converting between string and integer representations.

IPv4MySQLPerformance
0 likes · 5 min read
Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Techniques
Architecture Digest
Architecture Digest
Oct 7, 2024 · Databases

Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Techniques

The article explains that storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL saves storage and index space, enables faster range queries, outlines conversion functions like INET_ATON/INET_NTOA, discusses drawbacks such as readability, and provides Java utilities for IP‑long transformations.

Database DesignIP ConversionIPv4
0 likes · 6 min read
Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Techniques
Architecture Development Notes
Architecture Development Notes
Sep 5, 2024 · Fundamentals

Convert IPv4 Addresses to Integers in Rust with Built‑In Validation

This article explains the structure of IPv4 addresses, walks through a Rust function that parses dotted‑decimal notation into a 32‑bit integer with range checks, and provides example code demonstrating usage and error handling.

Address ConversionIPv4Rust
0 likes · 5 min read
Convert IPv4 Addresses to Integers in Rust with Built‑In Validation
IT Services Circle
IT Services Circle
Jun 30, 2024 · Fundamentals

Understanding localhost and 127.0.0.1: Differences, Similarities, and IPv6 ::1

localhost is a local hostname that resolves to the loopback IP address 127.0.0.1, while 127.0.0.1 is the IPv4 loopback address itself; both serve the same purpose, with differences in resolution and configuration, and in IPv6 the equivalent hostname maps to ::1.

127.0.0.1IPv4IPv6
0 likes · 7 min read
Understanding localhost and 127.0.0.1: Differences, Similarities, and IPv6 ::1
Efficient Ops
Efficient Ops
Jun 10, 2024 · Operations

Why IPv4 Is Running Out and How Companies Can Navigate the Costly IPv6 Migration

With IPv4 address space exhausted and providers beginning to charge for public IPv4 usage, organizations face rising costs and complex migration challenges, prompting a strategic shift toward IPv6 adoption, alternative solutions, or passing expenses to customers, while grappling with ISP support gaps and tooling limitations.

Cloud ComputingIPv4IPv6
0 likes · 13 min read
Why IPv4 Is Running Out and How Companies Can Navigate the Costly IPv6 Migration
Java Tech Enthusiast
Java Tech Enthusiast
Apr 5, 2024 · Fundamentals

Understanding Loopback Addresses, Ping, and Why 127.0.0.1 Works Offline

The IPv4 loopback address 127.0.0.1 (also reachable via the hostname localhost) is reserved for internal communication, so pinging it never leaves the host and works even with the network cable unplugged, while 0.0.0.0 is an unspecified address used only for binding to all interfaces and cannot be pinged.

IPIPv4IPv6
0 likes · 13 min read
Understanding Loopback Addresses, Ping, and Why 127.0.0.1 Works Offline
Bilibili Tech
Bilibili Tech
Feb 20, 2024 · Backend Development

Investigation and Optimization of Unexpected AAAA DNS Requests in Go Applications

The article investigates why Go applications unexpectedly send AAAA DNS queries to a secondary nameserver, tracing the issue to the built‑in resolver’s handling of non‑recursive responses from a NetScaler proxy, and recommends using the cgo resolver, enabling recursion, or forcing IPv4 to eliminate the added latency.

DNSDebuggingFailover
0 likes · 14 min read
Investigation and Optimization of Unexpected AAAA DNS Requests in Go Applications
IT Services Circle
IT Services Circle
Jan 23, 2024 · Operations

The Impending Paid Era for IPv4 and the Challenges of Migrating to IPv6

With global IPv4 address pools exhausted, major cloud providers like AWS and Fly.io are introducing hourly fees for public IPv4 usage, prompting a costly shift toward IPv6, yet many organizations face significant technical, ISP, and tooling challenges that make the migration complex and costly.

Cloud ComputingIPv4IPv6
0 likes · 12 min read
The Impending Paid Era for IPv4 and the Challenges of Migrating to IPv6
IT Services Circle
IT Services Circle
Sep 3, 2023 · Cloud Computing

AWS Announces New Public IPv4 Address Charges and Pushes IPv6 Adoption

Starting February 1, 2024, AWS will charge $0.005 per hour for each public IPv4 address across all services to manage scarce IPv4 resources, encourage IPv6 migration, and introduce a Public IP Insights tool for better usage monitoring.

AWSCloud ComputingIPv4
0 likes · 9 min read
AWS Announces New Public IPv4 Address Charges and Pushes IPv6 Adoption
Architecture Digest
Architecture Digest
May 6, 2022 · Fundamentals

Understanding Port Listening with Python Socket Examples

This article uses a conversational story to explain what it means to listen on a network port, covering TCP vs UDP, binding to specific IPs, reuse‑port options, IPv4 and IPv6 differences, and demonstrates the concepts with multiple Python socket code snippets.

IPv4IPv6Python
0 likes · 13 min read
Understanding Port Listening with Python Socket Examples
Python Programming Learning Circle
Python Programming Learning Circle
Aug 19, 2021 · Databases

Why Store IPv4 Addresses as UNSIGNED INT in MySQL and How to Convert Them

The article explains why storing IPv4 addresses as 32‑bit unsigned integers in MySQL saves space and improves range queries, outlines the pros and cons, shows MySQL conversion functions, and provides Java code for converting between string and numeric IP representations.

Database DesignIP ConversionIPv4
0 likes · 4 min read
Why Store IPv4 Addresses as UNSIGNED INT in MySQL and How to Convert Them
Selected Java Interview Questions
Selected Java Interview Questions
Aug 2, 2021 · Databases

Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Methods

Storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL saves space, enables faster range queries, and leverages built‑in conversion functions like INET_ATON/INET_NTOA, while requiring manual readability handling, and can be complemented by Java utilities for application‑level conversions.

Database OptimizationINET_ATONIPv4
0 likes · 5 min read
Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Methods
Practical DevOps Architecture
Practical DevOps Architecture
Dec 28, 2020 · Fundamentals

Understanding IPv4 Addressing, Subnetting, and Binary Calculations

This article explains IPv4 address structure, network and host bits, classful address ranges, broadcast addresses, subnet mask functions, and step‑by‑step binary calculations for subnetting and determining usable host counts across various examples.

IP addressingIPv4Subnetting
0 likes · 8 min read
Understanding IPv4 Addressing, Subnetting, and Binary Calculations
Practical DevOps Architecture
Practical DevOps Architecture
Nov 9, 2020 · Fundamentals

Why Subnetting Is Needed and How to Perform IPv4 Subnet Division, VLSM, and CIDR Calculations

This article explains the purpose of subnetting, introduces IPv4 subnet division and aggregation techniques such as VLSM and CIDR, and provides step‑by‑step calculations for determining network, broadcast, and usable IP ranges using examples like the 202.106.1.0/24 address block.

CIDRIP addressingIPv4
0 likes · 4 min read
Why Subnetting Is Needed and How to Perform IPv4 Subnet Division, VLSM, and CIDR Calculations
Architect
Architect
Jul 7, 2015 · Fundamentals

The Exhaustion of IPv4 Addresses and the Urgent Need for IPv6 Migration

With IPv4 address pools depleted across North America, Europe, Asia and Latin America, the article explains the impending end of IPv4, the limited options for ISPs, and urges accelerated adoption of IPv6, which offers a vastly larger address space but currently sees low global usage.

IPv4IPv6Networking
0 likes · 3 min read
The Exhaustion of IPv4 Addresses and the Urgent Need for IPv6 Migration