Create Native Data Type for IP Address data

Registered by Nadeem on 2010-11-30

This blueprint is to request a native data type specific to define columns that hold IP Address data.

Most of our customers prefer to declare IP addresses as a VARCHAR(15) or VARCHAR(20) etc.
Querying against these are not as efficient. Slow queries referencing IP address columns are quite common in our Cloud environment.

MySQL recommends storing it as an UNSIGNED INT and then using INET_ATON or INET_NTOA functions to decipher it.

Could Drizzle could come up with a native data type for IP addresses please?

Blueprint information

Status:
Started
Approver:
None
Priority:
High
Drafter:
None
Direction:
Needs approval
Assignee:
Brian Aker
Definition:
Approved
Series goal:
Accepted for 7.1
Implementation:
Good progress
Milestone target:
None
Started by
Lee Bieber on 2010-12-23

Related branches

Sprints

Whiteboard

Rackspace request

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.