Python Forum

Full Version: Django- which database i should use? with best speed and performance!!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hello

which database i should use for python for create web application??
a database with best speed an performance !!

i use windows 10 .. and IDE Visual studio Code

i want a database for python Which is not necessary to change it later to another database

i always work with SQL server in C#.. but now i trying to create a web application with Python . it is my First application but i never use MySQL or postgres in my application

!!!! another question : is visual studio best IDE for Python??


thanks for helps
(Dec-10-2018, 06:32 AM)ma_norouzifar Wrote: [ -> ]hello which database i should use for python for create web application?? a database with best speed an performance !! i use windows 10 .. and IDE Visual studio Code i want a database for python Which is not necessary to change it later to another database i always work with SQL server in C#.. but now i trying to create a web application with Python . it is my First application but i never use MySQL or postgres in my application !!!! another question : is visual studio best IDE for Python?? thanks for helps

If it is your first first application you shouldn't worry much about speed
as speed becomes important when you have thousands of users active at the same time.

You can use any database you know there is no problem.
You just need to change backend in settings.py of your Django project to preferred database.

Sqlite is built into python but has some limitations and it is used as default by Django.
Sqlite is simple like for creating a database you have to edit modely.py file like

from django.db import models
class User(models.Model):
first_name = models.CharField(max_length=50)

You can connect it to Visual Studio
https://dev.mysql.com/doc/visual-studio/...ction.html

You can connect Mysql databse from c#
VS is a good ide for django development with some python plugins.

You use Pycharm for Django Development but the free version has no support for Django.
I recommend to stick with the IDE you use because if you will choose a new IDE you will need some time to get familiar with that IDE which will waste your time.
No IDE is good or bad unless you know how to use them(exceptions are always there Smile ).

https://www.mysql.com/products/workbench/
(Dec-10-2018, 08:10 AM)amiy Wrote: [ -> ]
(Dec-10-2018, 06:32 AM)ma_norouzifar Wrote: [ -> ]hello which database i should use for python for create web application?? a database with best speed an performance !! i use windows 10 .. and IDE Visual studio Code i want a database for python Which is not necessary to change it later to another database i always work with SQL server in C#.. but now i trying to create a web application with Python . it is my First application but i never use MySQL or postgres in my application !!!! another question : is visual studio best IDE for Python?? thanks for helps

If it is your first first application you shouldn't worry much about speed
as speed becomes important when you have thousands of users active at the same time.

You can use any database you know there is no problem.
You just need to change backend in settings.py of your Django project to preferred database.

Sqlite is built into python but has some limitations and it is used as default by Django.
Sqlite is simple like for creating a database you have to edit modely.py file like

from django.db import models
class User(models.Model):
first_name = models.CharField(max_length=50)

You can connect it to Visual Studio
https://dev.mysql.com/doc/visual-studio/...ction.html

You can connect Mysql databse from c#
VS is a good ide for django development with some python plugins.

You use Pycharm for Django Development but the free version has no support for Django.
I recommend to stick with the IDE you use because if you will choose a new IDE you will need some time to get familiar with that IDE which will waste your time.
No IDE is good or bad unless you know how to use them(exceptions are always there Smile ).

https://www.mysql.com/products/workbench/


tanks for answer but what do you think about postgreSQl in Ranking Ranking postgreSQl become favorite very very Fast
Quote:what do you think about postgreSQl in Ranking Ranking postgreSQl become favorite very very Fast
All the databases listed at the top of this list are excellent. I guess you can safely pick any of them.
(Dec-10-2018, 08:59 AM)Gribouillis Wrote: [ -> ]
Quote:what do you think about postgreSQl in Ranking Ranking postgreSQl become favorite very very Fast
All the databases listed at the top of this list are excellent. I guess you can safely pick any of them.
yes all of them is good but is for me hard to select one of them .. i search in google and see most of them choice postgresql ... and now i want to select one of them and work on it for always .. because when i focus on one of them i find syntax .. error ... bugs .. and can find solution for them and become strong on that database