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

Why do programmers prefer to use Linux?

Windows is the most widely used operating system, both in home and business environments. Most of the programs are created to run on this operating system. However, the people who create these programs (developers, programmers and system administrators mainly) prefer to leave Windows aside and work on another operating system: Linux. Why? What brings you to this? Linux offers a large number of advantages when it comes to working and developing, advantages that range from flexibility to security and system performance. Today, Linux is a perfectly affordable system for any user, since it is not much more complicated to use than any Windows system. However, this OS does not end up gaining popularity within home environments, its main strength being the servers and the computers of the programmers. Read more

Databases: PostgreSQL JDBC 42.2.24, check_pgbackrest 2.1, and SQLite fdw 2.1.0

Kernel: BOLT, OpenZFS, and Latency-Related Work

  • Facebook Has Been Working On BOLT'ing The Linux Kernel For Greater Performance - Phoronix

    For several years now Facebook engineers have been working on BOLT as a way to speed-up Linux/ELF binaries. This "Binary Optimization and Layout Tool" is able to re-arrange executables once profiled to generate even faster performance than what can be achieved by a compiler's LTO and PGO optimizations. One of the latest BOLT efforts has been on optimizing the Linux kernel image.

  • OpenZFS 2.0.6 Released With Support For Newer Kernels

    While the OpenZFS 2.1 feature release has been available since July, for those still using the OpenZFS 2.0.x series and not yet prepared to make the jump to that big new release with dRAID and other changes, OpenZFS 2.0.6 was released this week. OpenZFS 2.0.6 is another maintenance release for those not migrating yet to the v2.1 series. OpenZFS 2.0.6 most notably brings support for newer versions of the Linux kernel: OpenZFS 2.0.5 supported up through Linux 5.12 while OpenZFS 2.0.6 now supports Linux 5.13/5.14 plus some early 5.15 compatibility patches.

  • Intel's User Interrupts With Sapphire Rapids Looking Quite Great For Faster IPC - Phoronix

    Earlier this month Intel engineers posted their initial Linux kernel enablement around x86 User Interrupts with this feature premiering with Xeon "Sapphire Rapids" CPUs. As implied by the name, the User Interrupt functionality allows for interrupts to bypass the kernel for more efficient, low-latency, low-utilization interrupts being received by other user-space tasks. Intel talked more about User Interrupts this week at LPC2021.

Firefox and Hardware Acceleration on Linux

In some Firefox version after 88.0 it looks like they're enabling WebRenderer by default, and it also looks like my hardware (an Nvidia graphics card with the proprietary driver)[1] isn't whitelisted, so what Firefox does is enable "software WebRenderer" instead. First things first, I had been trying WebRenderer for some time (more than a couple of month) by force-enabling it, and while it seemed to make things better at first, on the whole the experience was awful, and because WebRenderer, if I understand correctly, uses GPU acceleration, that affected the rest of the desktop, so after a while I disabled WebRenderer (and "Hardware Acceleration" in the preferences tab, and set the processes limit to 2, while I was there), and then things seemed to be better. Due to the iffy state Firefox can be in sometimes, I had decided to skip updates for as long as I can, i.e. I update Firefox, then stick with the version I have until an extension I use no longer works, or there is a really compelling new feature in a new version of Firefox (which, sadly, doesn't seem to be as often as it was before the "rapid release" schedule Mozilla had adapted...). So here I was using Firefox 88.0, shut the machine down at night, turned it on in the morning, then when I was opening a link, Firefox started and all the tabs had the "your tab crashed" "reload this tab?" message, clicking that button had no effect. So nothing worked, not restoring the previous tabs, disabling all extensions, moving ~/.mozilla and starting anew; a couple of online searches later, still nothing, then I looked at rpm -qa --last | less, now I think the reason is a glibc update, which broke Firefox, probably it would be fixed by rebuilding Firefox against the new glibc. Not really OpenSuse Tumbleweed's problem because the current version of Firefox in the repos is 92.0... Read more Also: Mozilla VPN boosted with multi-hop, blocking and custom DNS features