tursodatabase/libsql

Features

• SQLite Databases - Extends SQLite to provide a high-performance, distributed SQL database engine.
• Distributed Databases - Distributes database content across multiple geographic regions to reduce latency and ensure high availability.
• Distributed SQL Databases - Functions as a distributed SQL database engine for global, high-availability applications.
• Edge Databases - Provides an edge-ready database platform optimized for low-latency access in distributed environments.
• Embedded Database Engines - Integrates a local database engine directly into the application process for low-latency storage.
• Embedded Databases - Integrates as a lightweight embedded database library within application processes.
• Vector Similarity Search - Executes vector similarity queries directly within the database to support AI-powered workflows.
• Data Replication - Distributes database content across multiple geographic locations to reduce latency and improve availability.
• Distributed Data Synchronization Systems - Maintains consistent data across local replicas and remote primary instances for high availability.
• HTTP-to-SQL Mappers - Transmits SQL commands and results over standard HTTP requests for serverless and edge environments.
• Vector Databases - Stores and queries high-dimensional vector embeddings natively within the database engine.
• Vector Storage - Stores and queries high-dimensional vector data natively to support machine learning and AI applications.
• Data Change Subscriptions - Streams database table updates to clients in real-time as transactions are committed.
• Persistence & Durability - Persists committed transactions to cloud storage to ensure data remains recoverable.
• Database Branching - Generates isolated database instances from existing data to facilitate safe development and testing workflows.
• Database Query Execution - Enables executing SQL queries and managing data retrieval over standard HTTP requests.
• Multi-Version Concurrency Controls - Enables concurrent write operations across nodes without locking to improve throughput.
• Vector Search - Supports high-dimensional vector similarity search directly within the database engine.
• Local-First Synchronization - Maintains consistency between local database replicas and remote primary instances via automated synchronization.
• Encrypted Persistence - Secures local database files at rest using user-provided encryption keys.
• Network Access Restrictions - Limits incoming database connections to specific IP addresses, CIDR ranges, or VPC endpoints.
• Replica Request Routing - Directs database queries to the geographically closest replica to minimize network latency.
• Consistency Tuning - Ensures that clients can immediately query their own recent writes from a local replica.
• Database Backup Restoration - Reverts databases to specific timestamps using transaction logs to recover from data loss.
• Data Snapshotting - Saves point-in-time copies of remote databases to local files for analysis and backup.
• Data Synchronization Engines - Automates background tasks to synchronize local data with remote databases at defined intervals.
• Database Connectivity - Provides secure network connectivity for applications to access remote database instances.
• Transaction Management - Manages sequences of operations with manual commit or rollback triggers to ensure data integrity.
• Access Tokens - Validates client requests using scoped JSON Web Tokens to enforce granular permissions.
• Database Access Control - Implements granular authentication and network-level restrictions to secure multi-tenant database resources.
• Database Operation Permissions - Enforces granular table-level permissions for reading, inserting, updating, or deleting database records.
• SQL Batching - Groups multiple SQL statements into a single request to improve performance and reduce latency.
• Query Performance Monitoring - Tracks frequent database queries and reports row-level metrics to identify performance bottlenecks.
• Asynchronous Database Drivers - Performs non-blocking database interactions to maintain application responsiveness during high-concurrency workloads.
• Cloud Database Provisioning - Facilitates the provisioning and management of database instances through command-line tools.
• Concurrent Write Optimizations - Buffers write operations locally and synchronizes them in a single transaction to optimize performance.
• Database Drivers - Supports language-specific drivers to execute SQL statements and maintain authenticated communication.
• Geographic Proximity Routing - Determines the optimal database location based on network proximity to minimize latency.
• Query Performance Analyzers - Analyzes execution history to identify and surface resource-intensive SQL statements for performance tuning.
• Access Token Management - Generates scoped credentials for specific databases or groups to authenticate programmatic requests.
• API Request Authentication - Verifies caller identity and authorizes management operations using scoped tokens.
• Credential Revocation - Invalidates active database access tokens by rotating signing keys to terminate unauthorized connections.
• Session Authentication - Manages login flows and session tokens for persistent user access.
• Organization Management - Enables users to establish new organizational accounts for managing shared database resources and billing.
• Team Administration - Provides a centralized interface for managing organizational membership, team invitations, and subscription plans.
• Database Extensions - Supports integrating specialized modules for advanced data processing and indexing.
• Filesystem Synchronization - Replicates local filesystem state to remote databases for backups and multi-machine collaboration.
• File-Based Storage Systems - Maintains temporary database state entirely within system memory for ephemeral storage requirements.
• In-Memory Databases - Maintains temporary database state within system memory for high-speed access.
• Prepared Statements - Compiles SQL queries with placeholders to improve performance and prevent injection vulnerabilities.
• Virtualized Filesystem Layers - Creates isolated filesystem layers allowing agents to modify data without altering underlying source files.
• Storage Configurations - Allows storing database files within cloud infrastructure buckets to maintain control over data residency.
• Access Control and Authorization - Authenticates users and authorizes programmatic interactions with database resources.
• OAuth Scope Restrictions - Enforces least privilege by limiting credential scope to specific organizations or groups.
• Private Network Security - Routes database traffic through private virtual network connections to bypass the public internet.
• Health Monitoring - Reports operational status and version information for database instances to ensure system health.
• Security Audit Logs - Retrieves chronological records of administrative actions within an organization for security auditing.

Star history