mattn/go-sqlite3
Go Sqlite3
This project is a Go language driver for the SQLite database. It provides a relational database interface and a Cgo wrapper that connects Go applications to SQLite for persistent local data storage and query execution.
The implementation serves as a provider for JSON document storage and local full-text search. It enables the creation, querying, and modification of JSON data and the implementation of searchable indexes for large text datasets directly within the database.
The driver supports standard SQL query execution for both file-based and in-memory storage. It includes capabilities for foreign key constraint enforcement, numerical data analysis via custom mathematical functions, and user authentication and access management.
Features
- SQLite Drivers - Provides a Go language driver to connect applications to SQLite databases for persistent local storage.
- Embedded Databases - Implements a lightweight database engine that runs within the application process for local state management.
- SQL Query Execution - Enables the execution of standard SQL commands and management of data files through a driver interface.
- Relational Database Drivers - Provides a driver designed for connecting to and interacting with a SQL-based relational database management system.
- SQLite Integration - Provides direct support for querying and managing SQLite database files within Go applications.
- Go-C Bridges - Uses Cgo to provide a foreign function interface that connects Go applications to the C implementation of SQLite.
- SQL Driver Interfaces - Maps database operations to the Go standard library SQL interface for compatibility with generic database toolkits.
- Foreign Key Constraints - Enforces parent-child integrity by controlling how foreign key constraints are applied during data operations.
- Full Text Search - Implements local full-text search capabilities for efficient phrase and keyword discovery within large text datasets.
- JSON and Search Providers - Serves as a provider for both JSON document storage and local full-text search operations.
- Hybrid Relational-JSON Storage - Supports the storage and querying of flexible JSON documents within a relational SQLite database.
- JSON Document Manipulation - Provides built-in functions to create, query, and modify JSON data directly within the database.
- Custom SQL Functions - Allows the registration of Go functions as custom SQL scalar or aggregate functions via C-to-Go callbacks.
- Static Binary Compilers - Combines the C database engine and Go runtime into a single self-contained executable during build.
- C Source Embeddings - Bundles the complete SQL engine source code directly into the binary to avoid external shared library requirements.
- In-Database Numerical Analysis - Performs advanced math and statistical calculations directly within the database using custom functions.
- Database Math Extensions - Adds scalar math and aggregate statistics to the database for advanced numerical analysis.
- Database Drivers - SQLite3 driver for database/sql.
- Database Tools - SQLite3 driver for Go.
- Databases & Data - SQLite3 driver for interacting with relational databases.
