web design tips
 

web design tipsWhich Database is Right for You?

If you can choose your database, you're lucky: few hosts offer anything more than MySQL. If you're doing things yourself, though, or you have one of those rare hosts, then you might find that you need to weigh up the positives and negatives of different database software.

MySQL.

MySQL is the most common database software for small websites, but is laughed at in the rest of the industry. It's fine for simple insertion and retrieval of data, but if you start trying to do anything more advanced with it, you're going to start running into problems.

So what doesn't MySQL support? Today, MySQL doesn't support views ('virtual' tables made from other tables), stored procedures (small programs that can be stored in the database) or triggers
(actions that the database can be told to do automatically when certain things happen). However, many of these features are promised in future versions.

What does MySQL have going for it? Well, for one thing, it's free, and it's the most-used database on the web. The database has speed, simplicity, and a no-nonsense attitude on its side. MySQL is usable with a lot of different programming languages instead of being artificially restricted, and runs on a lot of operating system. There's no shortage of big websites using MySQL and doing just fine: CNet and Friendster spring to mind.

Visit www.mysql.com for more information.

PostgreSQL.

MySQL's biggest open source competitor is PostgreSQL (www.postgresql.org). It's often considered to be a better database overall than MySQL, and yet it has a much smaller market share. It a more established and mature database than MySQL, with roots in the early '80s compared to MySQL's start in the mid-'90s, and is also released under a more flexible license.

The biggest strength of PostgreSQL is that it lets the database do more of the work: you define rules to say how your tables relate to each other, and PostgreSQL 'understands' and make things easy on you. It supports all the latest standards and features, making it a much better choice as a drop-in replacement for an expensive enterprise database than MySQL is.

Microsoft SQL Server.

Microsoft's SQL Server supports lots of extra features that other databases don't - because they were entirely made up my Microsoft. There are two reasons why some people use SQL Server: first, it works well with IIS and ASP, and second, it works graphically instead of using text.

However, as with most Microsoft products, security has proved to be SQL Server's weak point. Back in 2003, the Slammer worm demonstrated how insecure the software is when it spread between servers using a vulnerability in SQL Server. The problems caused were bad enough that the entire Internet actually slowed down, and although Microsoft says it has committed to improving security in all its software, it remains to be seen whether something similar might happen again.

Oracle.

Oracle is widely considered to be the best database out there. It's a very old, stable database, and is the most-used in big enterprise operations, mainly because it's so much faster than anything else out there. Oracle works on lots of different operating systems, and has support for lots of interesting features like Java and XML.

Oracle offers a lot of documentation and support on its website and, despite what you might think, is usable with languages like PHP. People used to avoid Oracle because it was wildly expensive compared to other database soft out there, but Oracle now makes a 'Standard' version available for around $150 per user - quite comparable to Microsoft's SQL Server. At this point, the only reason not to use Oracle is that you want your database to be entirely free - you'd be a fool to choose SQL Server instead of this, for sure.

What Do You Want Your Website to Do

The Many Flavours of HTML

The Basics of Web Servers

Titles and Headlines Its Not a Newspaper

The Top 10 Biggest Web Design Mistakes

  

Web Design
◦ 5 Simple Steps to Accepting Payments.
◦ 5 Ways to Avoid the 1998 Look.
◦ 6 Reasons Why You Need a Website.
◦ 7 Ways to Make Your Web Forms Better.
◦ A Question of Scroll Bars.
◦ Ads Under the Radar: Linking to Affiliates.
◦ AJAX: Should You Believe the Hype?
◦ All About Design: Principles and Elements.
◦ An Introduction to Paint Shop Pro.
◦ An Issue of Width: the Resolution Problem.
◦ Avoiding the Nuts and Bolts: Content Management Software.
◦ Beware the Stock Photographer: Picking Your Pictures.
◦ Building a Budget Website.
◦ Building Online Communities.
◦ Clean Page Structure: Headings and Lists.
◦ ColdFusion: Quicker Scripting, at a Price.
◦ Column Designs with CSS.
◦ Content is King.
◦ CSS and the End of Tables.
◦ Cut to the Chase: How to Make Your Website Load Faster.
◦ Designing for Sales.
◦ Designing for Search Engines.
◦ Dreamweaver: The Professional Touch.
◦ Encryption and Security with SSL.
◦ Finding a Good HTML Editor.
◦ Focus on the User: Task-Oriented Websites.
◦ Fonts are More Important Than You Think.
◦ Free Graphics Alternatives.
◦ FrontPage: Easy Pages.
◦ Hints All the Way.
◦ Hiring Professionals: 5 Things to Look For.
◦ How Databases Work.
◦ How the Web Works.
◦ How to Get Your Website Talked About on Blogs.
◦ How to Install and Configure a Forum.
◦ How to Make Visitors Add You to Their Favorites.
◦ How to Run Ads Without Driving Visitors Crazy.
◦ How to Set Up Your Hosting in 5 Minutes Flat.
◦ IIS and ASP: Microsoft's Server.
◦ Image Formats: GIF, JPEG, PNG and More.
◦ It's a World Wide Web: Going International.
◦ JSP: Java on Your Server.
◦ LAMP: The Most Popular Server System Ever.
◦ Making Friends and Influencing People: the Importance of Links.
◦ Making Searches Simple.
◦ Offering Free Downloads on Your Website.
◦ Opening a Web Shop with E-Commerce Software.
◦ tag - they have one extra tag before it. This is the doctype, and it must be present right at the top of your document for it to be valid HTML. There are only really
◦ Perl: Cryptic Power.
◦ Photoshop: a Graphic Designer's Dream.
◦ Picking a Colour Scheme.
◦ Printing and Sending: the Two Things Users Want to Do.
◦ Putting Multimedia to Good Use.
◦ Python and Ruby: the Newer Alternatives.
◦ Registering a Domain Name.
◦ Registering Your Users by Stealth.
◦ RSS: Really Simple Syndication.
◦ Setting Up a Mailing List.
◦ Setting up a Test Server on Your Own Computer.
◦ Some Places to Go For More Information.
◦ Taking HTML Further. HTML might seem like a simple language for web documents, and to an extent, it is - that's what it was intended to be. If you know what
◦ Taking HTML Further with Javascript. Once you've built your HTML pages, you might need them to do something a little more interactive on the client-side (that
◦ Taking Your Website Mobile.
◦ Text Ads: Unobtrusive Advertising.
◦ The 5 Principles of Effective Navigation.
◦ The Art of the Logo.
◦ The Basics of Web Forms.
◦ The Basics of Web Servers.
◦ The Case Against Flash.
◦ The Confusing World of Web Hosting: Making Your Decision.
◦ The Evils of PDFs.
◦ The Importance of Validation.
◦ The Many Flavours of HTML.
◦ The Smaller, the Better: Avoiding Graphical Overload.
◦ The Top 10 Biggest Web Design Mistakes.
◦ The Web Designer's Toolbox.
◦ The Web is Not Paper.
◦ There's More than One Web Browser.
◦ Time for User Testing.
◦ Titles and Headlines: It's Not a Newspaper.
◦ Tracking Your Visitors.
◦ Understanding Web Jargon.
◦ Uploading Your Website with FTP.
◦ Using Flash Sensibly.
◦ Using Quizzes and Games to Get Traffic.
◦ VBScript: Javascript Made Easy.
◦ Websites and Weblogs: What's the Difference?
◦ What Do You Want Your Website to Do?
◦ What You See Isn't Always What You Get.
◦ Which Database is Right for You?
◦ Why Doing It Yourself is Best.
◦ Why Java Will Drive Your Visitors Away.
◦ Why Word is Bad for the Web.
◦ Why You Should Put Your Content in a Weblog Format.
◦ Why You Should Stick to Design Conventions.
◦ Working With Templates.
◦ Writing for the Web.
GoogleSense
Making Money with Articles
Webhosting
RSS
◦ Reading RSS Feeds with an RSS Aggregator

Web Traffic Machines

Link to Us    Contact Us   Privacy Statement   Links  

LT International Inc - Web Design ABC