Which database engines support IP addresses as a native type?

Posted by Matt McClellan on Stack Overflow See other posts from Stack Overflow or by Matt McClellan
Published on 2010-01-13T18:00:09Z Indexed on 2010/04/04 7:03 UTC
Read the original article Hit count: 214

Filed under:

database

|

ipaddress

I'm trying to find databases with support for IP addresses as a native type (as opposed to storing as a string, or an unsigned integer, which at least one commenter has already pointed out won't work for IPv6). The primary reason I'm looking for this is ease of development. For example, sorting on a "native" IP address column would be correct (as opposed to when it's stored as a string). I would assume support for such a type would also include useful operations such as determining if an IP address is inside a specified network for use in WHERE clauses.

The only one I'm aware of so far is PostgreSQL with its inet class. Does anyone have any others?

© Stack Overflow or respective owner

Related posts about database

SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
Cloning A Database On The Same Server Using Rman Duplicate From Active Database

as seen on Oracle Blogs - Search for 'Oracle Blogs'
To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option. In this case we do not require an existing backup, the active datafiles will be used as the source for the clone. In order to clone with the source database… >>> More
cPickle ImportError: No module named multiarray

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using cPickle to save my Database into file. The code looks like that: def Save_DataBase(): import cPickle from scipy import * from numpy import * a=Results.VersionName #filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More

Related posts about ipaddress

How to get IPaddress from domain name in java

as seen on Stack Overflow - Search for 'Stack Overflow'
HI I am writing an application where I need IP address. I have domain name, but I like to know hoe to get IP address from domain name. For ex www.girionjava.com how to get IP address of this by programming in java. Thanks >>> More
cannot get ip address on a virtual machine

as seen on Stack Overflow - Search for 'Stack Overflow'
so i have a code which gets me the ip address of a machine i am wroking on. so if my gui is published on the server and i access it from my local machine it gives me tha address of my local machine and when i access the gui from the server itself it gives me the server address.. which is fine. But… >>> More
Ip address of the client machine

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Please let me know how to get the client IP address, I have tried all of the below things , but I am getting the same output 127.0.0.1 string strClientIP; strClientIP = Request.UserHostAddress.ToString(); string strHostName = System.Net.Dns.GetHostName(); string clientIPAddress… >>> More
Get domain user from IPAddress or Hostname in .Net

as seen on Stack Overflow - Search for 'Stack Overflow'
We're trying to implement a custom solution for Growl for Windows. We tell the Growl client to subscribe to notifications from our server. The server then gets a message from the client via the GNTP (Growl messaging protocol). We require the name of the user logged into the client machine in order… >>> More
how to get ipaddress of my computer

as seen on Stack Overflow - Search for 'Stack Overflow'
hello i want to knw the ipaddress of my computer. /sbin/ifconfig eth0 | grep 'inet addr:' | cut -d: -f2 | awk '{ print $1}' this command gives the ipaddress of my computer and print result on console but i want it in a varible sothat i can use it in my C program. How can i do that. >>> More