[libreoffice-users] Base: Questions From Potential New User

2015-01-16 Thread Rich Shepard
Running LO-4.3.5 on Slackware-14.1. I am developing a database application to be used by unsophisticated users, all running some flavor of Windows. I've not before used Base so if I can it will make distribution easier than writing it in Python/wxPython and SQLite. I've read the Base handbook

Re: [libreoffice-users] Base: Questions From Potential New User

2015-01-16 Thread Florian Reisinger
Hi, From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Liebe Grüße / Yours, Florian Reisinger Am 16.01.2015 um 17:00 schrieb Rich Shepard rshep...@appl-ecosys.com: Running LO-4.3.5 on Slackware-14.1. I am developing a

Re: [libreoffice-users] Base: Questions From Potential New User

2015-01-16 Thread Rich Shepard
On Fri, 16 Jan 2015, Florian Reisinger wrote: From Base you can connect to your DB.. So no need to recreate anything. Base can be used to access the data in e.g. MySQL Florian, Yes, I read that. However, I do not see support for SQLite which is most appropriate for this application as it's

Re: [libreoffice-users] Base: Questions From Potential New User

2015-01-16 Thread Fernand Vanrie
Rich , Florian is pointing in to the good direction, just connect LO base tot SQLite, google for Openoffice and SLQLite for some starting points Greetz Fernand On Fri, 16 Jan 2015, Florian Reisinger wrote: From Base you can connect to your DB.. So no need to recreate anything. Base can be

Re: [libreoffice-users] Base: Questions From Potential New User

2015-01-16 Thread Rich Shepard
On Fri, 16 Jan 2015, Fernand Vanrie wrote: Florian is pointing in to the good direction, just connect LO base tot SQLite, google for Openoffice and SLQLite for some starting points Fernand, Thank you, I'll do that. I did not see sqlite mentioned as supported in the handbook. Of course, the

Re: [libreoffice-users] Base questions

2014-08-11 Thread Wolfgang Keller
This is one way Base is more powerful than Access. That's the whole point. By not focusing on promoting Base as *the* generic client-side FOSS tool for access to client-server RDBMs, they're missing a *HUGE* opportunity. And since Rekall has vanished (despite being GPL), there's not much in

Re: [libreoffice-users] Base questions

2014-08-06 Thread Rob Jasper
The weird thing is that Java is havely used in the Oracle databases. How com they can have quite reliable databases... Op 5 aug. 2014, om 15:35 heeft Tom Davies het volgende geschreven: Hi :) +1 I think Base nearly does do the best way around. The only problem is that the easiest thing,

Re: [libreoffice-users] Base questions

2014-08-06 Thread Wolfgang Keller
I know that its not LO base specific but can,t find a way how to or example of something like this. What i want using cars as example is to make a search for color,year,doors,model.kilometers driven,cabrio,engine,fuel and so many more options. Who can help me on my way how to set somthing

Re: [libreoffice-users] Base questions

2014-08-06 Thread Tom Davies
Hi :) An rtfm answer that DOES link to documentation is still a bit rude but i like this one. It's the links that make it really useful. Do these links go to the same place? https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook

Re: [libreoffice-users] Base questions

2014-08-06 Thread Paul D. Mirowsky
So, what appears to be happening is consensus that other database back-ends should be used. What is implied, is that Base does not have the ability to generate from a package, the selected external database of choice. 1. Is this correct? 2. Should it be corrected? 3. When generated, should

Re: [libreoffice-users] Base questions

2014-08-06 Thread Tom Davies
Hi :) i think that could get really confusing! At the moment internal means within Base itself and external means anywhere else. However the anywhere else is really quite a vast range of places! And the back-end could even be moved from one place to another with very little change in Base.

Re: [libreoffice-users] Base questions

2014-08-06 Thread jomali
Actually, it's just as easy to use Access as a front end to external DBMS' as it is to use Base. As long as an ODBC driver is available and registered in Windows, the external database looks like the native database. Just as in Base, the features of the external DBMS have to be exposed by the

Re: [libreoffice-users] Base questions

2014-08-05 Thread Rob Jasper
Op 4 aug. 2014, om 20:23 heeft Jean-Francois Nifenecker het volgende geschreven: Le 04/08/2014 18:59, dave boland a écrit : I'm getting a little confused. My understanding is that there are really two issues here. One is that LO Base is RAM resident - all updates are held in RAM until

Re: [libreoffice-users] Base questions

2014-08-04 Thread Wolfgang Keller
Average end-user is challenged enough just installing an O/S and productivity suite, and learning how to use them, much less a real RDBMS. PostgreSQL is pretty foolproof to install and use. I know what I am talking about since I am the reference fool. It may be something different if you need

Re: [libreoffice-users] Base questions

2014-08-01 Thread Tom Davies
-Original Message- From: Tom Davies [mailto:tomc...@gmail.com] Sent: 01 August 2014 00:09 To: Jean-Francois Nifenecker Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Base questions Hi :) All the database experts and many others of us keep on recommending using an external

Re: [libreoffice-users] Base questions

2014-08-01 Thread Wolfgang Keller
1. How robust are embedded Base files created by the GUI? With an embedded database, any bug in the application (doesn't even have to crash) can corrupt your data. With a client-server database, it's essentially impossible for the client to corrupt the data. 2. If they are not that reliable,

Re: [libreoffice-users] Base questions

2014-08-01 Thread Wolfgang Keller
All the database experts and many others of us keep on recommending using an external back-end such as Postgresql, MySql/MariaDb or anything else. The devs are working on removing the current warped and ancient version of HsqlDb and replacing it with Firebird. Using the embedded version of

Re: [libreoffice-users] Base questions

2014-08-01 Thread Jim Seymour
On Fri, 1 Aug 2014 12:55:48 +0200 Wolfgang Keller felip...@gmx.net wrote: [snip] I never understood why anyone halfway sane in their minds would use an embedded database anyway or why the developers of StarOffice/LO/OO even considered it. Convenience, with a dash of necessity. Average

Re: [libreoffice-users] Base questions

2014-08-01 Thread Tom Davies
Hi :) MS Access does it that way and therefore everyone else 'must' too. We can't sell Base by pointing out that it has huge advantages over Access. (One of those being that it's so much easier to connect it to an external back-end and is really kinda the default way of using Base). So we can

[libreoffice-users] Base questions

2014-07-31 Thread dave boland
All, Was reading the FAQ at https://wiki.openoffice.org/wiki/FAQ_%28Base%29 and came upon some insight that worries me. Under the heading So why should I avoid 'embedded databases'? it goes on to say the normal Base file is not reliable, so use a split file, the points to Microsoft docs. My

Re: [libreoffice-users] Base questions

2014-07-31 Thread Rob Jasper
If the normal Base file is not reliable, why do we have it in the first place? Either we (the community) must make it reliable, or we should abandon it and come with a reliable alternative. Not reliable is in fact not very acceptable. The documentation should describe when to use, and when not

Re: [libreoffice-users] Base questions

2014-07-31 Thread Jean-Francois Nifenecker
Hi Dave, Le 31/07/2014 21:22, dave boland a écrit : All, Was reading the FAQ at https://wiki.openoffice.org/wiki/FAQ_%28Base%29 and came upon some insight that worries me. Under the heading So why should I avoid 'embedded databases'? it goes on to say the normal Base file is not reliable,

Re: [libreoffice-users] Base questions

2014-07-31 Thread Jean-Francois Nifenecker
Le 31/07/2014 21:35, Rob Jasper a écrit : If the normal Base file is not reliable, why do we have it in the first place? Either we (the community) must make it reliable, or we should abandon it and come with a reliable alternative. Not reliable is in fact not very acceptable. The

Re: [libreoffice-users] Base questions

2014-07-31 Thread Tom Davies
Hi :) All the database experts and many others of us keep on recommending using an external back-end such as Postgresql, MySql/MariaDb or anything else. The devs are working on removing the current warped and ancient version of HsqlDb and replacing it with Firebird. Using the proper version of