User since: Oct 15, 2004 at 13:22 UTC (19 years ago) Last here: Nov 29, 2023 at 18:09 UTC (3 days ago) Experience: 10107 Level: Prior (17) Writeups: 550 Location: n/a User's localtime: Dec 03, 2023 at 00:12 UTC Scratchpad: View For this user: Search nodes

The Elephant doesn't forget.

    Date    | db-engines | db-engines |   %   
            |    score   |   score    |       
            |   Oracle   |  Postgres  |       
------------+------------+------------+-------
 2022-09-01 |       1238 |        620 |  50.1
 2021-09-01 |       1272 |        578 |  45.4
 2020-09-01 |       1369 |        542 |  39.6
 2019-09-01 |       1347 |        482 |  35.8
 2018-09-01 |       1309 |        406 |  31.0
 2017-09-01 |       1359 |        372 |  27.4
 2016-09-01 |       1426 |        316 |  22.2
 2015-09-01 |       1463 |        286 |  19.6
 2014-09-01 |       1467 |        256 |  17.4
 2013-09-01 |       1530 |        182 |  11.9
 2012-11-01 |       1517 |        195 |  12.9
(11 rows)

Time: 3.050 ms

--  file /tmp/db-engines.com_en_ranking_trend.txt

Nothing in Intelligent Design makes sense except in the light of Creationism   (original quote)

(The above paraphrase-quote was to go with a previous picture showing that evolutiondisbelief in the United States is almost as widespread as it is in Turkey (which I found astonishing) -- see fig. 2 in: this article (paywall!))

PostgreSQL release 16 - 15 September 2023

Legacy versions are: PostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21 - 10th August 2023

Versions 10 and lower are no longer supported (i.e., EOL = End of Life)

PostgreSQL development is done in so-called commitfests (a month-long period of committing patches in burst-mode.

Development patches (=new features) are semi-automatically tested in the Patch Tester (to play with patches: go get them there: there are links to the main mailing list, pgsql-hackers, where devs submit patches for scrutiny - there is a github repo but no pull-request-development)

dev docs (git master=xxdevel)

Waiting for ... (depesz.com) new features committed in PostgreSQL git master (=xxdevel)

(Of course you can also just read the commit log)


http://www.db-fiddle.com A nice tool to experiment with different flavours of SQL.


PostgreSQL / featurematrix

PostgreSQL Development: git://git.postgresql.org/git/postgresql.git / gitweb view

feb 2022 OaaP - Oracle-as-a-Pest: "Expect sales reps' calls if IT wants to ditch Oracle"
dec 2021 MySql is a pretty poor database
(PDF) Gaia and postgres
oracle cloud foulup (2017)
CodingHorror Happy (2018)
PostgreSQL learns to walk and chew gum - First shot at parallelisation arrives
Michael Stonebraker, initiator of Ingres and Postgres, gets Turing Award
"Unbreakable" Oracle turns out highly breakable - glaring oracle backdoor
PostgreSQL's hipper, feistier self: interview with Bruce Momjian (June 2014)
Because MySQL is the PHP of databases (reddit, May 2014)
War on Oracle (May 2013)
The gift that keeps on giving to Oracle ... is dying (Dec 2012)
Why Oracle must kiss goodbye to its database past (Sept 2012)
PostgreSQL / French government (sept 2012)
PostgreSQL vs. Oracle (2007 SPEC)
Oracle squeezing MySQL (Oct 2012)
PostgreSQL vs. Sybase (Nov 2011, report of a Sybase->Pg migration
PostgreSQL vs. Brand "M" (must you ask?)    (more of the same)
Why PostgreSQL Instead of Brand "M" 2009 (again...)
Is MySQL really this bad? (2008)
Oracle is in decline (Dec 2011)
Oracle/RAC: (PDF) You_Probably_Dont_Need_RAC (2003) (PDF)

10 reasons why postgres >> sql-server

PostgreSQL has stored procedures in several languages. One of those languages is Perl.
See the fine manual.





I've been doing Perl on and off for more than 20 years. Working structured and using strict makes Perl lose some of that uncanny ability to understand intention, but it is still easily the best language there is.

Somebody had to say it. ;)

TWIMC: TEI encoding projects



<img src="http://i.imgur.com/eMyw6.gif" alt="elephant hands down" title="elephant hands down" />

media hacks