ssage
From: Tom Davies
Date:07/16/2014 7:48 AM (GMT-05:00)
To: Paul
Cc: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Adding fields to existing Base table
Hi :)
There is a big difference between theory and practice. That doesn't mean
either is wrong. Find
Interbase/Firebird etc are all fully competent relational databases, and
> so is HSQLDB far as I know, but things like MongoDB aren't. SQLite is a
> bit of an anomaly in that it doesn't really do all the stuff of a
> proper relational database behind the scenes, but it can still be
a
bit of an anomaly in that it doesn't really do all the stuff of a
proper relational database behind the scenes, but it can still be used
as one.
> Your database is only as good as your plan!
>
>
>
>
> Original message ----
> From: Girvin Herr
>
Herr
> Date:07/10/2014 4:17 PM (GMT-05:00)
> To: users@global.libreoffice.org
> Subject: Re: [libreoffice-users">libreoffice-users] Adding fields to existing
> Base table
>
> Dave,
> I use the MySQL server and have added table fields before. It is simple
> in the L
: Girvin Herr
Date:07/10/2014 4:17 PM (GMT-05:00)
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Adding fields to existing Base table
Dave,
I use the MySQL server and have added table fields before. It is simple
in the LO Base table design window.
Tables -> right click
Hi :)
Thanks! :) I think it's definitely good to learn more about what back-ends
are available and what they are each best for. Also good when FUD or just
misunderstandings can be cleared up. Thanks for that :)
Regards from
Tom :)
On 12 July 2014 05:42, Marion & Noel Lodge wrote:
> Hi Tom
Hi Tom,
In relation to the H2 database you said -
> I get the impression that H2 is also a small, fast one but could easily
be wrong.
All of my H2 databases would be classified as small, but a couple of years
ago an H2 user posted on the Users Group that inserts to his data base
slowed down sig
IanW,
I'm concerned with Base, but I have some things to put together for next
Fri. which will be the data in some report. No big deal - just a
starting point. Since time is tight, do you think I would be smarter to
continue with Base/HSQL, or go to Base as the front tend and MySQL or
MariaDB as
Hi :)
Actually HsqlDb from their own site is usually a huge improvement over the
internal back-end version and is apparently really good too. However i
think HsqlDb aims to be for small, light-weight but extremely fast
databases so it probably wouldn't suit this particular use-case. I get
the
On 07/11/2014 04:21 PM, dave boland wrote:
Thank you Noel. I will check this out. My head is spinning right now
with all of the choices. I need to get something together for next
Fri., so I'm going with LO Base for now. Seems like a decent choice
because I will be the only user for most of t
Thank you Noel. I will check this out. My head is spinning right now
with all of the choices. I need to get something together for next
Fri., so I'm going with LO Base for now. Seems like a decent choice
because I will be the only user for most of the rest of the year. Later
this year there ma
Hi Dave,
You might also like to have a look at the H2 Database Engine, see -
http://www.h2database.com/html/main.html
I have found that it is a good stable replacement for HSQLDB and have used
it in 6 different databases with good success. There is an active users
group, and some of them report
Hi :)
1st thing is that Base is best when used 'just' as a front-end and with all
the data in some back-end such as MySql/MariaDb, Postgresql, HsqlDb or
whatever.
Generally i think it should be possible to fill an existing field, in all
rows, by using an action Query. However, i am really surpris
Hi :)
Errr, actually, using your spreadsheets as the back-end might be a good way
of doing it. At least while you are still exploring and planning. Once
proper data starts coming in it's going to need a much heftier back-end.
One of the advantages of Base is that it can be swapped to reading a
d
All,
I want to thank all of you for your very helpful responses. Yes, it has
bee a long time since I have used databases. Last was about 10 years
ago when I used Access with SQL for a real time data acquisition system.
That was a challenge!
What I'm doing now is creating a database of data tha
Hi Dave,
Having worked as a business systems designer and coder, I've dealt with
databases and database changes a lot. And the users always end up
changing stuff later. Some of what I am going to say may be obvious or
stuff you already know; if so I apologise, but your question makes it
seem like
On Thu, Jul 10, 2014, at 03:51 PM, Tom Davies wrote:
Hi :)
1st thing is that Base is best when used 'just' as a front-end
and with all the data in some back-end such as MySql/MariaDb,
Postgresql, HsqlDb or whatever.
Generally i think it should be possible to fill an existing
field, in all rows,
Dave,
I use the MySQL server and have added table fields before. It is simple
in the LO Base table design window.
Tables -> right click on table -> select Edit
MySQL accepts these changes and adds the field. Of course, then you
must add the new field to your forms, queries, relationships and
I'm setting up a database that is small (three tables, may grow to 3GB
over next year). I need a strategy to deal with the unknown, which is
how to add fields to an existing table. I read in the docs that doing
this can be painful and it is required to put something in each field
for each record.
19 matches
Mail list logo
