Use SQLite3 with LibreOffice Base in Fedora 38

LibreOffice Base requires the ODBC SQLite3 driver to be installed, but luckily it is in the repositories on Fedora.

This post is so far only helpful in some of the setup for using Base with SQLite. None of the usual options for creating primary keys are showing for the SQLite databases. Yet tables can be saved to the databases. Not sure if this is a problem with the specific driver, or a user malfunction, etc.

Why ODBC?

(Open Data-b-ase Connectivity)

SQLite3 developers might have programmed compliance specifically for the aging MS Access and/or LibreOffice Base applications. However, they chose general compliance with ODBC.

ODBC is a recognized, industry standard catch-all for compatibility between many relational databases. There is no such thing as a native ODBC relational database, as it is a connectivity API.

LibreOffice Base has compatibility with ODBC, as long as the system has the right ODBC drivers.

Stuff About Open Source Fonts and CSS/Base64

This is tentative information that I found useful for my preferences and use cases. It is not about advocating general practices, but it might be helpful to some people.

Manually Install Godot 4 on Fedora 37

This post is about installing/compiling the Godot Game Engine 4.x versions on Fedora. 

I maintain this post despite Godot having updated their instructions to apply to 4.x versions. You might prefer those instructions here.

Multimedia and Flatpaks in Fedora 37

Make Fedora have the cool stuff.

 

Tiddly Desktop on Fedora 35, 36

Install the official TiddlyWiki application on Fedora.

• View wikis separately from the browser
  
• Create wikis from personal templates
• Wikis open in individual windows
• External web links work to any browser

Fedora 35-37 Vulkan driver for some AMD GPUs

For AMD graphics cards between around 2012 and 2015, Fedora does not always correctly implement the amdgpu driver with Vulkan support for these cards.

 

Ubuntu i3 XFCE Final Hurrah

A way to get up and running with an i3 desktop with descent usability and visual appeal. Some people still prefer the other methods on the blog, which you might want to take a look at.

Lenovo Thinkstation C30 Linux EFI

The key to setting up the TS C30 for Linux is in changing the default efi entry to have the name "Windows Boot Manager".

This is done through the Linux program efibootmgr.

Ubuntu 20.10 i3 Workspaces Plugin Installation From Github

This guide is closer to a set of commands to build an installation script for i3ipc-glib and xfce4-i3-workspaces-plugin. It relates to this post here.

Python Install of Mnemosyne on Fedora 36/37

Menmosyne is an open source flashcard management application available on Linux. It is not included in the repos, probably because it asks for some form of data collection.

 

DeepSpeech and Python on Fedora 33

This is about performing an interesting demo of open source speech recognition on the command line. Deepspeech was being actively developed by Mozilla for a few years.

Python Environments on Fedora 33

How do you use an earlier version of Python for just one project?

Virtual Environments

Edit Connections in Fedora

Some network settings once found in the standard network connection editor are not present in the Gnome settings interface.

Tiddlywiki Sortable Static Tables

This is a cool hack for TiddlyWiki that allows all tables to be sorted with a browser page reload. However it does not lend any data capabilities to the tables.

Walkthrough for Lubuntu with i3 Tiling

The idea of this setup is to achieve the best of both worlds from convenient desktop features and essential i3 features.  This post uses LXQt, but this blog includes posts about XFCE and Sway instead of i3.

Xubuntu with i3 Tiling Windows Walkthrough

The idea of this setup is to achieve the best of both worlds from convenient desktop features and essential i3 features. See the Lubuntu version of this here.

Make a simple TiddlyWiki 'app' using Firefox

Edit: I don't think this works anymore. See the Tiddly Desktop installation post.