LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

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

Rep: Reputation: 8
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

Thank you in advance
 
Old 08-30-2012, 02:00 AM   #2
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,311

Rep: Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040
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/
 
Old 08-30-2012, 10:38 AM   #3
sag47
Senior Member
 
Registered: Sep 2009
Location: Philly, PA
Distribution: Kubuntu x64, RHEL, Fedora Core, FreeBSD, Windows x64
Posts: 1,503
Blog Entries: 35

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


Reply


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


All times are GMT -5. The time now is 08:43 AM.

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