Re: database (now "MySQL/PHP")

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Trent Shipley
Date:  
To: plug-discuss
Subject: Re: database (now "MySQL/PHP")
On Monday 2004-04-12 23:32, Michael Havens wrote:
> So are you saying that I also need to learn apache?
> I know noTHING! What should I learn for the purpose of starting a pay
> website? 1- html (this wasn't in your list)
> 2- PHP
> 3- MySQL (would SQLite work)(from what I've read it will)
> 4- Apache
> Ohhhhhhh! Is that what you meant by the traditional approach? Could someone
> possibly direct me to a tutorial? I'm googling right now and found
> www.google.com/search?q=sqlite%20tutorial&ie=UTF-8&oe=UTF-8!
> but I do not know what I really need.... it's just a shot in the dark. I
> need advice from those who have an idea.
>
> Does anyone know of a tutorial that includes everything I need to know?
>
> :)~MIKE~(:



Ok.
So how to create a money making website in 10 easy lessons.

Disclaimer: I'm not the one to talk to. If I knew how to do it, I'd do it
myself.

Putting up anything besides a static web site costs money. You'll need
webhosting, scripting services, database services, and e-commerce services.
Plus, they tend to charge for bandwidth used.

You CAN do it all yourself and get full creative control. That means renting
space and services at a colocation facility and is VERY expensive and
complicated. Almost no one does it.

Be optimistic. Shure, 95% of all small businesses fail in the first 5 years
but to even start a small biz you need to expect you'll be the deserving 5%.

=======================

To put up a commercial web site from scratch you need:

Business expertise.
E-commerce expertise.
E-commerce software.
Content development expertise
Content development software.
(For a large site you will need content management expertise and software.)
Software development expertise (web scripting specialization).
Software development tools.
Database development expertise
Database administration expertise.
Database software.
Web server administration expertise.
Web server software.
(Operating) system administration expertise.
Operating system software.
Industrial grade computer hardware.
Networking expertise.
Networking hardware.
Telephony expertise.
Telephony hardware.
Location with access to high-bandwidth WAN (telephony) and rent for bandwidth.

Note this list grossly oversimplifies the scope of the problem.

Fortunately, you do not have to learn all this. Items higher on the list are
more critical.

================================

Most web based businesses don't even try to do the entire stack. They do:

Business expertise.
E-commerce expertise.
E-commerce software.
Content development expertise
Content development software.
(For a large site you will need content management expertise and software.)
Software development expertise (web scripting specialization).
Software development tools.
Database development expertise
Database administration expertise.

I know little about the business of running a small commercial website. I
also have no training in e-commerce, point-of-sale, working with credit
companies like Visa, and so on.

For a commercial site the most important consideration seems to be graphic
design, followed by usability, then followed by written content. For some
select sites audio is also important. There is no substitute for design. If
you don't have a talent for it you will need a partner. For begginer level
content work you can get away with a very superficial knowledge of HTML by
letting a tool do most of the work for you.

---

Software development falls into various categories. In my opinion learning to
program in a Windows web environment is slightly easier than on *nix. Also,
there seems to be more work for Windows based web development.

There are three main parts to web programming.

-- Web server modules or plug-ins. This is for real gurus. You wont have to
do this.
-- Server side scriping. This is fundamental. On Windows it means VB Script.
On *nix it tends to mean PHP. With either OS you can see JSP or Cold Fusion.
-- Client side scripting. This usually means JavaScript. If you only are
interesting in IE browsers you can use VBS. (I regard client side scripting
as a trip through browser compatibility hell.)

For any web scripting you will need to be thoroughly proficient in HTML. HTML
with Client and server side scripting are basic. For advanced web oriented
software development you get to learn Java, XML, and XSLT.

Note that I like programming but HATE doing commercial web programming. I
look at it as daily competition in Junk Yard Wars [tm]. The goal always
seems to be get it done fast, get it done cheap, with inadequate
tools--quality and planning (let alone adequate financing) be damned.

Sometimes you see ads for ASP experts. I never know what they mean. Do they
need me to write plug-ins for IIS? Do they want me to administer IIS?

For most low-budget operations database development (SQL) gets rolled into the
rest of software development. In any case, all web developers need to know
how to do rudimentary database programming.

When you hire your web hosting you need to know a little bit about database
administration but not much since the hosting company does most of the DBA
work.

Needless to say, it is the rare individual who is compentent in all four
areas, particularly since personalities that are good at one (software
development) are often hopeless at another (like marketing).

=============================

Crawl, run, walk.

Have you ever put together a simple static web site?

---
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss