Choosing the Right Database System

The Web-surfing public doesn't really care about flashy-yet-useless technology. They want Web sites that do something for them: provide a service or entertainment; help get a job or a date; check bank account balances, stock prices, interest rates, availability of airline tickets, today's weather ... and so on.

Dice, Richard. Webmonkey (1998). Design>Web Design>Databases>Adaptive

Developing with Apache Derby -- Hitting the Trifecta

Along with creating a database schema and populating tables with data, being able to selectively modify data is one of the most important skills necessary for a database developer. This article teaches you how to selectively delete or update data in an existing table and how to modify the structure of an existing table. To perform data modifications on a more complex database schema, you'll learn about embedded subqueries, both scalar and table, with data update and data insert operations. You'll also find out how to delete and modify data in complex schemas using the Apache Derby database.

Brunner, Robert. IBM (2006). Design>Web Design>Server Side Includes>Databases

eRuby: Using Ruby and MySQL for Dynamic Web Pages

In a previous tutorial you learned how to get started using the Ruby language as a web scripting language by embedding it in HTML. You need some type of database connectivity to do the cool dynamic stuff. So here is a tutorial written by Markus Jais on how to connect to a MySQL database using Ruby. I will be updating and editing this tutorial to include more windows instructions where applicable.

Jais, Markus. Hiveminds (2002). Articles>Web Design>Databases>SQL

Everything You Wanted to Know About SQL Injection

If you are a CMS user or web developer then you should know what SQL injection attacks are and how to protect your web applications against them. Hackers are using more SQL based attacks, getting smarter about how to attack a website and using better tools. You have to get a good understanding of how their attacks work if you are going to choose the right software and keep your website secure. Here I will review several types of SQL injection attacks and how they occur. Then take a look at what web developers and end users can do to prevent them.

McDade, Carl. Hiveminds (2006). Articles>Web Design>Databases>SQL

Introduction to Databases for Web Developers

Unlike previous versions of data warehouses (people and books), that might be considered the australopithecines of the database lineage, libraries crossed over into the modern-day species.

Extropia. Design>Web Design>Databases>SQL

Programmatically Manipulating Microsoft Excel Spreadsheets with the Apache POI API

The Apache Jakarta POI project consists of Java APIs dedicated to the manipulation of files based on Microsoft's OLE 2 Compound Document format. In this article, you'll learn how to use the APIs of the POI project to read from and write to Microsoft Excel spreadsheets. As you will see, the programmatic liberty to manipulate Excel files represents a powerful offering to the Java programmer.The Apache POI contains a number of components. In this article, we'll be focusing our study on the HSSF component. The HSSF project will provide us with the ability to read and write from XLS spreadsheets.

Bhogal, Kulvir S. Dev Articles (2003). Articles>Web Design>Server Side Includes>Databases

Refining Data Tables

Many articles have been written on what is probably the single most ubiquitous interface element within Web applications today: the form. Forms justifiably get a lot of attention because their design is critical to successfully gathering input from users. Registration forms are the gatekeepers to community membership. Checkout forms are how eCommerce vendors close deals. But what goes in must eventually come out, and the information users provide to Web applications often makes its way back to users in the form of tabular data.

Wroblewski, Luke. UXmatters (2006). Design>Web Design>Forms>Databases

Storing Hierarchical Data in a Database

Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own CMS: there will be a moment that you'll want to store hierarchical data in a database. And, unless you're using a XML-like database, tables aren't hierarchical; they're just a flat list. You'll have to find a way to translate the hierarchy in a flat file.

Van Tulder, Gijs. SitePoint (2004). Design>Web Design>Information Design>Databases

Transactions in MySQL

Protect your data from crashes and the confusion of multiple user requests with a transaction-capable database.

Greenspan, Jay. Webmonkey (2002). Design>Web Design>Databases>SQL

VB/MySQL.com

An online resource for people developing database-driven web applications using Visual Basic and MySQL.

Hillyer, Mike. VBMySQL.com (2005). Articles>Web Design>Databases>SQL

Why (Almost) Every Web Site Needs an RDBMS

When your Web application reaches a certain size, it needs a good database design behind it. And in fact, this 'certain size' is much smaller than almost every small-site developer thinks. Relational Data Base Management Systems (RDBMSes) need not be restrictive or over-architected, as their bad reputation sometimes brings developers to fear. A bit of thought toward what your site does quickly turns into a sensible schema design, and it is easy to leave open expandable storage mechanisms like a configuration table within an RDBMS back end.

Mertz, David. IBM (2007). Articles>Web Design>Server Side Includes>Databases