What does sqlite/sqlite do?

SQLite este un motor de baze de date relaționale serverless și o bibliotecă bazată pe C care stochează datele într-un singur fișier local pe disc. Funcționează ca o bază de date SQL încorporată, integrându-se direct în aplicații fără a fi nevoie de un proces de server separat.

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 - încorporează baze de date SQL în apl…

Sqlite - încorporează baze de date SQL în apl… | Awesome Repos

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.
Baze de date - Popular lightweight embedded SQL database.

Alternative open-source pentru Sqlite

Proiecte open-source similare, clasificate după numărul de funcționalități comune cu Sqlite.

kuzudb/kuzu
kuzudb/kuzu
3,965Vezi pe 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
Vezi pe GitHub3,965
tencent/wcdb
Tencent/wcdb
11,502Vezi pe 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
Vezi pe GitHub11,502
cozodb/cozo
cozodb/cozo
3,880Vezi pe 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
Vezi pe GitHub3,880
google/leveldb
google/leveldb
39,152Vezi pe 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++
Vezi pe GitHub39,152

Vezi toate cele 30 alternative pentru Sqlite

sqlitesqlite

Sqlite

Features

Alternative open-source pentru Sqlite

kuzudb/kuzu

Tencent/wcdb

cozodb/cozo

google/leveldb

Frequently asked questions

Istoric stele

Alternative open-source pentru Sqlite

kuzudb/kuzu

Tencent/wcdb

cozodb/cozo

google/leveldb

Frequently asked questions