[KLUG Members] easy DB

[Adam Tauno Williams]

> > I need to set up a fairly simply DB which should, however be relational. Is there anything in Linux with the easy drag-and-drop form creation of Access? I don't want to have to spend time learning a new system  or setting up the forms by writing code.
> MySQL is a DBMS ONLY.  It does not do forms.  It only has tables.  You
> can define these tables to have relationships.  You can use the OBDC
> Drivers for windows to connect to MySQL from MS Access.

Or from any other ODBC tool on any platform. Using OOo for you forms and
scripting makes your solution entirely portable (since OOo runs and
supports ODBC on every major platform).

> Any DBMS in Linux will likely mean you will

True of any "real" RDBMS on ANY platform.

>  need to spend time learning
> SQL, sorry.  Look at the bright side, SQL is a wonderful skill to have
> anyhow.  MySQL has TONS of documentation on their SQL on their site,
> mysql.com

MySQL, PostgreSQL, Orable, DB2, Informix, M$-SQL, all support SQL92 and
most of SQL99.  Learning SQL is a 99.944% portable skill.   OOo does
provide a GUI query builder that works pretty well for simple queries, 
but a reasonably intelligent chap will quickly graduate to just using
SQL.  You can build queries and flop between the GUI builer and the
actual SQL statement, which is handy for the novice.