PostgreSQL server programming

PostgreSQL server programming: extend PostgreSQL and integrate the database layer into your development framework

by Krosing, Hannu

Type Book
Rate 0.0 /5

Title Statements

  • Full title :PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / Hannu Krosing, Jim Mlodgenski, Kirk Roybal.

Edition Statements

  • Publication Date:2013.

Publication Statements

  • Publisher(s):Packt Pub
  • Place of Publication:Birmingham
  • Language:eng
  • Publication Date:2013.

Notes

Includes index.

The Physical Object

  • Description:1 online resource (vi, 245 p. :) : ill. (some col.).

Edition Identifiers

  • ISBN:9781849516983, 1849516987, 9781849516990, 1849516995
  • oclc:on1152987386
  • LC Classification:QA76.9.D3
  • Dewey Decimal:005.7585

Table of Contents

Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:What Is a PostgreSQL Server?; Why program in the server?; Using PL/pgSQL for integrity checks; About this book's code examples; Switching to the expanded display; Moving beyond simple functions; Data comparisons using operators; Managing related data with triggers; Auditing changes; Data cleaning; Custom sort orders; Programming best practices; KISS -- keep it simple stupid; DRY -- don't repeat yourself; YAGNI -- you ain't gonna need it; SOA -- service-oriented architecture.

Type extensibilityOn caching; Wrap up -- why program in the server?; Performance; Ease of maintenance; Simple ways to tighten security; Summary; Chapter 2:Server Programming Environment; Cost of acquisition; Availability of developers; Licensing; Predictability; Community; Procedural languages; Platform compatibility; Application design; Databases are considered harmful; Encapsulation; What does PostgreSQL offer?; Data locality; More basics; Transactions; General error reporting and error handling; User-defined functions (UDF); Other parameters; More control; Summary.

Chapter 3:Your First…

Read More ↓

Subjects

Writers

More from this Series

Rate & Review

0.0/5
(0 people Voted)

No reviews yet. Be the first to rate this work.

Files & Downloads

  • PostgreSQL server programming -- (.pdf)

    PDF · 1.9 MB · updated
  • PostgreSQL Server Programming -- (.epub)

    EPUB · 2.0 MB · updated
  • PostgreSQL Server Programming -- (.epub)

    EPUB · 3.0 MB · updated
  • PostgreSQL Server Programming -- (.pdf)

    PDF · 4.0 MB · updated
  • PostgreSQL Server Programming: Extend PostgreSQL …

    PDF · 4.3 MB · updated
  • PostgreSQL Server Programming -- (.epub)

    EPUB · 2.0 MB · updated