What does sqlite/sqlite do?

SQLite is a serverless relational database engine and C-based library that stores data in a single local disk file. It functions as an embedded SQL database, integrating directly into applications without the need for a separate server process.

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 - SQL-Datenbanken in Anwendungen einbe…

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.
Datenbanken - Popular lightweight embedded SQL database.

Open-Source-Alternativen zu Sqlite

Ähnliche Open-Source-Projekte, sortiert nach der Anzahl der gemeinsamen Funktionen mit Sqlite.

kuzudb/kuzu
kuzudb/kuzu
3,965Auf GitHub ansehen
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
Auf GitHub ansehen3,965
tencent/wcdb
Tencent/wcdb
11,502Auf GitHub ansehen
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
Auf GitHub ansehen11,502
cozodb/cozo
cozodb/cozo
3,880Auf GitHub ansehen
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
Auf GitHub ansehen3,880
google/leveldb
google/leveldb
39,152Auf GitHub ansehen
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++
Auf GitHub ansehen39,152

Alle 30 Alternativen zu Sqlite anzeigen

Sqlite - SQL-Datenbanken in Anwendungen einbe… | Awesome Repos

sqlitesqlite

Sqlite

Features

Open-Source-Alternativen zu Sqlite

kuzudb/kuzu

Tencent/wcdb

cozodb/cozo

google/leveldb

Frequently asked questions

Star-Verlauf

Open-Source-Alternativen zu Sqlite

kuzudb/kuzu

Tencent/wcdb

cozodb/cozo

google/leveldb

Frequently asked questions