Kinto/kinto

SQLite Support

Open

#1668 opened on May 31, 2018

View on GitHub
 (8 comments) (0 reactions) (0 assignees)Python (4,291 stars) (425 forks)batch import
help wantedstale

Description

Would it be beneficial for kinto to have SQLite support? I am thinking of doing some part time projects and this seems like a good project for me since I have a good background in databases.

Contributor guide

Tech stack
pythonsqlite
Domain
database
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
needs investigation
Prerequisites
Familiarity with Kinto's storage APISQLite knowledge
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
35
Research direction
Examine Kinto's current storage layer (e.g., kinto/core/storage/) and its PostgreSQL backend to understand the interface. Review comments in issue #1668 for prior discussion and any design constraints. Prototype a simple SQLite backend using the same abstract base class, then propose the changes for maintainer feedback.