decentralized-identity / decentralized-identity/dwn-sql-store

Change MySQL blob column to `longblob`

Open
#6 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
7
Forks
6
PR merge metrics
No merged PRs in 30d

Description

Currently, each dialect defines the following column types for blobs:

* MySQL - `blob` - 64Kb limit
* Postgres - `bytea` - 1 GB limit
* SQLite - `blob` - 1 GB limit (by default, we can make it go up to 2GB)

MySQL has a `LONGBLOB` column type, which has a capacity of ~4GB, bringing it more inline with the other dialects.

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue names no files or tests. Search the TypeScript dialect definitions for the MySQL blob mapping, then run the relevant database tests; done means MySQL uses LONGBLOB while the Postgres and SQLite mappings remain unchanged.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, typescript
Domain
database
Issue type
Feature
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.