Welcome to esiq.org
|
Web Hosting - Databases, What Are They and Do You Need One?
'Database' is one of the most commonly used terms that one encounters in web site design. Yet, what they really are and whether they're essential is often not clear to novices.
A database is a collection of organized data, stored in files that have a specific structure. It's that organization and structure that allows for easy and rapid storage and retrieval.
The need for a database generally only arises when you have a certain amount of information and that information needs to have some structure. If you have a half-dozen names and addresses to store, a database is usually overkill. If you have a blob of data with no relationships between any of the items in that blob, maintaining a database is usually more trouble than it's worth.
Maintain a database? Yes, like other complex systems a database, to be effective, needs to be designed properly at the outset then kept 'tuned' for good performance. The alternative is to gradually allow the database to become more and more disorganized. That leads to difficulty in use, poor speed of retrieval and more frequent failures.
With MySQL, Access or MS SQL Server, the three most common choices of database product for web sites today, setting up a database is relatively simple. Even those with limited technical skill can get one up and running just by following some simple instructions. But some thought should be given to how you want the information organized, and to maintaining the system during its lifetime.
Suppose you have a set of names, addresses, email addresses, products purchased, date purchased and amount. If you have only a few dozen records it matters very little how these pieces are arranged and related. A database usually isn't even warranted in this scenario. Once you have several thousand or more records, it matters a lot. Speed, the ease of expanding the set of attributes (like adding, say, product category), and other issues come into play.
Even those with little technical expertise, but a willingness to exert logical thought and invest some time, can build a very robust database. Think about how you would organize a set of data (called 'tables'). Should Name, Address, and Product be in the same table? Or should the personal information be stored in one table and any product information (product, price, ...) in another?
Some experimentation may be needed to get it right, but the choices have an impact on how easy the tables are to maintain. It also affects the speed with which programs can fetch old data and store the new.
Having a database also introduces new maintenance issues for the server administrator, since backups usually need to be done differently. Recovering a failed database is usually more complicated than simply re-copying files from yesterday. Ask your hosting company what tools and skills they have for dealing with any database system you consider.
It's true that introducing a database creates more complexity and the need for additional thought and administrative effort. At a certain level, professional expertise will be needed. But clearly the advantages outweigh the costs in many cases. Companies large and small eventually use databases to store and organize data. At some point, you may be fortunate enough to be one of them.
Is Christian Publishing the Easy Road to the World of Writing Success? (Christian publishing) Any community with a special interest will pay for products that cater to that special interest. If that community is of significant size, you can bet that there will be products galore geared to them. There is money to be made where there is a need for a product. The Christian community is one such group that has a desire for a very specific product. They are interested in products that explain their faith and expand their knowledge of what is less understood within that faith. They also seek encouragement in what is already agreed upon. Because of all of these needs, there is certainly a market to be entered into within the Christian publishing network. The question is, since the group is exclusive, does that mean that there are too few writers for the consumers? Is it easier to get published when you’re not competing with the best of the secular authors? Those are difficult questions to answer with any certainty, but there are some topics to explore within that subject. Degree of Expertise In one genre of Christian publishing one qualification is essential. To write with expertise on subjects of faith, it is necessary to have the correct education. A seminary degree at the very least is required for convincing publications. The publishers do not accept authoritative writing from those without the proper education. When it comes to education, separate Christian denominations will expect degrees endorsed from those specific denominations. You may have expected that a Christian would need to write for the Christian community, but the requirements can be much more stringent. Just as a pastor or preacher must have the proper education to teach a congregation, a writer on subjects of theology or other topics from the Bible must also have the credentials to back up his claims. While it is not possible for every writer to obtain the correct degree for authoritative writing, there are other kinds of writing that will easier to achieve within Christian publishing. Experiential Knowledge A huge portion of Christian publishing is made up of personal stories. A Christian has unique experiences related to his faith. People who seek encouragement will buy books that relate to their own circumstances. A typical human problem is grief. If a Christian can effectively write about their grief from a perspective of faith then those writings will be helpful to other struggling Christians. Other important subjects include doubt, blessings and prayer. A lay Christian can back up their experiences and observations with scripture and therefore be much more relevant in their writing to the Christian community. If the writer’s material is not sufficient to fill a book, there are other outlets within Christian publishing for those who are able to inform and encourage fellow Christians. Magazines and church bulletins often publish poetry and short stories for the building up of believers. The Bottom Line Christian publishing may not be necessarily easier to do than secular publishing. If your heart is in the ministry to other Christians however, it may be the best field for you to attempt writing for. Christian publishing is not a ‘first step’ to enter into the publishing world. Most publishers are only looking for sincere and relevant publications. They will avoid writings done only for the money and will favor those with the honest goal of furthering the message of the Christian faith. Specific communities are looking for products geared to their lifestyles, but the best candidates for creating those products are those who have talent invested in that community. Entering into the Christian publishing world will be a similar task to entering into the scientific publishing world. It will take dedication and work. The writer will come out with a deeper understanding and faith of his own. Web Hosting - Email Issues When you build a web site, you often provide a means for users to communicate with you. One of the most common 'add-ons' to a web site is the addition of some kind of email access. Email is used to sign users up for newsletters, provide communication for administrative issues and a hundred other uses. But, as everyone sadly knows, email problems can occur. Virus infection is among the most common, though the situation is actually better today than in the past. Huge efforts, and some progress, has been made over the past 10 years to reduce the number and severity of virus attacks. Hackers haven't surrendered, far from it. But they're on the defensive like never before. Many of those viruses were (and are) spread through email, usually in the form of email attachments. That's the source of the now-common advice never to open an attachment from someone you don't know. Professionals will often extend that advice to suggest you never open an attachment that's unexpected, even if it's from someone you know. Well-meaning, but computer-challenged friends often accidentally forward virus infected emails. Spam has taken over the top spot for email annoyances. It's estimated by various different professional sources that 92-97% of all email sent today is spam. While the definition varies, spam is generally regarded as any unwanted commercial email sent by someone whom the recipient doesn't know or have a business relationship with. Spam clutters email inboxes, requires people to sift through to find valid messages, and often contains offensive messages in some form. But, it's a fact of life and isn't going away anytime soon. Even though laws are in place, thousands of spammers continue to risk fines or jail for the chance of making money from that small percentage who will open the unwanted email. Other forms of email problems are even more severe for many web site owners. When the mechanisms fail that they rely on to send and receive messages to and from their users, that's a problem. Dealing with those problems can range from sending an email or instant message to an administrator, to tracking down the right person to get your site removed from a blacklist. Email is the communications vehicle of choice for millions everyday. When the system burps, someone has to take time to do something about it. Often, that means relying on a person who is already overburdened with too many issues to resolve. So, besides pointing out some sad facts or complaining, what's the point? All of the above shows just one more area you should look at when selecting a web host or deciding whether to move to another. Just as with server or network administration, companies vary in their ability to deal with email-related issues. Some are responsive and super-competent. Others, are simply indifferent or worse. And many are in between. Email administration, like server maintenance or network management, is a professional specialty. Skill in one does not necessarily mean quality work in another. Finding a web hosting company and/or system that has few email problems, and solves them quickly when they occur, is an important task. Spend some time researching who provides superior support in email. You'll be happy you did. |