Some of this software might be useful to you.
Design Tools
- DBDesigner
- Description: A tool for designing MySQL databases.
Licence: Free, open source.
URL:www.fabforce.net
- DbVisualizer
- Description: A designer tool
License: Personal use free, otherwise $99.
URL: www.minq.se
- Relation Diagrammer
- Description: Produces ERD diagrams from MS Access databases.
License: Free version for limited number of tables.
URL: www.msbsoftware.ch/relation.html
Databases
- MySQL
- This is the most popular database used with low/medium size web servers
(as well as the similar mSQL), eg, with a CGI or
PHP interface. Recent versions of MySQL has added a number of features, including
transactions and replication.
There are many free addons -- check their links for lots of stuff.
Comments: I use it and am quite happy with it.
URL: www.mysql.com
License: Free, open-source.
- Links to MySQL clients, etc
- Description: Lots here.
URL: www.mysql.com/portal/software/admin/index.html
- MySQL frontend
- URL: www.mysqlfront.de/
- Article on installing J/Connect JDBC driver for MySQL
- URL: stardeveloper.com/articles/display.html?article=2003090201&page=1
- Slashdot discussion of DB GUI admin tools
- URL: Hmmm
- Rekall
- Description: Open source Access-like front end to MySQL, PostgreSQL, ...
URL: www.totalrekall.co.uk
- PostgreSQL
- Description: A good, complete, free, open-source database which has improved greatly over
early versions. Unix, but available for Windows reportedly only with complicated Cygwin installation.
License: Free, open-source.
URL: www.postgresql.org
- SQLite
- Description: small database usable from C++.
Free, open source.
URL: sqlite.org
- Hibernate
- Description: Java programming interface to JDBC. From their website:
Hibernate is a powerful, ultra-high performance object/relational
persistence and query service for Java. Hibernate lets you develop persistent
objects following common Java idiom - including association, inheritance,
polymorphism, composition and the Java collections framework.
Extremely fine-grained, richly typed object models are possible.
The Hibernate Query Language, designed as a "minimal" object-oriented
extension to SQL, provides an elegant bridge between the object and relational worlds.
Hibernate is now the most popular ORM solution for Java.
License: Open source.
URL: www.hibernate.org/
Clients
All database engines provide some kind of client interface, even if it is
as primitive as a text based DOS window. Here are some other client programs
that either interface via a general ODBC connection, or can use the native
protocol to a particular server.
- WinSQL
- Description: Windows interface to SQL databases via ODBC.
Comment: It's a nice SQL interface. I've used it and like it,
but the recent free version seemed too crippled.
License: Lite Version Free
Size: 0.7 MB
URL: www.synametrics.com
Misc. Database Links
- Sentences, an Associative Databases
- Sentences uses metaphors of chapter, paragraph, noun, verb
(verbs form the associations). In Java.
:License: Free(?) personal edition.
to use.
URL: www.lazysoft.com