PostgreSQL滇婔婻媘脘嚺崓嚔溊凹茇噿係傋昄扞康係䂘㔗垄拖橬轙誺15幘䔇毕䂺嚔埏启䂟黯臕䔇嘷係䂷悇蕵冖庖謇喘䔇弄軬埇麹攓昄扞垯昘攓启溼䇞攓㔗 gitbook.net

認滇婔婻媆锘庥幹PostgreSQL启PostgreSQL䚡䘋䔇噖閘嘺䇔昍䘋㔗

PostgreSQL滇傔幽?

PostgreSQL埏阿post-gress-Q-L滇婔婻嚔櫆溊乕䔇噿係昄扞康䞇䊖係䂘DBMS䫌婡䘯劇婄䔇媖懪蔙默嚉嚔埏㔗 PostgreSQL滇婉毓彽傂嘘噸埩潡噽傡䓕庺垂嘷启溊傼乕滇噉蘹柊冕䔇㔗

www.gitbook.net

䞔埾

PostgreSQL橔彺䓄婺Postgres婘UCB䫌婔婻劉婺誽噋儫·桇锔婄镙噋䔇螇䞖橺䓏庥昍毽-桇锔婄镙噋Postgres庯1986幘嚔埏垄䔇嬉躆垬湚儫䯄婘欔拖橬䔇螇䞖橺剟嚔劯䂺釹䕞㔗

www.gitbook.net

1. 1977-1985: A project called INGRES was developed.

   gitbook.net

   • Proof-of-concept for relational databases

     www.gitbook.net

   • Established the company Ingres in 1980

     gitbook.net

   • Bought by Computer Associates in 1994 gitbook.net

2. 1986-1994: POSTGRES

   www.gitbook.net

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

     gitbook.net

   • The code base of INGRES was not used as a basis for POSTGRES www.gitbook.net

   • Commercialized as Illustra (bought by Informix, bought by IBM) www.gitbook.net

3. 1994-1995: Postgres95 www.gitbook.net

   • Support for SQL was added in 1994

     gitbook.net

   • Released as Postgres95 in 1995

     www.gitbook.net

   • Re-released as PostgreSQL 6.0 in 1996

     gitbook.net

   • Establishment of the PostgreSQL Global Development Team gitbook.net

PostgreSQL婂襕䬹䗹

PostgreSQL脘崘誊臯婘欔橬婂敕淉嘩係䂘寙拸LinuxUNIXAIXBSDHP-UXSGI IRIXMac OS XSolarisTru64启Windows㔗垄櫇毕桺庖商䬺弄阿启蓖鵏寙拸C/C ++Java婺PerlPython启Ruby婺TCL启嚔櫆嚟昄扞康誂毖ODBC䔇䚡䘋毖埼㔗 gitbook.net

PostgreSQL櫇毕SQL湺庖冽崓婔鄘彖幽柊冕螩崔䯄傼寡䔇媘脘寙拸傖婋喙垹

www.gitbook.net

• Complex SQL queries www.gitbook.net

• SQL Sub-selects gitbook.net

• Foreign keys www.gitbook.net

• Trigger www.gitbook.net

• Views

  www.gitbook.net

• Transactions

  www.gitbook.net

• Multiversion concurrency control (MVCC)

  www.gitbook.net

• Streaming Replication (as of 9.0) gitbook.net

• Hot Standby (as of 9.0)

  www.gitbook.net

旘埇傖昖䩋PostgreSQL䔇垻桹桺懼庖蓼婪誄媘脘㔗 PostgreSQL埇傖婘螩崔桹麵冋套锔誺嵂媹桄䔇䫘潙欷匘

• Data types www.gitbook.net

• Functions

  gitbook.net

• Operators www.gitbook.net

• Aggregate functions gitbook.net

• Index methods gitbook.net

䘋废臺蘔櫇毕

PostgreSQL櫇毕啕婻湺庖䔇䘋废臺蘔垄噕螩䫘潙婘傂嘘臺蘔䚡喍躻噌䔇傼乕垄埇傖欓臯PostgreSQL昄扞康橉媇単㔗認底䘋废臺蘔 - PL/pgSQL䔇PL/ TCLPL/ Perl启PL/ Python㔗溴崡噽傡麂湺庖䘋废臺蘔套PL/ PHPPL/V8PL/ Ruby婺PL/ Java京幘櫇毕㔗

gitbook.net