Back to all Tasks

SQLite storage backend

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

6178

LND Issue

Weeks

Estimated Effort

Not 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
Back to all Tasks
© 2023 NYDIG. All rights reserved.
LICENSES | PRIVACY POLICY
This website is provided for informational purposes only. None of the material on NYDIG.com is intended to be, nor does it constitute, a solicitation, recommendation or offer to buy or sell any security, financial product or instrument. You should conduct your own analysis and consult with professional advisors prior to making any investment decisions. Bitcoin investments have historically been highly volatile and are for investors with a high risk tolerance. Investors in bitcoin could lose the entire value of their investment. All statistical information is as of December 31, 2022 unless otherwise specified.‍

Only certain NYDIG legal entities or businesses are regulated. New York Digital Investment Group LLC is not overseen by any regulator. Please see the NYDIG disclosures or terms and conditions for the particular service or transaction for more details. NYDIG Execution LLC (NMLS ID: 1781446) is licensed to engage in Virtual Currency Business Activity by the New York State Department of Financial Services. NYDIG Trust Company LLC (NMLS ID: 1985471) is chartered as a limited purpose trust company by the New York State Department of Financial Services. Full-Service Brokerage refers to bitcoin trading services provided by NYDIG Execution LLC and NYDIG Trust Company LLC; neither entity is registered as a broker-dealer with the SEC or FCM with the NFA or CFTC. NYDIG Trust Company LLC does business under registered dba names in various states as disclosed here. NYDIG, NY\DIG, and NEW YORK DIGITAL INVESTMENT GROUP are registered trademarks of NYDIG.

Loans made in California are made by NYDIG Funding LLC. Such loans are made or arranged pursuant to a California Financing Law license.