• Complain

Daniel K. Lyons - Instant PostgreSQL Starter

Here you can read online Daniel K. Lyons - Instant PostgreSQL Starter full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2013, publisher: Packt Publishing, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Daniel K. Lyons Instant PostgreSQL Starter
  • Book:
    Instant PostgreSQL Starter
  • Author:
  • Publisher:
    Packt Publishing
  • Genre:
  • Year:
    2013
  • Rating:
    5 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 100
    • 1
    • 2
    • 3
    • 4
    • 5

Instant PostgreSQL Starter: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Instant PostgreSQL Starter" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. Instant PostgreSQL Starter is a step-by-step guide to getting a PostgreSQL database up and running, with an accessible approach that helps you perform some initial steps with setup and optimization. If youre completely new to databases youll benefit from this books step-by-step approach to getting PostgreSQL installed and running. If youre curious about what sets PostgreSQL apart, youll get a taste of the diverse features it has to offer. All you need to get started is this book and an Internet connection.

Daniel K. Lyons: author's other books


Who wrote Instant PostgreSQL Starter? Find out the surname, the name of the author of the book and a list of all author's works by series.

Instant PostgreSQL Starter — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Instant PostgreSQL Starter" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Instant PostgreSQL Starter

Instant PostgreSQL Starter

Copyright 2013 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the Daniel K. Lyons, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: April 2013

Production Reference: 1180413

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-78216-756-3

www.packtpub.com

Credits

Author

Daniel K. Lyons

Reviewer

Reid Givens

Acquisition Editor

Erol Staveley

Commissioning Editor

Ameya Sawant

Technical Editor

Saijul Shah

Project Coordinator

Suraj Bist

Proofreader

Mario Cecere

Production Coordinator

Arvindkumar Gupta

Cover Work

Arvindkumar Gupta

Cover Image

Nitesh Thakur

About the Author

Daniel K. Lyons is a programmer and database administrator at the NRAO in Socorro, NM. He's been using PostgreSQL professionally and privately for a decade and it is one of the few technologies that he likes despite much use. In his spare time he likes to program in Haskell and Prolog.

I'd like to thank my beautiful wife Liz, whose firm but gentle patience made this book happen.

About the Reviewer

Reid Givens is the owner of Viaduct Digital, LLC, a digital media, and web development agency out of New Mexico. Reid received a degree in Interactive Media from the International Academy of Design and Technology in 2001. Reid started his career as a creative, working as a print, and web designer for small agencies. Since then, he has moved from graphic designer to creative director, advertising manager, and a few years as an organizational strategist until starting his own agency in 2007. He also speaks about marketing and the web, and has spent a few years running his own digital agency. Reid has also been known to pick up drumsticks from time to time.

www.packtpub.com
Support files, eBooks, discount offers and more

You might want to visit www.packtpub.com for support files and downloads related to your book.

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at > for more details.

At www.packtpub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.

packtlib.packtpub.com

Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books.

Why Subscribe?
  • Fully searchable across every book published by Packt
  • Copy and paste, print and bookmark content
  • On demand and accessible via web browser
Free Access for Packt account holders

If you have an account with Packt at www.packtpub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.

Chapter 1 Instant PostgreSQL Starter Welcome to the Instant PostgreSQL Starter - photo 1
Chapter 1. Instant PostgreSQL Starter

Welcome to the Instant PostgreSQL Starter . This book has been especially created to provide you with all the information that you need to get set up with PostgreSQL. You will learn the basics of PostgreSQL, get started with installing your first database, and discover some tips and tricks for using and running PostgreSQL.

This document contains the following sections:

So, what is PostgreSQL? finds out what PostgreSQL actually is, what you can do with it, and why it's the most advanced open-source relational database management system.

Installation will show you how to download and install PostgreSQL with the minimum fuss and then set it up so that you can use it as soon as possible. We will take a brief detour afterwards to discuss a few important settings and how they affect performance.

Quick start Creating your first table section will show you how to perform two of the core tasks of PostgreSQL; creating databases and users. Follow the steps to create your own database and administrator account, which will be the basis of most of your work in PostgreSQL.

Top 9 features you need to know about here you will learn how to perform six tasks with the most important features of PostgreSQL. By the end of this section you will be able to insert data and perform queries, examine database structure and size, backup and restore databases, import and export data to CSV, install extensions, and store unstructured data and passwords securely.

People and places you should get to know section provides you with many useful links to the project page and forums, as well as a number of helpful articles, tutorials, blogs, and the Twitter feeds of PostgreSQL super-contributors.

So, what is PostgreSQL?

PostgreSQL is the premier open-source relational database. Long the underdog of the database world, its recent surge in popularity has come from users of other databases searching for a system with better reliability guarantees, better querying capabilities, more features, more predictable operation, or simply wanting something easier to learn, understand, and use. You will find PostgreSQL to be all of these things and more.

  • Easy-to-use : PostgreSQL's SQL commands are consistent with each other and standard. The command-line tools all take the same arguments. The data types do not have silent truncation or other strange edge-case behavior. Surprises are rare and everything generalizes to other aspects of the system.
  • Safe : PostgreSQL is fully transactional, including destructive structural changes. This means you can safely try anything within a transaction, even deleting data or changing table structures, secure in the knowledge that if you roll back the transaction every change you've made will be reverted. Easy backup and restore makes it trivial to clone a database across the network and experiment on a private database copy.
  • Powerful : PostgreSQL supports many sophisticated data types out of the box, including JSON, XML, geometric objects, hierarchies, tags, and arrays. New data types and functions can be written in SQL, C, or many embedded procedural languages including Python, Perl, TCL, and others. Extensions add diverse capabilities quickly and easily, including full-text search, slow query monitoring, password encryption, and more.
Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Instant PostgreSQL Starter»

Look at similar books to Instant PostgreSQL Starter. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Instant PostgreSQL Starter»

Discussion, reviews of the book Instant PostgreSQL Starter and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.