#326 closed enhancement (wontfix)
IPAddressField in decimal format
Reported by: | Bless | Owned by: | Adrian Holovaty |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 1.0 |
Severity: | normal | Keywords: | |
Cc: | Triage Stage: | Accepted | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
An IP address is stored in string format and allocating 15 bytes (120 bits)
But it would be possible convert that address to decimal format and store it in less bits.
>>> import socket, struct >>> ip = "192.168.2.1" >>> q = ip.split(".") >>> n = reduce(lambda a,b: long(a)*256 + long(b), q) >>> n 3232236033L >>> socket.inet_ntoa(struct.pack('!I', n)) '192.168.2.1'
http://groups-beta.google.com/group/comp.lang.python/browse_thread/thread/d4d9d1870a481568/
http://groups-beta.google.com/group/comp.lang.python/browse_thread/thread/b2e259d7d55a6071/
Note:
See TracTickets
for help on using tickets.
If you're concerned about using fewer bits, use PostgreSQL, which has a custom IP address column type (which Django uses). Django only uses string formats for MySQL and SQLite.