Re: [libreoffice-users] Set JRE in LibreOffice

[Robert Großkopf]

Hi Tom,

> Is anyone here in the MariaDb or MySql communities?  Is there any chance of
> attracting some of their devs to work on an Open Source connector or better
> yet to work with our devs to create native support?

There is a native connector available for MySQL/MariaDB:
https://extensions.libreoffice.org/extensions/mysql-native-connector


I have tested both, native connector and JDBC. Have forgotten what I
missed in native-connector and works in JDBC, but decided to take
JDBC-connector instead.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Set JRE in LibreOffice

[Robert Großkopf]

Hi Girvin,

> 
> To create the relationships, I use the "Queries" "Database" option of
> Base and the "Tasks" options. I prefer to start with the "Create Query
> in Design View" to do most of the work. 

Seems you create the relation between tables in queries. That is not the
way to create relationships in databases. It doesn't define foreignkeys
to other tables and the behavior of a database, which should be done
when loosing the value for the foreignkey of the other table.

MyISAM-tables are a part of MySQL/MariaDB. If you have created a
database you could connect with Base to the database. You could create
tables. All this tables, which are created by GUI, are MyISAM-tables.
And this tables doesn't have functionality for creating relationships.
So Base says, when opening Tools > Realtionships: "Your database doesn't
allow to create relationships".

You have to create Innodb-tables to create such relationships with
foreignkeys. And this isn't supported by the GUI of Base. You have to do
it in direct SQL or with other tools.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: [MariaDB Announce] MariaDB 10.3.7 now available

[Tom Davies]

Hi :)
Good timing! :)

MariaDb announce release of new stable release.
Regards from
a Tom :)

On Sun, 27 May 2018 20:16 MariaDB Announce List, 
wrote:

> The MariaDB Foundation is pleased to announce the availability
> of MariaDB 10.3.7.
>
> This is the first stable release in the MariaDB 10.3 series.
>
> See the Release Notes and Changelogs for details.
>
>
> - - Links  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
> MariaDB 10.3.7
>- Release Notes: https://mariadb.com/kb/en/mdb-1037-rn/
>- Changelog: https://mariadb.com/kb/en/mdb-1037-cl/
>- Downloads: https://downloads.mariadb.org/mariadb/10.3.7
>
>About MariaDB 10.3:
> - https://mariadb.com/kb/en/what-is-mariadb-103/
>
>APT and YUM Repository Configuration Generator:
> - https://downloads.mariadb.org/mariadb/repositories/
>
>
> - - MariaDB Books  - - - - - - - - - - - - - - - - - - - - - - - - - -
>
> There is an ever-growing library of MariaDB books available to help
> you get the most out of MariaDB. See the MariaDB Books page for
> details and links:
>
>- https://mariadb.com/kb/en/mariadb/books/
>
>
> - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - -
>
> MariaDB includes a User Feedback plugin. This plugin is disabled by
> default. If enabled, it submits basic, completely anonymous MariaDB
> usage information. This information is used by the developers to
> track trends in MariaDB usage to better guide development efforts.
>
> If you would like to help make MariaDB better, please add
> "feedback=ON" to your my.cnf or my.ini file!
>
> See http://mariadb.com/kb/en/user-feedback-plugin for more
> information.
>
>
> - - Quality  - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
> The project always strives for quality, but in reality, nothing is
> perfect. Please take time to report any issues you encounter at:
>
>- http://jira.mariadb.org
>
> Note that the bug tracker is not a support channel. If you are
> running MariaDB in an enterprise environment, please consider paying
> for support and related services from a commercial company:
>
> - https://mariadb.org/about/service-providers/
>
> MariaDB is a true open source project. We welcome everyone's
> contributions, be it by testing, submitting good bug reports,
> debugging and writing code, writing documentation or in any other
> way that helps to make the MariaDB server and related
> software ever better.
>
>- https://mariadb.org/get-involved/
>
>
> We hope you enjoy MariaDB!
>
> --
> MariaDB Foundation
>   Website - http://mariadb.org
>   Twitter - http://twitter.com/mariadbfdn
>Knowledge Base - http://mariadb.com/kb
> ___
> announce mailing list
> annou...@mariadb.org
> https://lists.askmonty.org/cgi-bin/mailman/listinfo/announce
> To unsubscribe, send an email with "unsubscribe" as the Subject: to
> announce-requ...@mariadb.org

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] overlap(?) objects in draw

[Tom Davies]

Hi :)
It wasn't me
Regards from
a Tom :)

On Sun, 27 May 2018 22:54 anne-ology,  wrote:

>curiously wondering why you deleted the message to which I was
> replying???;
>   to make what point???
>
>The initial messager was interested in knowing how to create a 3D
> drawing of interlocking tubes;
>   that can be easily be done by hand; even if it's done to
> architectural scale.
>
>
>
>
> From: Regina Henschel 
> Date: Sun, May 27, 2018 at 1:14 PM
> Subject: Re: [libreoffice-users] overlap(?) objects in draw
> To: users@global.libreoffice.org
>
>
> Hi anne-ology,
>
> anne-ology schrieb am 27.05.2018 um 19:45:
>
>The best method can't be done with these computers - I've tried LOs,
> > as well as others, only to be disappointed yet again;
> >   so my suggestion would be to draw what you have in mind,
> >  then scan this into your machine;
> >  you'll then have what you've imagined.
> >
> >BTW - even expert cartoonists, as Disney's, have not been able to
> > find a machine to make drawings better than the artist;
> >   for proof, just compare Disney's animated films - the
> hand-drawn
> > ones are so superior to the computer robotic movements
> >
>
>
>
>
> You disregard the point, that Draw is a tool for construction of vector
> graphics. It is not a tool for painting. So do not blame Draw for not been
> able to do, for which it is not designed.
>
> Kind regards
> Regina
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] overlap(?) objects in draw

[anne-ology]

   curiously wondering why you deleted the message to which I was
replying???;
  to make what point???

   The initial messager was interested in knowing how to create a 3D
drawing of interlocking tubes;
  that can be easily be done by hand; even if it's done to
architectural scale.




From: Regina Henschel 
Date: Sun, May 27, 2018 at 1:14 PM
Subject: Re: [libreoffice-users] overlap(?) objects in draw
To: users@global.libreoffice.org


Hi anne-ology,

anne-ology schrieb am 27.05.2018 um 19:45:

   The best method can't be done with these computers - I've tried LOs,
> as well as others, only to be disappointed yet again;
>   so my suggestion would be to draw what you have in mind,
>  then scan this into your machine;
>  you'll then have what you've imagined.
>
>BTW - even expert cartoonists, as Disney's, have not been able to
> find a machine to make drawings better than the artist;
>   for proof, just compare Disney's animated films - the hand-drawn
> ones are so superior to the computer robotic movements
>




You disregard the point, that Draw is a tool for construction of vector
graphics. It is not a tool for painting. So do not blame Draw for not been
able to do, for which it is not designed.

Kind regards
Regina

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Set JRE in LibreOffice

[Girvin Herr]

On 05/26/2018 11:47 PM, Robert Großkopf wrote:

Hi *,

I 'm using the internal database for deveopement of databases, with
pupils in scool and for some little projects, which only need a
standalone-database. For "normal" use I also prefer MariaDB. The native
driver had some (little) problems here so I switched to JDBC. I am using

jdbc:mysql://«hostname»:3306/«databasename»?autoReconnect=true

to connect to MariaDB and don't loose the connection to the server.

Problem for MariaDB/MySQL: You have to know much about SQL or you must
create the tables with PHPMyAdmin or something else for using
Innodb-tables and create relationships between them.

Regards

Robert

Robert,
Your "Problem for MariaDB/MySQL" has not been my experience. Yes, LO 
will not create the database. That must be done with the MariaDB/MySQL 
tools. I use the "mysql" tool and the "GRANT" and "CREATE DATABASE" 
commands to create my empty database. As you say, there are other tools 
available to do this. Use whatever tool fits your "hand". After the 
database is created, Base can be used to do all the rest: create tables, 
add relationships, etc. I did need to learn a bit of SQL to do some 
sorting of lists (tables) so they are alphabetically listed in the forms 
I made. I found the book "Teach Yourself SQL in 24 Hours" by Ryan 
Stephens and Ron Plew, published by Sams, to be of value to me.


To create the relationships, I use the "Queries" "Database" option of 
Base and the "Tasks" options. I prefer to start with the "Create Query 
in Design View" to do most of the work. In this option, the screen has 
two main windows. The top window is for adding tables and relationships. 
The bottom window is for specifying the Query output fields. Then, 
instead of specifying the table directly in a form or report data 
source, I reference the query for the form or report's data source 
input. This part of Base is very nice to use. Base then creates the SQL 
for you. If you really need to see or edit the SQL for the query, you 
can do that by editing in SQL mode. You can switch between the SQL 
editing mode and the "Design" editing mode with the Turn Design View 
Off/On icon. You can even "Run" the SQL or design to verify the output 
is what you expected with the "Run Query" icon. Slick.


BTW: I am currently running Mariadb 10.0.34 with mysql-connector-java 
5.1.42 and LO 5.3.4 and AOO 4.1.5 under Slackware Linux 14.2 
(k4.4.118_smp). I have a database with many tables and relationships and 
several Base forms for data entry/maintenance on each table. I have 
several reports with different data sorting to sort the table data by 
different fields. Each report and form has their own query. Several of 
my tables have thousands of records. Most of my tables contain critical 
inventory data that I need in my work. So, my Base usage is not trivial 
and losing it, including the report generation, would be painful to me.


HTH.
Girvin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] How to display AutoFilter filter criteria?

[Alan B]

When I set up a spreadsheet with AutoFilter I often insert a row at the top
to show how many rows are displayed by the current filter, e.g. ="Rows
displayed - " & SUBTOTAL(103,A3:A2)

Now I'm trying to find a way to display the criteria used by the AutoFilter.

e.g. "Rows displayed - " & SUBTOTAL(103,A3:A2) & " - filter applied:
"

Obviously could use an Advanced Filter and create some formula to produce
the  element above.

Am hoping to find a way to inspect the conditions used in the AutoFilter
and append them to the "Rows displayed..." legend.

Any suggestions?

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] overlap(?) objects in draw

[Tom Davies]

Hi :)
I had a good run with Inkscape for a while.  Again it's vector graphics
rather than 3d modelling.  It was a bit mind-warping at first because it's
so different from Gimp/Photoshop.

For 3d how about "Sketch-up";
https://www.sketchup.com/

It's not OpenSource afaik but the free version is pretty good and kinda
intuitive(ish).  I suspect the paid vedsion is better but the free one did
everything needed.
Regards from
a Tom :)


On Sun, 27 May 2018 19:16 Regina Henschel,  wrote:

> Hi anne-ology,
>
> anne-ology schrieb am 27.05.2018 um 19:45:
> >The best method can't be done with these computers - I've tried
> LOs,
> > as well as others, only to be disappointed yet again;
> >   so my suggestion would be to draw what you have in mind,
> >  then scan this into your machine;
> >  you'll then have what you've imagined.
> >
> >BTW - even expert cartoonists, as Disney's, have not been able to
> > find a machine to make drawings better than the artist;
> >   for proof, just compare Disney's animated films - the
> hand-drawn
> > ones are so superior to the computer robotic movements.
>
> You disregard the point, that Draw is a tool for construction of vector
> graphics. It is not a tool for painting. So do not blame Draw for not
> been able to do, for which it is not designed.
>
> Kind regards
> Regina
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

On 27 May 2018 19:16, "Regina Henschel"  wrote:

Hi anne-ology,


anne-ology schrieb am 27.05.2018 um 19:45:
>The best method can't be done with these computers - I've tried
LOs,
> as well as others, only to be disappointed yet again;
>   so my suggestion would be to draw what you have in mind,
>  then scan this into your machine;
>  you'll then have what you've imagined.
>
>BTW - even expert cartoonists, as Disney's, have not been able to
> find a machine to make drawings better than the artist;
>   for proof, just compare Disney's animated films - the hand-drawn
> ones are so superior to the computer robotic movements.

You disregard the point, that Draw is a tool for construction of vector
graphics. It is not a tool for painting. So do not blame Draw for not
been able to do, for which it is not designed.

Kind regards

Regina


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] overlap(?) objects in draw

[Regina Henschel]

Hi anne-ology,

anne-ology schrieb am 27.05.2018 um 19:45:

   The best method can't be done with these computers - I've tried LOs,
as well as others, only to be disappointed yet again;
  so my suggestion would be to draw what you have in mind,
 then scan this into your machine;
 you'll then have what you've imagined.

   BTW - even expert cartoonists, as Disney's, have not been able to
find a machine to make drawings better than the artist;
  for proof, just compare Disney's animated films - the hand-drawn
ones are so superior to the computer robotic movements.


You disregard the point, that Draw is a tool for construction of vector 
graphics. It is not a tool for painting. So do not blame Draw for not 
been able to do, for which it is not designed.


Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Set JRE in LibreOffice

[Tom Davies]

Hi :)
Is anyone here in the MariaDb or MySql communities?  Is there any chance of
attracting some of their devs to work on an Open Source connector or better
yet to work with our devs to create native support?

I tried asking the MariaDb people around the time they forked off from the
Oracle overlords but I'm really bad with people and they were quite busy.

Someone in the Postgresql community did a fantastic job of getting their
devs and our devs working together a few years ago and so LibreOffice
apparently connects to LO really neatly.

Regads from
a Tom :)

On Sat, 26 May 2018 20:58 H. Stoellinger,  wrote:

> Hi Girvin,
> The same as you I have used MySQL/MariaDB with OO/LO for at least a
> decade. Before that
> I looked after DB2 (Mainframe...) as an IBM-Systems Engineer. I also
> cave been using the
> JDBC-connector happily. One of the problems I encountered with the
> "native" connector
> was the absence of a capability to reconnect to my remote server after
> an activity timeout
> occurred (the server would allow me to increase the timeout specified).
> In any case - I feel that a connection to an external database server
> should continue to be
> available. One reason - databases in enterprises tend to be used by more
> than just ONE
> application system...
> Just my two cents worth...
> Regards from Salzburg
> H. Stoellinger
>
> On 2018-05-26 21:15, Girvin Herr wrote:
> >
> >
> > On 05/26/2018 02:59 AM, Tom Davies wrote:
> >> Hi :)
> > Snip
> >> Base is supposed to MUCH better when using an external back-end -
> >> it's what
> >> Base was originally designed for and it's where Base beats Access.
> >> Annoyingly that seems to be a little known fact that doesn't get
> >> picked up
> >> on by people marketing LO.  Oddly hsqldb as an external back-end (ie
> >> installing the most recent version into the OS and getting it from the
> >> hsqldb project themselves, instead of using the old twisted version
> >> hard-coded into LO) tends to be quite fantastic - but it is totally
> >> dependent on Java and Java is a nightmare. So the move away from the
> >> twisted old version of hsqldb to firebird is great news.
> > Snip
> >
> > Hi Tom,
> > History lesson as I remember it: I suppose OO/AOO/LO wanted a built-in
> > database engine to better compete with Access, which had the Jet
> > engine built-in. Choosing hsqldb must have had its reasons back then.
> > Going back before OO, StarOffice had its own built-in database engine,
> > Adabase D, but I never could get it to work. (Granted, I was a
> > database newbie back then and my problems may not have been
> > StarOffice's fault.) I was glad to get OO (back then) working with
> > MySQL about 2005. BTW: I think there was a crude and circuitous way to
> > get Access 1.1 to talk to an external database server via a
> > "connector" system. But I never tried to do it before I converted my
> > databases to MySQL and never looked back.
> >
> > My experience: I have always used LO with MySQL as my backend (aka
> > server) with the Java connector between them. Actually, I am now using
> > Mariadb, as this is what Slackware Linux distributes now. I have not
> > had any problems with my database system, after the initial
> > configuration learning curve. It works. Therefore, hsqldb and now the
> > proposed switch to the firebird backend are a non-issue for me, as
> > long as LO will continue to support the external server paradigm. But
> > that is me. Others may require the built-in engine paradigm.
> >
> > For years, LO, has been reporting an imminent built-in (aka "native")
> > support for MySQL so that the Java connector is no longer needed.
> > However, that functionality seems to be another myth.
> >
> > Girvin Herr
> >
> >
> >
>
> --
> Gruesse aus Fuerstenbrunn
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] overlap(?) objects in draw

[anne-ology]

   The best method can't be done with these computers - I've tried LOs,
as well as others, only to be disappointed yet again;
  so my suggestion would be to draw what you have in mind,
 then scan this into your machine;
 you'll then have what you've imagined.

   BTW - even expert cartoonists, as Disney's, have not been able to
find a machine to make drawings better than the artist;
  for proof, just compare Disney's animated films - the hand-drawn
ones are so superior to the computer robotic movements.



From: Albert Oszkó 
Date: Tue, May 22, 2018 at 11:43 AM
Subject: [libreoffice-users] overlap(?) objects in draw
To: users 


Hi all,

I've never used Draw up to now, but I got a task and thought I could do it
with that. I am reading and viewing tutorials but did not find the method
for the following: how to overlap, combine, or be it called something else,
two objects.

I mean for example: how can I draw a tube that is pushed into a ring. Ok, I
could do it by drawing two tubes, one is above, the other is below the
ring, but can it be done in a simpler and cleverer way?

Thanks: Albert

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Set JRE in LibreOffice

[Tom Davies]

Hi :)
I hadn't realised the Firefox was previously called "Mozilla Firebird"
after being forced to rename itself from Phoenix due to name infringement
with "Phoenix Technologies".  Annoyingly for them Firebird was also taken
but they were was less hostile to Firefox about possible name
infringement.

Of course you know Firefox used to be Netscape which was (ime) far, far
better than any other web-browser but lost a marketting war with
Microsquish.  I just hadn't known about the intermediate names Firefox went
through around 20 years ago.

Ironically LibreOffice uses the "Mozilla License" as well as the LGPL and
now is going to be using the Firebird product that kinda pushed Mozilla
into having to rebrand themselves a 3rd time!

I think it shows that moving away from MS is a move towards a much more
co-operative but still competitive free-trade market.  Also that these
young revolutionary anti-corporate new upstarts are actually decades-old
companies/communities.  Instead of getting bogged down into a kludgy
unweildy mess, 'we' have remained innovative and fresh by allowing each
community to retain it's indepence and focus.

Regards from
a Tom :)

On Sun, 27 May 2018 10:15 Tom Davies,  wrote:

> Hi :)
> Access can be forced into using an external database and some people claim
> it's easy but it makes a kludgy mess that makes it difficult and risky to
> update Access.  It pushes people into buying other M$ database programs if
> they need to upscale an Access database.  Access just is not designed to be
> used that way.  Base is.
>
> Java was widely advertised as being by far the best and sometimes as the
> only way to write code that could be used on any machine using any OS.
> Even today there are many expensive training courses teaching people how to
> use it.  It's still kinda like "The Emporer's New Clothes".
>
> Hsqldb is an excellent fast and light database program but it needs to be
> kept updated, just like any program.  The version hard-coded into LO can't
> be updated and is stuck on some ancient transitional version.  The
> hard-coding was allegedly done by just 2 people without the support of the
> Hsqldb community and against the wishes of LO's former, former, former
> owners and community - however it did make it more competitive with
> Access.  So it was a heroic effort and should have been supported and
> applauded.
>
> Future iterations of the in-built hsqldb(ish) were probably envisaged as
> being closer to proper Hsqldb and as being made easier to update -
> but without the support of either community or their leadership the code
> just stagnated for a few decades instead.  People sniping at each other and
> pulling in opposing directions rather than helping and supporting each
> other doesn't always work well.
>
> The main reasons I really like the move to Firebird are;
> 1.  The name is more excitingly fashionable and easier to market
> 2.  Tactically good to have a refreshing break from our tragic past
> regardless of whether it might have been easier and more consistent to just
> upgrade to a newer, easier to upgrade, purer version of Hsqldb.  (Oddly it
> would have been harder to go with Hsqldb and there discussions about which
> way to go.)
> 3.  The move to C++ and away from Java - even though it's a step backwards
> to a more geeky, less marketable name.
>
> It is really great to see Base getting some much needed love and tlc.  It
> deserves it.
>
> Regards from
> a Tom :)
>
>
>
>
>
>
>
> On Sun, 27 May 2018 07:51 Robert Großkopf, 
> wrote:
>
>> Hi *,
>>
>> I 'm using the internal database for deveopement of databases, with
>> pupils in scool and for some little projects, which only need a
>> standalone-database. For "normal" use I also prefer MariaDB. The native
>> driver had some (little) problems here so I switched to JDBC. I am using
>>
>> jdbc:mysql://«hostname»:3306/«databasename»?autoReconnect=true
>>
>> to connect to MariaDB and don't loose the connection to the server.
>>
>> Problem for MariaDB/MySQL: You have to know much about SQL or you must
>> create the tables with PHPMyAdmin or something else for using
>> Innodb-tables and create relationships between them.
>>
>> Regards
>>
>> Robert
>> --
>> Homepage: http://robert.familiegrosskopf.de
>> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>
> On Sun, 27 May 2018 07:51 Robert Großkopf, 
> wrote:
>
>> Hi *,
>>
>> I 'm using the internal database for deveopement of databases, with
>> pupils in scool and for some little projects, which only need a
>> 

Re: [libreoffice-users] Set JRE in LibreOffice

[Tom Davies]

Hi :)
Access can be forced into using an external database and some people claim
it's easy but it makes a kludgy mess that makes it difficult and risky to
update Access.  It pushes people into buying other M$ database programs if
they need to upscale an Access database.  Access just is not designed to be
used that way.  Base is.

Java was widely advertised as being by far the best and sometimes as the
only way to write code that could be used on any machine using any OS.
Even today there are many expensive training courses teaching people how to
use it.  It's still kinda like "The Emporer's New Clothes".

Hsqldb is an excellent fast and light database program but it needs to be
kept updated, just like any program.  The version hard-coded into LO can't
be updated and is stuck on some ancient transitional version.  The
hard-coding was allegedly done by just 2 people without the support of the
Hsqldb community and against the wishes of LO's former, former, former
owners and community - however it did make it more competitive with
Access.  So it was a heroic effort and should have been supported and
applauded.

Future iterations of the in-built hsqldb(ish) were probably envisaged as
being closer to proper Hsqldb and as being made easier to update -
but without the support of either community or their leadership the code
just stagnated for a few decades instead.  People sniping at each other and
pulling in opposing directions rather than helping and supporting each
other doesn't always work well.

The main reasons I really like the move to Firebird are;
1.  The name is more excitingly fashionable and easier to market
2.  Tactically good to have a refreshing break from our tragic past
regardless of whether it might have been easier and more consistent to just
upgrade to a newer, easier to upgrade, purer version of Hsqldb.  (Oddly it
would have been harder to go with Hsqldb and there discussions about which
way to go.)
3.  The move to C++ and away from Java - even though it's a step backwards
to a more geeky, less marketable name.

It is really great to see Base getting some much needed love and tlc.  It
deserves it.

Regards from
a Tom :)







On Sun, 27 May 2018 07:51 Robert Großkopf, 
wrote:

> Hi *,
>
> I 'm using the internal database for deveopement of databases, with
> pupils in scool and for some little projects, which only need a
> standalone-database. For "normal" use I also prefer MariaDB. The native
> driver had some (little) problems here so I switched to JDBC. I am using
>
> jdbc:mysql://«hostname»:3306/«databasename»?autoReconnect=true
>
> to connect to MariaDB and don't loose the connection to the server.
>
> Problem for MariaDB/MySQL: You have to know much about SQL or you must
> create the tables with PHPMyAdmin or something else for using
> Innodb-tables and create relationships between them.
>
> Regards
>
> Robert
> --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

On Sun, 27 May 2018 07:51 Robert Großkopf, 
wrote:

> Hi *,
>
> I 'm using the internal database for deveopement of databases, with
> pupils in scool and for some little projects, which only need a
> standalone-database. For "normal" use I also prefer MariaDB. The native
> driver had some (little) problems here so I switched to JDBC. I am using
>
> jdbc:mysql://«hostname»:3306/«databasename»?autoReconnect=true
>
> to connect to MariaDB and don't loose the connection to the server.
>
> Problem for MariaDB/MySQL: You have to know much about SQL or you must
> create the tables with PHPMyAdmin or something else for using
> Innodb-tables and create relationships between them.
>
> Regards
>
> Robert
> --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Set JRE in LibreOffice

[Robert Großkopf]

Hi *,

I 'm using the internal database for deveopement of databases, with
pupils in scool and for some little projects, which only need a
standalone-database. For "normal" use I also prefer MariaDB. The native
driver had some (little) problems here so I switched to JDBC. I am using

jdbc:mysql://«hostname»:3306/«databasename»?autoReconnect=true

to connect to MariaDB and don't loose the connection to the server.

Problem for MariaDB/MySQL: You have to know much about SQL or you must
create the tables with PHPMyAdmin or something else for using
Innodb-tables and create relationships between them.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy