[KLUG Members] easy DB

[Andrew Thompson]

On Tue, 2004-06-15 at 22:20, Adam Tauno Williams wrote:
> 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).

Could you elaborate on the OOo stuff? The only feature I've found that
uses is is the spreadsheet's Data Pilot, what MS Excel calls a pivot
table. What else is in there, and where?

> 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.

I disagree. I find it a lot faster and easier to be able to drag and
drop a field from one table to one in a different table to join them,
instead of having to type tbl1 JOIN tbl2 ON... all the time, especially
when I've got two or three different joins in the same query. If you
already know exactly what SQL you need, sure, it's great, but I find the
graphical interface to be a real timesaver for designing complex
queries.

-- 
Andrew Thompson <tempes at ameritech.net>
The Imagerie