Re: [libreoffice-users] Re: documentation for LO base
I use it at the office for time registration and invoicing. At home for the Taekwon-do club membership. Should I perceive that as a threat? ;- It's actually marvelous in combination with postgresql SDBC driver. And actually useful as it is so easy to get your data to Calc, more useful then I remember Access. In fact that's also the only application case that I would consider using Calc and Writer for in their current state - for graphing and printing database data. Imho the most logical and least error-prone way to use Calc is to do all your calculations in PostgreSQL and only display and graph the results in Calc. *Never* do complex calculations in Calc. It always hurts a bit when people who don't use databases say that Base is not good, databases are not useful etc. Because they don't have a use for it (pure letter-writers for home-use) or because they don't have a clue (most office users). I know a lot of people that never use a spreadsheet either. But I think LO wouldn't be complete with Calc or Base. You mean withOUT, I presume? Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: documentation for LO base
I agree. I use it at the office for time registration and invoicing. At home for the Taekwon-do club membership. It's actually marvelous in combination with postgresql SDBC driver. And actually useful as it is so easy to get your data to Calc, more useful then I remember Access. It always hurts a bit when people who don't use databases say that Base is not good, databases are not useful etc. I know a lot of people that never use a spreadsheet either. But I think LO wouldn't be complete with Calc or Base. My experience: de builtin hsql backend was very slow last time I tried, sqlite unusefull, mysql OK but I couldn't find anything like PG Admin to administer it. So, if you have the choice, go for postgresql. Ferry Wolfgang Keller schreef op za 06-10-2012 om 21:34 [+0200]: I am going to stick my head above the parapet and say it should have an embedded database functionality that is secure and reliable. Since recently, LO comes with a native driver for PostgreSQL. That's probably the best thing that the LO developers have done for quite some time. Since it makes LO Base actually useable *and a lot better* than Access (which is unusable with PostgreSQL). That is an essential requirement for entry-level users that have only ever used Access. Reliability? As an essential requirement for Access users? Huh? Access is a pathological data shredder. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: documentation for LO base
On 10/09/2012 05:01 PM, Ferry Toth wrote: I agree. I use it at the office for time registration and invoicing. At home for the Taekwon-do club membership. It's actually marvelous in combination with postgresql SDBC driver. And actually useful as it is so easy to get your data to Calc, more useful then I remember Access. It always hurts a bit when people who don't use databases say that Base is not good, databases are not useful etc. I know a lot of people that never use a spreadsheet either. But I think LO wouldn't be complete with Calc or Base. My experience: de builtin hsql backend was very slow last time I tried, sqlite unusefull, mysql OK but I couldn't find anything like PG Admin to administer it. mysql workbench (available from Oracle) works well with MySQL/MariaDB So, if you have the choice, go for postgresql. Ferry Wolfgang Keller schreef op za 06-10-2012 om 21:34 [+0200]: I am going to stick my head above the parapet and say it should have an embedded database functionality that is secure and reliable. Since recently, LO comes with a native driver for PostgreSQL. That's probably the best thing that the LO developers have done for quite some time. Since it makes LO Base actually useable *and a lot better* than Access (which is unusable with PostgreSQL). That is an essential requirement for entry-level users that have only ever used Access. Reliability? As an essential requirement for Access users? Huh? Access is a pathological data shredder. Sincerely, Wolfgang -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: documentation for LO base
Back in my Mainframe days, I had to write a General Ledger Accounting system in COBOL [not my choice] with a master database file[s] used for more than just accounting. If anyone wants to choose to say packages like Base is not good or some other negative term, ask them to try and write the database package from scratch with programming languages that are not designed to be a flexible as the modern object-oriented languages. I have not used Access since 2000 or 2003, so I have not used Base, except to try it once and awhile. To be honest, one reason why we do not have much Base documentation is the simple fact that there are not as many people out there that know Base well enough and can write documentation. It is much easier to find Writer and Calc documentation, since more people use it and understand it better than Base. That does not mean that Base is not a good package, just one that it not used as in-dept by as many people as the other parts of LO. On 10/09/2012 05:01 PM, Ferry Toth wrote: I agree. I use it at the office for time registration and invoicing. At home for the Taekwon-do club membership. It's actually marvelous in combination with postgresql SDBC driver. And actually useful as it is so easy to get your data to Calc, more useful then I remember Access. It always hurts a bit when people who don't use databases say that Base is not good, databases are not useful etc. I know a lot of people that never use a spreadsheet either. But I think LO wouldn't be complete with Calc or Base. My experience: de builtin hsql backend was very slow last time I tried, sqlite unusefull, mysql OK but I couldn't find anything like PG Admin to administer it. So, if you have the choice, go for postgresql. Ferry Wolfgang Keller schreef op za 06-10-2012 om 21:34 [+0200]: I am going to stick my head above the parapet and say it should have an embedded database functionality that is secure and reliable. Since recently, LO comes with a native driver for PostgreSQL. That's probably the best thing that the LO developers have done for quite some time. Since it makes LO Base actually useable *and a lot better* than Access (which is unusable with PostgreSQL). That is an essential requirement for entry-level users that have only ever used Access. Reliability? As an essential requirement for Access users? Huh? Access is a pathological data shredder. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: documentation for LO base
Hi :) I keep forgetting about this one even though i have added it to the Publications page https://wiki.documentfoundation.org/Documentation/Publications Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 13:09 Subject: [libreoffice-users] Re: documentation for LO base The ultimate guide by Mariano Casanova: http://www.scribd.com/doc/48635562/Base-Tutorial-OOo -- View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: documentation for LO base
Just like MSAccess, Base is extremely useful as a frontend for database engines. The last time I tried to run a non-trivial query (involving a join) from Access against PostgreSQL, the result was a never-ending cursor animation. It seems that Access fetches *all* records from the database and runs the query locally. You must not use the built-in JET engine with Access. HSQL is an excellent platform independent database engine but you must not embed HSQL in extensions which are installed and repackaged every time you open or close the so called database document. Embedding databases anywhere is imho nonsense. Database *content* can imho be passed around between users in a pretty fool-proof way as a zipped SQL dump, if required. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: documentation for LO base
Am 06.10.2012 21:34, Wolfgang Keller wrote: Huh? Access is a pathological data shredder. Not as bad as Base's default type of database. This part of Base is not even a valid proof-of-concept. The whole concept is dysfunctional by design and nobody dares to stop this madness. Just like MSAccess, Base is extremely useful as a frontend for database engines. You must not use the built-in JET engine with Access. HSQL is an excellent platform independent database engine but you must not embed HSQL in extensions which are installed and repackaged every time you open or close the so called database document. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: documentation for LO base
The ultimate guide by Mariano Casanova: http://www.scribd.com/doc/48635562/Base-Tutorial-OOo -- View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: documentation for LO base
I think one of the guys who is writing the Base documentation for OpenOffice, and converting it to LO, is a very busy person and it is taking him a lot of time to do the work for OpenOffice and does not have as much time to convert each finished chapter to LO. It also takes other people to look over the work and proofread and test out what is stated. There seems not to be enough Base people who are able/willing to help with this hard process. It seems that Draw and Base are the two more difficult modules to write guides for, with Base being the hardest. Question: How many people do you know use Base, or have tried to use Base? Then ask the same for Writer, Calc, Impress, Draw, and then Math. I rarely use anything other than Writer or Calc, for LO's suite. On 10/04/2012 09:01 AM, Tom Davies wrote: Hi :) Thanks :) I just added it to the list in the Publications page https://wiki.documentfoundation.org/Documentation/Publications#Base Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 13:09 Subject: [libreoffice-users] Re: documentation for LO base The ultimate guide by Mariano Casanova: http://www.scribd.com/doc/48635562/Base-Tutorial-OOo -- View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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