The most suitable database with Django

In the name of God

hi .
what is the best database to work with django?

I’ve always felt that Django has best support for PostgreSQL. The other well supported options are MySQL or sqlite. My opinions may change depending on your use case though.

There is no single “best” - it really depends upon your application and environment. If you have existing data being used, or other systems using (or wanting to use) your data, that’s going to affect your decision.

The size and type of your site can affect your decision as well. I’ve got a dozen or so small sites (2 users) for which sqllite is the right answer. I’ve got a couple of larger sites where I use PostgreSQL. I’ve got one site needing to share data with a different system using MariaDB. They all work well. They all do exactly what they need to do. It’s not that one is in any way better than any of the others - it’s that they’re the right choice for their specific deployment.

Thank you for your answer
I understood you completely
But I want to know a suitable that is good for both small and large projects or data
Can you suggest me the best one in this case ?

They’re all suitable. There is no “best” one in the absence of the context in which it’s going to be used. (The deployment environment, the number of users, the activity level, integration with other data and data sources, etc, etc, etc.)

The main point is that Django shields you from the fundamental differences between the databases - for 99+% of the applications likely to be written, it’s not going to matter to Django what database you use.

1 Like

Thank you for the time you spent to answer me .
Excuse me are you satisfied of django as you are working 6 years with that ?
Kind regards

Absolutely! I’ve taken the last two jobs I’ve had, specifically so that I could work with Django.

Python, as a language, resonates more with me than any other language with which I’ve worked for any period of time. And Django has been the most complete and flexible-for-my-needs Python framework that I have found. (There are other frameworks that provide more options in different areas, but none of those area of flexibility that they provide are of any real value to me.)

1 Like

OK . That is great .
But in your mind , is Nasa website in Django or in PHP ?
Because I have used Wappalyzer extention for chrome in Nasa and it told Nasa is in PHP
Which are you agree with ?

I’ve worked with too many frameworks and systems to care about what other organizations choose to use. What organization XYZ has selected for their systems doesn’t affect me in the least.

The point is that the technologies are generally so mature and reliable that it doesn’t really matter what you pick. There are factors beyond the technical issues that should drive decisions like this.

I understand and “get” the desire to make the right choices. However, this is a situation where there is no “wrong” choice - just a sub-optimal choice for a given situation.

Look past the “language X vs language Y” (or database A vs database B) debates. Examine the total environment in which the system is going to be used and make your decisions based on a complete picture.

1 Like

Hi dear Mr.Whitesell
Good time
Excuse me I have checked the question that people asks in this website and understood that you are really expert and experienced due to the answers that you gave people .
Dear Mr.Whitesell , if it is possible I want to give me a peice of advice .
I like python very much because I can code in the fields of programming that I want and I have just started to learn django .
But due to my short time and you are expert , is it possible to suggest me a complete and free django tutorial to learn most of the things in django and then I can make a high level and good CMS project with spending an enough time for learning it ?
I will thank if you introduce me your learning resource for django when you was learning .
Kind regards

I am not aware of any tutorials that are both “complete” and “free”. There’s a lot to Django, and the time and effort that it would take to make and maintain such a complete tutorial is a level of work that would deserve to be compensated.

I do always recommend both the Official Django Tutorial and the Django Girls Tutorial. Between the two of them, there’s enough there to get you started. If you’re looking for something in the area of CMSs, you might want to check out both Wagtail and DjangoCMS. (There are others as well - see the DjangoPackages grid for some more ideas.)

My primary learning resource beyond the official Django tutorial were my two co-workers about 7 years ago. I had the good fortune of getting a job as a Django developer with no real Django experience. (I did have about 15 years of Python experience and years of experience with other web frameworks, both Python based and otherwise, so it’s not like I was new to the technology and principles.)

And while I appreciate your kind remarks, I’m definitely not a Django expert - I’d classify myself as an intermediate level. There are many parts of Django that I still have to treat as a “black box” and there are some things I do only because I’ve been told that’s how I should do them. There are a number of people on here with far more knowledge and experience than me. (I just happen to have the luxury of time to be able to answer questions.)

1 Like

Thank you Mr .Whitesell
But when I finished django official tutorial is it good to continue my learning from its documentation or its better to making projects by myself and try other tutorials on the internet?

That’s a personal decision - it’s a question of how you best learn new material. I wouldn’t suggest just reading the documentation - at least not by itself. You do want to keep practicing techniques and working with code - whether you want to do that by working on a personal project or through a more formal tutorial is up to you.
However, what I would suggest is that you take time to read through the docs as well. No tutorial is going to expose all features available to you, so there’s some value in reading through the docs to see what’s in there, even if you don’t understand most of it yet or can find use for some features. It’s good just to be aware that there are some things there that when you recognize the need, you know it exists.

1 Like

Hi Dear Mr. Whitesell , I hope you are fine .

I have asked this question about a month ago and as that time I researched and found a perfect django tutorial in youtube called trydjango .

Right now I am in the introductory part of my learning journey of django and I really like django and I am learning that very well .

I want to thank you for your previous answers and I want to give a piece of advice from you if it is possible .

Dear Mr .Whitesell I will thank you if you give me a guidance because as you explained before you have its experience .

Dear Mr .Whitesell , I want to know that how can I get a job or an intership job of django in USA or UK with my knowledge now ?

Thanks .

Kind Regards .

I’m sorry, I don’t have any real advice to give in that area, and absolutely no experience outside the US. My jobs were all found the old-fashioned way - find every company looking for programmers, fill out applications and submit with my resume. That translated into spending a lot of time digging through websites, talking to recruiters and placement firms, and in general making it known that I was looking for a job.

What I didn’t mention in that paragraph was that I wasn’t specifically looking for a Django position - I also had (different) resumes out highlighting my Java, C# / .Net, database, and Linux system administration experience. (I think I had two or three other interviews before taking that job, but I did prefer a Python-oriented role over any of the others.)

So the only advice I would have to share is that it doesn’t hurt to send out applications and resumes - and keep in mind that you may need to send out a lot of them.

Ok thank you very much