Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 08-29-2012, 08:46 AM   #1
Registered: Jan 2007
Location: Indonesia
Distribution: Slackware Linux
Posts: 67

Rep: Reputation: 10
Social media prototype web server database (sqlite or mysql)

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
Old 08-30-2012, 02:00 AM   #2
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,411

Rep: Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397
Well you're going to need to know the cli eg use bash, so
Old 08-30-2012, 10:38 AM   #3
Senior Member
Registered: Sep 2009
Location: Orange County, CA
Distribution: Kubuntu x64, Raspbian, CentOS
Posts: 1,850
Blog Entries: 36

Rep: Reputation: 455Reputation: 455Reputation: 455Reputation: 455Reputation: 455
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.

Last edited by sag47; 08-30-2012 at 10:41 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLite vs MySQL on a web-site Mr. Alex Programming 4 01-20-2012 10:53 AM
LXer: Sqlite-Commander - A ncurses based tool to display the records and tables of a sqlite database LXer Syndicated Linux News 0 01-02-2011 09:11 AM
LXer: Caught Web-Handed: Social Media Become Valuable Tool in Crime-Fighting LXer Syndicated Linux News 0 03-18-2010 11:20 PM
LXer: Flock 2.5 Delivers the Promise of Social Media on the Web LXer Syndicated Linux News 0 05-27-2009 02:10 PM
How can i copt the MYSQL Database to a other server (Database) halvorls Linux - Server 3 07-27-2008 10:19 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 07:19 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration