Hello,
i'm not sure with if posted in the right section, but anyways..

I need to develop a social media prototype for uni work
and I got a web server which I've been assigned to and I can ssh into.

I've played around a bit in the shell and it seems that i can use
python, mysql and sqlite

I'm interested in developing the database using sqlite
(if possible and preferred because i want to learn it, if not possible mysql would be fine)
But I'm not sure how to bind it with html and

secondly, i have zero experience in actually developing a database
although i know how to design it. So i'd like to know where to start. .

*i''m fairly fluent with python if it's needed
and i'm actually keen on learning bash as well

Thank you in advance

Well you're going to need to know the cli eg use bash, so
http://rute.2038bug.com/index.html.gz
http://tldp.org/LDP/Bash-Beginners-G...tml/index.html
http://www.tldp.org/LDP/abs/html/

I don't know about sqlite but if we're talking about a "social media" prototype then I would recommend MySQL because of scalability.

Connecting to a database requires a server side language more robust than pure HTML. So we're talking Python, PHP, Perl, Ruby, or any other language of choice with a decent web framework that generates W3C standard HTML.

One advantage to using PHP is you can use a client development platform such as XAMPP to develop your application on any local machine without much hassle in setup and deploy when you're ready. However, if you're going to develop in PHP use a framework! It is very easy for you to be extremely insecure using PHP to develop if you aren't used to best practices.

Another recommendation is to avoid using phpMyAdmin and webmin to manage your MySQL. As a sysadmin I can't tell you the number of times I've seen in attack logs that the perpetrators attempted to access utilities at those URLs (they aren't installed on my machines) as a possible infiltration point.

Google around for tutorials on developing websites in the different languages. There's many tutorials out there for any language.

The tools that you need to know about first are HTML and CSS. You can use these two languages together in order create a site’s design, which will then be compiled into JavaScript or anything else needed for your application's functionality (depending on what kind of program it was designed primarily as). Next up would probably come Python if we're going down the path where database access is desired - but not necessary at all! Thank you so much!!!

Your answer does not really apply to the question asked, except for containinf some of the same keywords.
The thread is 10 years old.
There was no reason to resurrect it.
No offense, but are you a real person or a spambot?