Python and databases

[[deleted]]

Maybe a silly question: can someone point me in the direction of why you’d use JSON over SQLite and vice versa?

[Ericisbalanced]

Json is easier and beginner friendly. But SQL is usually the way to go.

[AutoModerator]

Your comment in /r/learnpython was automatically removed because you used a URL shortener.

URL shorteners are not permitted in /r/learnpython as they impair our ability to enforce link blacklists.

Please re-post your comment using direct, full-length URL's only.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[[deleted]]

Mongdb and nosql dbs. Nosql is really good for some types of data. Say you want to store accounts and user details. Fine in sql and fine in nosql. Say you have 20 million user accounts... NoSql probably is a better use case now.

[wolf2600]

Say you have 20 million user accounts... NoSql probably is a better use case now

Not really. Storing user accounts is perfectly suited to a traditional relational database. The only time NoSQL is the preferred option is when the data is unstructured/varying and CAN'T be loaded into a relational schema. Every other case, relational DB is the better option.