Tag Info

Hot answers tagged

61

1) Tables shouldn't be used for page layouts because they are: Slow to render as the browser needs to download most, if not all of the table to render it properly They require more HTML then non-table layouts which means slower loading and rendering as well as increased bandwidth usage They can be a nightmare to maintain as they can get complex quickly ...


12

I'd have separate database for separate clients. A client might demand this for security reasons - i.e. only their site has access to their data. It also means that if a client want to move their data then it's going to be much easier to manage. It also means that if there is a problem with one client's database it doesn't affect all of the others. If you ...


10

There are inherit risks and rewards to both system. I worked for a financial firm that supported roughly 40 clients (national banks) on 1 database. We then purchased another company that sold similar software and that had gone with 1 database per client. Finally, the company went bankrupt and we did have to export all user data. Here is what the people I ...


6

Tables are for tabular data, not design. People often misunderstand the motivation behind making pages "tableless". It is wrong to use tables to create your layout. You should use other elements for layout (divs, lists, sections, articles, headers, footers, asides, etc.). And you can achieve great effects with minimal HTML/CSS (leaving your code ...


6

Wikipedia probably counts as having a "huge website", even if it's still tiny compared to, say, Google. You can find a description of their server architecture here. Basically, their SQL backend consists of a bunch of clusters, each one consisting of a single MySQL master server whose data is replicated to a bunch of read-only slave servers. Also, images ...


5

I would consider using a WordPress plugin called "WordPress Database Backup (WP-DB-Backup)" which is also listed on the Wordpress Database backup guide. This plugin can backup the database on a schedule and email it to you(assuming its a small database). You can also just back it up locally. You can exclude comment spam and revisions to make the DB smaller ...


5

I can tell you that I currently use mysqldump to maintain a backup of my database. I do this because my goal is to keep weekly backups so that in the event someone removes their webpage(s), I can recover it from at most a week ago. The good thing about this is that it is a basic text file so I can import it over to any computer with MySQL, load it up, and ...


5

You can use simple text file to simulate real database. If folder = album, then store order of images in text file in each folder (same file name, for example: order.txt.db). Possible file format: single line of text that you need to parse after reading from file (for example: file1.jpg|file2.jpg|file5.jpg|file3.jpg) -- it is easy to parse if you select ...


5

There are many IP to Location databases/services there, but going for free will cost in limited number of API calls, and features (paid one gives comparatively more). Freeness of service and the accuracy of service is inversely proportional to each other. Listed below are some services arranged by accurate (or more feature) to free: MaxMind Offers ...


5

A database-driven site doesn't necessarily have to have only a single URL or be entirely search-based. Most sites on the web today (including SE) are database-driven, but they still have different pages with individual URLs. And even search-based sites can be made to be search-engine-friendly. Your site should have a RESTful architecture wherever possible. ...


4

The truth is that if you're not building a site that will have large scale traffic from launch, it doesn't really matter what stack you choose. Just pick whatever stack will allow you to get started the quickest so you can get something up and running before you lose any motivation. Then, keep improving the site. Launching a site and getting it out ...


4

9grams, The first step is to determine why the database is so large. Though not impossible, it's extremely unlikely that it needs to be that large. There's probably some plugin inefficiently or unnecessarily storing data. If you're not sure what's going on, it may help to access phpMyAdmin, a database management tool, to see what table in the database is ...


4

Looks like a corrupted installation of phpmyadmin. Make sure your permissions are set correctly. Also consider reinstalling phpmyadmin using the latest stable build.


4

There can be several explanations. One of them is security. It's definitely safer to disallow any kind of special character that might eventually be misinterpreted during a query. Of course, the best way (from the end-user perspective) would be to allow these characters and safe escape/quote them, but this behavior increases the risk a developer might ...


4

20,000 records is not a lot at all. It's not uncommon for a table to have millions of records and, if your database is designed properly, still be very fast. So using Autocomplete with a table of 20,000 or even one million records is definitely feasible and shouldn't be slow. If it is you need to revisit your database design and SQL queries to make sure ...


4

Yes it is possible. Once you know the Host, Username and Password for your MySQL account, you can just log in to it as you normally would from as many hosts as you want. I once did it with two different hosts. My website was on one host, and from other host I was running some cron jobs that were running queries on the other site. Although depending on ...


4

You can try dailychanges.com, it does provide a list of domain names on a certain day. However Dailychanges doesn't give access to a relevant search form, so you have to manually type the following url pattern : site:http://www.dailychanges.com/{web hosting company}/{YYYY-MM-DD} For example if you want domain names registered on March 05, 2011 and hosted ...


3

Nightly DB Dump to file Nightly DB permissions dump to file (Maatkit) Use Tarsnap for offsite backup of DB dumps plus everything in /var/www/


3

The site code is in Subversion, which is in turn backed up nightly. Any development of the code is done on dedicated dev servers. Production is only updated once the new version has been tested. The content in relational databases is backed up nightly. Some of our sites have a huge volume of static content (images, pdfs etc.) and those are stored on RAID5 ...


3

Practically any modern CMS offers what you are asking for - Wordpress, Drupal, Joolma, etc. The limits for tags on a page are mostly editable - although the question elements needs elaborated for any further help (there are plugins for the three CMS's mentioned above that cover this). If it is a community focused site and you like the stackoverflow way of ...


3

It is definitely possible to convert an existing site over. What SquareSpace can do for an existing site is give it a really nice front-end editor for layout, etc. However, while SquareSpace does host the site, they don't host databases. What that means is even if you move to SquareSpace, you'll still need to host your own customer database. As a result, ...


3

You can sign up for a Flickr Pro account (not free otherwise you can only see the last 200 pictures) and tell people the email address that they've set up for you on this page: http://www.flickr.com/account/uploadbyemail/ You can use the subject line to give your photo or video a title and the body to add a description.


3

Could there be any technical motivation behind this? Very likely - in theory, mySQL database names can contain almost any character, but as they are stored as folders on filesystem level, I can see why one would want to prevent "complicated" naming schemes, especially in a mass hosting environment with thousands of customers. One could argue that the ...


3

This isn't really a programming question, and you would be better off asking the hosting provider, but here's my take. I really couldn't tell you, to be honest. If you think about it though, you're moreso referring to a shared hosting environment, which is not designed to cater to the tech savvy. Shared hosting and the tools provided for it are moreso ...


3

Backing up the database isn't enough, as you can't prove the contents of the database were displayed on the pages. If the dynamically generated pages look the same for each user, and don't depend on picking options for lists, say, which then generate pages depending on those options, then you can use spidering software. It will take a snapshot of the pages ...


3

Update your phpMyAdmin. The latest version (3.5) has exactly what you describe.


3

You have to read each company's Terms of Use, or contact each company directly. Nobody can determine the legality of republishing content based upon the information you've given.



Only top voted, non community-wiki answers of a minimum length are eligible