# google/lovefield

Lovefield is a relational database for web apps. Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast, safe, and easy to use.

Repository: https://github.com/google/lovefield
Canonical: https://ross.abutalabs.com/products/lovefield
Homepage: https://google.github.io/lovefield/
Language: JavaScript
License: Apache-2.0
License Family: permissive
Archived: true
Last push: 2021-08-10T22:09:29+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 4355, "days_push": 1849, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 6767, forks 361 (observed 2026-08-28T04:09:48.419580+00:00)

## What it is
Lovefield is a pure JavaScript relational database for web apps, providing SQL-like APIs that work cross-browser. It enables structured, queryable client-side data storage for offline-capable web applications.

## Use cases
- store structured data in the browser with SQL-like queries
- build offline-capable web apps with local relational storage
- query client-side data without a backend database
- manage relational data across browsers in JavaScript
- replace raw IndexedDB with a friendlier query API

## When to choose
- you need a relational data model with SQL-like queries entirely in the browser
- you want cross-browser client-side persistence without server dependencies
- you prefer typed, safe query APIs over raw IndexedDB

## When to avoid
- you need a server-side or Node.js production database
- you require active development and recent updates - the project has seen little activity since 2021
- you need large-scale data storage beyond browser limits

## Facets
- artifact type: library
- maturity: maintenance
- function: database, orm
- domain: databases, web-development, frontend
- platform: browser
- tags: client-side-database, sql-like-api, indexeddb, offline-first, cross-browser, nodejs, javascript

## Member repositories
- google/lovefield (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:48.419580+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:42:32.137470+00:00, confidence not recorded.
  - readme: https://github.com/google/lovefield (fetched 2026-08-28T04:09:48.419580+00:00, sha 0273b8fcbaaf)
  - homepage: https://google.github.io/lovefield/ (fetched 2026-08-29T08:38:48.500933+00:00, sha f8546bc97fdc)
  - registry_npm: https://registry.npmjs.org/lovefield (fetched 2026-08-29T08:38:48.509785+00:00, sha 86e94feeb620)
- Data as of 2026-08-30T08:39:29.467469+00:00.