Language Selection

English French German Italian Portuguese Spanish

Programming: MySQL, JavaScript, GCC

Filed under
  • MySQL RANK Window Function – Linux Hint

    The Ranking method allocates a rank inside the partition of an outcome of a set to every row. A row’s rank is determined by incrementing one figure of ranks from the row which precedes it. MySQL utilizes a ranking feature that helps one rank per row in a schema partition. In MySQL, the rating methods are indeed a semi-part of the window method.

  • MySQL Row Number Window Function – Linux Hint

    Within MySQL, a ROW NUMBER() method contains a chronological number for every row inside the partition. It is just a window feature of some kind. The figure of rows begins at 1 with the figure of rows within the partition. Remember, before version 8.0, MySQL doesn’t permit the ROW NUMBER() function however, it offers a session variable that helps one imitate this feature. We will understand more about MySQL ROW NUMBER() functionality throughout this guide and produce a consecutive number for every row in the result collection.

  • SQL Truncation Attack – Linux Hint

    The SQL Truncation vulnerability occurs when a database truncates the user input due to a restriction on the length. Attackers can gather information about the length of a critical field (such as a username) and exploit this information to gain unauthorized access. Attackers can log in as some other user, such as an admin, with their own registered password.

    SQL truncation vulnerability usually exists in MySQL databases. This vulnerability was first described in CVE-2008-4106, which was related to WordPress CMS.

  • Vue Watch to make Dynamic Interaction – Linux Hint

    Vue.js is a very impressive and reactive JavaScript’s front-end framework used to develop front-end websites quickly and easily. This post will learn about the watch property that is one of the most fundamental concepts.

    Vue.js provides a watch property to watch a variable, and on the change of that variable, it allows us to run a function so that we can make Dynamic Interaction. Let’s try an example and have some dynamic interaction using the Vue Watch property.

  • What is a Vue Directive, and how to use it? – Linux Hint

    A framework aims to provide such features that make the development process easier and faster for the developers. Vue.js is such a feature-enriched JavaScript framework that provides many built-in functions and directives to quickly make the development process. But, there must come some scenarios when you need some functionality that is not available by the framework, so you have to build your own.

    In this post, we will learn and take a look at the built-in directives provided by the Vue.js framework, and we will also learn to create and use our own custom-made Vue directive.

  • User Authentication in Node.js with Passport.js and JWT – Full 6-Hour Course

    If you are making a web app, chances are it will have users that need to be authenticated.

    We just published a 6-hour course on the YouTube channel that will teach you how to implement user authentication from scratch in your Node.js and Express apps. You will lean how to use Passport.js.

  • GraphQL VS REST – Benefits and Code Example Comparisons

    REST was not the first protocol for sending information over the web. But for over a decade, it has dominated the API landscape.

    More recently, GraphQL, a newcomer designed by Facebook, has become more and more popular. It is intended to correct some of REST’s weaknesses, but no technology is perfect.

    What are the benefits of GraphQL over REST, and why would you use one over the other in your project?

  • Zen 3 GCC Tuning Continues With More Correct Latencies Rather Than "Random Numbers"

    On Monday, the AMD EPYC 7003 "Milan" launch day, we finally got to see some serious tuning begin for the Zen 3 "Znver3" CPU target in the GCC compiler after that initial code landed at the end of last year. Yesterday a second Zen 3 tuning patch was published and then today a third tuning patch has made it out.

    This third Znver3 tuning patch out today is again from SUSE's Jan Hubicka. He sent it out on the mailing list and right away merged it as a "fix" for the GCC 11 compiler release that will debut as stable in the next month or so as GCC 11.1

    This third patch is a small change but is updating the costs of integer divides to match the actual latencies found with Zen 3 processors.

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.