planetscale / planetscale/cli

Allow for hex formatting against binary fields for dumping exports

Open
#1,172 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Go
Stars
670
Forks
63
Avg merge
11h 37m
Merged PRs (30d)
64

Description

For databases with large amounts of binary data, data integrity and interoperability is important, as some other tools or importers can struggle with special characters and encoding in raw binary.

Export tools like mydumper and mysqldump already use a --hex-blob option to store binary as hex.

https://mydumper.github.io/mydumper/docs/html/mydumper_usage.html#cmdoption-mydumper-hex-blob

https://dev.mysql.com/doc/refman/9.2/en/mysqldump.html#option_mysqldump_hex-blob

Having something similar with the native pscale database dump would ensure users are getting the same popular benefits found elsewhere.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start at the native pscale database dump command and inspect how binary fields are currently serialized in exports. Use the linked mydumper and mysqldump documentation as behavioral references. Done means the dump supports hex formatting for binary data and verifies the resulting export preserves interoperable values.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.