What does sqlite/sqlite do?

SQLite est un moteur de base de données relationnelle sans serveur et une bibliothèque en C qui stocke les données dans un seul fichier disque local. Il fonctionne comme une base de données SQL embarquée, s'intégrant directement dans les applications sans nécessiter de processus serveur séparé.

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: kuzudb/kuzu — Kùzu is an embedded property graph database engine designed for high-performance analytical queries and local data… 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…

Sqlite - intégrer des bases de données SQL da…

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 données - Popular lightweight embedded SQL database.

Alternatives open source à Sqlite

Projets open source similaires, classés selon le nombre de fonctionnalités partagées avec Sqlite.

kuzudb/kuzu
kuzudb/kuzu
3,965Voir sur GitHub
Kùzu is an embedded property graph database engine designed for high-performance analytical queries and local data management. It operates as a library within the host application process, utilizing a columnar-based storage architecture and just-in-time query compilation to execute complex graph traversals and pattern matching efficiently. By mapping database files directly into system memory, it ensures data durability and high-speed access while maintaining ACID-compliant transactional integrity. The engine distinguishes itself by integrating vector similarity search and full-text search di
C++cypherdatabaseembeddable
Voir sur GitHub3,965
tencent/wcdb
Tencent/wcdb
11,502Voir sur 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
Voir sur GitHub11,502
cozodb/cozo
cozodb/cozo
3,880Voir sur 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
Voir sur GitHub3,880
google/leveldb
google/leveldb
39,152Voir sur 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++
Voir sur GitHub39,152

Voir les 30 alternatives à Sqlite

Sqlite - intégrer des bases de données SQL da… | Awesome Repos

sqlitesqlite

Sqlite

Features

Alternatives open source à Sqlite

kuzudb/kuzu

Tencent/wcdb

cozodb/cozo

google/leveldb

Frequently asked questions

Historique des stars

Alternatives open source à Sqlite

kuzudb/kuzu

Tencent/wcdb

cozodb/cozo

google/leveldb

Frequently asked questions