A short little Gambas review

Gambas is a Visual Basic like programming environment for Linux. I did some consulting work with MS-Access which used VB. So this would be handy to access small databases I might create on Linux in SQLite3. Actually SQLite3 would have no problems working with one million records. However SQLite3 wouldn’t be a great choice for a multi-user database. But Gambas can connect with real SQL databases also. With Gambas combined with SQLite you could create some fairly portable applications between Linux’s.

I found a Gambas folder on a USB flash drive. And it had a few sub folders from 2017. So I did do something with it 5 years ago.

Here is an advanced : ) GUI interface I created…

What’s most interesting to me is how Visual Basic like the simple button click me code is.

This is much more interesting…

A live connection to a SQLite3 dogs database. You can see the other tables also. I red boxed the above because I went back and had some trouble locating the project. At startup I was shown this…

Sure it’s obvious now.

Oh the possibilities. However I really should concentrate on my Udemy Go course right now.

Where did Gambas go?

I installed it recently…just 12 days ago and didn’t really do much with it at the time. And today, I decided I’d look at it and it’s nowhere to be found. Totally gone. Not in the programming menu or terminal. Typing gamb+TAB shows nothing. Very very strange! The PPA is still there.

So I typed (as per my above instructions)…

sudo apt update
sudo apt install gambas3

and…

It Worked…again!

except no errors…like last time.

Here’s proof. Same as I already saw 12 days ago

Dogs, PHP and family

I always had a love for animals, but especially dogs. My grandfather bought me this book (see below) from Bennett’s Drug Store in Miami when I was a young boy. I bought many expensive dog books since then but this cheap little paperback book holds a special meaning for me. I poured over this book for many hours back then. Memorizing facts about German Shepherds, Dobermans, Bull Mastiffs and many others. I always wanted a Bull Mastiff but shied away from large breeds because of their shorter lifespan. My parent’s encouraged me in everything and would take me to dog shows even when vacationing in North Carolina. My mom especially, because my dad was often working or resting on the weekend from work. I spent much of my allowance and lawn-mowing money on dog books since then. And checked out many books from the library that my mom would frequently drive me to.

So one of the 1st databases I created was dog stats. In MS-Access back then and later in SQLite and MySQL for the webserver. In the early 2000’s I was thinking of projects to learn PHP and use some basic HTML, so of course I thought of dogs. And I created Dog-Size way back then. It looks dated today. And I don’t really update it anymore because people “create” dog breeds on a whim these days. I don’t make money from it and I’m sure it isn’t accessed very often. But it was a good project to learn PHP. I wouldn’t really consider myself a PHP programmer these days. Looking back, I think my PHP code was pretty bad back then. But it has mostly been online for ~20 years at this point.

Occasionally I have to learn just enough PHP to update my code to run on newer versions of PHP.

Copyright listed from 1964-1968

Amazon needs negative search option like Google

Searching for “analog electric clock” is that so hard? Apparently yes! Page after page of digital battery clocks, and analog battery clocks. I tried “-battery” but doesn’t work. Apparently negative search use to work. I can think of many hard programming tasks…but this is not one of them! I guess I’ll have to wait for some Amazon developer to need this before it’s fixed.

BTW, I want a analog electric clock so I can tell how long my power has been off if I’m not there.

I’m editing this a few weeks later after watching “Super GOOGLE: Top 12 Advanced Search Techniques” from Dave’s Garage. So addressing the title…use google! Prefix google search with site:amazon.com along with other Google options for a much better search results..