dwyl / dwyl/github-backup

Why do we store the issue data in s3

Aperta
#126 1 commento 0 reazioni 1 assegnatario Rivendicata da @RobStallion Vedi su GitHub
discuss question technical
Lingua principale
Elixir
Stelle
33
Fork
3
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

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)

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.