PostgreSQL
Hex Artifact Content
Not logged in

Artifact 274f8d093b25d6658e2785ec917a1ed91aacaabf:

Wiki page [HomePage] by drh 2014-05-19 10:10:38.
0000: 44 20 32 30 31 34 2d 30 35 2d 31 39 54 31 30 3a  D 2014-05-19T10:
0010: 31 30 3a 33 38 2e 37 34 32 0a 4c 20 48 6f 6d 65  10:38.742.L Home
0020: 50 61 67 65 0a 50 20 37 33 32 63 32 31 33 65 36  Page.P 732c213e6
0030: 30 36 30 39 65 31 35 34 36 36 33 64 62 38 36 61  0609e154663db86a
0040: 32 63 34 66 35 61 39 63 39 33 31 66 37 65 32 0a  2c4f5a9c931f7e2.
0050: 55 20 64 72 68 0a 57 20 31 34 37 35 0a 54 68 69  U drh.W 1475.Thi
0060: 73 20 5b 68 74 74 70 3a 2f 2f 77 77 77 2e 66 6f  s [http://www.fo
0070: 73 73 69 6c 2d 73 63 6d 2e 6f 72 67 2f 20 7c 20  ssil-scm.org/ | 
0080: 46 6f 73 73 69 6c 5d 20 72 65 70 6f 73 69 74 6f  Fossil] reposito
0090: 72 79 20 68 6f 6c 64 73 20 61 20 73 6e 61 70 73  ry holds a snaps
00a0: 68 6f 74 20 6f 66 0d 0a 74 68 65 20 5b 68 74 74  hot of..the [htt
00b0: 70 3a 2f 2f 77 77 77 2e 70 6f 73 74 67 72 65 73  p://www.postgres
00c0: 71 6c 2e 6f 72 67 2f 20 7c 20 50 6f 73 74 67 72  ql.org/ | Postgr
00d0: 65 53 51 4c 5d 20 73 6f 75 72 63 65 20 63 6f 64  eSQL] source cod
00e0: 65 20 74 61 6b 65 6e 20 66 72 6f 6d 20 74 68 65  e taken from the
00f0: 0d 0a 47 69 74 20 72 65 70 6f 73 69 74 6f 72 79  ..Git repository
0100: 20 61 74 20 67 69 74 3a 2f 2f 67 69 74 2e 70 6f   at git://git.po
0110: 73 74 67 72 65 73 71 6c 2e 6f 72 67 2f 67 69 74  stgresql.org/git
0120: 2f 70 6f 73 74 67 72 65 73 71 6c 2e 67 69 74 20  /postgresql.git 
0130: 6f 6e 20 32 30 31 34 2d 30 35 2d 31 37 2e 0d 0a  on 2014-05-17...
0140: 0d 0a 54 68 65 20 70 75 72 70 6f 73 65 20 6f 66  ..The purpose of
0150: 20 74 68 69 73 20 73 6e 61 70 73 68 6f 74 20 69   this snapshot i
0160: 73 20 74 6f 20 64 65 6d 6f 6e 73 74 72 61 74 65  s to demonstrate
0170: 20 74 68 65 20 73 75 70 65 72 69 6f 72 69 74 79   the superiority
0180: 20 6f 66 20 61 0d 0a 72 65 6c 61 74 69 6f 6e 61   of a..relationa
0190: 6c 20 64 61 74 61 62 61 73 65 20 28 75 73 65 64  l database (used
01a0: 20 62 79 20 46 6f 73 73 69 6c 29 20 6f 76 65 72   by Fossil) over
01b0: 20 61 20 6b 65 79 2d 76 61 6c 75 65 20 64 61 74   a key-value dat
01c0: 61 62 61 73 65 20 28 75 73 65 64 20 62 79 20 47  abase (used by G
01d0: 69 74 29 0d 0a 62 79 20 70 72 6f 76 69 64 69 6e  it)..by providin
01e0: 67 20 61 20 70 6c 61 74 66 6f 72 6d 20 6f 6e 20  g a platform on 
01f0: 77 68 69 63 68 20 74 6f 20 73 68 6f 77 20 68 6f  which to show ho
0200: 77 20 73 69 6d 70 6c 65 20 53 51 4c 20 71 75 65  w simple SQL que
0210: 72 69 65 73 20 63 61 6e 20 65 78 74 72 61 63 74  ries can extract
0220: 0d 0a 75 73 65 66 75 6c 20 69 6e 66 6f 72 6d 61  ..useful informa
0230: 74 69 6f 6e 20 66 72 6f 6d 20 61 20 6c 61 72 67  tion from a larg
0240: 65 20 73 6f 75 72 63 65 20 72 65 70 6f 73 69 74  e source reposit
0250: 6f 72 79 20 74 68 61 74 20 77 6f 75 6c 64 20 62  ory that would b
0260: 65 20 64 69 66 66 69 63 75 6c 74 20 74 6f 0d 0a  e difficult to..
0270: 6f 62 74 61 69 6e 20 77 69 74 68 6f 75 74 20 61  obtain without a
0280: 20 68 69 67 68 2d 6c 65 76 65 6c 20 71 75 65 72   high-level quer
0290: 79 20 6c 61 6e 67 75 61 67 65 20 73 75 63 68 20  y language such 
02a0: 61 73 20 53 51 4c 2e 0d 0a 0d 0a 53 6f 6d 65 20  as SQL.....Some 
02b0: 69 6e 74 65 72 65 73 74 69 6e 67 20 6c 69 6e 6b  interesting link
02c0: 73 3a 0d 0a 0d 0a 20 20 2a 20 20 5b 2f 72 65 70  s:....  *  [/rep
02d0: 6f 72 74 73 3f 76 69 65 77 3d 62 79 75 73 65 72  orts?view=byuser
02e0: 20 7c 20 43 68 65 63 6b 2d 69 6e 20 63 6f 75 6e   | Check-in coun
02f0: 74 73 20 62 79 20 75 73 65 72 5d 0d 0a 20 20 2a  ts by user]..  *
0300: 20 20 5b 2f 74 69 6d 65 6c 69 6e 65 3f 61 3d 31    [/timeline?a=1
0310: 39 37 30 2d 30 31 2d 30 31 26 6e 3d 31 30 20 7c  970-01-01&n=10 |
0320: 20 54 68 65 20 66 69 72 73 74 20 31 30 20 63 68   The first 10 ch
0330: 65 63 6b 2d 69 6e 73 5d 0d 0a 20 20 2a 20 20 5b  eck-ins]..  *  [
0340: 2f 74 69 6d 65 6c 69 6e 65 3f 63 3d 32 30 30 30  /timeline?c=2000
0350: 2d 30 35 2d 32 39 26 6e 64 20 7c 20 57 68 61 74  -05-29&nd | What
0360: 20 77 61 73 20 50 47 20 64 6f 69 6e 67 20 77 68   was PG doing wh
0370: 65 6e 20 53 51 4c 69 74 65 20 77 61 73 20 66 69  en SQLite was fi
0380: 72 73 74 20 73 74 61 72 74 65 64 3f 5d 0d 0a 20  rst started?].. 
0390: 20 2a 20 20 5b 2f 66 69 6e 66 6f 3f 6e 61 6d 65   *  [/finfo?name
03a0: 3d 73 72 63 2f 62 61 63 6b 65 6e 64 2f 63 6f 6d  =src/backend/com
03b0: 6d 61 6e 64 73 2f 70 72 65 70 61 72 65 2e 63 20  mands/prepare.c 
03c0: 7c 20 48 69 73 74 6f 72 79 20 6f 66 20 74 68 65  | History of the
03d0: 20 73 72 63 2f 62 61 63 6b 65 6e 64 2f 63 6f 6d   src/backend/com
03e0: 6d 61 6e 64 73 2f 70 72 65 70 61 72 65 2e 63 20  mands/prepare.c 
03f0: 73 6f 75 72 63 65 20 66 69 6c 65 5d 0d 0a 20 20  source file]..  
0400: 2a 20 20 5b 2f 73 74 61 74 20 7c 20 52 65 70 6f  *  [/stat | Repo
0410: 73 69 74 6f 72 79 20 73 74 61 74 69 73 74 69 63  sitory statistic
0420: 73 5d 0d 0a 0d 0a 54 68 69 73 20 69 73 20 6e 6f  s]....This is no
0430: 74 20 61 6e 20 6f 66 66 69 63 69 61 6c 20 72 65  t an official re
0440: 70 6f 73 69 74 6f 72 79 20 61 6e 64 20 69 73 20  pository and is 
0450: 75 6e 73 75 70 70 6f 72 74 65 64 2e 0d 0a 0d 0a  unsupported.....
0460: 54 68 69 73 20 72 65 70 6f 73 69 74 6f 72 79 20  This repository 
0470: 77 61 73 0d 0a 63 72 65 61 74 65 64 20 61 73 20  was..created as 
0480: 73 75 70 70 6c 65 6d 65 6e 74 61 6c 20 69 6e 66  supplemental inf
0490: 6f 72 6d 61 74 69 6f 6e 20 66 6f 72 20 74 68 65  ormation for the
04a0: 20 6b 65 79 6e 6f 74 65 20 74 61 6c 6b 20 61 74   keynote talk at
04b0: 0d 0a 5b 68 74 74 70 3a 2f 2f 77 77 77 2e 70 67  ..[http://www.pg
04c0: 63 6f 6e 2e 6f 72 67 2f 32 30 31 34 2f 20 7c 20  con.org/2014/ | 
04d0: 50 47 63 6f 6e 20 32 30 31 34 5d 20 61 6e 64 20  PGcon 2014] and 
04e0: 69 73 20 65 70 68 65 6d 65 72 61 6c 2e 0d 0a 43  is ephemeral...C
04f0: 6c 6f 6e 65 20 74 68 69 73 20 72 65 70 6f 73 69  lone this reposi
0500: 74 6f 72 79 20 69 66 20 79 6f 75 20 77 61 6e 74  tory if you want
0510: 20 74 6f 20 6b 65 65 70 20 69 74 20 62 65 63 61   to keep it beca
0520: 75 73 65 20 69 74 20 77 69 6c 6c 20 70 72 6f 62  use it will prob
0530: 61 62 6c 79 0d 0a 62 65 20 64 65 6c 65 74 65 64  ably..be deleted
0540: 20 61 66 74 65 72 20 61 20 66 65 77 20 6d 6f 6e   after a few mon
0550: 74 68 73 2e 20 20 4f 72 20 72 65 63 72 65 61 74  ths.  Or recreat
0560: 65 20 79 6f 75 72 20 6f 77 6e 20 72 65 70 6f 73  e your own repos
0570: 69 74 6f 72 79 20 6f 66 0d 0a 50 6f 73 74 67 72  itory of..Postgr
0580: 65 53 51 4c 20 66 72 6f 6d 20 74 68 65 20 47 69  eSQL from the Gi
0590: 74 20 72 65 70 6f 73 69 74 6f 72 79 20 75 73 69  t repository usi
05a0: 6e 67 20 74 68 65 20 66 6f 6c 6c 6f 77 69 6e 67  ng the following
05b0: 20 63 6f 6d 6d 61 6e 64 3a 0d 0a 0d 0a 3c 62 6c   command:....<bl
05c0: 6f 63 6b 71 75 6f 74 65 3e 3c 76 65 72 62 61 74  ockquote><verbat
05d0: 69 6d 3e 0d 0a 67 69 74 20 66 61 73 74 2d 65 78  im>..git fast-ex
05e0: 70 6f 72 74 20 2d 2d 61 6c 6c 20 7c 20 66 6f 73  port --all | fos
05f0: 73 69 6c 20 69 6d 70 6f 72 74 20 70 67 2e 66 6f  sil import pg.fo
0600: 73 73 69 6c 0d 0a 3c 2f 76 65 72 62 61 74 69 6d  ssil..</verbatim
0610: 3e 3c 2f 62 6c 6f 63 6b 71 75 6f 74 65 3e 0d 0a  ></blockquote>..
0620: 0a 5a 20 36 35 63 35 37 38 37 39 62 32 39 32 35  .Z 65c57879b2925
0630: 64 37 65 63 64 31 35 31 38 33 38 64 33 31 32 36  d7ecd151838d3126
0640: 36 66 65 0a                                      6fe.