LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   Social media prototype web server database (sqlite or mysql) (http://www.linuxquestions.org/questions/linux-server-73/social-media-prototype-web-server-database-sqlite-or-mysql-4175424579/)

red_fire 08-29-2012 08:46 AM

Social media prototype web server database (sqlite or mysql)
 
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 :D

Thank you in advance

chrism01 08-30-2012 02:00 AM

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/

sag47 08-30-2012 10:38 AM

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.


All times are GMT -5. The time now is 09:31 PM.