Language Selection

English French German Italian Portuguese Spanish

Server

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

Filed under
Server
BSD
  • 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
Server
  • 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
Server
  • 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
Server
  • 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
Server
Software

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
Server
  • 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
Server

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
Server

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

PostgreSQL 14 Released!

Filed under
Server

The PostgreSQL Global Development Group today announced the release of PostgreSQL 14, the latest version of the world’s most advanced open source database.

PostgreSQL 14 brings a variety of features that help developers and administrators deploy their data-backed applications. PostgreSQL continues to add innovations on complex data types, including more convenient access for JSON and support for noncontiguous ranges of data. This latest release adds to PostgreSQL's trend on improving high performance and distributed data workloads, with advances in connection concurrency, high-write workloads, query parallelism and logical replication.

"This latest release of PostgreSQL advances our users' ability to manage data workloads at scale, enhances observability, and contains new features that help application developers," said Magnus Hagander, a PostgreSQL Core Team member. "PostgreSQL 14 is a testament to the dedication of the global PostgreSQL community in addressing feedback and continuing to deliver innovative database software that is deployed by organizations large and small."

PostgreSQL, an innovative data management system known for its reliability and robustness, benefits from over 25 years of open source development from a global developer community and has become the preferred open source relational database for organizations of all sizes.

Read more

Cockpit 254

Filed under
Server
Software

Cockpit is the modern Linux admin interface. We release regularly.

Here are the release notes from Cockpit 254 and cockpit-machines 253:

Read more

Syndicate content

More in Tux Machines

Today in Techrights

CuteFish – An Elegant, Beautiful and Easy-to-Use Linux Desktop

CutefishOS is a new free and open-source desktop environment for Linux operating systems with a focus on simplicity, beauty, and practicality. Its goal is to create a better computing experience for Linux users. Cutefish OS is among the newest kids on the block of desktop environments. And since it has been born at such a time when the KDE aesthetic leads in the UI/UX stand for Linux users, it features a design that is strikingly similar. Given its goal of making a better desktop experience, the team uses KDE Frameworks, KDE Plasma 5, and Qt. My guess is that Qt is the source of its “cute” name. They seem to have collaborated heavily with JingOS, a beautiful Linux OS targeted at Tablets. Read more

Former Microsoft Security Analyst Claims Office 365 Knowingly Hosted Malware For Years

Malware on Windows devices has become a real problem in the last few years, specifically with a recent uptick in ransomware. It appears that Microsoft has been trying to combat this issue, though, with updates to Microsoft Defender, so it has more teeth than ever before. However, what if Microsoft is part of the problem too? On Friday, cybersecurity researcher TheAnalyst explained on Twitter how BazarLoader malware leads to ransomware that can severely affect healthcare, among other industries. He then called out Microsoft, asking if the company has “any responsibility in this when they KNOWINGLY are hosting hundreds of files leading to this,” alongside an image of what appears to be malicious files being hosted in OneDrive. Read more

today's leftovers

  • pam-krb5 4.11

    The primary change in this release of my Kerberos PAM module is support for calling pam_end with PAM_DATA_SILENT. I had not known that the intent of this flag was to signal that only process resources were being cleaned up and external resources should not be (in part because an older version of the man page doesn't make this clear).

  • QB64 Hits Version 2.0, Gets Enhanced Debugging | Hackaday

    Despite the name, BASIC isn’t exactly a language recommended for beginners these days. Technology has moved on, and now most people would steer you towards Python if you wanted to get your feet wet with software development. But for those who got their first taste of programming by copying lines of BASIC out of a computer magazine, the language still holds a certain nostalgic appeal.

  • All Things Open: Diversity Event Today - Big Top Goes Up Monday! - FOSS Force

    By now things are going full tilt boogie in downtown Raleigh, as the All Things Open conference is well into its “pre” day. Keeping with the trend set by other conferences, All Things Open opens a day ahead of time, partially to stage free event’s that aren’t officially a part of the main show, but which offer attendees from out-of-town a reason to fly in a day early to settle in. This is good for the travelling attendees, because they don’t spend the first day suffering for jet lag or other forms of travel fatigue, and good for the event, because it means that more people are in place to fill seats and attend presentations, beginning with the opening keynote. [...] At ATO, the registration desks are open on Sunday from noon until 5:30 Eastern Time, and the pre-conference is a free Inclusion and Diversity Event that started at noon and will run until 5pm, emceed by Rikki Endsley, formally with Red Hat and now a community marketing manager at Amazon Web Services.

  • [Older] Arduino Nano Pros and Cons: Is the Cheapest Arduino Worth It?

    While there is quite an array of Arduino boards to choose from, the Nano is a versatile board suitable for almost all DIY electronic projects. These tiny micro controllers make compact DIY hardware development available to more people than ever before. In the past we have covered reasons you may not want to choose a genuine Arduino for your projects, but today lets take a look at the positives and negatives of the Arduino Nano.

  • Pnevmo-Capsula: Domiki rolls onto Windows, Mac and Linux

    Usually the term "on rails" refers to a highly linear experience over which the player has little control. But sometimes it's meant far more literally than that, as is the case in Pomeshkin Valentin Igorevich's recently released steampunk adventure, Pnevmo-Capsula: Domiki.

  • How to install Thinkorswim Desktop on a Chromebook in 2021

    Today we are looking at how to install Thinkorswim Desktop on a Chromebook. Please follow the video/audio guide as a tutorial where we explain the process step by step and use the commands below.