I'Ve an web app which uses dynamic db connection (connection

Question

I'Ve an web app which uses dynamic db connection (connection

fields will be filled by user on app installation)
Which way is better to store data, JSON or Sqlite ?
I'm using ASP dotnet 5 and app will work with MySql, MsSql, PostgreSql and Sqlite related to users config

0

21.12.2020

20 ответов

4 просмотра

Kazem Автор вопроса

Gian
you want to use a db to store the config to connec...

Yes exact db config with some other fields about app installation how to secure json file ?

0

21.12.2020

Gian

Kazem
Yes exact db config with some other fields about a...

secure in what way?

0

21.12.2020

Gian

!admins

0

21.12.2020

Kazem Автор вопроса

Gian
secure in what way?

plain text file is not secure

0

21.12.2020

Gian

Kazem
plain text file is not secure

how do you think things are deployed? the application needs to know the username/password to connect to the db.

0

21.12.2020

Kazem Автор вопроса

Gian
how do you think things are deployed? the applicat...

Yes but storing db pass in plain text is not so good

0

21.12.2020

Gian

Kazem
Yes but storing db pass in plain text is not so go...

you'll store it on a sqlite db then? and you think that's secure?

0

21.12.2020

Kazem Автор вопроса

Gian
you'll store it on a sqlite db then? and you think...

isn't ? i can use password on sqlite db but not on json file

0

21.12.2020

Gian

Kazem
isn't ? i can use password on sqlite db but not on...

how will your application open the sqlite db to get the other db's password? 🤔

0

21.12.2020

Kazem Автор вопроса

Gian
how will your application open the sqlite db to ge...

what ? like other databases

0

21.12.2020

Gian

Kazem
what ? like other databases

Didn't you just say you're going to store the application configuration on a sqlite db, including the password to connect to the mysql db?

0

21.12.2020

Kazem Автор вопроса

Gian
Didn't you just say you're going to store the appl...

yes

0

21.12.2020

Gian

Kazem
yes

how do you plan to open a password protected sqlite db in the first place?

0

21.12.2020

Kazem Автор вопроса

Gian
how do you plan to open a password protected sqlit...

normally

0

21.12.2020

Gian

Kazem
normally

This doesn't answer my question. how will your application know the password to the sqlite db in the first place?

0

21.12.2020

Kazem Автор вопроса

Gian
This doesn't answer my question. how will your app...

thats constant

0

21.12.2020

Gian

Kazem
thats constant

wait, what?

0

21.12.2020

Sharuzzaman Ahmat Raslan

Kazem
plain text file is not secure

https://www.vaultproject.io/

0

21.12.2020

Raptor Blue Bear

Sharuzzaman Ahmat Raslan
https://www.vaultproject.io/

The best solution

0

21.12.2020

Gian · Accepted Answer

Gian

you want to use a db to store the config to connect to another db? use a configuration file. it can be json

0

21.12.2020

Похожие чаты

I'Ve an web app which uses dynamic db connection (connection

20 ответов

Похожие вопросы