3 ms·
My condolences. I think one thing that's not mentioned enough in the SQL vs NoSQL debate is the benefit of powerful storage types. For example, when storing IP
by spamizbad 9y ago
My condolences.
I think one thing that's not mentioned enough in the SQL vs NoSQL debate is the benefit of powerful storage types. For example, when storing IP addresses in Postgres, you can use the inet datatype and easily query results if they fall within a given cidr range. Example:
SELECT * FROM audits WHERE ip_address << '10.0.0.0/20'
gives you any matching address between 10.0.0.1 and 10.0.15.254
- StavrosK 9y agoThat's one of the reasons why I love Postgres. Relatedly, people swear by PostGIS.