Thought I’d install Gambas to work with SQLite3 databases. However when I typed gambas3 I was told to sudo apt install gambas3-ide. And tht resulted in gbr3: unable to load component: gb.form.print. Googled to find the answer (a tad more packages)…
sudo apt-get -y install gambas3 gambas3-gb-form-print gambas3-gb-gtk-opengl gambas3-gb-gtk3 gambas3-gb-gui-opengl gambas3-gb-gui-qt gambas3-gb-gui-qt-webkit gambas3-gb-gui-trayicon gambas3-gb-libxml
gambas3-gb-option gambas3-gb-report gambas3-gb-sdl gambas3-gb-sdl-sound gambas3-gb-v4l gambas3-templates gambas3-gb-qt5 gambas3-gb-qt5-ext gambas3-gb-qt5-opengl gambas3-gb-qt5-webkit
This seemed to work! However it was v3.14…
I wanted the current version 3.17.3 so…
I followed this to add the PPA
Then typed…
sudo apt install gambas3
It bombed at the end with
dpkg: error processing archive /var/cache/apt/archives/gambas3-ide_3.17.3+git202207211120.ed4736ca5+build16~ubuntu20.04.1_all.deb
(–unpack):
trying to overwrite ‘/usr/share/gambas3/template/console/.directory’, which is also in package gambas3-runtime 3.14.3-2ubuntu3.1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Thanks to this solution I typed…
sudo dpkg -i –force-overwrite /var/cache/apt/archives/gambas3-ide_3.17.3+git202207211120.ed4736ca5+build16~ubuntu20.04.1_all.deb
And finally…
sudo apt -f install
And Success!
I was then able to successfully start the latest (3.17.3) gambas3
This tutorial is for Gambas Version2. But it mentions here, that newer version of Gambas also work with SQLite version 3. So it might be a place to start.
Other useful and potentially better links:
https://gambaswiki.org/wiki/howto/databasesqlite
http://forum.gambas.one/viewtopic.php?t=546