As I am Carrying out a project to Design Social Networking Databases, I need 5 tables for designing it.My frontend being php and backend being Mysql.I need to know what are the 5 tables I can have and how to implement them.
View 4 RepliesSelf learner developer since about 2 years, I'm trying to understand deeper how to design a database in the best and most efficient way possible.Reading about UML design, I've found this: Do not automatically add ID numbers(surrogate keys) or substitute keys to a table until you are sure that:
-There is at least one candidate key (before the surrogate is added),
-the table is a parent in at least one association, and
-there is no candidate key small enough for its values to be copied many times into the child table.
Until then, I've always did this (I mean using ID) to identify my rows.So my questions are:
1. Why should we avoid using ID to identify rows?
2. Candidate keys add some weight to our database, and this can huge if we have millions of records, so why should we use these over surrogate keys?
I'm a full-time developer in my day-job, I get paid real money for it and everything! Nowadays I generally write web-based business apps using VB.net and ASPX.net, but I'v recently been asked to come up with a social networking type site (something in-between Facebook and twitter) that will initially be used for training purposes... don't ask or I'll have to send the men in the dodgie overcoats round
Problem is, it is to be written like real social-networking site, I've no idea what I'm going to make it look like and was, more fundamentally, wondering what to write it in?I've written commercial systems using Perl, PHP, ASP and the .net (VB and C) stuff.
Perhaps this is not the best place to ask, however, I have not had any luck finding answers elsewhere and I know the someone here knows the answer.In a nutshell, I am looking to purge information which I do not want retained (for privacy reasons) from the various database files used by Firefox. Using the available preference settings I have configured Firefox to clear everything on quit except for:
Saved Passwords
Site Preferences
Browsing History
I have no concern with the first two categories. It is the third one which I wish to fine tune beyond what I can do within the Firefox app. I wish to keep those sites which I have typed in so that they can be accessed by the Old Location Bar add-in - so that when I enter "li" in the address bar I am directed to linuxquestions.org. However, I do not want the data stored which allows Firefox to display previously visited links in a different color (and probably more data as I dig further).
So my plan would be to build some scripts to remove the offending data from the applicable sqlite databases (places.sqlite in the case of browsing history) by brute force. As mozilla.org does not expect users to do this they do not seem to have any documentation readily available describing the layout and use of the databases behind Firefox.So my question is... can someone point me to a source of the documentation I am seeking?
I am not clear as how to put my question but what I am looking at is some tool which has a GUI to be able to design a databases and also once the database is done it should be working.Some thing like drag and drop interface for a database.As an example I can write a query on mysql command prompt or phpmyadmin to create table its fields etc.Can I use some thing which does not involve mysql command line?What should I search for?I know very well how to work with mysql command prompt I need a GUI tool for the same to some non technical users.
View 1 Replies View RelatedI want to design an audio chat programming in Ubuntu.So how shall I proceed? Any help on this please?I am complete novice in this topic. Currently my aim is to capture audio from microphone.
View 1 Replies View RelatedI'm working with computers that need to be public, so I'm trying to remove the social networking from 10.04.Unfortunately, this means that the "Indicator Applet" needs to go.The Indicator applet, holds the volume control.Is there anyway to add volume back to the panel after I remove the Indicator Applet?
View 5 Replies View RelatedI have a Debian server running at the gateway level on a LAN. This runs squid for creating block lists of websites - for eg. blocking social networking on the LAN. Also uses iptables.
I am able to do a lot of things with squid & iptables, but a few things seem difficult to achieve.
1) If I block http://www.facebook.com, people can still access https://www.facebook.com because squid doesn't go through https traffic by default. However, if the users set the gateway IP address as proxy on their web browser, then https is also blocked. So I can do one thing - using iptables drop all outgoing 443 traffic, so that people are forced to set proxy on their browser in order to browse any HTTPS traffic. However, is there a better solution for this.
2) As the number of blocked urls increase in squid, I am planning to integrate squidguard. However, the good squidguard lists are not free for commercial use. Anyone knows of a good squidguard list which is free.
3) Block yahoo messenger, gtalk etc. There are so many ports on which these Instant Messenger softwares work. You need to drop lots of outgoing ports in iptables. However, new ports get added, so you have to keep adding them. And even if your list of ports is current, people can still use the web version of gtalk etc.
4) Blocking P2P. Haven't been able to figure out how to do this till now.
what the best free linux graphic design interface was? Possibly one from the ubuntu one software center. I tried boa constructor and it was glitchy and kept crashing. I want something very easy to use and as simple as possible as i am new to programming. I want something that also supports the major programming languages like python C++, etc and was also wondering where i could go to learn codes for python.
View 4 Replies View RelatedI am designing a KEDB (Known Error Database) which I am currently maintaining with MS-Excel. I want to develop a Web Application to accomplish this task in a more convenient and effective way. Well, you guess, the client should be happy to see how we provide support more effectively...? I want to make it ITIL-Compliant. I (optionally) want to provide the Problem and Change Management facilities within it in a way that the concerned teams and the management can find the KEDB very useful for their work also. I am going to do it entirely in PHP and JavaScript for client-side validations wherever needed.
View 3 Replies View Relatedim interested in improving my web designing. ive been trying to learn ajax and flash completed a couple tutorials and i was thinking about starting a project. the goal of the project is to make a banner on top of a webpage that basicly is a slide show of thumbnails. but at the same time when u click on the image that flashes by it send you to the page where u can buy a print of the image. when you hover over the banner it stops. and is all contained in its own box. i did try to use a banner slide show box b4 but it didnt do everything i wannted and at the same time it expanding the length of the webpage as it scrolled the top.i was wondering how i might get the tools and knowlege i need to acomplish my goal.
View 3 Replies View RelatedIs there anything that Windows can and GNU/Linux can't in Web programming and design?
View 10 Replies View RelatedI am having trouble accessing social networking sites like orkut due to govt restriction.
View 1 Replies View RelatedI want to learn how to create computer software/programs. I want to be able to design them to be cross platform (Win32, OSX, Linux). I was wondering if anyone knows what kind of courses I need to take for this? And would it be possible to study by myself and learn it for free?
View 13 Replies View RelatedSo a friend and I are new-ish to linux (I am reasonably comfortable with basic /etc text editing, command admin). We are, however, completely new to programming and (x)html. We have a few (what we think are) interesting ideas for dynamic websites.Ideally we would like to develop our own course of study to get to the point where we have a basic understanding of programming so that our adventures in the programming of a dynamic website would be possible. Much of what we need learn to do is the following: use daily updated public-domain data from several other sites, manipulate that data algorithmically, which would then yield updating output on our site. Here is what I would like to do:
1. learn the basics of programming with a language that would teach good code habits and fundamental understanding.
2. become comfortable with (x)html
3. learn another language for the extension of (x)html into a dynamic data-heavy website.
Question could you please suggest a way about going about 1>2>3?Ideally the language of (1) would be something that would not be "wasted" just on web design etc. As a language, C really appeals to me. However, if learning this wouldn't lend itself to being helpful in learning another language for webdesign maybe I shouldn't use it(?).If (1) weren't to be C, what language would be funadmental enough to teach good coding but also be helpful in learning (3)
know abt daemon process and how it is used for acting as proxy server if nay tutorial is there for it .
View 3 Replies View RelatedI want to restrict some site (Social Networking) through my newly configured squid proxy. But It always allow those site How to block those site. My squid.conf file is configured as follow :-
#Recommended minimum configuration:
acl all src all
acl manager proto cache_object
acl localhost src 127.0.0.1/32
acl to_localhost dst 127.0.0.0/8 0.0.0.0/32
[coder].....
I do not know much at all when it comes to setting up hardware--servers, switches, etc.
I have a 1701HG 2Wire wireless router that I use for my home network. I have an old pentium 3 tower that is just laying around, and I want to be able to host my projects on it for testing. Basically, I just want to be able to do everything on my laptop and then upload it to the server for testing.
I have set up an Ubuntu LAMP server on the desktop and am able to do everything I want via SFTP; however, I want to be able to type in "projectx.local" in a browser on my laptop to go to one test site, "projectz.local" to go to another, etc.
Is this possible, since I do not have the server set up as my gateway? It is merely connected to the router like everything else.
How to design secure fault tolerant network (routers, firewall, domain servers, etc) of 300 wireless computers separated in multiple buildings and floor with multiple users for each station mainly utilizing dtp and internet software?
View 1 Replies View RelatedI recently "saw the light" and realized that ubuntu was becoming a buggy overly-social joke of a distro, and i found that fedora seemed to fix most of my issues with making my laptop run well.Samba was not one of them.Anyway, I installed samba, check. (I also installed the graphical utility). I checked off samba and the client in the firewall. check. I used the utility (system-config-samba?) to switch the workgroup over. check.it did not want to access my fileserver at first; it saw it but as soon as i tried to mount and open it, it timedout and gave me the "unable to mount location" "Failed to retrieve share list from server" error. the next day it worked perfectly. now it is back to not working. it also is not working on my main rig (but it has a faulty hard disk so it will be out for a while).
View 5 Replies View RelatedI am currently working on a volunteer project to build a socializing community site for several affiliated religious communities. All the basic things like, a shared calendar, blogging, email, any suggestions?
View 1 Replies View RelatedI've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
What database can I use for c++?,this is my first week programming in c++.
View 14 Replies View Relatedsql statement. I am trying to check if there is such a value in the database.
Code:
string NewMovie = "ww";
string queryText ;
queryText = "Select * from movie_info WHERE movie_title = '"+ NewTitle +"'";
MYSQL *conn;
conn=mysql_init(NULL);
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
[Code]......
return 0; The problem i am facing is how do i check if the value is found. I read up and found that a query will return a value of TRUE if the query is a success and a FAIL if there is an error. How do i call these values and then based the check on it?
How to create a database using c language it includes structures, pointers, arrays and switch..
View 4 Replies View RelatedI have a php scriptI want it to ping list of ips from a databse(using fping) and based on the status of the values to put them in a field(status) into the database(0 if down,1 if up)i executed tghe script and it gives me this error:Thread 1 - 17:51:01 26-04-2011 4.2.2.2 alive Couldn't execute query.I cant see what 's wrongthis is the source of the php script:
<?php
require_once("conf.php");
$connection1 = mysql_connect($h, $u, $p) or die("Couldn't connect.");
[code]....
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
How to shorten the long URL without using database(i.e. without storing url entries in DB)?
View 2 Replies View RelatedI am trying to unload file from a database. Which contains few lines with the character below. Rest of the data was unloaded appropriately.
Code:
a) What does this below character means?
b) How can i remove it,
I already have
Code:
sed '/^$/d'
c) Will this effect the file by any means (If I am guessing properly, this is the eof notation)
i get some trouble setting up good environment in linux.i have problem regarding connecting php(under linux) to a sybase server(under windows)is there anyway connecting this two technologies?.
View 1 Replies View Related