Riders Of The Bit

Conocer la IP asociada a un interfaz de red (solo para Linux)

Transcribo una receta, de código Python, publicada en ActiveState Code por Paul Cannon, donde se ve como conocer la dirección IP asociada a un interfaz de red (bajo Linux) mediante la llamada a sistema ioctl SIOCGIFADDR.

1
2
3
4
5
6
7
8
9
10
11
import socket
import fcntl
import struct
 
def get_ip_address(ifname):
s = socket.socket(socket.AF_INET, socket.SOCK_DGRAM)
return socket.inet_ntoa(fcntl.ioctl(
[...]

SQL case-sensitive comparison over MySql

If someone is finding a way to do a case sensitive comparison in SQL (over MySql), below can find the recipe:
This one produces a True result:

1
SELECT ‘A’ = ‘a’;

The solution is doing the comparison with a = or LIKE and the BINARY clause:

2
SELECT ‘A’ LIKE BINARY ‘a’;

or

3
SELECT ‘A’ = BINARY ‘a’;

This produces a False result [...]