Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


Hi again,
First Tom:
I will try. Let us see what comes from the deeps of my mind and if I can find some old projects to investigate so I can give an understandable answer - I'm a little afraid that not.

Andreas:
Thank you for very interesting info. Please note that I am talking from a consumers point of view in no way professional in databases. When I worked with MSAccess I plainly saw it as a program - a tool - and tried to learn how to get it producing the needed results, how to do data input - data mixing and processing - data output. The background philosophy and programming details were of no interest - I did not even know to ask. Knowing could have been of help. I am aware of what you say about "real" relational dbs; my intention is to do the ODBC connection (or JDBC if necessary) between LO-Base and (e.g.) MySQL but if I'm correct the LO-Base (32bit) must first start working stable with or without a JRE.
That's why I now put my question "how" to your admirable community.
Best regards
Pepe


On 1.2.2012 20:51, Andreas Säger wrote:
Am 01.02.2012 19:36, Pertti Rönnberg wrote:
All of you.
Thanks very much for your kindness to bother answering - and for the
very interesting discussions.

My conclusion is that LO-Base (and OO-Base ?) is not yet - and perhaps
will not be as mentioned in the desciption at LO-Wikipedia: "A database
management program
<http://en.wikipedia.org/wiki/Database_management_program>, similar to
Microsoft Access .. etc" <http://en.wikipedia.org/wiki/Microsoft_Access>.

The difference amounts to a multi-million Dollar budget and a decade of development. OOo Base was maintained by 2 Sun/Oracle employees.

It is similar to Access. Access is named Access because you can access databases with it. In *addition* Access provides the JET database engine which embeds a database backend in the frontend file. Unfortunately, most people work with JET which is why Access has a bad reputation among professionals. I've seen very nice Access frontends for MySQL databases.

Base connects ODF documents with databases. In *addition* it can embed a HSQLDB into the frontend file which is basically a zip archive with configuration and Writer documents. Unfortunately, most people use the embedded HSQLDB which is why Base has such a bad reputation.

If you ever had created some relational database backend using any database specific, mature tool for the database, you would acknowledge how straight-forward Base connects your database with this office suite.

Simply do your database with a database program. Base is not a database program.




--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.