Hash, Salt & Encryptwith SQL-like Simplicity

# Start interactive CLI
bash mixql.sh

# Or run directly with custom host/port
bash mixql.sh -h mixql.demo.senicity.com -p 9797

# Example session:
mixql> SELECT SHA1(:input) AS hash
Enter value for "input": hello
Result: aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d

mixql> CREATE UUID
Result: a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d

mixql> CREATE SALT LIMIT 3 LENGTH 24
Result:
  • xY8pLq9RzT2wN4bV7mK3jH6
  • gF5dS1aQ8wE3rT6yU9iO2p
  • bN7vM4cX1zL9kJ8hG5fD2s

<?php
include_once 'mixql-php/autoload.php';

// Create client instance
$mixql = new MixQL('localhost', 7272);

// SHA-1 hash with parameter
$result = $mixql->query(
  'SELECT SHA1(:input) AS hash',
  ['input' => 'hello']
);
// Result: aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d

// Generate UUID
$uuid = $mixql->createUuid();
// Result: a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d

// Batch salt generation
$salts = $mixql->createSalts(5, 32, true);
// Returns array of 5 SHA-1 hashed salts

// Store query for reuse
$mixql->storeQuery(
  'hash_password',
  'SELECT SHA1(:password) AS hash'
);

-- SHA-1 hash with uppercase output
SELECT SHA1(:data) AS hash UPPERCASE

-- Nested functions with timestamp
SELECT SHA1(CONCAT(:user, NOW())) AS hash

-- MD5 hash
SELECT MD5(:input) AS hash

-- Base64 encoding
SELECT BASE64_ENCODE(:secret) AS hash

-- Create UUID
CREATE UUID

-- Generate 5 salts of 32 characters
CREATE SALT LIMIT 5 LENGTH 32

-- Generate salts with SHA-1 post-hash
CREATE SALT SHA

-- Generate 10 keys
CREATE KEY LIMIT 10

-- Store query for reuse
SELECT SHA1(:password) AS hash STORE AS hash_password

-- Execute stored query
STORE USE hash_password

# Pull latest image
docker pull senicity/mixql:latest

# Run with default config
docker run -p 7272:7272 senicity/mixql:alpine

# Run with custom port and auth
docker run -p 8080:8080 \
  -e SERVER_PORT=8080 \
  -e SERVER_AUTH_ENABLED=true \
  senicity/mixql:ubuntu

# Mount custom config file
docker run -p 7272:7272 \
  -v /path/to/config.ini:/app/config/config.ini \
  senicity/mixql:alpine

# Test connection
echo -e "CREATE UUID\n" | nc localhost 7272

# Available tags:
# • senicity/mixql:alpine   (25MB, minimal)
# • senicity/mixql:ubuntu   (90MB, full libs)
# • senicity/mixql:latest   (points to alpine)

# Simple netcat example
echo -e "SELECT SHA1(:input) AS hash\nhello" | nc localhost 7272

# Python TCP client
import socket

def mixql_query(query, params=None):
    payload = query + "\n"
    if params:
        payload += "\n".join(params)
    
    with socket.socket(socket.AF_INET, socket.SOCK_STREAM) as s:
        s.connect(("localhost", 7272))
        s.sendall(payload.encode())
        return s.recv(4096).decode()

# JavaScript/Node.js example
const net = require('net');

function mixqlQuery(query, params = []) {
  return new Promise((resolve, reject) => {
    const client = new net.Socket();
    const payload = query + '\n' + params.join('\n');
    
    client.connect(7272, 'localhost', () => {
      client.write(payload);
    });
    
    client.on('data', (data) => {
      resolve(data.toString());
      client.destroy();
    });
    
    client.on('error', reject);
  });
}

# config.ini
[server]
port=7272
dbname=mixql
auth_enabled=true
auth_users=admin:secret123,user:password456

# Environment variables (override config.ini)
export SERVER_PORT=8080
export SERVER_DBNAME=customdb
export SERVER_AUTH_ENABLED=true

# Authentication example
# When auth_enabled=true, clients must send:
# AUTH username:password
# Before any other queries

# Priority order:
# 1. Environment variables
# 2. config.ini file
# 3. Default values

# Default values:
# port: 7272
# dbname: datastore
# auth_enabled: false
# auth_users: {} (empty map)