nalgeon/sqlean

Features

• SQLite Extensions - Provides a comprehensive suite of extensions and plugins that expand the native capabilities of the SQLite database engine.
• Database Extensions - Provides a broad set of extensions for adding cryptography, mathematics, and text manipulation to SQLite.
• CSV Query Engines - Allows for direct SQL querying of CSV files by treating them as virtual tables.
• Cryptography Toolsets - Provides binary hashing and encoding functions for BLAKE3, SHA-2, Base64, and Hex within SQLite.
• Filesystem Interfaces - Implements virtual tables for querying CSV files and functions for direct filesystem I/O from within SQLite.
• Virtual Tables - Implements virtual tables that map external data sources and files directly into the relational schema.
• Virtual Table Mappings - Maps CSV files to virtual tables, enabling data queries without importing the files into the database.
• C Shared Libraries - Provides a collection of high-performance C shared libraries that can be dynamically loaded into the SQLite engine.
• Unicode Text Handling - Provides advanced Unicode-aware text handling and multi-byte character processing for SQLite strings.
• Cryptographic Operations - Provides cryptographic primitives for hashing, encoding, and decoding to ensure data integrity.
• Data Hashing Utilities - Executes cryptographic hashing and encoding operations to secure and transform data.
• Cryptographic Hash Computations - Generates binary hashes of text or blobs using algorithms like BLAKE3 and SHA-2.
• Phonetic String Encoders - Implements algorithms that transform text into phonetic codes to enable approximate string matching in SQL.
• Regex Pattern Matching - Provides regular expression capabilities to check if strings match specific patterns.
• Regex Text Replacement - Supports modifying text by substituting matching substrings using regular expression search and replace.
• Dynamic SQL Query Executions - Enables the execution of dynamic SQL statements that return results as joined strings.
• High-Precision Temporal Types - Manages date and time data using timestamps with high-precision resolution.
• Regular Expression Engines - Provides a full suite of regular expression functions for searching and manipulating text.
• Custom Scalar Function Writing - Enables the creation of custom scalar user-defined functions to encapsulate reusable single-value logic.
• Fuzzy Matching Extensions - Provides specialized SQLite extensions for performing fuzzy string matching and scoring within database queries.
• String Concatenation Functions - Combines multiple strings using a specified separator while handling null values.
• String Repetition Functions - Creates new strings by repeating an original string multiple times.
• Temporal Comparison Operators - Determines if one time instant is before, after, or equal to another.
• Temporal Formatters - Converts time values into human-readable strings using ISO 8601 or custom layouts.
• Temporal Value Generators - Generates time representations from date components, Unix timestamps, or the current UTC time.
• Text Pattern Matching - Enables text pattern matching using the standard SQL LIKE syntax.
• Text Replacement Functions - Provides functions to swap substrings or translate individual characters within database text fields.
• Time Component Extractors - Includes functions for isolating specific time portions like year, month, or hour from datetime values.
• Unique Identifier Generators - Generates unique version 4 and version 7 identifiers for use as primary keys.
• Table Function Invocation - Supports table-valued functions that return multiple rows via internal select statements.
• Date Arithmetic Logic - Provides mathematical operations for adding or subtracting durations and date components.
• Duration Rounding - Rounds time values down to a specific precision field or the nearest multiple of a duration.
• Date String Parsers - Provides utilities for converting formatted date or time strings back into native time values.
• Filesystem Management - Includes utilities for creating directories, managing symbolic links, and listing files in folders.
• Date Difference Calculators - Computes the duration between two time instants or the time elapsed since a specific point.
• String Case Transformers - Transforms strings between upper case, lower case, and title case.
• String Padding Utilities - Provides utilities to add characters to the beginning or end of a string to reach a target length.
• IP Address Validation - Validates the structural correctness of IP address strings for network-related analysis.
• Address Analysis - Extracts network components, address families, and prefix lengths from IP addresses and subnets.
• IP Range Analyzers - Determines if specific IP addresses or subnets are contained within a network range.
• File Content Reading - Provides functions to read file contents as raw blobs or lines and write binary data to disk.
• File I/O Management - Implements low-level primitives for reading and writing data directly to the local filesystem.
• Transliterations - Converts UTF-8 strings into ASCII by replacing characters with their closest equivalents.
• Database Function Registrations - Implements mechanisms to register deterministic C functions within the database environment for query optimization.
• String Reversal Operations - Provides functionality to flip the order of characters in a string.
• String Splitting - Divides strings into segments based on delimiters and allows retrieval by index.
• String Trimming - Removes specified characters or whitespace from the start and end of strings.
• String Byte Size Calculators - Calculates string length in characters, bytes, or bits, accounting for multi-byte Unicode characters.
• High Precision Mathematics - Computes high-precision mathematical, statistical, and temporal values.
• Mathematics - Provides advanced mathematical calculations and statistical analysis for data processing.
• SQL Mathematical Functions - Provides built-in rounding, logarithmic, trigonometric, and hyperbolic functions for use in SQL queries.
• String Distance Algorithms - Calculates the distance between two strings to determine their similarity for fuzzy matching purposes.
• Substring Counting - Calculates how many times a specific substring appears within a larger string.
• Substring Extraction Methods - Retrieves specific portions of strings using start positions, lengths, or ranges.
• Substring Search Algorithms - Locates the index of a substring or verifies if a string starts or ends with a specific pattern.
• SQLite Modules / Extensions - Listed in the “SQLite Modules / Extensions” section of the Awesome Sqlite awesome list.

Star history