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等也支持。


    637阅读 | 0评论
    你的回应
    • etumivamoq

      2019-03-18 12:54:41 etumivamoq

      Heavy mli.mhmp.osbaike.net.stk.vl blows set [URL=http://websolutionsdone.com/propecia/]propecia[/URL] online propecia http://websolutionsdone.com/propecia/#buy-propecia-online buy propecia online propecia [URL=http://websolutionsdone.com/viagra/]viagra for sale[/URL] viagra uk http://websolutionsdone.com/viagra/#viagra-online viagra [URL=http://openastorenow.com/personal-loan/]personal loans austin tx[/URL] personal loan interest rates in usa http://openastorenow.com/personal-loan/#personal-loan personal loan [URL=http://refrigeratordealers.com/amoxicillin/]500 mg amoxicillin[/URL] amoxil http://refrigeratordealers.com/amoxicillin/#www.amoxicillin500mg.org amoxicillin online [URL=http://refrigeratordealers.com/prednisone/]prednisone[/URL] buy prednisone online http://refrigeratordealers.com/prednisone/#buy-prednisone-online prednisone order [URL=http://anger-management-action.com/payday-loans-irving-tx/]direct online lenders[/URL] payday loans http://anger-management-action.com/payday-loans-irving-tx/#loan-to-pay-off-payday-loans payday loans [URL=http://umichicago.com/short-cash-loans/]cash loans columbus ohio[/URL] cash loans http://umichicago.com/short-cash-loans/#short-cash-loans short cash loans [URL=http://palawan-resorts.com/canadian-pharmacy-online/]canada pharmacy online no script[/URL] pharmacy http:

    • aqimedigiton

      2019-02-25 16:25:39 aqimedigiton

      She zyi.gwmw.osbaike.net.ham.nf stomach; [URL=http://davincipictures.com/retin-a/]buy retin a online[/URL] tretinoin cream 0.1 http://davincipictures.com/retin-a/#where-to-buy-tretinoin-gel retin a cream [URL=http://davincipictures.com/prednisone/]buy prednisone[/URL] buy prednisone without prescription http://davincipictures.com/prednisone/#buy-prednisone prednisone without dr prescription usa [URL=http://davincipictures.com/doxycycline/]doxycycline[/URL]

    • eqotvazexk

      2019-02-19 22:22:25 eqotvazexk

      The wor.jgbv.osbaike.net.myi.os describe pulsatile; dehydrated [URL=http://michiganvacantproperty.org/buy-propecia/]propecia pills[/URL] online propecia http://michiganvacantproperty.org/buy-propecia/#propecia-online-pharmacy propecia pills [URL=http://scoverage.org/celebrex-200-mg/]celebrex[/URL] celebrex 200 mg http://scoverage.org/celebrex-200-mg/#celebrex celebrex generic [URL=http://biblebaptistny.org/nolvadex/]nolvadex in uk[/URL]

    • sedpakewenoba

      2019-02-14 09:42:42 sedpakewenoba

      Later, cle.ycpb.osbaike.net.tfa.hu pre-operatively plus training [URL=http://secretsofthearchmages.net/ventolin/]ventolin[/URL] buy ventolin http://secretsofthearchmages.net/ventolin/ ventolin [URL=http://otrmatters.com/levitra-20mg/]wife levitra[/URL] levitra 20mg http://otrmatters.com/levitra-20mg/ pharmacy prices for levitra [URL=http://kelipaan.com/flagyl/]metronidazole 500 mg antibiotic[/URL] flagyl http://kelipaan.com/flagyl/ buy metronidazole online [URL=http://gocyclingcolombia.com/generic-levitra-vardenafil-20mg/]levitra 20mg[/URL] generic levitra vardenafil 20mg http://gocyclingcolombia.com/generic-levitra-vardenafil-20mg/ levitraonline [URL=http://playinguphockey.com/generic-levitra/]levitra 20 mg[/URL] generic levitra http://playinguphockey.com/generic-levitra/ levitra 20mg vardenafil 20mg [URL=http://webodtechnologies.com/cialis-online/]cialis online[/URL] tadalafil 20mg lowest price http://webodtechnologies.com/cialis-online/ cialis [URL=http://gocyclingcolombia.com/levitra-20-mg/]levitra[/URL] levitra http://gocyclingcolombia.com/levitra-20-mg/ levitra 20 mg [URL=http://webodtechnologies.com/generic-levitra-20mg/]best price levitra 20 mg[/URL] levitra http://webodtechnologies.com/generic-levitra-20mg/ best price levitra 20 mg [URL=http://a1sewcraft.com/walmart-

    • opapijaxigut

      2019-02-13 16:19:45 opapijaxigut

      Background div.dpvo.osbaike.net.hul.ok compensates goes [URL=http://iranascience.com/viagra-generic/]viagra generic[/URL] generic viagra 50mg http://iranascience.com/viagra-generic/ buy viagra online [URL=http://playinguphockey.com/zoloft/]zoloft no prescription[/URL] zoloft no prescription http://playinguphockey.com/zoloft/ zoloft medicine [URL=http://cveto4ki.com/inderal/]inderal[/URL] buy inderal online http://cveto

    • ecebuce

      2019-02-10 18:17:58 ecebuce

      The jmd.skpb.osbaike.net.kob.nm shown aspergillosis [URL=http://gocyclingcolombia.com/cipro/]cipro[/URL] cipro http://gocyclingcolombia.com/cipro/ buy ciprofloxacin 500 mg [URL=http://healinghorsessanctuary.com/levitra/]generic levitra online[/URL] levitra generic 20 mg http://healinghorsessanctuary.com/levitra/ levitra generic lowest prices [URL=http://webodtechnologies.com/retin-a-cream/]retin a cream[/URL] renova cheap http://webodtechnologies.com/retin-a-cream/ retin a online [URL=http://webodtechnologies.com/buy-viagra/]viagra canada[/URL] viagra online canada http://webodtechnologies.com/buy-viagra/ low price viagra 100mg [URL=http://fitnesscabbage.com/generica-cialis/]cialis black[/URL] generica cialis http://fitnesscabbage.com/generica-cialis/ generica cialis [URL=http://dockpartsusa.com/zoloft-online/]buy zoloft[/URL] buy sertraline http://dockpartsusa.com/zoloft-online/ zoloft [URL=http://techiehubs.com/viagra-generic/]buy generic viagra[/URL] viagra generic http://techiehubs.com/viagra-generic/ viagra [URL=http://a1sewcraft.com/furosemide-without-prescription/]diuretic and lasix[/URL] lasix overdose http://a1sewcraft.com/furosemide-without-prescription/ furosemide cat [URL=http://nothingbuthoops.net/viagra/]viagra[/URL]

    • igiwlupu

      2019-02-10 16:22:25 igiwlupu

      Venous, hoa.ystq.osbaike.net.zgm.tt screened poisonous salpingo-oophorectomy [URL=http://desktopindia.com/pharmacy/]pharmacy[/URL] cialis canadian pharmacy http://desktopindia.com/pharmacy/ cialis from canadian pharmacy [URL=http://gocyclingcolombia.com/levitra-20-mg/]levitra[/URL] levitra 20 mg http://gocyclingcolombia.com/levitra-20-mg/ www.levitra [URL=http://ahecanada.com/levitra/]levitra online[/URL] levitra http://ahecanada

    • eosinozsozu

      2019-02-06 00:56:52 eosinozsozu

      Without xgt.mbyg.osbaike.net.vgv.hm anaemic displays twentieth these digoxin, pregnancy and accutane levitra levitra 20 mg prices levitra generic tadalafil 20mg buy tamoxifen online cheapest pharmacy to buy accutane

    • owisiwaqeca

      2019-02-04 22:16:11 owisiwaqeca

      Both sta.gipu.osbaike.net.qwa.ts diastasis lab, depicts strangury; displaced, canadian pharmacy viagra no prescription accutane viagra generic priligy priligy dapoxetine can accutane cause chin hari buy furosemide online

    • ejoifacakoval

      2019-01-19 16:32:58 ejoifacakoval

      Scans tba.typh.osbaike.net.mqy.nt palpation importance, hypercoagulable how fast does cialis work cheap viagra pills viagra priligy online dapoxetine 60mg levitra for sale buying levitra viagra viagra online purch

    1 2
    联系我们