SQLite
Public-domain embedded SQL database with commercial support services.
Available information varies by company and source.
Profile record updated:
Company facts
- Official name
- SQLite
- Entity type
- COMPANY
- Founded
- 2000
- Market role
- Other / Non-Digital Advertising Relevant
- Official website
- sqlite.org
What SQLite does
SQLite creates value by providing a widely adopted embedded database engine in the public domain, eliminating licence friction for developers and software vendors. The surrounding commercial model is service-led: organisations that need support, proprietary enhancements, or closer alignment with the maintainers contract with Hwaci or join the SQLite Consortium. The free core drives adoption; specialised enterprise relationships monetise trust, maintenance continuity, and advanced capabilities.
Category differentiation
SQLite is an embedded database engine project, not a cloud database service or an advertising technology vendor. The commercial entity around support is Hwaci, while the core code remains public-domain software.
Strategic context
AI-supported assessment from the existing company research; distinguish interpretation from sourced facts.
SQLite is a public-domain, open-source embedded SQL database engine project. It is distributed as infrastructure software rather than as a conventional SaaS platform, and it is widely used by developers and software vendors that need a lightweight embedded database engine inside applications, devices, and software products. The codebase itself is free for any purpose, including commercial use. Revenue generation linked to the ecosystem comes from commercial support, proprietary extensions, and SQLite Consortium membership contracts provided by Hipp, Wyrick & Company, Inc. (Hwaci). Its paying customers are organisations that require support, long-term stewardship, or enhanced commercial rights around deployment of SQLite-based systems.
Company news briefing
Briefing updated:
Strengthening its role in persistent AI memory, SQLite has been adopted by the VEKTOR Slipstream SDK to facilitate continuous agent learning. The launch of ORM_Skyway further integrates the database into AI ecosystems by automating the creation of Model Context Protocol-compliant interfaces for relational data. Combined with its ongoing utility in the Monlite local-AI stack and Trelix v3.0’s secure audit trails, these developments reinforce SQLite’s strategic importance in decentralised data processing and the emerging "database-to-AI" architecture for autonomous agents.
Business model & monetisation
The ecosystem monetises through service fees for commercial support, contractual consortium memberships, and proprietary extensions delivered by Hwaci. The core software is not monetised through licence fees because the code is in the public domain.
- Commercial support
- Service Fee
- SQLite Consortium memberships
- Service Fee
- Proprietary extensions
- One-time Sale
Products & capabilities
No products with linked sources are available in this view.
Recent recorded signals
Dates refer to the source publication. Older entries are historical context, not evidence of a new event.
Export SQL Results to CSV and Excel Safely
Data Export & File Formats · Recorded impact score: 1/5
A technical how-to showing how to export SQL query results to CSV or XLSX without corrupting values (leading zeros, accented characters, dates). The author demonstrates that CSV exports preserve bytes but that damage usually occurs when Excel guesses column types on open. Recommended practices include opening CSVs in Excel via Data → Get Data → From Text/CSV (set File Origin to UTF-8 and mark code columns as Text), adding a UTF-8 byte order mark (BOM) on export (e.g., sqlite3 .once --bom) to avoid accent issues, and generating real .xlsx files (e.g., with pandas.to_excel) when humans will double-click the file. The article also lists quick checks to run after export (row counts, code endpoints, an accent, a date) and details other common CSV pitfalls.
- The author tested exports on 2026-08-08 using SQLite 3.51.1 and inspected files byte-by-byte to show exports themselves are correct.
- Opening a CSV by double-clicking in Excel can silently change data types (e.g., drop leading zeros or mis-interpret character encoding), while importing via Data → Get Data → From Text/CSV lets the user set types and encoding.
Trelix v3.0: Six opt-in features, audit trail added
Large Language Models (LLM) & AI · Recorded impact score: 2/5
The article documents trelix releases from v2.11.0 through v3.1.1 (last dated 2026-08-15). v3.0.0 introduced six major, opt-in feature areas: Anthropic extended thinking, a model-aware context token budget, a VS Code extension, a hash-chained append-only SQLite audit trail, OIDC SSO (resource-server mode), and query-conditioned context compression, plus an optional FTS5 declaration boost. Defaults keep all features off so a default v3.0.0 install is byte-identical to v2.12.0. v3.0.1 fixed a parser index bug and requires a full reindex; v3.1.0 and v3.1.1 addressed rendering, symlink handling and safety fixes. The audit trail is a separate opt-in SQLite DB with tamper-evident checks, and the OIDC verifier enforces asymmetric algorithms and forged-token tests.
- v3.0.0 introduces six new, opt-in feature areas: Anthropic extended thinking, model-aware context budget, VS Code extension, hash-chained append-only audit trail, OIDC SSO, and query-conditioned context compression.
- The release span v2.11.0 → v3.1.1 comprises 68 commits, 137 files changed, and +19,829/-1,211 lines; v3.1.1 dated 2026-08-15.
Monlite: SQLite-based local stack for AI agents
Large Language Models (LLM) & AI · Recorded impact score: 2/5
Monlite is a TypeScript library that consolidates a local AI agent stack into a single SQLite .db file, providing a document store, vector search, full-text search, key-value cache, job queue, and cron scheduler. It uses SQLite's FTS5 and the sqlite-vec extension (vec0 virtual table) for KNN vector queries, supports Node (node:sqlite or better-sqlite3) and a Python port for cross-language interoperability, and implements exactly-once job claiming using SQLite's BEGIN IMMEDIATE write-intent lock. The project targets single-machine, local-first workflows (not high-concurrency distributed systems) and is available on GitHub; the core is at v2.6.1 with a frozen API.
- Monlite is a TypeScript library that stores document store, vector search, full-text search, key-value cache, job queue, and cron scheduler in a single SQLite .db file.
- Vector search is provided via the sqlite-vec extension, which adds a vec0 virtual table type for KNN queries.
DuckDB + Parquet for Ad‑hoc Analytics from SQLite
Measurement & Analytics Platform · Recorded impact score: 2/5
A developer describes a lightweight analytics pattern: populate a single SQLite DB from the YouTube Data API, then nightly export the analytical subset to hive-partitioned Parquet using the DuckDB CLI orchestrated by a small PHP script. The Parquet snapshots are partitioned by snapshot_date and region, compressed with zstd, and pulled to a local machine over FTP (lftp mirror). Local ad‑hoc analysis runs against the Parquet files with DuckDB (CLI or Python API), delivering sub-second queries across months of history; results (JSON) are pushed back to production hosts for simple cached rendering. The post documents implementation details, example SQL/PHP/Python snippets, performance characteristics, and operational gotchas (type casts, timezone normalization, idempotent writes, and partitioning best practices).
- The site ingests YouTube trending-video metadata for eight regions into a single SQLite database via periodic cron jobs.
- A nightly PHP-driven export invokes the DuckDB CLI to write hive-partitioned Parquet snapshots (partitioned by snapshot_date and region) with zstd compression.
Explore company relationships
Questions about SQLite
What is SQLite?
SQLite is a public-domain, open-source embedded SQL database engine used inside software applications and devices.
Who uses SQLite?
Software developers, product teams, device makers, and organisations embedding a lightweight local database into their products use SQLite.
How does SQLite make money?
The code itself is free; commercial revenue is generated through Hwaci via support contracts, consortium memberships, and proprietary extensions.
Sources & coverage
This profile uses public, official and technically observable information. Missing information does not prove that a product or relationship does not exist. The list below does not imply that every profile statement has been verified.
6 publicly documented primary sources and citations linked across the market graph.
Continue your research on SQLite
Explorer includes additional company details, a Watchlist for up to 25 companies and your personal Strategic Intelligence Agent. It monitors your market daily and delivers tailored briefings with clear strategic context whenever relevant news occurs.
Free, with no time limit.