What does sqlite/sqlite do?

SQLite es un motor de base de datos relacional sin servidor y una biblioteca basada en C que almacena datos en un único archivo de disco local. Funciona como una base de datos SQL embebida, integrándose directamente en las aplicaciones sin necesidad de un proceso de servidor independiente.

What are the main features of sqlite/sqlite?

The main features of sqlite/sqlite are: Embedded Databases, Embedded Database Integrations, File-Based Storage Systems, SQLite Databases, Embedded Database Engines, R-Tree Indexes, SQL Query Execution, B-Tree and R-Tree Indexed Stores.

What are some open-source alternatives to sqlite/sqlite?

Open-source alternatives to sqlite/sqlite include: tencent/wcdb — WCDB is a cross-platform storage layer and embedded database engine that serves as a framework for SQLite. It… cozodb/cozo — Cozo is a logic-based database engine that functions as a relational data store, an embedded graph database, and a… google/leveldb — LevelDB is an embedded database library and persistent storage engine that provides a sorted key-value store. It uses… tursodatabase/libsql — LibSQL is a high-performance, distributed SQL database engine that extends SQLite to support remote network access,… syndtr/goleveldb — goleveldb is an embedded key-value storage database for Go. It provides local data persistence and indexing, allowing… tidwall/buntdb — BuntDB is an embedded key-value store for Go applications, providing in-memory storage with optional disk persistence.…

Sqlite - integrar bases de datos SQL en aplic…

Features

Embedded Databases - Functions as a self-contained relational database engine that integrates directly into applications without a server.
Embedded Database Integrations - Integrating a full SQL engine directly into a larger application as a library to manage data without a separate server.
File-Based Storage Systems - Provides a serverless storage architecture that persists all database data within a single cross-platform disk file.
SQLite Databases - Provides a serverless, transactional SQL engine that stores the entire database in a single disk file.
Embedded Database Engines - Functions as an embedded engine that integrates directly into applications without requiring a separate server process.
R-Tree Indexes - Uses R-Tree indexing to enable efficient geometric and geographic queries for multi-dimensional coordinate data.
SQL Query Execution - Executes SQL statements to manipulate and retrieve data from local files.
B-Tree and R-Tree Indexed Stores - Implements balanced B-Tree structures to ensure efficient logarithmic time complexity for data searches and insertions.
Relational Local Storage - Provides a relational local storage engine for managing structured data within a single disk file.
Write-Ahead Logging - Employs write-ahead logging to ensure atomic commits and durability by recording changes before applying them to the main database.
C Libraries - Ships as a portable C library that can be compiled as a shared library or embedded source.
Database Page Caching - Manages data movement between disk and memory using a page-based caching system to optimize I/O.
Bytecode Virtual Machines - Compiles SQL statements into bytecode executed by a specialized internal virtual machine.
Spatial Querying - Enables the retrieval of data objects based on spatial bounding boxes and coordinates.
Database Change Tracking - Tracks data changes in sessions to generate changesets for synchronizing modifications between databases.
Database Administration Interfaces - Ships a terminal-based management interface for interacting with and administering multiple database files.
Full Text Search - Provides specialized indexing and searching capabilities for large volumes of text.
Full-Text Search Engines - Implements a full-text search system for indexing and retrieving text-based content.
Full-Text Search Indexes - Provides full-text search indexes for rapid keyword retrieval across large bodies of text.
Spatial Database Engines - Provides a database implementation optimized for indexing and querying spatial coordinate ranges.
Database Extension Modules - Allows the loading of external modules to extend the engine's search and indexing capabilities.
Source Code Amalgamations - Distributes the entire database engine as a single amalgamated C source file to simplify integration.
Database Recovery Utilities - Provides utilities to analyze and salvage data from corrupted database files.
Database Systems - Embedded, file-based SQL engine.
Bases de datos - Popular lightweight embedded SQL database.

Alternativas open-source a Sqlite

Proyectos open-source similares, clasificados según cuántas características comparten con Sqlite.

tencent/wcdb
Tencent/wcdb
11,502Ver en GitHub
WCDB is a cross-platform storage layer and embedded database engine that serves as a framework for SQLite. It functions as an object relational mapper, linking application classes to database tables to enable data operations via objects rather than raw queries. The project is distinguished by an integrated encryption layer for securing data at rest and a full-text search engine that uses language-specific tokenizers for text lookups. It also features transparent field compression to reduce storage footprints and a connection-pooling model to coordinate simultaneous read and write operations a
Candroiddatabaseios
Ver en GitHub11,502
cozodb/cozo
cozodb/cozo
3,880Ver en GitHub
Cozo is a logic-based database engine that functions as a relational data store, an embedded graph database, and a temporal vector database. It utilizes a Datalog-inspired query language to execute relational, recursive, and graph queries. The system distinguishes itself through specialized indexing for high-dimensional vector similarity searches and near-duplicate detection using locality sensitive hashing. It also provides built-in temporal versioning, allowing for historical state retrieval and time-travel queries to access data as it existed at specific points in time. Its broader capabi
Rustclient-servercozocozoscript
Ver en GitHub3,880
google/leveldb
google/leveldb
39,152Ver en GitHub
LevelDB is an embedded database library and persistent storage engine that provides a sorted key-value store. It uses a log-structured merge-tree architecture to map byte arrays to values, running directly within a process to provide storage without the need for a separate server process. The system is distinguished by its use of custom comparison functions to define key ordering, enabling efficient range scans and sequenced lookups. It ensures data reliability through atomic batch execution, consistent snapshot generation, and log-based recovery after failures. The engine covers broad capab
C++
Ver en GitHub39,152
tursodatabase/libsql
tursodatabase/libsql
16,887Ver en GitHub
LibSQL is a high-performance, distributed SQL database engine that extends SQLite to support remote network access, edge computing, and real-time synchronization. It functions as an embedded database library that integrates directly into application processes while providing the infrastructure to maintain consistency across multiple geographic regions. The platform distinguishes itself by enabling database interaction over standard HTTP protocols, allowing applications to query remote data sources in serverless and edge environments without requiring local filesystem access. It includes nativ
Cdatabaseembedded-databaserust
Ver en GitHub16,887

Ver las 30 alternativas a Sqlite

Sqlite - integrar bases de datos SQL en aplic… | Awesome Repos

sqlitesqlite

Sqlite

Features

Alternativas open-source a Sqlite

Tencent/wcdb

cozodb/cozo

google/leveldb

tursodatabase/libsql

Frequently asked questions

Historial de estrellas

Alternativas open-source a Sqlite

Tencent/wcdb

cozodb/cozo

google/leveldb

tursodatabase/libsql

Frequently asked questions