Re: [libreoffice-users] Re: OO Base has serious critical issues...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/07/2011 04:37 PM, Andreas Säger wrote:

> IMHO, LibreOffice should cut off embedded HSQLDB,

I never understood the rational for using HDSQLdb as the database engine.

> All the Base tools for back-end creation are known to be insufficient.
> There are plenty of mature and free database tools tailored to the
> different types of databases. LibreOffice is not obliged to do this part
> as well. Just like any code editor is better than our Basic editor, most
> of the generic SQL editors and composers outperform the infamous query
> designer.

OOo needed something more substantial than the built in dbase 3 clone
that it included, to compete with MS Access.

So in came HDSQLdb.  And what was promptly forgotten was a front end
that non-database programmers could understand.

And that is still the biggest problem with the database component of
LibO. Database programmers hate it, because it has so many bugs.
Non-database programmers hate it, because nothing is understandable
without learning how to program databases.

###

Base development should be:
* Scrap HDSQLdb;
* Retain the built in dBase 3 clone;
* Add SQLite;
* Write two front-ends:
# Front end # 1: This is a "simple" front end, that doesn't use SQL.
This front end is for people who need a database, but neither know, nor
care about the difference between a database field, and normalization of
a database;
# Front end # 2: This uses SQL. This front end is designed for power
users of databases;

jonathon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNUugiAAoJEERA7YuLpVrV+ooH+QHW2s91LPBW9QLlKnbwoIqH
58Hv4AbdIG4ETUyQDJ03QMXPn7CYDxjj3ujcbv5EzoBR4m+918PmjKNnNDsNYM5m
6SslPlU2haFCEzx62qYVE09Qv5pBZISWTtzphi7M+oo1bIf8l3xmVh20v0KB3X0e
X90hpPrSxKDoBRvps4s2UnMB7ETnjM9VJh4nYSIDgXkNv3nhG0BnbvD2C0QRun2U
78SU9P6jAeDlq/sPjxex9V3J5Ykh7xo7vJUddPEb+RMdTjbPHhgM9rgBGT1Ql393
iEErSiHxi+8h5q2jKbYorb4K3HD5f7VoiavyR1N7dtPxEDEN5JIJpY+f+TJVUOM=
=V5dW
-----END PGP SIGNATURE-----

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***