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

Le 09/03/2016 10:43, Ian Whitfield a écrit :

Hi Ian,

Database and re-designing your Forms etc. This has happened repeatedly
with the embedded engine and also with the MySQL engine.

I'm sorry, but crashing and subsequent corruption of an ODB file that
links to a mysql database does not lead to dataloss of the linked mysql
db, or at least it shouldn't if you know how to manage your mysql db. At
worst, you can mess up your forms, lose your query definitions and
report setups, but that's about it. Yes, with embedded hsqldb, dataloss
is a known problem, but not with an external database.

As far as I'm concerned there is basic unstability in Base itself which
makes it unusable on a day-to-day basis!!
This was why I was wanting to try another route.

I tried Kexi but it is still to early in its development to be reliable.
I wanted to try Glom but it is unavailable on my OpSys (PClinuxOS).
So I was hoping to try a simpler option of Calc plus a Form.

Why not separate out your forms from the ODB file if you are concerned
about the stability of the ODB file itself ? It is perfectly possible,
you can still link to a mysql db and you won't have the issues of
screwing up your ODB just because the power goes off, or your network
goes down, or some other life-event that seems to befall computer users
on a daily basis.

You could look at Dabo (a python based UI interface to mysql dbs), or
webforms using Ruby, Rails, or PHP. They all require some kind of effort
to obtain a "usable" solution. Even the MySQL UI admin tool has a simple
Form view mode, where you can enter data in what looks like a form -
sophisticated it isn't, but it works !


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.