Language Selection

English French German Italian Portuguese Spanish


Databases: Managing Database Migrations, PostgreSQL-Related Releases

Filed under

GNU/Linux on Servers: WebLogic, Cubic, and ARM

Filed under
  • Trend Micro duo find Linux malware targeting Huawei Cloud [Ed: As it turns out, Linux isn't the security risk but proprietary software people install on it]

    A vulnerability in the Oracle WebLogic Server product of Oracle Fusion Middleware is one route through which Linux malware, observed by researchers at Trend Micro to be attacking Huawei Cloud, a relatively new cloud service provider, gain access to systems.

  • How to create your own data center-specific Linux image with Cubic - TechRepublic

    At this point, you most likely use Linux in your data center. It's an inevitability that you cannot fight these days. And that's a very good thing because Linux is incredibly powerful, flexible and (without question) powers so much of what we depend on.

    If you're deploying to a lot of servers in your data center, the idea of installing a base server distribution and then adding everything you need, one server at a time, can be a bit of a daunting task. That's understandable, especially when those servers might number in the hundreds. And if you're not using virtual machines for those deployments, you're probably looking for a way to make those rollouts a bit easier.

  • Cortex-M55 based Arm Virtual Hardware is now available in AWS Cloud

    The Arm DevSummit 2021 is taking place on October 19-21, and the first announcements from Arm are related to IoT with “Arm Total Solutions for IoT delivering a full-stack solution to significantly accelerate IoT product development and improve product ROI”, “Project Centauri” aiming to achieve for an extensive Arm Cortex-M software ecosystem in the way that Project Cassini does for the Cortex-A ecosystem, starting with support for PSA Certified and Open-CMSIS-CDI cloud-to-device specification, and Arm Virtual Hardware based on Corstone-300 IoT platform with a Cortex-M55 MCU core and an Ethos-U55 microNPU accessible from Amazon Web Services.

  • Announces Support for Arm® SystemReady Initiative with Future-proof Linux Platform for Securing IoT and Edge Products

    Foundries.​io, leader in cloud native development and deployment solutions for secure IoT and Edge devices, today announced support for the new Arm SystemReady initiative.

Nextcloud, iXsystems tie up to offer Hub features on TrueNAS systems

Filed under
  • Nextcloud, iXsystems tie up to offer Hub features on TrueNAS systems

    Open-source file syncing and sharing software company Nextcloud has announced a partnership with open storage systems developer iXsystems to bring all Nextcloud Hub features to TrueNAS systems.

    iXsystems sells high-availability storage with servers running open source solutions like FreeNAS, FreeBSD, OpenZFS, and TrueNAS, all based on the ZFS filesystem.

    In a statement, Nextcloud founder and chief executive Frank Karlitschek said: "As self-funded companies that share a strong open-source philosophy, Nextcloud and TrueNAS are natural partners.

    “Our mutual customers will benefit from an open and flexible platform with strong enterprise support capable of delivering efficient collaboration at any scale.”

  • Nextcloud and TrueNAS Deliver Productivity and Privacy

    Nextcloud GmbH, the company behind the worlds' most deployed on-premises content collaboration platform, and iXsystems inc., developers of the industry’s number one Open Storage platform, announce a partnership to bring the full suite of Nextcloud Hub features to TrueNAS. Tens of thousands of TrueNAS systems already run Nextcloud and availability of a supported, well integrated offering will give larger organizations more confidence to deploy.

MySQL HowTos

Filed under
  • What is connection string in MySQL

    In this article, we will learn how we can access the data from the MySQL database using the PHP language.


    Connection string is a string that specifies the information related to database login. For understanding, we will consider an example of a PHP scripting language and will write a code to establish the connection with the database. We have a database, named “Organization”, the user name is “maadi” and password is “qwer1234”...

  • What is schema in MySQL

    The data in MySQL is managed in databases in the form of tables, which further consist of rows and columns. What is Schema? Schema is different from databases as it does not have all the privileges that a database holds, it has only privileges of tables, rows, and columns which defines the structure of a database.

    In this write-up, we will explain what a schema is, how it works, and what are the differences between the schema and database.

  • What is “IS NULL” query in MySQL

    The ‘IS NULL” query in the MySQL database shows the data which is either missing or is unknown to DMS. A NULL value is different as it has no value, it is neither equal to zero integer or to an empty set. Null is a state, not a value, if we compare the NULL value to any other NULL value, the result will always be NULL because it’s unknown itself. A “IS NULL” query is used when data is missing or unknown for example we make a list of phone directories, if any person’s phone number is unknown then “IS NULL” will extract it and the number can later be added to complete the directory.

    In this article, we are going to understand what the “IS NULL” query is and how it works with some examples.

  • How to use the SELECT INTO TEMP table statement in MySQL

    Sometimes, we are supposed to fetch out data from different MySQL tables which we can use for some specific purpose. For our ease, we create a temporary table and place all the data there which we can later use. When the session is over, the table will vanish on its own, else it can delete it using the DROP command. Similarly, to create the clone of the table we use the statement “SELECT INTO”, which not only copies the contents of the selected table but also inserts all the content into the newly created table.

    In this write-up, we will learn how to use the statement “SELECT INTO TEMP TABLE” in MySQL and how this statement works.

  • How to use mysqli_real_escape_string function

    A mysqli_real_escape_string is a built-in function of the PHP that is used to control the unwanted and dangerous characters. In this article, we will discuss with the help of an example what is the mysqli_real_escape_string function and how it can be used for the protection of the database.

  • How to use MySQL Substring function

    Mysql has a variety of built-in functions for different purposes, one of them is the function of the substring. The function of substring deals with the “string” data type and it is used in database management to extract the string from the tables. Now what the string is? The string is the collective combination of the characters. For example, “Hello LinuxHint” and “KHG1234” are strings.

    In this article, we will understand what is the substring function and how it can be used in MySQL in managing the data in the databases.

  • How to use MySQL COALESCE function

    MySQL is a DBMS that has a concept of Null values. In MySQL, COALESCE function is used as it returns the first non-null value from the specified series of expressions. If all values of the column are null then COALESCE will also return the null. It works similarly to “IS NULL query ”; both deals with the NULL values but the difference in both of them is of their behavior, “IS NULL” query extracts the null values from the table whereas the COALESCE function gives the first non-null value if there is any null value present in the table.

    In this write-up, we will explain what COALESCE function is in MySQL and how it can be used with the help of examples.

PostgreSQL Leftovers

Filed under
  • pg_partman 4.6.0 released

    PostgreSQL Partition Manager (pg_partman) v4.6.0 has been released.

  • PostgreSQL: PGConf NYC 2021 Sessions Announced, Last Week for Early Bird!

    The first community PostgreSQL conference in many months is coming to New York City in less than two months! PGConf NYC is a non-profit, community-run and PostgreSQL community recognized conference being run by the United States PostgreSQL Association (PgUS).

    PGConf NYC delivers two days packed with presentations about PostgreSQL and related technologies, as well as the usual hallway and social track. PGConf NYC is being held December 2nd and 3rd, 2021 in New York City.

  • Psycopg 3.0 released

    I am extremely excited to announce the first stable release of Psycopg 3!

    Psycopg 3 is a complete rewrite based on the experience accumulated with the development and maintenance of psycopg2. Psycopg 3 targets all the current versions of Python (3.6-3.10) and PostgreSQL (10-14) and allows the use of modern Python development techniques, such as async and statically typed code. A list of the new features is available in the documentation.

Server: Cloud Native Computing Foundation (CNCF), New in Kubernetes, and Apache Spark

Filed under
  • Granulate Joins The Cloud Native Computing Foundation

    Granulate, a provider of autonomous real-time computing workload optimization and cost reduction solutions, today announced it is joining the Cloud Native Computing Foundation (CNCF), part of the nonprofit Linux Foundation. The announcement comes as part of Granulate's deepening connection to the cloud computing community and the Kubernetes and open-source ecosystems.

  • Dual-Stack Networking in Kubernetes

    Dual-stack networking has arrived in Kubernetes. IPv4/IPv6 dual-stack support is key to the future of Kubernetes, whether powering new 5G and edge workloads or scaling beyond today’s cluster limits to meet your future needs. Let’s dive into the cross-organizational collaboration that brought us this long-awaited goal and examine how the feature evolved over time.

  • GridGain Expands Ignite Summit, Adds Pre-conference Day with New Kubernetes Training
  • [Old] OverOps Bolsters Big Data App Reliability with Root Cause Analysis for Apache Spark

    OverOps, the leading solution for root cause analysis at runtime, today debuted its support for Apache Spark, the popular open-source analytics engine for large-scale data processing. This support allows developers to identify and resolve critical exceptions on Spark jobs in minutes, eliminating the need for laborious and time-consuming detective work in searching logs to figure out why their Apache Spark job broke. With no code changes required, OverOps captures a full stack trace of when, where, and why exceptions occurred along with the associated variable state.

Announcing Istio 1.9.9

Filed under

This is the final release of Istio 1.9. We urge you to upgrade to the latest Istio supported version, Istio (1.11.3).

This release contains bug fixes to improve robustness. This release note describes what’s different between Istio 1.9.8 and Istio 1.9.9.

Read more

Also: Support for Istio 1.9 has ended

Istio 1.10.5 and OpenStack Xena

Filed under
  • Announcing Istio 1.10.5

    This release contains bug fixes to improve robustness. This release note describes what’s different between Istio 1.10.4 and Istio 1.10.5.

  • OpenStack Xena, the 24th OpenStack release, is out

    It was out at 3pm, and I managed to finish uploading the last bits to Unstable at 9pm… Of course, that’s because all of the packaging and testing work was done before the release date. All of it is, as usual, also available through a Bullseye non-official backports repository that can be added using extrepo (ie: “extrepo enable openstack_xena”).

MySQL vs MariaDB: What Are the Main Differences Between Them

Filed under

An in-depth comparison of MariaDB vs MySQL based on license model, popularity, features, performance, and support.

MySQL and MariaDB are relational database management systems (RDBMS) best known for their mutual compatibility and their identical command and query syntaxes. In fact, MariaDB is a free and open source fork of MySQL that inherited many of that database’s characteristics.

The MariaDB and MySQL database management systems have a lot in common, which can make it difficult to choose when you need to decide on a database solution for your needs.

But before we get into an in-depth analysis on the topic MySQL vs MariaDB, let’s start at the very beginning.

Read more

Moodle LMS review

Filed under

Despite the open source origin, Moodle still has plenty of features. A notable one is the modern interface, that is designed to be used via a web browser on a desktop or laptop, or on mobile platforms with available iOS and Android apps (see below). This interface includes a personalized dashboard that can display a list of courses, including the current ones, along with past courses, and future ones as well. Also displayed are the pending tasks.

There are plenty of advanced features as well that go beyond the basics. A good example is the text editor. This easy to use text editor is designed to work from within the web interface, and facilitates both formatting text, and also adding in images and other content. There is also file management, and allows users to drag and drop files from popular online cloud storage providers, such as DropBox and Google Drive. There is also an all-in-one calendar to track everything from group meetings and personal events.

Moodle also encourages collaboration among educators and among learners. To this end, there is support for a variety of activities, such as chat, wikis, forums, database activities and glossaries. Teachers can also encourage interaction, by including full quizzes, or even a single multiple choice question that is called ‘Choice.’

Teachers not only can grade an assignment online, but also can provide comments to guide the student’s learning. Surveys can also be created for learners to provide feedback and to guide lessons. Workshops can also be created to get a peer assessment.

Read more

Syndicate content

More in Tux Machines

Android Leftovers

Stable vs. Bleeding-Edge Linux Distros: Which One Should You Choose?

Linux distributions have multiple ways of delivering software to their users. But which one should you go for—stability or the latest software? One of the major choices that many Linux users face when choosing a Linux distribution is its stability, or how much the software changes. Some distros favor stable, tried-and-true software while others will include newer software that may not be as reliable, also known as "bleeding-edge," a play on "cutting-edge." So, which one should you choose? Let's find out. Read more

This week in NeoChat

Last Saturday we had an improvised NeoChat mini development sprint in a small hotel room in Berlin in the occasion of the 25th anniversary of KDE. In a good KDE tradition, Carl spent this time on improving NeoChat settings. He ported both the NeoChat general settings and the specific room settings to the new Kirigami.CategorizedSetting component. Tobias fixed a lot of papercuts and now the power level should be fetched correctly, we show the number of joined users instead of joined+invited users in the room information pane, the user search is now case insensitive. Nicolas focused on fixing our Android build by making the spellchecking feature compile on Android. Read more

StarLabs StarLite is an Attractive 11-inch Linux Laptop

This dinky 11.6-inch Linux notebook, the latest from UK-based company StarLab, is modestly priced and moderately spec’d. Consciously so. See, not everyone needs to crunch code, battle orcs, or render 4K video. “More power” is nice, but when all you really do with a laptop is browse the web, e-email, Zoom, and binge-watch Netflix shows… A mid-range laptop can suffice. Problem is there isn’t a lot of choice when it comes to mid-range (and well-made) Linux laptops in the lower price brackets. Read more