Databases

Table of Contents:

• Tools that make possible interactions with DataBases from the WWW
• Pointers to Various DBs' implementations
• Database Tutorials
• WWW <=> DataBase Related Boards
• DB Related Things
• Books To read

Tools that make possible interactions with DataBases from the WWW

• EvoScript (http://www.evoscript.org/about/)is a free, database-enabled web application framework written in Perl. The framework facilitates development by providing an extensible class framework and an easy-to-use embedded scripting syntax.
• WDBI -- a must see project!

WDBI - The new WDB!!! (http://www.wdbi.net/) (the latest release!!!)

WDB-P95 - A Web interface to Postgres95 (http://www.eol.ists.ca/~dunlop/wdb-p95/)

WDB - A Web interface to SQL Databases (http://www.dtv.dk/~bfr/wdb/)

Minivend (http://www.minivend.com/minivend/)

Pointers to Various DBs' implementations:

• Webteacher's Webdata, the first EASY database for the world wide web. (http://www.webteacher.com/webdata/)
• Using online Databases - Push Technology - Java - Javascript - Chat ->Free Samples You Can Use On Your Website (http://www.rede.com/samples/index.html)
• ITU Selected Sites - Database Management Systems (http://www.itu.int/Sites/wwwfiles/comp_db.html)
• Links to Programming Tutorials on the Web (http://www.eng.uc.edu/~jtilley/tutorial.html)
• ACM SIGMOD Index of publicly available database software (http://bunny.cs.uiuc.edu/sigmod/databaseSoftware/)
• Web Development Series Overview (http://www.iftech.com/oltc/webdev/webdev0.stm)
• Web Development Series: Accessing Databases from CGI Scripts (http://www.iftech.com/oltc/webdev/webdev4.stm)
• Linux Databases (http://linas.org/linux/db.html)
• Web-Database Gateways (http://gdbdoc.gdb.org/letovsky/genera/dbgw.html)
• Database (http://www.wag.caltech.edu/home-pages/jinsong/httpd_1.4.2/html/8_database.html)
• Linux SQL Databases and Tools (http://linas.org/linux/db.html)
• Free Database List - Table of Contents (http://iamwww.unibe.ch/~scg/FreeDB/FreeDB.list.html)
• mSQL Keeper (http://www.cglis.com/msql_keeper/)- is a collection of perl scripts that enables easy management of an mSQL database.
• Database Archive (http://www.lpac.ac.uk/SEL-HPC/Articles/DBArchive.html)- Lots of articles
• University of California at Berkeley - DataBase Research (http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/)
• Client-Server Databases
• Database Middleware
• Transaction Monitors
• Client-Server Client Application Development Tools
• Graphic User Interface Tools and Guidelines
• Software Engineering/CASE Analysis and Design Tools
• Distributed Computing
• Distributed Object Oriented Computing
• Information System Services Companies
• Computer Vendors
• Operating Systems
• The WWW Virtual Library's list of Web/database resources (http://www.stars.com/Vlib/Providers/Database.html)
• Jim Buyens Home Page: Windows-based development links (http://www.primenet.com/~buyensj/)
• More Web/database resources (http://gdbdoc.gdb.org/letovsky/genera/dbgw.html)
• Yahoo's page on searching databases from the Web (http://www.yahoo.com/Computers/World_Wide_Web/Databases_and_Searching/)
• A list of products to put Mac databases on the Web (http://www.comvista.com/net/www/cgidata.html)
• A list of free databases (http://cuiwww.unige.ch/~scg/FreeDB/FreeDB.list.html)
• Database and CASE Tools Resources (http://www.dataspace.com.au/resource.html)
• A list of database resources (Can be a slooooow link) (ftp://ftp.inf.ethz.ch/pub/publications/papers/is/ea/gisi95t2.html)
• The Windows CGI interface (http://www.city.net/win-httpd/httpddoc/wincgi.htm)
• The FreeODBC Driver Pack project (http://www.ids.net/~bjepson/freeODBC/index.html)
• Lots of good Web resources (http://www.primenet.com/~buyensj/ntwebsrv.html)

MySQL

A free database can boost your site (http://www.netscapeworld.com/ned-02-1998/ned-02-develop.html)-- Check out MySQL before you invest in Oracle or Microsoft

Responses to the article from slahsdot.org (http://slashdot.org/articles/00000787.shtml)

Xmysql homepage (http://web.wt.net/~dblhack/)

Frequently Asked Questions about MySQL. - Table of Contents (http://www.tcx.se/FAQ/mysql-faq_toc.html)

Mysql rpms (ftp://www.tcx.se/pub/mysql/rpm/)

mySQL (http://www.matrice.it/risorse/mysql/)

MySQL Contrib Dir (http://www.tcx.se/Contrib/)

MySQL Programs & utils [Search tool] (http://home.pi.net/~hverbeek/mysql/)

MySQL by TcX DataKonsult AB (http://www.tcx.se/)

PostgreSQL

WRS MPSQL (http://www.troubador.com/~keidav/mpsql.html)

PostgreSQL Administration Menu (PAM) (http://home.t-online.de/home/kappel.novalisa/pam-info.htm)

PostgreSQL User Digests Archive + Search (http://www.phil.uni-erlangen.de/tree/postgresql/index.html)

POSTGRES95 MAN PAGES (http://www.eol.ists.ca/~dunlop/postgres95-ref/)

PostgreSQL Documentation Project Home Page (http://www.postgresql.org/~dunlop/)

PostgreSQL: Home (http://www.postgresql.org/)

msql + w3-msql +lite

Hughes Technologies Web Site (http://ausweb.com.au/)

ftp://bond.edu.au/pub/Minerva/msql/Contrib/mSQLCGI/MsqlCGI-0.8.README

Mini SQL (http://curiac.acomp.usf.edu/nic/db/msql/index.html)

Mini SQL Documentation (http://cscsun1.larc.nasa.gov/~beowulf/msql/index.html)

mSQL 2.0 Manual (http://www.Hughes.com.au/library/msql2/manual/)

mSQL Keeper - miniSQL Maintenance Utility (http://www.cglis.com/msql_keeper/)

mSQL Lite Site Contributors List (http://www.gold-cousins.org/lite_site/list.msql)

mSQL Tools (http://design.delta.net/msqltools/)

msql.class Home Page (http://mama.minmet.uq.oz.au/msqljava/)

msqlperl by thread (http://franz.ww.TU-Berlin.DE/msqlperl/)

The mSQL FAQ (ftp://Bond.edu.au/pub/Minerva/msql/faq.html#msqltools)

The Unofficial Guide to W3-AUTH (http://www.dancooks.com/~jason/w3-msql/w3auth.html)

W3-mSQL Version 2 Documentation (http://cs1.inf.uni-hohenheim.de/ftp/sw/sun-solaris-2.x/mSQL/w3-msql/2.0/w3-msql.html)

Interbase

• http://www.cvalde.com/
• http://www.ibphoenix.com/
• http://www.interbase2000.org/
• http://www.ibobjects.com/
• http://www.karwin.com/
• http://www.volny.cz/iprenosil/interbase/
• http://ib.demo.ru/
• http://firebird.sourceforge.net/

MSQL

• The mSQL FAQ (ftp://Bond.edu.au/pub/Minerva/msql/faq.html#msqltools)
• mSQL Lite Site Contributors List (http://www.gold-cousins.org/lite_site/list.msql)
• Mini SQL (http://curiac.acomp.usf.edu/nic/db/msql/index.html)
• The Unofficial Guide to W3-AUTH (http://www.dancooks.com/~jason/w3-msql/w3auth.html)
• msql.class Home Page (http://mama.minmet.uq.oz.au/msqljava/)
• mSQL Keeper - miniSQL Maintenance Utility (http://www.cglis.com/msql_keeper/)
• mSQL Tools (http://design.delta.net/msqltools/)

Database Tutorials

• SQL for Web Nerds (http://photo.net/sql/)by Philip Greenspun
• DataBase Central (http://baobabcomputing.com/databasecentral/) Everything about DataBases
• Tutorials at WebReview (http://webreview.com/wr/pub/Databases)
• Introduction to Databases for the Web (by Selena Sol) (http://WDVL.com/Authoring/DB/Intro/)
• Web Database Crash Course (http://www.hotwired.com/webmonkey/98/24/index0a.html?tw=backend) (webmonkey at hotwired.com)
• Day 1 Interested in selling products online? Offering your users customized pages? Saving money with automated support? Database it. Richard shows you how in this 5-day tutorial. 15 June 1998
• Day 2 Are you ready to parent your own bouncing baby database? Windows NT or Linux? Today get the answers burning questions like these. 16 June 1998
• Day 3 Take a step-by-step tour of the configuration of the Apache Web server and demystification of MySQL. 17 June 1998
• Day 4 Fill in some blanks with basic tips for database programming using CGI, ePerl, and DBI. 18 June 1998
• Day 5 On the last day of this 5-part tutorial, Richard give you the last put your database instincts to work.19 June 1998
• EARP HomePage (http://www.oswego.edu/Earp/)
• Simple Perl DataBases (http://www.inlink.com/~perlguy/simple/)- This is a tutorial intended to teach you some of the powerful features of Perl while also showing you a very practical example of a set of CGI programs that you can add to your web site.
• SAL- Database Systems - Utilities & Other DBMS (http://www.llp.fu-berlin.de/lsoft/H/3/)

DBI-Users Archive (http://outside.organic.com/mail-archives/dbi-users/)

DBI - A Database Interface Module for perl5 (http://www.symbolstone.org/technology/perl/DBI/index.html)

Sorting Algorithms Demo (http://www.cs.ubc.ca/spider/harrison/Java/sorting-demo.html)

Berkeley DB - The Sleepycat Software Home Page (http://www.sleepycat.com/db/)

• The WDVL: Database (http://www.stars.com/Vlib/Providers/Database.html)
• Interfacing CGI Programs to Databases (http://iip.ucsd.edu/courses/s96/sql/)- DB Locks Concepts (http://iip.ucsd.edu/courses/s96/sql/locks.html)
• 1.Examples of the use of databases with CGI programs
• 2.Examples of database managers
• 3.Linking your CGI program to a database
• 4.Using the language SQL
• 5.An example of several implementations of a simple database
• Database Manual: Language, Design , and Resource (http://www.wag.caltech.edu/home-pages/jinsong/httpd_1.4.2/html/8_database.html)
• Simple Databases with Perl (http://www.rapidcity.com/~brent/simple/)by: Brent Michalski
• How to be a Web Whore Just Like Me (http://www-swiss.ai.mit.edu/wtr/dead-trees/index.html)by Philip Greenspun, vaguely part of Web Tools Review (http://www-swiss.ai.mit.edu/wtr/index.html)
• Web Development Series (http://www.iftech.com/oltc/webdev/webdev4.stm)- Tutorial on Accessing Databases from CGI Scripts
• DataBases and the Internet (http://w3c2.com.au/steve/dbinter.htm)
• How to do a searchable database (http://www2.ncsu.edu/bae/people/faculty/walker/hotlist/isindex.html)- Lot's of links
• Database Programming & Design (http://www.dbpd.com/) - On-Line On-line magazine for managers, developers, and administrators of the enterprise data resource. Contains valuable, original articles as well as summits and surveys.
• Providing Data on the Web: From Examples to Programs (http://fiaker.ncsa.uiuc.edu:8080/WWW94-2/paper.html)Zelig, a system to deliver on the fly access to databases and dynamic information through effective user interfaces. By Carlos Verla and Caroline Hayes, Oct. 1994
• SQL Tutors
• Interfacing CGI Programs to Databases (http://iip.ucsd.edu/step/s96/sql/)
• SQL Reference Page (ftp://ftp.postgresql.org/pub/incoming/ANSI-ISO-SQL-SPECIFICATIONS/CLICK_ME_FIRST.htm)
• Ask the SQL Pro - Welcome! (http://www.inquiry.com/techtips/thesqlpro/)
• SQL Tutorial (http://www.1keydata.com/sql/sql.html)

WWW <=> DataBase Related Boards

DB Related Things

• Database E-Mailer Suite (http://www.datademand.com/de/index.html)(for Win'95) retrieves information submitted by forms over the Internet and directs that information to tables in popular ODBC database programs like Access(TM). It will even write to Excel(TM) Spreadsheets!
• English Wizard (http://www.englishwizard.com/) allows users throughout the organization to access any relational database using the one language they already know - English!

Books to read