Ubuntu Unleashed 2019 Edition: Covering 18.04, 18.10, 19.04

(singke) #1
PostgreSQL  command-line    client,  534
SSH access, 530 – 531
web access, 532

commands for, 535


MySQL


command-line    client,  533 – 534
configuring, 522 – 523
creating databases, 524 – 526
MariaDB versus, 511
password setup, 523 – 524
performance tuning, 423 – 426
PostgreSQL versus, 520 – 522

NoSQL, 513


advantages  of,  538
disadvantages of, 538 – 539
document stores, 542 – 545
explained, 537 – 538
graph stores, 546 – 547
key/value stores, 540 – 542
NewSQL versus, 539
resources for information, 547 – 548
UnQL, 539 – 540
wide column stores, 545 – 546

PostgreSQL


command-line    client,  534
configuring, 526
creating database users, 527 – 528
creating databases, 527
deleting database users, 528
Free download pdf