Language Selection

English French German Italian Portuguese Spanish

today's leftovers

Filed under
Misc
  • MySQL data types: Know the ones to use and how

    When creating a table in a database, it should have both a name and a data type. A column’s data type defines the values the column holds, such as integer, money, binary, character, date, and time. Therefore, it is a developer’s task to determine which data types will be stored in each column while creating databases and tables.

    In simple terms, data types are guidelines that aid SQL in understanding what type of data is required inside a column. It is also efficient in identifying how SQL interacts with the stored data.

    A point to note is that data types might contain different names in different databases, and in cases where the names are the same, other aspects and details such as size will differ. Therefore, it is recommended that you always refer to documentation whenever you encounter similar cases.

  • Mozilla VPN Review [Ed: One paragraph before last shows that Mozilla does not actually do VPN; it's a reseller for some dodgy company, reusing the Firefox brand to sell a bunch of crap or upsell (likely bogus privacy or a ticking time bomb)]

    Mozilla VPN protects your privacy, and your subscription fee supports a proponent of a free internet. It's a simple service for anyone who needs a virtual private network, but it offers no bonus privacy tools beyond the VPN.

    [...]

    Mozilla VPN is not, strictly speaking, wholly a Mozilla project like Firefox. Instead of building and maintaining the infrastructure required for a consumer VPN, Mozilla found another company to partner with. During Mozilla's earliest forays into the world of VPNs, Mozilla courted Editors' Choice-winner ProtonVPN.

  • Dealing with burnout in open source [Ed: Sorry, IBM/Red Hat... but burnout is burnout and can happen to anybody, nothing to do with Free software ("open source"); this is as silly as your several articles about breakfasts for "open source people" (as if coding and software licences affect your diet). You've run out of topics. This Web site called Open Source dot com has become a lot of openwashing, IBM marketing and general non-tech articles being painted with the "open" crush to make it seem "tech".]

    Burnout is something you don't expect to happen to you—until it does. The technology industry is one of the worst offenders; over 60% of industry professionals report they've experienced burnout. Sixty percent! Chances are, you or someone you know has dealt with it. How can we tackle such a staggering burnout rate if those who make decisions about mental health barely know what burnout is, never mind how to prevent it?

  • Recently and soon in openSUSE #1

    Today (Saturday 31st of August, 17:00 UTC) is the third installment of the recently rejuvenated Community meetings! Taking place on Jist Meet, it will be an excellent opportunity to discuss and coordinate on solutions for improving things in the Project.

    One important topic will be openSUSE Membership, soon to be affected by the shutdown of connect-o-o.

  • Instructions: Cut videos with Kdenlive on Linux and Windows [Ed: Automated translation]

    A small clip for social media, a YouTube video about the last big trip, the hobby or even short film projects: the open source software Kdenlive is a versatile video editor that can be used to create very different videos. Getting started is pleasantly easy And if you want, you can also build small animations, add a subtitle track to the video and render it in the appropriate format for the desired publication platform.

    Lots of effects and transitions provide variety, a library saves clips that are used frequently so that they are quickly available in all projects. Generators produce clips with a countdown, white noise, or a test pattern. The Kdenlive user interface can be adjusted in detail so that everything goes quickly when editing video.

  • My Work on Documentation (June/July)

    After two month in documentation I can tell you this: documentation in general is quite alive and kicking. Smile From the outside you might see outdated content here and there, but there are quite a few people working on improving that. Of course, as most things, it is a never-ending effort and every helping hand is appreciated. If you are interested in helping, please talk to us on our mailing list. One of the more time-consuming tasks is currently porting documentation from TechBase to the new Developer Portal. It's basically copy&paste with some adjustments, so volunteers welcome Smile

    For me the time flew by blazingly fast. In the beginning ... there was Akademy, the first conference for me. It meant getting up at 7 to go to work, joining Akademy when I came back home and staying up till midnight or longer for the last talks or events to finish. Processing and carving out the outcome of the three documentation BoF sessions is still on my todo list.

    In the time before and since Akademy, I have been busy reading through several years of documentation improvement planning backlog and fixing lots of smaller issues in existing docs in the wikis and on the new Developer Portal. This also included cleaning up some outdated content (EBN has been decommissioned) and proofreading other people's documentation-related merge requests when asked to do so.

    Unfortunately, my first contribution to one of the website's Git repositories is still unmerged at the time of writing. I blame me for that not keeping track of my own merge requests. But it also shows one of the things we need to put more effort into: closing merge requests (one way or another). Also, check your own merge requests once in a while.

  • You can get Delver, Tower of Time and more in the Humble RPG Heroes Bundle | GamingOnLinux

    It seems Humble Bundle are starting to ramp-up their game bundles again and they have another with the Humble RPG Heroes Bundle that has some great games inside.

    The bundle is on the smaller side though but even so, what's there seems like a pretty good deal overall with some real indie gems included.

  • Using FSR To Boost Any Game’s Framerate on Linux

    Ever heard of the little war between AMD and Nvidia regarding upscaling technologies? Nvidia has DLSS (Deep Learning Super Sampling) and AMD has recently released FSR (FidelityFX Super Resolution).

    [...]

    On Linux, we have an extra opportunity to use FSR, without asking anyone to do anything. Proton already has a full screen hack upscaler included, which prevents Windows games from trying to change the current screen’s resolution. This hack instead uses a software upscaler pretending the resolution change is happening while remaining at the native monitor’s resolution. If an old game uses 800×600 as maximum resolution, the upscaler will fill your 1920×1080 screen by scaling up that tiny picture so that it fits in the larger monitor screen.

    Some folks have had the genius idea to simply replace the basic upscaler included in Proton by… AMD’s FSR! It makes it work out of the work on any game that uses Vulkan through ProtonGE – a benefit that Windows gamers can’t get for now!

    Of course, this is NOT how you are supposed to use FSR: ideally you want to apply FSR on a picture before the HUD and the post processing is applied, but still, it’s an acceptable usage of the upscaler, and provide massive performance boosts. You can see the video I published earlier today for Max Payne 3 and how much boost I can get from a meager Nvidia GTX 1060 3GB (with 470.x drivers), without much visual information loss (Using Proton-6.13-GE-1).

  • How microservices and containers work, apart and together

    CMicroservices and containers are two methods that enable companies to more efficiently create and deliver applications. Here's how they work -- and when they're best used together.

    Containers and microservices are related concepts that help companies design and adopt applications with speed, efficiency and flexibility. It's hard to talk about one without also talking about the other. Microservices and containers are distinct technologies -- they don't have to be used together, but they often are. Let's break down how each works, their key similarities and differences, and how an enterprise can use them in tandem.

    What are microservices?

    Microservices are individual units of software that combine to provide all of the functions required to run an application. Typically, each microservice handles a discrete type of functionality within an application. For example, one microservice handles logins, another generates the UI, another populates the interface with content specific to each user session and yet another interfaces with the database that stores user data.

    Until about 2010, most applications were monolithic designs in which the entire application ran as a single unit and, in most cases, as a single process. Prior to wide adoption of the internet and APIs, a service-oriented architecture (SOA) approach evolved to break applications into somewhat smaller pieces. However, the individual services within an SOA are typically not as small or dynamic as microservices.

More in Tux Machines

digiKam 7.7.0 is released

After three months of active maintenance and another bug triage, the digiKam team is proud to present version 7.7.0 of its open source digital photo manager. See below the list of most important features coming with this release. Read more

Dilution and Misuse of the "Linux" Brand

Samsung, Red Hat to Work on Linux Drivers for Future Tech

The metaverse is expected to uproot system design as we know it, and Samsung is one of many hardware vendors re-imagining data center infrastructure in preparation for a parallel 3D world. Samsung is working on new memory technologies that provide faster bandwidth inside hardware for data to travel between CPUs, storage and other computing resources. The company also announced it was partnering with Red Hat to ensure these technologies have Linux compatibility. Read more

today's howtos

  • How to install go1.19beta on Ubuntu 22.04 – NextGenTips

    In this tutorial, we are going to explore how to install go on Ubuntu 22.04 Golang is an open-source programming language that is easy to learn and use. It is built-in concurrency and has a robust standard library. It is reliable, builds fast, and efficient software that scales fast. Its concurrency mechanisms make it easy to write programs that get the most out of multicore and networked machines, while its novel-type systems enable flexible and modular program constructions. Go compiles quickly to machine code and has the convenience of garbage collection and the power of run-time reflection. In this guide, we are going to learn how to install golang 1.19beta on Ubuntu 22.04. Go 1.19beta1 is not yet released. There is so much work in progress with all the documentation.

  • molecule test: failed to connect to bus in systemd container - openQA bites

    Ansible Molecule is a project to help you test your ansible roles. I’m using molecule for automatically testing the ansible roles of geekoops.

  • How To Install MongoDB on AlmaLinux 9 - idroot

    In this tutorial, we will show you how to install MongoDB on AlmaLinux 9. For those of you who didn’t know, MongoDB is a high-performance, highly scalable document-oriented NoSQL database. Unlike in SQL databases where data is stored in rows and columns inside tables, in MongoDB, data is structured in JSON-like format inside records which are referred to as documents. The open-source attribute of MongoDB as a database software makes it an ideal candidate for almost any database-related project. This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of the MongoDB NoSQL database on AlmaLinux 9. You can follow the same instructions for CentOS and Rocky Linux.

  • An introduction (and how-to) to Plugin Loader for the Steam Deck. - Invidious
  • Self-host a Ghost Blog With Traefik

    Ghost is a very popular open-source content management system. Started as an alternative to WordPress and it went on to become an alternative to Substack by focusing on membership and newsletter. The creators of Ghost offer managed Pro hosting but it may not fit everyone's budget. Alternatively, you can self-host it on your own cloud servers. On Linux handbook, we already have a guide on deploying Ghost with Docker in a reverse proxy setup. Instead of Ngnix reverse proxy, you can also use another software called Traefik with Docker. It is a popular open-source cloud-native application proxy, API Gateway, Edge-router, and more. I use Traefik to secure my websites using an SSL certificate obtained from Let's Encrypt. Once deployed, Traefik can automatically manage your certificates and their renewals. In this tutorial, I'll share the necessary steps for deploying a Ghost blog with Docker and Traefik.