SQLite storage backend

Add a new local storage backend to allow data to be persisted in SQLite
Available
$8,000.00
Check Out Task
Task Bounty Details

6178

LND Issue

Weeks

Estimated Effort

Available

Current Status

$8,000.00

Paid in USD or equivalent BTC upon acceptance

LND Issue

Last year, Postgres support was merged into the code base. Unfortunately it is not yet possible to use structured SQL with Postgres because compatibility with BBOLT’s key-value model needs to be retained. This task adds SQLite support to LND. SQLite is widely supported across (mobile) devices and has the potential to eventually replace BBOLT. At that point, the possibility of a gradual migration to structured SQL opens up.

An initial proof of concept which may be used for inspiration is referenced in the issue description. One of the main missing pieces is an abstraction layer that covers both Postgres and SQLite.

Prerequisite Skills

golang, SQL

Code Guidelines

Repository Code Guidelines Page

Definition of Done

Get a PR merged which results in a close of the linked issue

Check Out Task