An introduction to an application server that allows you to build MySQL user interfaces without programming. Assume you are tasked to write a browser-based, MySQL user interface for the table called CITY. CITY has two columns. The column names are city_name and state_code—each combined are the primary key. Your user interface must enable users to execute the four main SQL operations: select, insert, update and delete. The main characteristics for each operation are:

Learn how to embrace open standards while you remove stubble.

Is there room for FOSS in the AI, VR, AR, MR, ML and XR revolutions—or vice versa? Will the free and open-source revolution end when our most personal computing happens inside the walled gardens of proprietary AI VR, AR, MR, ML and XR companies? I ask, because that's the plan.

Microsoft was founded in 1975—that's 43 years ago and a ton of history. Up until the last decade, the company led a campaign against the Open Source and Free Software movements, and although it may have slowed the opposition, it did not bring it to an end. In fact, it emboldened its supporters to push the open-source agenda even harder. Fast-forward to the present, and open-source technologies run nearly everything—mobile devices, cloud services, televisions and more.

Deploying and managing complex stateful applications on Kubernetes.

Net giants depend on open source: so where's the gratitude?

Seven years ago, we started building Tutanota, an encrypted email service with a strong focus on security, privacy and open source. Long before the Snowden revelations, we felt there was a need for easy-to-use encryption that would allow everyone to communicate online without being snooped upon. As developers, we know how easy it is to spy on email that travels through the web. Email, with its federated setup is great, and that's why it has become the main form of online communication and still is. However, from a security perspective, the federated setup is troublesome—to say the least.

Nitrux is a Linux distribution with a focus on portable, application formats like AppImages. Nitrux uses KDE Plasma 5 and KDE Applications, and it also uses our in-house software suite Nomad Desktop. What Can You Use Nitrux For? Well, just about anything! You can surf the internet, word-process, send email, create spreadsheets, listen to music, watch movies, chat, play games, code, do photo editing, create content—whatever you want!

Puppet, the company that makes automation software for managing systems and delivering software, has introduced Puppet Bolt, an open-source, agentless multiplatform tool for running commands, scripts, tasks and orchestrated workflows on remote Linux and Windows systems.

The "Year of the Desktop" has been a perennial call to arms that's sunken into a joke that's way past its expiration date. We frequently talk about the "Year of the Desktop", but we don't really talk about how we would achieve that goal. What does the "Year of the Desktop" even look like? What it comes down to is applications—rather, a market for applications. There is no market for applications because of a number of cultural artifacts that began when the Free Software was just getting up on wobbly legs.

In the past decade or so, we've learned to equate the ability to collaborate with the need to be online. The advent of SaaS clearly marked the departure from a decentralized collaboration model to a heavily centralized one. While on the surface this is a very convenient delivery model, it simply doesn't fit a number of scenarios well.

A list of FOSS alternatives to popular proprietary software was compiled in to an infographic by anonymiss@despora.de. We've contributed by making a text list of the infographic. Now it's your turn-- tell us what FOSS alternatives you recommend in each category and we'll add them to this master list. Google FOSS: searX, https://searx.me/ YouTube

The entire landscape of how we authenticate domain names likely will see a complete overhaul, all powered by blockchain technologies. Just released, Handshake brings with it the much needed security and reliability on which we rely. Backed by venture capitalists and industry-established blockchain developers, Handshake has raised $10.2 million to replace the current digital entities maintaining our current internet infrastructure.

Pydio Cells is a brand-new product focused on the needs of enterprises and large organizations, brought to you from the people who launched the concept of the open-source file sharing and synchronization solution in 2008. The concept behind Pydio Cells is challenging: to be to file sharing what Slack has been to chats—that is, a revolution in terms of the number of features, power and ease of use.

ONLYOFFICE is a free and open-source office suite that provides an alternative for three major MS Office apps—Word, Excel and PowerPoint—working online. ONLYOFFICE's main features include:

With the rise of IoT, we're inside a short window where "open" is a strong differentiator for hardware products. Is your company ready to take advantage of it?

The Comprehensive and Progressive Agreement for Trans Pacific Partnership (CPTPP) is an enormous (roughly 6,000-page) treaty between Australia, Brunei, Canada, Chile, Japan, Malaysia, Mexico, New Zealand, Peru, Singapore and Vietnam that was signed in Chile on March 8, 2018. So far, only Mexico and Japan have ratified it. CPTPP is almost identical to the original TPP, which included those 11 countries plus the United States.

Exploring the current state of musical Linux with interviews of developers of popular packages. Linux is ready for prime time when it comes to music production. New offerings from Linux audio developers are pushing creative and technical boundaries. And, with the maturity of the Linux desktop and growth of standards-based hardware setups, making music with Linux has never been easier.

The Codelobster free web language editor has been available for quite some time and has attracted many fans. It allows you to edit PHP, HTML, CSS and JavaScript files, and it highlights the syntax and provides hints for tags, functions and their parameters. This editor deals with files that contain mixed content easily as well.

Are you bored with the look of your desktop? Are the wallpapers that come with your distro enough for you? WallpaperDownloader is a graphical application that will help you customize your desktop and find wallpapers automatically.