System that handles large amounts of data in an organised fashion.

learn more… | top users | synonyms

33
votes
5answers
3k views

Why aren't we supposed to use <table> in a design?

What are some clear and logical reasons for why we shouldn't be designing websites with tables? Where are the benefits, what has been driving this idea in the industry? When is it okay to use a table? ...
15
votes
6answers
492 views

How do you backup your websites?

I was just wondering how the community backs up their websites? I take a nightly dump the database and shift it across onto another server which then gets backed up onto removable media. It is ...
13
votes
6answers
4k views

Single V/s Multiple Databases

I've built this web app (php & mysql) which stores information for various organisations (about 20 clients currently). The current scenario stores client-related information in individual ...
11
votes
7answers
3k views

Should I use mysqldump or mysqlhotcopy for MySQL database backups?

I have a WordPress blog running on a MySQL database that I want to back up regularly. Would it be better to use the mysqldump program or the mysqlhotcopy script to make backups? What are the pros and ...
5
votes
4answers
346 views

What database use for huge servers?

Suppose I had a HUGE website (which I don't, but let's suppose), the common MySQL on a single server wouldn't work, because the MySQL server wouldn't be able to handle thousands of requests per second ...
4
votes
1answer
799 views

Looking for free, specific Ip2Location Database

I am searching for a free db (like an updated XML or CSV file) that relates IP addresses to specific locations. I want more information than just the country. I want some sort of region or city ...
4
votes
4answers
715 views

How do I Choose a Technology Stack For My Site? [closed]

There are a lot of different, competing, technologies to build a site with. From the front end of the site and client side technologies to databases. How do I choose a technology stack, what factors ...
4
votes
2answers
454 views

Am I legally required to remove all data associated with a customer (UK)?

A customer has asked that we remove all our stored information from our database. From a moral standpoint, we have no problem with this, but simply deleting all the data will leave us with orders ...
4
votes
1answer
491 views

Performance : Auto Complete Search for a large amount of data?

I have a table(mysql) containing around 20,000 records and I am trying to build a auto complete search box for my website. Someone told me that auto-complete search for such a large number of records ...
4
votes
4answers
874 views

Accept Credit Cards / PayPal on Website for Delayed Processing

I'm trying to setup a basic system on my site to accept credit cards for delayed processing. What I will be doing is collecting a bunch of orders/credit cards for a group of people, then after a ...
4
votes
3answers
422 views

Can I place a directory that lists other companies contact details on my commercial website?

Can I place a directory that lists other companies contact details and other relavent information on my commercial website? We are a magazine site and this would be placed for an additional resource ...
4
votes
1answer
543 views

How to show content for logged-in vs logged-out users?

We have a set of pages with the following urls: www.mysite.com/info/page1.html www.mysite.com/info/page2.html www.mysite.com/info/page3.html Each has a structure as follows: ---------------------- ...
3
votes
4answers
324 views

Why do some hosting companies restrict the allowed characters in DB names?

GoDaddy allows nothing but letters and numbers in database names. Other hosting companies have similar restrictions. Could there be any technical motivation behind this?
3
votes
3answers
1k views

what to do when your WordPress database is too large?

My WordPress site's database is nealy reaching 1GB which is the limitation of my host (GoDaddY), what should I do? I can't purchase a dedicated solution for it? There must be a way out to split this ...
3
votes
2answers
89 views

Storing image order without a database

The classic question is whether to store images in a database or on the file system. In my case I feel it is probably best to store it on the file system. However the specific order of the albums and ...
3
votes
2answers
97 views

How to safely saving users' data and NOT get responsibility of users' data?

I am programming a website which will save up users' inputs for their next visits. For example, I might save their phone numbers. The user will know that I save their phone numbers. However, do I need ...
3
votes
1answer
1k views

Search Engine Indexing of a Database-Driven Website

Suppose I have a MySQL whose rows are dog breeds and whose columns are properties of the breeds (e.g. coat color). The purpose of the site is to allow users to query the database with questions like ...
3
votes
2answers
94 views

Receive anonymous users' input by web upload form or email. Any online service for that?

Are you aware of any online service or online "platform" allowing users, not previously registered, to upload pairs of picture+comment to a database? It would be a collaborative database of ...
3
votes
2answers
259 views

creating a tag-based website and not using programming?

I want to create a tag-based website, and I need a tool that I could use (preferably without programming). It's a site where a user could pick tags on a certain item. All tags will be placed under a ...
3
votes
3answers
46 views

Web user authentication methods

Is there any method besides using a DB with username and password for authenticating a user?
3
votes
2answers
766 views

Remote database connections in mysql and php is it possible?

I need to know whether remote database connections are possible in every server? does every host provides the option for remote DB connection? and further this connection will be the second connection ...
3
votes
2answers
314 views

How can I archive (for historical record) my website?

If I launch a website that displays 1000's of pages of content (text) delivered dynamically from data in a database and and I want some sort of record to prove that this data had been published (on ...
3
votes
2answers
1k views

How do I disable username prefixes on mySQL databases?

I know of the potential risks. The only "useful" thing I've been able to find after Google-ing is this, on the cPanel website, which has no context whatsoever. Does anyone know how to do this? My ...
3
votes
2answers
1k views

MySQL vs. SQL Server GoDaddy, What is the difference between hosted DB and App_Data Db

I'm using GoDdady for site hosting, and I'm currently using MySQL, because there are less limits on size,etc. My question is what is the difference between using a hosted GoDaddy Db such as MySQL vs. ...
3
votes
2answers
144 views

Setting up a coming soon page. Should I create a whole database for “Sign up now for updates” email addresses?

I'm helping a friend set up a "Coming Soon" page for his website. Naturally, he wants people to enter their email addresses so they can get updates about the status of the website. I know I can set up ...
3
votes
1answer
40 views

Disabling frequent reloads of visitor

In my website i have some pages, that makes connections to 3-4 sites and checks the results with my database and gathers a full table. This table includes all the data that the visitor would need. ...
3
votes
3answers
1k views

Storing User-uploaded Images

What is the usual practice for handling user uploaded photos and storing them on the database and server? For a user profile image: After receiving the image file from user, rename file to ...
3
votes
2answers
86 views

Easy way to determine if a client's web host supports/allows creating SQL databases?

This is a very particular question, but I'm working on establishing a criteria at my company for when we bring new web clients aboard. Our sales team is looking for an effective way to determine ...
3
votes
2answers
101 views

Moving big database from one server to another

I have created a website that I know that its database size will increase rapidly. It will become terabytes and by the way I don't want to get a expensive server at first. What is I'm concerned about: ...
3
votes
3answers
108 views

Help with a CMS for content only not display [duplicate]

Hello I'm trying to make some kind of tool for an school website, what I need to do is to make students take a test and according to what are the results (27 posibilities) they get a set of activities ...
2
votes
4answers
76 views

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases?

In order to connect to a MySQL database, you typically use the following command: mysql -h host_address database_name -u db_user -p where db_user is associated with the database in question. ...
2
votes
2answers
289 views

Two websites at the same host but on different accounts to use the same database

I have 2 websites and would like to use the same database for both sites. The MySQL database contains just a simple guestbook. The websites are one seperate hosting accounts, but with the same host. ...
2
votes
4answers
2k views

Text files vs. text in database

I'm designing a new site, deciding whether to keep the bulk of the content for each page in a text file, with just the file name in a database record for that page, or to keep the entire text in the ...
2
votes
3answers
132 views

Know a good place to purchase seed data of storenames, addresses, and phone numbers?

I just build a new web app, and I am looking for data to seed it with. Anyone know any good seed data retailers? Or am I missing something and there is a way to do this for free. I am entirely open to ...
2
votes
3answers
132 views

How can I tell how big my Amazon RDS database (MySQL) is?

I have a MySQL database for my website hosted on Amazon AWS using RDS. It has 5GB of storage available to it. How can I tell how big the data in it actually is (and therefore how much of the 5GB ...
2
votes
2answers
96 views

How do yelp and google business collect information about businesses?

Do they work with some governmental sources ? Do they only use the information sent by business owners themselves ? Do they scrap the web to collect these information ? Do they have employees that ...
2
votes
3answers
4k views

Accessing PHPMyAdmin via URL (without cPanel)

I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root. I cannot seem to be able to make another account for cPanel either, and research indicates this ...
2
votes
1answer
839 views

Trouble creating new MySQL user/database with PHPMyAdmin

I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database. I now want to add a new user and new database. So, I went to the ...
2
votes
3answers
188 views

Database Management System do exist? [closed]

I want to build a database for my no-profit association, and i was planning to do it by myself. But then i realize that really i don't have the time to buid a solid, secure system. So i was ...
2
votes
2answers
584 views

CIA.gov “World FactBook” MySQL? [closed]

Is the CIA's 'World FactBook" of statistics and national data available in a MySQL format or some format conducive to parsing and incorporating into a website?
2
votes
1answer
406 views

Looking to move current e-commerce website to Squarespace

I have a business website, www.stockrumors.com, and it is a pretty simple design on the user side of things but the back end and admin side of things are a bit more complicated. Is it possible to ...
2
votes
2answers
380 views

Best ways to collect location-based user input

I'm working on a website where users will be able to register and provide information about their location. In order to prevent users from inputting incorrect data, we don't want users to provide ...
2
votes
1answer
261 views

Product catalog API

What is the common practice in creating (and updating) the product catalog (all products/models/tech specs) for online electronics store? Does any of the manufacturers/OEMs have an appropriate API to ...
2
votes
1answer
36 views

How do domain names get into WHOIS database and which databases get updated for each domain?

The WHOIS query and response protocol is widely used for databases holding various Internet resources like IPv4 assignments, IPv6 assignments, AS numbers and RIR (for example ARIN in USA or RIPE in ...
2
votes
2answers
45 views

Address database?

I'm not sure if this is the best place to ask this, but it goes. I'm doing planning/research for a website that NEEDS a database of addresses for every home in the US. I don't need resident names or ...
2
votes
2answers
479 views

Is there anyway i can create an intranet request form and have it be stored in a database? [closed]

I am trying to create a form for my companies intraNet site. The idea is as follows: An employee wants to make a purchase, so they will go to the appropriate page in the intraNet They will fill out ...
2
votes
2answers
80 views

full environment for development and production web site [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? is there any hosting that gives you full environment for development and production web site including IIS,Sql ...
2
votes
2answers
389 views

301 Redirect exception vs. Script new connection to DB

I'll get right to it because this will be long. I've built a WordPress site for a client on a new domain name and 301 redirected his 3 other domains to point to it. Then, I learn that he has a ...
1
vote
4answers
47 views

Is it possible to represent MySQL database as text files?

I find manually editing MySQL databases tedious. If the whole database was optionally represented as text files (as per Unix "everything is a file") for quick manually edits, searching and replacing ...
1
vote
4answers
341 views

Is it possible to have a better sql editor for phpMyAdmin? [closed]

I am studying database systems and using MySQL and phpMyAdmin. The editor that comes with phpMyAdmin is plain editor that does not highlight any special syntax like for example: gEdit in ubuntu. Can ...