Connection to SQL database

users
#21

LibreOffice also contains a Logo variant called LibreLogo. There is also a LibreLogo help section, but I wants to learn a bit more about this interesting (and nostalgic?) programming language, but am not able to find any tutorials or other details about this language. Someone who know where I can find it?
Kolbjoern

#22

Update:

Thanks everyone for your help. I finally figured out how to access phpMyAdmin and then figured out how to "import" the data file properly. I then encountered lots of errors trying to export it but ultimately figured out a workaround. All seems to be fine now with a 13MB file, but next I've been given a 250MB file to open then export!

In any case, it ended up being easier to just work within MySQL and phpMyAdmin for this purpose, but I'll try to use Base to connect over the weekend just to learn it.

Anyway, thanks again, especially to Alex and Jay.

Carl

#23

Peter West

So his fame spread throughout all Syria...

Basically, I'm at a huge disadvantage b/c I don't understand ANY of the terms or tools. I'm watching a ton of videos and reading a ton of material. But being someone who has done a lot of teaching/tutoring, I have to say no one out there seems to know how to assume a user knows nothing but is still capable of learning. Too much is assumed in all the materials I find.

Carl, this is an endemic problem in _all_ software documentation. I don't know whether it's worse in this area than others, but it is in any case horribly difficult to remember what it is like not to know anything. We don't observe the steps by which we come to know something; we are too busy struggling to understand.

#24

Hi Carl,

figured out a workaround. All seems to be fine now with a 13MB file,
but next I've been given a 250MB file to open then export!

I'm glad you managed to get there in the end :slight_smile:

One word of warning - PHPMyAdmin via the file php.ini has a default cap
on the size of data it can import in one write operation - this is done
to prevent people crafting sql queries that could cause the server to
keel over, so-called denial of service attacks. The default limit is
something like 8Mb, so you might want to be wary of trying to import
even your 13Mb file, not to mention a 250Mb file, via that method, as
phpmyadmin will either fail, and/or truncate the data to the limit allowed.

For big data imports, you really ought to be using the mysql command line.

Alex

#25

Hi :slight_smile:
I've never heard of LibreLogo and have no idea about any tutorials for it!
Many apols and regards from
Tom :slight_smile:

#26

From the integrated help, search for 'Logo':

    Consulte http://www.numbertext.org/logo/librelogo.pdf

#27

Den 19.01.2014 21:51, skreiv Denis J Navas:

From the integrated help, search for 'Logo':

   Consulte http://www.numbertext.org/logo/librelogo.pdf

Yes, I recognized this, and it is a good start, but I hoped to find some more tips on using LibreLogo or even someone using it.
Tom: It looks like LobreLogo is one of the more or less hidden secrets of LibreOfice.
Kolbjoern

#28

Page 18 gives you the needed extension, but it gives you the 1.0 version by default. You need to click on the 2.0 release version to download that one.

I forgot about Logo. I remember seeing it over 20 years ago but never really had any need to learn it. For controlling a "robot", this would be the first step in learning how to move it the way you want to. I have a Robosapien X and it has controls for movement of left, right, forward, and back. So Logo can teach you how to think in terms of robot movement and then later "translate" what you learned to the type of movement a different "robot" uses, whether on wheels or legs. I still have not learn how to program my Christmas present to myself, i.e. the Robosapien X, since I have not had the time to do so.

#29

Den 20.01.2014 15:57, skreiv Kracked_P_P---webmaster:

Den 19.01.2014 21:51, skreiv Denis J Navas:

From the integrated help, search for 'Logo':

   Consulte http://www.numbertext.org/logo/librelogo.pdf

Yes, I recognized this, and it is a good start, but I hoped to find some more tips on using LibreLogo or even someone using it.
Tom: It looks like LobreLogo is one of the more or less hidden secrets of LibreOfice.
Kolbjoern

Page 18 gives you the needed extension, but it gives you the 1.0 version by default. You need to click on the 2.0 release version to download that one.

I am running LibreLogo on LibreOffice 4.2.0.2. Do not know which LibreLogo version. It is a part of the package, not an extension.
How to find LibreLogo in LibreOffice: View -> Toolbars -> Logo. Click on one of the icons on the Logo toolbar to get the turtle visible. In help, search for Logo and click on the "LibreLogo Toolbar".

I forgot about Logo. I remember seeing it over 20 years ago but never really had any need to learn it. For controlling a "robot", this would be the first step in learning how to move it the way you want to. I have a Robosapien X and it has controls for movement of left, right, forward, and back. So Logo can teach you how to think in terms of robot movement and then later "translate" what you learned to the type of movement a different "robot" uses, whether on wheels or legs. I still have not learn how to program my Christmas present to myself, i.e. the Robosapien X, since I have not had the time to do so.

Have fun with your robot. :slight_smile:
Kolbjoern