Skip to main content

​
Built-in Extensions

​
vsql_complex

Status: Built-in with VillageSQL Repository: villagesql-server/villagesql/examples/vsql-complex Complex number data type with full arithmetic support for electrical engineering, signal processing, and scientific computing. Features:
  • COMPLEX column type for storing complex numbers (a + bi)
  • Constructor: COMPLEX(real, imaginary)
  • Arithmetic: add, subtract, multiply, divide
  • Utilities: complex_real(), complex_imag(), complex_abs(), complex_conjugate()
  • Binary storage: 16 bytes (2 doubles)
Installation: 
INSTALL EXTENSION 'vsql_complex';
Example Usage: 
CREATE TABLE signals (
    id INT PRIMARY KEY,
    impedance COMPLEX,
    frequency_response COMPLEX
);

INSERT INTO signals VALUES
    (1, COMPLEX(50.0, 0.0), COMPLEX(0.95, 0.31));

SELECT
    complex_abs(impedance) as magnitude,
    complex_add(impedance, frequency_response) as total
FROM signals;
Learn More: vsql_complex Deep Dive

​
Additional Built-in Extensions

The following built-in extensions are maintained in separate repositories. Each extension provides its own installation instructions and documentation.

vsql_uuid

UUID data type and functionsGenerate, validate, convert, and compare UUIDs. Includes v1, v4, and v5 UUID generation.

vsql_crypto

Cryptographic functionsHashing (SHA-256, SHA-512), encryption (AES), and secure random data generation using OpenSSL.

vsql_network_address

Network address typesIPv4, IPv6, and MAC address data types with validation, comparison, and network operations.

vsql_ai

AI-powered SQL functionsIntegrate AI capabilities directly into your database queries.

​
Installing Built-in Extensions

Built-in extensions are included with VillageSQL and ready to install: 
INSTALL EXTENSION 'extension_name';
See Installing Extensions for detailed instructions.

​
Creating Your Own Extension

Build custom extensions using the VillageSQL extension template:

vsql_extension_template

Fork this template to start building your own VillageSQL extension
 Get started: Creating Extensions Guide

​
Next Steps

Install Extensions

Add extensions to your database

Create Extension

Build your own extension

Managing Extensions

Monitor and troubleshoot

System Reference

Query extension metadata