+- Sinisterly (https://sinister.ly)
+-- Forum: Coding (https://sinister.ly/Forum-Coding)
+--- Forum: Python (https://sinister.ly/Forum-Python)
+--- Thread: Database Driven Website In Python (/Thread-Database-Driven-Website-In-Python)
Pages:
1
2
Database Driven Website In Python - sliped_disk - 11-30-2013
Hello there!
I am designing a website were the visitors to the site can add information to a database using forms. The purpose of the website is to supply prices of certain items, the prices of the items are supplied by the users of the site. Like a watchdog of prices.
I would like to give the visitor information like average price in say Australia of item X, or England of item Y. The information I would like to be made available in graphs and tables at the users choice. Over time getting a more accurate index of prices like average price per state or county then eventually cities and towns. I plan it to incorporate most countries.
I have a few questions.
Can I use Python for such a website?
What would be the first steps in building such a database?
Does anybody have any recommendations for reading
material or tutorials to get me started?
I have knowledge in HTML and CSS and have started to learn Python.
Any help would be most appreciated
RE: Database Driven Website In Python - Psycho_Coder - 11-30-2013
Yes you can by using the Django framework. But I would prefer PHP for the purpose of building Dynamic websites
RE: Database Driven Website In Python - sliped_disk - 11-30-2013
(11-30-2013, 11:50 AM)Psycho_Coder Wrote: Yes you can by using the Django framework. But I would prefer PHP for the purpose of building Dynamic websites
Thank you for the reply. Can databases and graphs be made in Django as part of the website?
Or would i need to use something like Mysql and an external graphing web app?
RE: Database Driven Website In Python - Psycho_Coder - 11-30-2013
(11-30-2013, 11:55 AM)sliped_disk Wrote:(11-30-2013, 11:50 AM)Psycho_Coder Wrote: Yes you can by using the Django framework. But I would prefer PHP for the purpose of building Dynamic websites
Thank you for the reply. Can databases and graphs be made in Django as part of the website?
Or would i need to use something like Mysql and an external graphing web app?
For database you can use any db at backend like : MySQL, PostGre etc.
If you use HTML5 then you have canvas with which you can draw objects, shapes etc. You can even draw graphs based on your requirement.
RE: Database Driven Website In Python - sliped_disk - 11-30-2013
(11-30-2013, 12:00 PM)Psycho_Coder Wrote:(11-30-2013, 11:55 AM)sliped_disk Wrote:(11-30-2013, 11:50 AM)Psycho_Coder Wrote: Yes you can by using the Django framework. But I would prefer PHP for the purpose of building Dynamic websites
Thank you for the reply. Can databases and graphs be made in Django as part of the website?
Or would i need to use something like Mysql and an external graphing web app?
For database you can use any db at backend like : MySQL, PostGre etc.
If you use HTML5 then you have canvas with which you can draw objects, shapes etc. You can even draw graphs based on your requirement.
Thank you. The graphs would have to be semi live (the info implanted by the users will be afect the graph).
Kind of like how stockmarkets are displayed.
RE: Database Driven Website In Python - The Real Slim Shady - 11-30-2013
(11-30-2013, 12:05 PM)sliped_disk Wrote: Thank you. The graphs would have to be semi live (the info implanted by the users will be afect the graph).
Kind of like how stockmarkets are displayed.
This is not a problem. When drawing the graph with HTML5/Javascript you would dynamically specify the size of the graph, bars, etc based on your needs. Just because HTML is mentioned does not mean its automatically static content.
RE: Database Driven Website In Python - sliped_disk - 11-30-2013
(11-30-2013, 12:57 PM)Geoff Wrote:(11-30-2013, 12:05 PM)sliped_disk Wrote: Thank you. The graphs would have to be semi live (the info implanted by the users will be afect the graph).
Kind of like how stockmarkets are displayed.
This is not a problem. When drawing the graph with HTML5/Javascript you would dynamically specify the size of the graph, bars, etc based on your needs. Just because HTML is mentioned does not mean its automatically static content.
Thanks. I will do some research and get some stuff done.
I am sure i will have many more questions in a weeks time.
RE: Database Driven Website In Python - upsurt - 01-10-2014
(01-10-2014, 12:49 AM)maho Wrote: Thanks!
Thanks!
15 characters " Hack this "
you should really stop it, else you might get blocked
RE: Database Driven Website In Python - maho - 01-10-2014
How to make a MySQL database and use the data from it...
RE: Database Driven Website In Python - upsurt - 01-10-2014
first, get a copy and install somewhere
=> http://dev.mysql.com/usingmysql/get_started.html
then go ahead
=> http://dev.mysql.com/tech-resources/articles/mysql_intro.html
maybe you want to have a look at MariaDB instead of MySQL