Search the Community

138 Results
  • Tutorial

    How To Install MySQL on Ubuntu 18.04

    MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to ma...
    By Mark Drake MySQL Databases Ubuntu Ubuntu 18.04
  • Tutorial

    How To Install MySQL on Ubuntu 16.04

    MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to ma...
    By Hazel Virdó MySQL Ubuntu Ubuntu 16.04
  • Tutorial

    How To Install MySQL on Ubuntu 14.04

    MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to ma...
    By Hazel Virdó MySQL Ubuntu
  • Tutorial

    How To Rewrite URLs with mod_rewrite for Apache on Ubuntu 16.04

    The mod_rewrite module allows us to rewrite URLs in a cleaner fashion, translating human-readable paths into code-friendly query strings or redirecting URLs based on additional conditions. This guide is split into two...
    By Mateusz Papiernik Apache Ubuntu Ubuntu 16.04
  • Tutorial

    How To Use MySQL Query Profiling

    MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distr...
    By Jesse Cascio MySQL Server Optimization MariaDB
  • Tutorial

    How To Use Prometheus to Monitor Your Ubuntu 14.04 Server

    Prometheus is an open source monitoring system which stores all its data in a time series database and offers a multi-dimensional data-model and a powerful query language. The Prometheus project also includes PromDash...
    By Hathy A Monitoring Ubuntu
  • Tutorial

    How to Rewrite URLs with mod_rewrite for Apache on Ubuntu 18.04

    Apache's modrewrite module lets you redirect URLs based on additional conditions, or rewrite URLs in a cleaner fashion, translating human-readable paths into code-friendly query string. In this tutorial, you'll enable...
    By Mateusz Papiernik, Brian Hogan Apache Ubuntu 18.04
  • Tutorial

    How To Manage an SQL Database

    SQL databases come installed with all the commands you need to add, modify, delete, and query your data. This cheat sheet-style guide provides a quick reference to some of the most commonly-used SQL commands.
    By Mark Drake MySQL PostgreSQL MariaDB Databases
  • Tutorial

    How To Optimize MySQL with Query Cache on Ubuntu 18.04

    Query cache is a prominent MySQL feature that speeds up data retrieval from a database. In this tutorial, you will first configure MySQL without query cache and run queries to see the duration results. Then you'll set...
    By FRANCIS NDUNGU Caching MySQL Databases Server Optimization Ubuntu 18.04
  • Tutorial

    How To Build and Deploy a GraphQL Server with Node.js and MongoDB on Ubuntu 18.04

    In this tutorial you'll build and deploy a GraphQL server with Node.js that can query and mutate data from a MongoDB database that is running on Ubuntu 18.04. At the end of this tutorial, you'll be able to access data...
    By Roy Derks Databases Node.js Development MongoDB Ubuntu 18.04
  • Tutorial

    How To Rewrite URLs with mod_rewrite for Apache on Debian 10

    Apache's mod_rewrite module lets you rewrite URLs in a cleaner fashion, translating human-readable paths into code-friendly query strings. It also lets you rewrite URLs based on conditions. In this tutorial, you'll en...
    By Mateusz Papiernik, Brian Hogan, Mark Drake Apache Debian Debian 10
  • Tutorial

    How To Rewrite URLs with mod_rewrite for Apache on Debian 9

    Apache's mod_rewrite module lets you rewrite URLs in a cleaner fashion, translating human-readable paths into code-friendly query strings. It also lets you rewrite URLs based on conditions. In this tutorial, you'll en...
    By Mateusz Papiernik, Brian Hogan, Kathleen Juell Apache Debian Debian 9
  • Tutorial

    How To Rewrite URLs with mod_rewrite for Apache on Debian 8

    The mod_rewrite module allows us to rewrite URLs in a cleaner fashion, translating human-readable paths into code-friendly query strings or redirecting URLs based on additional conditions. This guide is split into two...
    By Mateusz Papiernik Apache Debian
  • Tutorial

    How To Prepare For Your MySQL 5.7 Upgrade

    This tutorial will help you prepare to upgrade to MySQL 5.7 from earlier versions. It covers sql_mode with practical examples of query responses that get stricter. The tutorial also contains instructions for checking ...
    By Morgan Tocker MySQL Scaling CentOS CoreOS Debian FreeBSD Ubuntu
  • Tutorial

    A Practical GraphQL Getting Started Guide with Node.js and Express

    GraphQL is a query language created with the purpose of building client applications based on intuitive and flexible syntax for describing their data requirements and interactions. In this tutorial, we are going to im...
    By John Kariuki NoSQL JavaScript Node.js
  • Tutorial

    How To Monitor Your System Security with osquery on Ubuntu 16.04

    osquery is an open-source security tool that takes an operating system and turns it into one giant database, with tables that you can query using SQL-like statements. With these queries, you can monitor file integrity...
    By finid System Tools Monitoring Logging Security Ubuntu 16.04
  • Tutorial

    How To Create Data Queries in PostgreSQL By Using the Select Command

    PostgreSQL is a database management system used to store and manipulate data from other applications or websites. This tutorial will cover how to query databases for information that meets specific criteria. Masteri...
    By Justin Ellingwood PostgreSQL Getting Started
  • Tutorial series

    How To Manage a Redis Database

    Redis (https://redis.io/) is an open-source, in-memory key-value data store. A NoSQL database, Redis doesn't use structured query language (https://en.wikipedia.org/wiki/SQL), otherwise known as SQL. Redis instead com...
    By Mark Drake Redis Databases NoSQL Ubuntu 18.04 Configuration Management
  • Tutorial

    How To Build a Realtime Chat App with React and GraphQL

    In this article you'll use GraphQL and React to build a realtime chat app. You'll set up and React and GraphQL project, interact with GraphQL from React, query and mutate entities, and implement realtime messaging and...
    By Chris Nwamba React JavaScript Development
  • Tutorial

    How To Configure OpenLDAP and Perform Administrative LDAP Tasks

    Managing an OpenLDAP system can be difficult if you do not know how to configure your system or where to find the important information you need. In this guide, we'll demonstrate how to query your OpenLDAP server for ...
    By Justin Ellingwood System Tools