dwyl / dwyl/github-backup

Why do we store the issue data in s3

Abierto
#126 1 comentario 0 reacciones 1 asignado Reclamado por @RobStallion Ver en GitHub
discuss question technical
Lenguaje dominante
Elixir
Estrellas
33
Forks
3
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

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)

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.