DATABASE PROGRAMMING
SITES
Build your own Database Driven Website using PHP & MySQL
The first four chapters of a book on building websites with PHP and MySQL.
BUILDER.COM: Put Your Database on the Web
BUILDER.COM article on the basics of connecting your site to a database.
FileMaker Web Man
A set of two articles detailing a user's experiences in setting up and maintaining a web server and database on a Macintosh computer.
Hughes Technologies
The home page for Hughes Technologies, makers of MiniSQL, a shareware database for Unix and Windows NT. MiniSQL is freeware for educational institutions and non-profits.
Interactive/On-line SQL Tutorial 
A 9-step online course teaching SQL basics; includes an opportunity to practice SQL commands on an online database.
MySQL
The official home page for MySQL, a freeware SQL database for Unix and Windows NT. Includes benchmarks for several freeware and shareware databases.
SQL Server Performance Tuning and Optimization Tips
Tips for getting better performance from Access and Microsoft's SQL Server.
SQL Tutorial
An online tutorial demonstrating the basics of using Structured Query Language (SQL) for dealing with information in databases.
Sybase FAQ
Answers to questions about Sybase's SQL server. Includes information on interfaces between Sybase and various web-ready programming languages.
WDB - A Web interface to SQL databases
The homepage for WDB, a software toolkit that facilitates interaction between SQL databases and the World Wide Web. Not updated since 1996.
Web Database Crash Course 
A thorough five-day tutorial that includes hardware and server configuration and everything from custom Apache configurations to Perl's database interface (DBI). From Webmonkey.
Web Databases: Part 1
This Anchor article explains the basics of web databases, including how they're structured and when it makes sense to use one. Part 1 of a 3-part series.
Web Databases: Part 2
Part 2 of this Anchor series on web databases covers how to set up your system, including choosing the tools that are right for you. Discussion of Unix vs. NT for serving the system.
Web Review: Databases
Articles on database development and connectivity from Web Review magazine.
ARTICLES
Access Granted
How to secure your MySQL installation against unauthorized users, using the access control system and grant tables. (4/24/2001 at DevShed)
Accessing a Microsoft SQL Server Database From PHP Running Under Linux
Using PHP on a Linux server to connect to Microsoft SQL Server on a Windows NT server. (9/19/2000 at PHPBuilder)
Adding A Dealer Locator To Your Site
How to use database and programming technologies (MySQL and Perl, specifically) to locate resources in or close to particular zipcodes. (2/29/2000 at Web Developers' Journal)
Boolean Fulltext Searching With PHP and MySQL
Some code snippets to help with performing boolean searches on MySQL text fields using PHP. (9/11/2001 at evolt.org)
Building Web Applications Using Servlets and JSP Part II
Information on using JSP and JDBC to interact with a SQL database; specifically, validating user ids and passwords stored in a database. (6/12/2000 at WDVL)
Calling Stored Procedures From Active Server Pages
An example and explanation of calling stored procedures from ASP. (8/10/2000 at 15 Seconds)
Creating Custom Hierarchical Recordsets
Using ADO for data shaping, creating custom recordsets, and creating hierarchical recordsets. (6/3/2001 at 4 Guys From Rolla)
Creating Listserver Functionality Using ASP and SQL Server 7
A tutorial on generating mailing lists, and sending email, using ASP and user data stores in SQL databases. (2/10/2000 at ASP Today)
Creating Next/Previous Buttons With PHP and MySQL
Code, and thoughts, behind a PHP class that lets you show a limited number of database query results per page. (11/2/2000 at O'Reilly Network)
Database Access Protocols
An explanation of the various protocols that have grown up around database programming - ODBC, JDBC, OLE-DB, and SQL. (11/19/1999 at Web Review)
A Database-Independent API for PHP
Examines several different ways to build your own API for database manipulation in PHP, to make your code more portable. (9/14/2000 at Web Techniques)
Day 1: Learning the Basics of PL/SQL
An excerpt from Sams Teach Yourself PL/SQL in 21 Days, Second Edition; covers what PL/SQL is, how it relates to other Oracle products, and writing a simple PL/SQL function. (6/4/2001 at Earthweb)
DBIx::Recordset: a DBI Extension for Application-Level Database Use
The case for using DBIx::Recordset for building database-driven applications: "speed of development, power of expression and availability of standard and necessary application-level functionality." (2/27/2001 at Perl.com)
Disk-Based Data Structures (DBM)
Using Perl with DBMs - a faster, more light-weight alternative to relational databases. (12/18/2000 at WDVL)
Dynamic Web-based Data Access Using JSP and JDBC Technologies
Using JDBC, JSP, and JavaBeans to provide access to dynamic database content. (9/27/2001 at IBM)
Getting Started with SQL
Advice on a personal database to use for learning SQL, and an introduction to some terms used in relation to relational databases. (10/20/2000 at O'Reilly Network)
How to Make Your Own Ebay
How to use ASP and a SQL database to build an auction website (like EBay). (9/11/2000 at WDVL)
Introducing SQL Sets
Using SQL's UNION, INTERSECT, and EXCEPT operators to customize query results. (8/2/2001 at ONLamp.com)
Introduction to dbXML
The basic model of dbXML, a native XML database, and how to write a Java program that connects to it. (11/28/2001 at XML.com)
Journeyman SQL: SQL Functions
Using SQL functions to deal with data - one row at a time, or aggregating data across multiple rows. (3/24/2000 at Web Review)
The JSP Files (Part 5): No Forwarding Address
Shows how to use Java Database Connectivity (JDBC) to connect to a MySQL database and both extract and manipulate data. (3/19/2001 at DevShed)
Managing Data Integrity
How to make sure avoid race conditions and data corruption with Oracle, MySQL, and mSQL. Discusses table locking, triggers, and referential integrity. (1/1/2000 at Web Techniques)
Migrate Your Site From MySQL To PostgreSQL -- Part 1
Motivation and instructions for moving from MySQL to PostgreSQL as a website backend. (10/10/2001 at WebmasterBase)
More on JOINS
An in-depth explanation of SQL JOINS, and exploration of INNER JOINS. (6/1/2001 at ONLamp.com)
MySQL 4.0 Released
Discussion of the release of MySQL 4.0.0 alpha, and how MySQL compares to PostgreSQL. (10/16/2001 at Slashdot.org)
MySQL Connectivity With Python
How to use Python's MySQLdb module to connect to a MySQL database. (8/21/2002 at DevShed)
MySQL Developer Contests PostgreSQL Benchmarks
Michael Widenius, lead MySQL developer, contests recent benchmarks put out by Great Bridge LLC that say PostgreSQL is significantly superior to other open-source databases. (8/15/2000 at DevShed)
Open Source Databases Bloom
Open-source databases like MySQL and PostgreSQL are finding more use at corporate sites, especially as commercial support for them become available. (9/10/2001 at IDG.net)
Optimizing MySQL Queries and Indexes
How to use indexes, and the explain, analyze, and optimize commads to make your MySQL queries faster. (11/26/2001 at WDVL)
Oracle 8i, Java, and the Mustang Index
A look at Oracle 8i's features. (11/2/1999 at Web Techniques)
The Perfect Job (part 2)
Using MySQL and PHP to write web applications for a human resources department. (7/11/2001 at DevShed)
PHP 101 (part 4) - Look, Ma...It's Alive!
Examples and explanation of how to use PHP and MySQL to put information into, and take information out of, a database. (9/1/2000 at DevShed)
PostgreSQL: Taking E-Business Up a Notch
A look at the history and features of PostgreSQL, the most robust open-source database available; and a quick mention of Interbase and MySQL. (12/17/2000 at Web Techniques)
Self-Inflicted SQL
An explanation of self-joins - SQL joins that involve linking a table to itself. (7/12/2001 at ONLamp.com)
Setting Up a MySQL Based Website - Part II
How to use MySQL to control user access to your site. (1/24/2000 at Linux Planet)
SQL Joins - Multi-table Queries
How to use SQL joins effectively, and leverage the power of relational databases. (2/28/2002 at WDVL)
SQL Savvy: Using SQL Statements With ASP
How to mix SQL statements in with ASP and present the results of queries to users. Covers a bunch of SQL basics. (10/26/1999 at builder.com)
SQL Server Stored Procedures 101
How to use SQL stored procedures - with a focus on Microsoft SQL Server. (6/3/2002 at DevArticles)
Taking Advantage of MySQL's Query Optimizer
Using Query Optimizer, EXPLAIN, and PROCEDURE ANALYSE, and other tricks in MySQL to speed up database queries. (4/20/2001 at ZDNet Developer)
Tuning JDBC: Measuring JDBC Performance
How to measure how well JDBC is performing, and identifying what parts of JDBC you should work on optimizing for your applications. (12/5/2001 at ONJava.com)
Understanding SQL Joins
Left joins, right joins, inner joins... effective use of joins in SQL. (8/20/2002 at DevShed)
Uploading, Saving and Downloading Binary Data in a MySQL Database
Code for, and discussion on, building a web system to upload binary data (such as images and multimedia) to a MySQL database and download it as well. (9/15/2000 at O'Reilly Network)
Using MySQL under Windows NT
Why you might want to install and use MySQL on Windows NT, and how to do so. (9/22/2000 at 4 Guys From Rolla)
Using MySQL's Built-In Replication To Maximize Availability
Using MySQL's new internal replication feature, and how to use PHP to failover to a secondary database server if the first one fails. (9/12/2000 at PHPBuilder)
Using ODBC Databases With PHP
A quick look at using PHP to manipulate ODBC databases. (2/2/2000 at ASP Today)
Web Databases: New and Improved, Now With Better Taste!
A non-technical review of database technologies available for building websites. (7/13/2001 at Web Review)
Website Database Basics With PHP and MySQL
A long article demonstrating how to use PHP and MySQL to create a useful application - in this case, a penpal service. (1/11/2000 at DevShed)
What's the Big Deal about SQL?
A history of SQL, and information on why it and where it is useful. (10/20/2000 at O'Reilly Network)
Where to Use WHERE
Details on how to use the "WHERE" clause in SQL select statements. (1/5/2001 at O'Reilly Network)
Wrapping DBMS Stored Procedures as Methods in Session EJB Components
Shows how to use Enterprise JavaBeans to invoke already-existing stored procedures in your database management system (DBMS). (10/31/2000 at IBM)
|
