Create Native Data Type for IP Address data
Registered by
Nadeem
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
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Rackspace request
(?)
