Questions tagged [database]

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

Filter by
Sorted by
Tagged with
41
votes
6answers
7k 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?
17
votes
6answers
7k 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 ...
16
votes
7answers
689 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 ...
14
votes
7answers
4k 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 ...
11
votes
4answers
21k 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 ...
7
votes
2answers
974 views

Deleting backups - Request to delete customer data - Data Protection Act 1998

It was brought up today about the customers right to have their data deleted and went on to an interesting talk about backed up data (we have a rolling 93 day window for backups on AWS s3) I was ...
6
votes
5answers
1k 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 ...
5
votes
4answers
388 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 ...
5
votes
3answers
3k 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 <...
5
votes
1answer
2k 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: ---------------------- |...
4
votes
4answers
4k 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 ...
4
votes
1answer
2k 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
2answers
1k 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 ...
4
votes
4answers
779 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
3k 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
1k 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
3answers
862 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 ...
3
votes
4answers
389 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
2k 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
115 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
109 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
2k 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
103 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 picture+...
3
votes
5answers
76 views

Moving website images to remote server vs moving database to remote server

I have a wordpress website that has gotten too big for a single server. I need to decide whether I should host the database externally i.e. purchase another server for the DB or if i should host the ...
3
votes
2answers
751 views

Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars

While exporting Magento database from xampp (using PhpMyAdmin).I am getting error .sql file. and also getting a warning message during export start. Warning: a form on this page has more than 1000 ...
3
votes
2answers
343 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
1answer
127 views

How to secure database access

I am developing a personal web-site with a lot of relatively sensitive (genealogical) information stored in a MySQL database. The site engine is written in PHP. So far (prototype phase) I have only ...
3
votes
2answers
633 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 ...
3
votes
3answers
65 views

Web user authentication methods

Is there any method besides using a DB with username and password for authenticating a user?
3
votes
2answers
603 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
1answer
54 views

Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))

Hi all I am fairly new to web development, I've made a couple of my own sites over the years with simple html tables and free webhosts. This time, I have decided to try to host my own site using WAMP ...
3
votes
1answer
115 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
2answers
189 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
2answers
3k 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
2k 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
1answer
41 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
2answers
97 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
3answers
176 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
91 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. However,...
2
votes
2answers
354 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
3answers
141 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
1k views

Is there any downside to using dokuwiki considering it does not use database?

I'm planing to use dokuwiki for my website but my friend told me since dokuwiki don't use database and store the data in plain text files it will put lots of strain on my host as my website grows and ...
2
votes
4answers
87 views

Will a standard CMS on a shared web hosting account work for this?

I have two questions concerning CMS's that I need answered if possible: I need to create a site with a Database. This site will in due time have lots of traffic and many users if things go as planned....
2
votes
2answers
870 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
2k views

Search engine misunderstanding

I have this, probably a misunderstanding, about search engines. How do they search for pages? If i have a page which loads contents from database and / or changes content thought jquery will a search ...
2
votes
3answers
10k 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
2k 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
224 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 thinking,...
2
votes
2answers
1k 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
458 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 ...