knowledge of postgresql

Currently, I am learning Django. My aim is to create a journal management site. Is it necessary to become proficient in SQL database using PostgreSQL?
Thanks

1 Like

It depends.

It is beneficial to have some knowledge of SQL, at least to the extent of fairly predicting what Django may do. I expect a Journal management site to be fairly challenging. PostgreSQL is one of other viable SQL database engines. It is not likely that you will interact directly with the engine on a regular basis if your Django is good.

However, a fair knowledge of SQL can help steer Django is specific ways. I therefore suggest that you focus on Django until it becomes necessary to dive deeper into SQL engines.

1 Like

Welcome @jpour !

Adding to the above, you will need some degree of knowledge of PostgreSQL. At a minimum, you’ll need to know how to create users and databases, and possibly granting permissions. You’re likely going to need to learn other database administrative skills such as handling backups and restores, or configuring for non-localhost access, or other sysadmin type tasks.

2 Likes