Ubuntu Unleashed 2019 Edition: Covering 18.04, 18.10, 19.04

should be able to use su to become this user, and no one will ever log in directly as the user. (See ...

issue the following command from the shell prompt (not the PSQL client prompt, but a normal shell prompt): ...

create new databases or additional users.) You can also use the PostgreSQL command-line client to create a new ...

Granting and Revoking Privileges in PostgreSQL As in MySQL, granting and revoking privileges in PostgreSQL is ...

client is a primitive way of interfacing with a database and generally isn’t used by end users. As a DB ...

FIGURE 28.4 The user logs in to the database server located on host Simba from the workstation (host Ch ...

FIGURE 28.5 The user logs in to the remote host Leopard from the workstation (host Cheetah) and starts ...

FIGURE 28.6 The user starts a GUI database program on the user’s workstation (hostname Cheetah). This progr ...

The front end is the user’s web browser, the client is running on Leopard, and the server is running on Simba. In ...

More options are available than are listed in Table 28.1, but these are the most common options. See the man ...

mysql> use animals Database changed mysql> The PostgreSQL Command-Line Client You invoke the PostgreSQL comma ...

mysql—Interactively queries the mysqld server mysqladmin—Administers the mysqld server mysqldump—Dumps or backs up MySQL ...

CHAPTER 29 NoSQL Databases IN THIS CHAPTER Key/Value Stores Document Stores Wide Column Stores Graph Stores ...

—Dwight Merriman, CEO of MongoDB, at OSCON 2011, as quoted in an article from ZDNet at www.zdnet.com/article ...

please most readers of this book. However, this also means that, unlike with most enterprise-focuse ...

somehow different than “NoSQL” databases. While “NoSQL” is much more common to hear, “NewSQL” is the latest ...

what the value object is, just that it is stored using the given key. These databases have no schema ...

Cassandra Cassandra was developed by Facebook for its inbox searching feature. It was released as an open ...

Memcached stores data requested on a system in RAM for a specific period of time to make retrieving t ...

capacity planning. The same operational tasks apply to small clusters and large clusters. More machines ...