Watch Django Wednesdays Ecommerce Playlist Subscribe To My RUclips Channel: bit.ly/3OBQJfN bit.ly/2IGzvOR See More At: Join My Facebook Group: Codemy.com bit.ly/2GFmOBz Learn to Code at Codemy.com Buy a Codemy T-Shirt! Take 50% off with coupon code: youtube50 bit.ly/2VC9WUN Get The Code bit.ly/47xAhWJ
Hey John! I hope you are doing well. Can I please ask for an AWS implementation of the database? Even if its just hooking it up and doing basic things with it. I just really love AWS and use it for other projects and I'd like to be able to follow along with your tutorials and knowing how you do the things on railway, but I do it on AWS? (even if it is just a random side-video completely outside of the series)
Even when I delete orders from the Django Admin payment>Orders area, the order numbers do not reset. For example, if I had 10 orders previously, then deleted all of them and created a new order after filling out the form, it assigns the new order number as 'Order - 11' instead of 'Order - 1'. How can I reset this issue?
You don't. That's not how databases work, and that's not how you would want it to work. Otherwise many people could have the same order number, and you don't want that.
where are the videos to finish this project ? I have finished video 43 and I thought that there would be more, such as the payment system and launching the site from github.
Hello I am Abhi from India and I watch your videos because I get to learn a lot from them. You made a video on deploy. I have many projects which are ready for deployment and there are many videos also but I am not able to understand their content.
I'm having an issue that i cannot find a solution. conn = _connect(dsn, connection_factory=connection_factory, **kwasync) django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: nodename nor servname provided, or not known i'm on a macbook air m2 i'm from brazil i tried running pg_isready, and i get 'accepting connections', however when i type in the host, i get 'no response' please help thank you
hi sir !! heroku free hosting isnt available anymore can you please point me towards something similar which I can use to deploy my project online and just get a website link ??
Hello John, I followed along and set up my code as provided by you. But I am encountering an error repeatedly. I looked for answers in the railway community, but in vain. I tried using LLMs and also tried connecting pgAdmin, but always got an error. The terminal shows this error - "django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known." Please let me know if you are aware of any solutions. Thank You
@@Codemycom Hey John, I was able to migrate. PGHOST always shows error. And in my effort to solve the issue, I encountered that a lot of users have been facing the issue. What worked for me is - Settings section provides the Public Networking option to connect with TCP using a proxied domain and port. Hope I should share. If you feel like pinning this comment might help others, please feel free to do so. Thank You.
@@Gabriel-ql7eb use the proxy port: should be 5 numbers long. Format is likely - viaduct.blah.raikways.blah:52368. Check it, and you will get it in few trys.
I am having this stupid eror and ı couln't find any solution yet! So ı write here as well. if anybody knows how to fix this error. please help me out UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xf6 in position 79: invalid start byte I checked any explanation but none works and again thank you for the course sir!!
I have been dealing with this for more than a day now and still persists. I couldn't find more or understand why. So by all means if anybody knows. Reach out!
@@Codemycom I trust your judgement John Elder. To me it matters because I'm more familiar with MySQL even though the process is the same. Postgres here I go
@@TheLummen. Yeah, django abstracts away the database layer anyway so you're not using mysql or postgres syntax...so you're right, it's all the same...
hello Sir i have used all the same steps as you but still this error . I cannot understand what is the issue this is the issue Microsoft Windows [Version 10.0.19045.4717] (c) Microsoft Corporation. All rights reserved. D:\Backend Development\Django Ecommerce\Practical\Ecommerce>python manage.py runserver Watching for file changes with StatReloader Performing system checks... System check identified no issues (0 silenced). Exception in thread django-main-thread: Traceback (most recent call last): File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 275, in ensure_connection self.connect() File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 256, in connect self.connection = self.get_new_connection(conn_params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\postgresql\base.py", line 277, in get_new_connection connection = self.Database.connect(**conn_params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\psycopg2\__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ psycopg2.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\threading.py", line 1073, in _bootstrap_inner self.run() File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\threading.py", line 1010, in run self._target(*self._args, **self._kwargs) File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\autoreload.py", line 64, in wrapper fn(*args, **kwargs) File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management\commands unserver.py", line 136, in inner_run self.check_migrations() File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management\base.py", line 581, in check_migrations executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS]) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations\executor.py", line 18, in __init__ self.loader = MigrationLoader(self.connection) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations\loader.py", line 58, in __init__ self.build_graph() File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations\loader.py", line 235, in build_graph self.applied_migrations = recorder.applied_migrations() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations ecorder.py", line 89, in applied_migrations if self.has_table(): ^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations ecorder.py", line 63, in has_table with self.connection.cursor() as cursor: ^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 316, in cursor return self._cursor() ^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 292, in _cursor self.ensure_connection() File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 274, in ensure_connection with self.wrap_database_errors: File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\utils.py", line 91, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 275, in ensure_connection self.connect() File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 256, in connect self.connection = self.get_new_connection(conn_params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\postgresql\base.py", line 277, in get_new_connection connection = self.Database.connect(**conn_params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\psycopg2\__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known. however my host variable is same as on railway . I have used exact steps plus exact copied data from railway app
hi John, I'm David from Nigeria, just wanted to thank you for giving these courses for free, I've really learned a lot from them, I just wanted your help with this error that keeps happening, by the way, I've rewatched the video like 5 times so it's not from me, I keep getting this error "django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known", I have gone online to see how to solve it but got nothing, so can you find out what's wrong and get back, thank you.
Watch Django Wednesdays Ecommerce Playlist Subscribe To My RUclips Channel:
bit.ly/3OBQJfN bit.ly/2IGzvOR
See More At: Join My Facebook Group:
Codemy.com bit.ly/2GFmOBz
Learn to Code at Codemy.com Buy a Codemy T-Shirt!
Take 50% off with coupon code: youtube50 bit.ly/2VC9WUN
Get The Code
bit.ly/47xAhWJ
You, my friend, are the best...thank you for the teachings!
Glad you like them!
The best Python-Django Tutorial ever seen, thank u so much!!!!!!
Wow, thanks!
awesome tutorial - thank you so much! will you be doing any stripe implementation?
Yes, soon
Éxitos tengo tiempo viendo te Saludos desde República Dominicana, Casi 2 años de experiencia como Dev
Happy to hear it!
Hey John!
I hope you are doing well.
Can I please ask for an AWS implementation of the database? Even if its just hooking it up and doing basic things with it.
I just really love AWS and use it for other projects and I'd like to be able to follow along with your tutorials and knowing how you do the things on railway, but I do it on AWS?
(even if it is just a random side-video completely outside of the series)
sorta doubt I'll do aws
Thank you sir for the teaching
You are welcome
Thank you a lot, this is very helpful !
Glad to hear it!
@@Codemycom something else, i want to ask if there is a way to get codemy courses for free ?
Even when I delete orders from the Django Admin payment>Orders area, the order numbers do not reset. For example, if I had 10 orders previously, then deleted all of them and created a new order after filling out the form, it assigns the new order number as 'Order - 11' instead of 'Order - 1'. How can I reset this issue?
You don't. That's not how databases work, and that's not how you would want it to work. Otherwise many people could have the same order number, and you don't want that.
@@Codemycom Yeah right, Thanks.
thanks a lot my teacher
You are very welcome
where are the videos to finish this project ? I have finished video 43 and I thought that there would be more, such as the payment system and launching the site from github.
This is an ongoing playlist, new videos come out every Wednesday...hence the name Django Wednesdays.
Hello I am Abhi from India and I watch your videos because I get to learn a lot from them. You made a video on deploy. I have many projects which are ready for deployment and there are many videos also but I am not able to understand their content.
We'll begin deploying the site in the next video
Lovely man
Thanks
I'm having an issue that i cannot find a solution.
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: nodename nor servname provided, or not known
i'm on a macbook air m2
i'm from brazil
i tried running pg_isready, and i get 'accepting connections', however when i type in the host, i get 'no response'
please help
thank you
Rewatch the video, follow the steps again, discover what you did differently from the video...
Can I use MySQL instead of Postgres in this course ?
You can use anything you want anytime you want
hi sir !!
heroku free hosting isnt available anymore can you please point me towards something similar which I can use to deploy my project online and just get a website link ??
That's what this video is beginning to do... Railway.
@@Codemycom eagerly waiting for next wednesday!! Thnak you for this series!
@@Codemycom Is it for free ?
Sir, do i understand correctly that we're doing this to make the website accessible online to anyone?
yes
Hello John, I followed along and set up my code as provided by you. But I am encountering an error repeatedly. I looked for answers in the railway community, but in vain. I tried using LLMs and also tried connecting pgAdmin, but always got an error.
The terminal shows this error - "django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known." Please let me know if you are aware of any solutions.
Thank You
that URL is not a valid hostname. Contact railway support. (postgres.railway.internal should be an actual URL like in my video)
@@Codemycom Thank You John ♥️
@@Codemycom Hey John, I was able to migrate. PGHOST always shows error. And in my effort to solve the issue, I encountered that a lot of users have been facing the issue. What worked for me is - Settings section provides the Public Networking option to connect with TCP using a proxied domain and port.
Hope I should share. If you feel like pinning this comment might help others, please feel free to do so.
Thank You.
@@rajbhatta5595 hi, i found that section in settings, but i didn't understand how to use it. Can you explain more detailed please
@@Gabriel-ql7eb use the proxy port: should be 5 numbers long. Format is likely - viaduct.blah.raikways.blah:52368. Check it, and you will get it in few trys.
thank you john and The site is slow before add postegres
that's a matter of your own computer speed since the original database ran on your computer not the cloud where postgres runs...
python decouple can be used instead?
only one way to find out
Please make a problem solving playlist!!
I don't know what that is
I am having this stupid eror and ı couln't find any solution yet! So ı write here as well. if anybody knows how to fix this error. please help me out
UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xf6 in position 79: invalid start byte
I checked any explanation but none works and again thank you for the course sir!!
if anybody knows what is the issiue please ı will be checking. or ı will lose it :):)
I have been dealing with this for more than a day now and still persists. I couldn't find more or understand why. So by all means if anybody knows. Reach out!
Oh no ! What happened to MySQL ? Happy to see the content though
MySQL isn't as good as Postgres for production level websites. But also....what does it matter?
@@Codemycom I trust your judgement John Elder.
To me it matters because I'm more familiar with MySQL even though the process is the same. Postgres here I go
@@TheLummen. Yeah, django abstracts away the database layer anyway so you're not using mysql or postgres syntax...so you're right, it's all the same...
"Oh let's use AWS " ... ! And the doors to hell opened ! It's an arduous process to say the least !
yeah lol it's a hassle
please can you add videos about django multi tenant?
No that's not really applicable here
hello Sir i have used all the same steps as you but still this error . I cannot understand what is the issue this is the issue
Microsoft Windows [Version 10.0.19045.4717]
(c) Microsoft Corporation. All rights reserved.
D:\Backend Development\Django Ecommerce\Practical\Ecommerce>python manage.py runserver
Watching for file changes with StatReloader
Performing system checks...
System check identified no issues (0 silenced).
Exception in thread django-main-thread:
Traceback (most recent call last):
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 275, in ensure_connection
self.connect()
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 256, in connect
self.connection = self.get_new_connection(conn_params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\postgresql\base.py", line 277, in get_new_connection
connection = self.Database.connect(**conn_params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\psycopg2\__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\threading.py", line 1073, in _bootstrap_inner
self.run()
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\autoreload.py", line 64, in wrapper
fn(*args, **kwargs)
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management\commands
unserver.py", line 136, in inner_run
self.check_migrations()
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\core\management\base.py", line 581, in check_migrations
executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations\executor.py", line 18, in __init__
self.loader = MigrationLoader(self.connection)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations\loader.py", line 58, in __init__
self.build_graph()
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations\loader.py", line 235, in build_graph
self.applied_migrations = recorder.applied_migrations()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations
ecorder.py", line 89, in applied_migrations
if self.has_table():
^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\migrations
ecorder.py", line 63, in has_table
with self.connection.cursor() as cursor:
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 316, in cursor
return self._cursor()
^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 292, in _cursor
self.ensure_connection()
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 274, in ensure_connection
with self.wrap_database_errors:
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 275, in ensure_connection
self.connect()
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\base\base.py", line 256, in connect
self.connection = self.get_new_connection(conn_params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\backends\postgresql\base.py", line 277, in get_new_connection
connection = self.Database.connect(**conn_params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\hp\AppData\Local\Programs\Python\Python312\Lib\site-packages\psycopg2\__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known.
however my host variable is same as on railway . I have used exact steps plus exact copied data from railway app
you have the wrong pg url
hi John,
I'm David from Nigeria,
just wanted to thank you for giving these courses for free, I've really learned a lot from them,
I just wanted your help with this error that keeps happening,
by the way, I've rewatched the video like 5 times so it's not from me,
I keep getting this error "django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: No such host is known",
I have gone online to see how to solve it but got nothing,
so can you find out what's wrong and get back,
thank you.
contact railway support
have you solve this? because i alse face the same problem...
awesome tutorial - thank you so much! will you be doing any stripe implementation?
Yes, soon