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

learn more… | top users | synonyms

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. ...
1
vote
3answers
153 views

What to do with database in dev/production phases of a website?

For a while now I've been keeping a website I'm developing in the standard dev/production phases. Its been pretty simple: Mercurial repo for dev, repo for production. Do work in dev, get approved, ...
0
votes
1answer
64 views

Phantom activity on MySQL

This is probably just my total lack of MySQL expertise, but is it typical to see lots of phantom activity on a MySQL instance via phpMyAdmin? I have a shared hosting plan through Lithium, and when I ...
34
votes
5answers
4k 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? ...
1
vote
1answer
111 views

Thoughts on this approach for a news post caching system?

I'm working on a website which uses /news/title-of-news-article--111.html (111 = unique ID of the news article). I was thinking it might be a good idea to have some form of a caching system for the ...
2
votes
3answers
133 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 ...
0
votes
1answer
359 views

Merge two existing forms together, Add PHPBB2.x posts in to an existing SMF1.1x

I have two community website each running their own forms and I would like to merge the content of both forum in to one forum. Specifically from (PHPBB 2.x) in to a SMF (1.1). Both forums have been ...
4
votes
4answers
881 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 ...
15
votes
6answers
506 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 ...
2
votes
1answer
273 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 ...
3
votes
2answers
261 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 ...
4
votes
4answers
718 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 ...
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 ...