dwyl / dwyl/github-backup

Why do we store the issue data in s3

Ouverte
#126 1 commentaire 0 réactions 1 personne assignée Réclamée par @RobStallion Voir sur GitHub
discuss question technical
Langage dominant
Elixir
Étoiles
33
Forks
3
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

Why do we store our issue data as JSON in S3?

What are the pros/cons of storing this kind of data in S3 over our own sql database?
e.g.
- is it faster to load data
- is it cheaper
- does it take up less space as a json file on S3 than as a string in postgres. If so could storing the data as a binary help? (see quotes below)

quotes from https://github.com/dwyl/phoenix-ecto-encryption-example
> The reason we are creating the encrypted/hashed fields as :binary is that the data stored in them will be encrypted and :binary is the most efficient Ecto/SQL data type for storing encrypted data; storing it as a String would take up more bytes for the same data. i.e. wasteful without any benefit to security or performance.

> The best data type for storing encrypted data is :binary (it uses half the "space" of a :string for the same ciphertext)

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.