Server Costs

  • Server Acquisition – $1,500 – $25,000
  • Professional Installation – $1,000 – $5,000
  • Monthly support costs – $200 – $1,000
  • UPS – $250 – $2,000
  • Five (5) year warranty cost – $1,500 – $5,000 (4 hour repair)
  • Backup
  • Power
  • Heating and Cooling
  • Space utilization and access control

Web Site Design

In our experience, most websites are created from the perspective of what the owner or Chief Executive found to be attractive. But the value of a website comes from the insides too. In fact the ability of the web design implementation to communicate with the major search engines the purpose of the web site is more important than how it looks.

No matter how appealing your web-site looks, and how well it draws the consumer to act on an offer, pick up the phone or visit your business, first the website must be found by searchers using Google, Bing and Yahoo. For example, properly designed, you can expect more than half the visitors to your web-site to find it using Google searches, and another five to eight percent from Bing and Yahoo searches, possibly more.

The number of new visitors your web-site receives each month can directly translate to your revenues. But if you use the $199 website approach, you have thrown the investment away. Others sign up for the monthly website design support option at their hosting provider, such as Network Solutions or GoDaddy, where after two or three years they have spent a thousand dollars and receive no traffic.

Enterprise owners need to bluntly consider skipping the website altogether. There are more than 100 million websites, and unless you spend money on frequent technology upgrades and create new content, i.e. a changing menu at a restaurant, $9.99 a month is a waste of money. Design companies have no conscience charging thousands for websites that make no difference. Understand that a website solution price range where it matters might be hundreds of thousands of dollars. Solutions available vary, features required vary. There is a difference in the detail each type solution business. A menu online on a wordpress site with a free website template at a cheap hosting company, not counting the learning curve to overcome website publishing and managing your online hosting account will cost starting at $5-$15 a month, your domain for $8-25 a year, and you might have a low cost website up and running. Domain registration and the website, the hosting account and projected website functions could be too expensive, and a business digital business card is a far different cry than selling items in a shopping cart format, a plethora of retailers are already competing to engage customers and have mastered the call to action. Development of leads and prospects information datasheets customer service website metrics visitor analytics

Model View Controller

requirements website search engine optimization (SEO) keywords description utility relevance website searching for keywords related business website content code tags meta info title tag page structure css authority links reputable website social media engagement search engines Google recognize individual ranking factors signals changing weight plan build website know understand how SEO work ranking factor optimize engage strategies build relate trust authority search engines invest time research build website understand work website leads increase hits views visitors website engineered design content SEO strategy successful process building website success level expertise create winning visibility website strategy keyword industry research graphics flash planning blogging content creation linking organizing professional design prospects call to action funneling leads visitors page-views appropriate action website metrics analytics statistices optimization process actual visitor data new visitor pageviews time on site bounce search engine data build website successful website online inexpensive resource online website producing leads interact service resource customers prospects cost developed website real cost website

Server Roles

  • Domain Name Services (adding internal domain)
  • Firewall
  • File Sharing
  • Identity Management
  • Web hosting
  • Email hosting
  • Application hosting
  • SQL hosting
  • Terminal Services
  • Backup Server

Search Engine Optimization for Companies

Web-Atlanta is a key component to the South Eastern technology engine. It’s important in web design to have good local web designers who are familiar with your project. The web designers you use for your web project should not be in India, Pakistan, Russia, or any location other than the United States. Your project should only be worked on by a local web expert. We are Atlanta web designers; our programmers are what makes the difference between us and our competition. Having a web design company that has a group of great web designers or freelancers is good; but having a company that has the web design team, the high level programmers, the database gurus and the project managers that have seen it all is much better.

The outsourcing scammers are cold calling Atlanta customers and pretending to be local companies. They make big promises and deliver no results. Foreign companies pretending to be the real local Atlanta web experts are easy to spot by their high pressure and extravagant claims.

It’s one thing to be in Atlanta and be a web expert or designer, but its another thing to try and trick companies from Atlanta, Georgia. Even when seeing a local 404, 770 or 678 number, know that anyone can get these numbers and use them from anywhere in the world. Atlanta, Georgia companies like Web-Atlanta have more clients in the south eastern United States than these off-shore boiler rooms. For real SEO expertise right here in Atlanta contact Web-Atlanta and maximize your keyword positioning.

Foreign companies pretending to be the real local Atlanta web experts are easy to spot by their high pressure and extravagant claims.

Basic Website Pricing Cost

Many new business people fail to consider the cost of a website in their startup costs. They may also want to hold off on a website until other avenues are exhausted. The first rule of prospects and leads is to do business with people you know. Then ask them if they know anyone that could use your services. It’s all free!

But at some point you need to have a website. It is the new yellow pages. People need to find your phone number, and while they may remember your brand name, or your city and trade, we tend to misplace your business card and rely on looking up your phone number with google. That could suck for you.

To begin with, instead of wondering how much it will cost, set a budget of $ 750 for your first web-site. First you will have to register a domain, for at least five years, you have $ 700 left. Now you need a computer to store and provide your website to visitors, an annual service called hosting. There goes a hundred bucks a year. Your website should incorporate your logo. Don’t have one? There goes $ 150 to $ 500 for a digital branding package. That might leave you with from $ 100 to 500 to spend on the website design, and yes it can be done.

The most difficult part of the web design will not be the designers job, it will be talking about your business. You need 500 words about your business, philosophy, customers and market. You then need at least 500 words about your products and or services. Finally you need a contact page that contains your phone number, and if you have an office or mailing address, that should be included. There, we are done. That is a simple three page web-site.

If you have a business address, it is time to establish listings in Google Places and Bing Local Listings. These have become more important than the yellow and white pages. You can struggle through this yourself, or pay various professionals three to five hundred dollars to accomplish this somewhat technical task.

Been there done that, and ready to do it for real? Here is a guide to budgeting for a website upgrade, probably better suited for your second time through:

  Small BudgetBig Budget
Number of Pages6 to 10  $ 2,000  $ 3,000
Style and DesignSimple yet attractive  $ 2,000  $ 3,000
Copywritingthree to five pages  $ 1,000  $ 1,500
SEOmajor keywords and phrases   $ 2,000  $ 4,000
Graphical and Photography  Just Enough  $ 1,000  $ 2,000
Content Management System Standard  $ 2,000  $ 4,000
 TOTAL BUDGET COSTS $10,000 $15,500

Whoa, Nelly! Do I need all that? Probably not, but when you are ready to truly be found on search engines with an attractive web design, be prepared to budget three to five thousand. Need a professional photographer? Expect to spend from $ 300 to 1000 a session. Do you want to include products from your database, with current pricing or inventory levels? Expect to spend a couple thousand for the integration. Looking to sell things on-line? Expect to pay a consultant to help you with Amazon or Yahoo shopping to make an initial foray. If you want to run your own shopping site, the costs can be $ 10,000 quickly.

Python Mysql multi handle 2.7.2

Real world use case for multiple instantiations of python classes, Use a Python Class more than once

At the beginning of our python program, we normally would import the library for MySql operations;

import MySQLdb

Using this library, we then use .connect() and .cursor but because we may be using the same database repeatedly, here is an alternate method of initializing our connection. First, we create a file called credentials.py in our working directory to initialize the database connection;

#!/usr/bin/python
import MySQLdb
def dbconn():
  server = 'localhost'
  user = 'MySql_user_name'
  password = 'MySql_password'
  dbase = 'MySql_database_name'
  return MySQLdb.connect(server,user,password,dbase)

This means that I can quickly connect to the same database, everytime I write a new Python program, substituting the new library for making the connection.

import credentials
handle = credentials.dbconn();

We now can look at some table rows with only four more statements;

cursor=handle.cursor()
sql="SELECT * FROM table_name WHERE 1=1"
cursor.execute(sql)
rowArray=cursor.fetchone()

Add on more statement, like ‘print rowArray’ or do whatever you need to do to look at the row. You probably will write a loop that encloses the last statement.

Just to take another approach, let’s look at our MySql Python connect without the separate credentials function;

#!/usr/bin/python
import MySQLdb
server = 'localhost'
user = 'MySql_user_name'
password = 'MySql_password'
dbase = 'MySql_database_name'
handle = MySQLdb.connect(server,user,password,dbase)

cursor=handle.cursor()
sql="SELECT * FROM table_name WHERE 1=1"
cursor.execute(sql)
rowArray=cursor.fetchone()

print rowArray

And with the credentials library;

#!/usr/bin/python
import credentials
handle=credentials.dbconn()
cursor=handle.cursor()
sql="SELECT * FROM table_name WHERE 1=1"
cursor.execute(sql)
rowArray=cursor.fetchone()

print rowArray

Next an example using your credentials.py to make a python program to read two tables,first we get the user record, and then their posts.

import credentials
userHandle=credentials.dbconn()
uSql="SELECT * FROM jos_users WHERE id=57"
cursor=userHandle.cursor()
cursor.execute(sql)
uArr=cursor.fetchone
contHandle=credentials.dbconn()
cSql="SELECT * FROM jos_content WHERE created_by=57"
cCursor=contHandle.cCursor()
cCursor.execute(cSql)
for i in cCursor.fetchone
  print i['title']

python string split example 2.7.2

6 lines of code, no modules to import

x = 'joe fred terry mitch jane betty mary ellen'
while (1==1):
    y = x.find(" ")
    if y==-1: break
    print 'next name ',x[:y]
    x = x[y+1:]

3 lines of code, using the string module. Elegant because the loop definition is overt and evident.

import string

x = 'joe fred terry mitch jane betty mary ellen'
for name in string.split(x):
  print 'next name ',name

Other Examples

  1. split a semicolon delimitted string, or any delimiter in a string of fields
  2. some string library in python constants
  3. search a string (you don’t need the string library), i.e. ‘pos’ or re.search
import string

x = 'joe;fred;terry;mitch;jane;betty;mary;ellen'
for name in string.split(x,';'):
  print 'next name ',name

import string

print "1..",string.printable
print "2..",string.uppercase
print "3..",string.letters
print "4..",string.digits
print "5..",string.punctuation

x='joe,john'
print x.index('john')
# this yields the integer '4'
print x[4:]
# this would print john, or the rest of the string which is here john