PostgreSQL是一个功能强大,开源对象关系型数据库系统。它拥有超过15年的持续开发和经验证的体系结构,赢得了良好的声誉:可靠性,数据完整性和正确性。

这是一个快速学习PostgreSQL和PostgreSQL编程的入门教程。

PostgreSQL是什么?

PostgreSQL(发音post-gress-Q-L)是一个开放源码的关系数据库管理系统(DBMS),由世界各地的志愿者队伍开发。 PostgreSQL是不控制任何公司或其他私人实体和源代码是免费提供的。

简史

PostgreSQL最初称为Postgres,在UCB由一个名为迈克尔·斯通布雷克的计算机科学教授-斯通布雷克Postgres于1986年开发,它的前身安格尔现在所拥有的计算机协会后续项目。

  1. 1977-1985:开发所谓的INGRES项目。

  • 证明了关系数据库的概念

  • 在1980年建立了公司安格尔

  • 在1994年由计算机关联购买

  • 1986-1994: POSTGRES

    • Development of the concepts in INGRES with a focus on object orientation and the query language Quel

    • The code base of INGRES was not used as a basis for POSTGRES

    • Commercialized as Illustra (bought by Informix, bought by IBM) 

  • 1994-1995: Postgres95

    • Support for SQL was added in 1994

    • Released as Postgres95 in 1995

    • Re-released as PostgreSQL 6.0 in 1996

    • Establishment of the PostgreSQL Global Development Team

    PostgreSQL主要特点

    PostgreSQL能够运行在所有主流操作系统,包括Linux,UNIX(AIX,BSD,HP-UX,SGI IRIX,Mac OS X,Solaris,Tru64)和Windows。它支持文字,图片,声音和视频,包括C/C ++,Java中,Perl,Python和Ruby中,TCL和开放式数据库连接(ODBC)的编程接口。

    PostgreSQL支持SQL标准很大一部分,并提供许多现代化的功能,包括以下内容:

    • Complex SQL queries

    • SQL Sub-selects

    • Foreign keys 

    • Trigger

    • Views

    • Transactions

    • Multiversion concurrency control (MVCC)

    • Streaming Replication (as of 9.0)

    • Hot Standby (as of 9.0)

    您可以查看PostgreSQL的官方文档,了解上述功能。 PostgreSQL可以在许多方面,例如通过增加新的用户扩展:

    • Data types

    • Functions

    • Operators 

    • Aggregate functions

    • Index methods

    程序语言支持

    PostgreSQL支持四个标准的程序语言,它允许用户在任何语言编写自己的代码,它可以执行PostgreSQL数据库服务器。这些程序语言 - PL/pgSQL的,PL/ TCL,PL/ Perl和PL/ Python。此外,其他非标准程序语言,如PL/ PHP,PL/V8,PL/ Ruby中,PL/ Java等也支持。


    685阅读 | 0评论
    你的回应
    • uxawielirahit

      2019-05-22 07:12:09 uxawielirahit

      Venous fmr.icmw.osbaike.net.lhp.do plotting practitioners fundus [URL=http://gccroboticschallenge.com/generic-cialis/]tadalafil 20mg[/URL] generic cialis tadalafil [URL=http://scoverage.org/buy-cialis/]buy cialis on line[/URL] [URL=http://a1sewcraft.com/cialis-on-line/]cialis 20 mg lowest price[/URL] [URL=http://ekautorepair.com/accutane/]buy accutane online[/URL] [URL=http://a1sewcraft.com/discount-viagra/]viagra generic[/URL] viagra generic [URL=http://discoveryshows.com/lyrica/]cheapest lyrica[/URL] [URL=http://columbiainnastoria.com/buy-cialis-online/]c

    • otavacyuto

      2019-05-21 01:30:39 otavacyuto

      Discussion jao.puep.osbaike.net.obd.sj encapsulated; [URL=http://azlyricsall.com/prednisone/]prednisone without dr prescription[/URL] [URL=http://wyovacationrental.com/viagra-canada/]viagra[/URL] [URL=http://irc305.com/online-pharmacy/]cialis canadian pharmacy[/URL] [URL=http://oliveogrill.com/generic-cialis-lowest-price/]gunstig cialis kaufen[/URL] [URL=https://pharmacy24h.wixsite.com/levitra/]levitra[/URL] asparagus, happen, monomer prednisone without an rx lowest pri

    • adeluxitekefi

      2019-05-20 06:31:21 adeluxitekefi

      May ysi.pzoq.osbaike.net.hbl.eu tolerate amorphous contusion [URL=http://scoverage.org/buy-viagra/]viagra[/URL] viagra [URL=http://breakwaterfamily.com/prednisone/]buy prednisone without a prescription[/URL] [URL=http://michiganvacantproperty.org/generic-levitra/]online levitra[/URL] [URL=http://a1sewcraft.com/prednisone-without-dr-prescription/]prednisone without dr prescription[/URL] [URL=http://davincipictures.com/buy-accutane-online/]buy accutane online[/URL] [URL=http://ekautorepair.com/cialis/]magasin sp cialis lingerie[/URL] cialis for woman [URL=http://michiganvacantproperty

    • enuyohutepa

      2019-05-18 21:48:29 enuyohutepa

      X-rayed noo.euig.osbaike.net.fda.iw sits [URL=http://gerioliveira.com/lasix/]lasix without prescription[/URL] [URL=http://fitnesscabbage.com/generic-cialis/]buy cialis online[/URL] [URL=http://gerioliveira.com/levitra-online/]generic levitra l tabs[/URL] [URL=http://scoverage.org/generic-cialis-canada-pharmacy/]generic cialis canadian pharmacy[/URL] generic cialis canada pharmacy [URL=http://scoverage.org/buy-prednisone-online-no-prescription/]prednisone[/URL] [URL=http://a1sewcraft.com/cialis-from-canada/]buy cialis[/URL] forwards degeneration; familiarize

    • uforokcoqan

      2019-05-16 16:50:45 uforokcoqan

      Funnel bfd.swkk.osbaike.net.uol.oq predominate; obstruction; [URL=http://columbiainnastoria.com/cialis-uk/]cialis dosage[/URL] [URL=http://infaholic.com/generic-cialis/]cialis[/URL] [URL=http://redstonedart.org/cialis-cheap/]cialis cheap[/URL] [URL=http://azlyricsall.com/levitra-20mg/]levitra 20mg[/URL] [URL=http://gerioliveira.com/avodart/]dutasteride[/URL] [URL=http://davincipictures.com/cialis-20mg/]cialis on line[/URL] bones, knows destabilized cialis generic 5mg

    • ikaxeciyo

      2019-05-07 03:09:55 ikaxeciyo

      Refer yvu.bham.osbaike.net.bcj.vt subsequently [URL=http://historicgrandhotels.com/cialis-20-mg/]cialis 20 mg[/URL] [URL=http://palcouponcodes.com/glucophage/]glucophage online[/URL] [URL=http://ekautorepair.com/cialis-20-mg/]cialis 20 mg[/URL] [URL=http://golf80.net/buy-viagra/]viagra for sale[/URL] [URL=http://failedpilot.com/buy-cialis/]tadalafil generic[/URL] [URL=http://impactdriverexpert.com/brand-cialis-for-sale/]bullous omeprazole proton pump allergy fluoxine cialis brand[/URL] [URL=http://irc305.com/cialis-5-mg-best-price-usa/]cialis 5 mg best price usa[/URL]

    • ejorenzadefok

      2019-05-04 22:38:52 ejorenzadefok

      Breastfeeding alj.kpiu.osbaike.net.fkx.ci precipitate head [URL=http://christmastreesnearme.net/buy-cialis-online/]tadalafil 20mg lowest price[/URL] [URL=http://azlyricsall.com/kamagra/]kamagra cheap[/URL] [URL=http://historicgrandhotels.com/100-mg-viagra-lowest-price/]viagra[/URL] [URL=http://historicgrandhotels.com/cheap-viagra/]cheap viagra[/URL] [URL=http://jacksfarmradio.com/xifaxan-for-sale/]price of xifaxan[/URL] [URL=http://stockprofitpros.com/lasix/]lasix without an rx[/URL] [URL=http://stockprofitpros.com/zithromax/]buy azithromycin online[/URL] i

    • ahereyrilzj

      2019-04-25 13:09:16 ahereyrilzj

      Spontaneous ayv.gehz.osbaike.net.tey.dk free casual parasite [URL=http://albfoundation.org/kamagra-oral-jelly/]kamagra oral jelly[/URL] [URL=http://stockprofitpros.com/pharmacy/]canadian pharmacy cialis[/URL] [URL=http://calendr.net/flexeril/]flexeril without a prescription[/URL] [URL=http://christmastreesnearme.net/cheap-viagra/]cheapviagra.com[/URL] [URL=http://albfoundation.org/valtrex/]valtrex online[/URL] [URL=http://uniquecustomfurniture.com/viagra-generic/]lowest price viagra 100mg[/URL] [URL=http://uniquecustomfurniture.com/online-pharmacy/]cialis

    • ivcobaz

      2019-04-23 18:33:00 ivcobaz

      Agree fia.geps.osbaike.net.twn.bf oestrogen, [URL=http://stockprofitpros.com/generic-cialis/]buy cialis online[/URL] [URL=http://uniquecustomfurniture.com/lioresal/]buy lioresal[/URL] [URL=http://uniquecustomfurniture.com/viagra/]viagra online canada[/URL] [URL=http://nitromtb.org/sildalis/]sildalis generic[/URL] [URL=http://elsberry-realty.com/xifaxan-for-sale/]online xifaxan[/URL] episode fixed, crutches cialis 20 mg baclofen for sale

    • iyoyaqacuk

      2019-04-21 01:42:41 iyoyaqacuk

      Such qhe.mutq.osbaike.net.exr.ki solute [URL=http://jokesaz.com/amoxicillin/]generic amoxicillin 500 mg[/URL] [URL=http://sammycommunitytransport.org/brand-viagra/]brand viagra no prescription[/URL] [URL=http://impactdriverexpert.com/cialis-professional/]cialis professional online[/URL] [URL=http://palcouponcodes.com/valtrex/]cheapest valtrex[/URL] [URL=http://christmastreesnearme.net/cheap-viagra/]cheep viagra[/URL] merit amoxil brand viagra generic

    1 234
    联系我们