arn-c0de / arn-c0de/Geograbber

Issue: Python Tools – Missing SQLCipher Encryption Support

Open
#19 0 comments 0 reactions 0 assignees View on GitHub
area: database bug enhancement medium python
Dominant language
Java
Stars
29
Forks
3
PR merge metrics
No merged PRs in 30d

Description

### Description
The current Python tools cannot open or process encrypted databases created by the Android app.
Encryption support using SQLCipher has not yet been implemented.

### Tasks
- [ ] Integrate SQLCipher support into both Python tools
- [ ] Implement passphrase/key input handling
- [ ] Add decryption/encryption routines compatible with Android database format
- [ ] Update documentation (usage + troubleshooting)
- [ ] Add tests for encrypted import/export operations

### Priority
High – Required for full cross-platform compatibility

### Affected Components
- `python_import_tool.py`
- `python_export_tool.py`

Contributor guide

Open the contributing guide

Research direction

Read python_import_tool.py and python_export_tool.py first, then review how their database operations must support the Android SQLCipher format. Define the passphrase flow, add tests for encrypted import/export operations, and update the usage and troubleshooting documentation to cover the completed support.

Written by the indexing model from the issue text.

Assessment

Tech stack
android, python, sqlite
Domain
databases, security
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.