user
erix
intelligence
MySQL_guru
lowlander
intellige
artificial
language
natural
AI
BioPerl
Generator
Parsing
NLP
Bioinformatics
<p>The Elephant doesn't forget.
<!-- <p>[https://en.wikipedia.org/wiki/Sarcosuchus | Sarcosuchus ]</p> -->
<br />
<p><pre>
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
</pre>
</p>
<br />
<!--
http://blogs.cfr.org/zenko/2016/02/20/evaluating-michael-haydens-defense-of-cia-drone-strikes/
<br />
<br />
-->
<!--
<p>(the article that contains the above picture is here:<br />
<a href="http://www.biochemj.org/bj/417/bj4170029.htm">http://www.biochemj.org/bj/417/bj4170029.htm</a> (pay-site) )
<br />
<p>( source: presentation Jim Gray (1999)
http://loci.cs.utk.edu/dsi/netstore99/ )
<br />
<br />
<br />
<br />[https://www.youtube.com/watch?v=KDiLEyT9spI | MH17 Crash - report ]
<br />
<br />[http://www.cepa.org/sites/default/files/Infowar%20Report.pdf | Disinformation as weapon ] PDF (Ben Nimmo & Edward Lucas)
<br />
[ https://www.youtube.com/watch?v=awArTC8iQ3Q | The Ferrari 330 P4 is One Sexy Beast ] <br />
-->
<br />
<br />
<br />
To paraphrase [wp://Dobzhansky]:<br />
<blockquote>
Nothing in Intelligent Design makes sense except in the light of Creationism
([
http://en.wikipedia.org/wiki/Nothing_in_Biology_Makes_Sense_Except_in_the_Light_of_Evolution|original quote])
</blockquote>
<p>(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: [https://portlandpress.com/biochemj/article-abstract/417/1/29/45187/Darwin-Dover-Intelligent-Design-and-textbooks|this article] (paywall!))
<br />
<br />
<!--
<p><a href="https://rhaas.blogspot.fr/2017/04/new-features-coming-in-postgresql-10.html" target="_blank">New Features Coming in PostgreSQL 10</a> (expected sept 2017)</p>
-->
<br />
<p><a href="https://www.postgresql.org/about/news/postgresql-161-155-1410-1313-1217-and-1122-released-2749/"
target="_blank">PostgreSQL release 16.1 November 2023</a></p>
<p>Legacy versions are:
PostgreSQL <a href="https://www.postgresql.org/about/news/postgresql-161-155-1410-1313-1217-and-1122-released-2749/" target="_blank">15.5, 14.10, 13.13, 12.17, 11.22 - November 2023</a>
<br />
<p>
Versions 11 and lower are no longer supported (i.e., EOL = End of Life)
</p>
<br />
<p>PostgreSQL development is done in so-called <a href="https://commitfest.postgresql.org/" target="_blank">commitfests</a> (a month-long period of committing patches in burst-mode.</p>
<p>Development patches (=new features) are semi-automatically tested in the <a href="http://commitfest.cputube.org/" target="_blank">Patch Tester</a> (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)</p>
<p><a href="http://www.postgresql.org/docs/devel/static/" target="_blank">dev docs (git master=xxdevel)</a>
<br />
<br />
<p><a href="https://www.depesz.com/waiting-for/" target="_blank">Waiting for ...</a> (depesz.com) new features committed in PostgreSQL git master (=xxdevel)<br />
<br />
(Of course you can also just read [http://git.postgresql.org/gitweb/?p=postgresql.git;a=log|the commit log])
<br />
<!--
<p><a href="https://www.postgresql.org/about/news/1777/" target="_blank">PostgreSQL 9.6.5</a> released (31 august 2017)</p>
<br />
<p>[http://www.postgresql.org/|PostgreSQL 9.5.5] is released -
<a href="http://www.postgresql.org/ftp/source/v9.5.5">source</a>/<a href="http://www.postgresql.org/download/">binary</a> downloads (august 11, 2016)
<br />
<p><a href="http://www.depesz.com/?s=waiting+for" target="_blank">Waiting for ...</a> (depesz.com) new features committed in the postgesql devel branch.<br />
<br />
(Of course you can also just read [http://git.postgresql.org/gitweb/?p=postgresql.git;a=log|the commit log])
<br />
<!--
<p><a href="https://en.wikipedia.org/w/index.php?title=PostgreSQL&oldid=729098581#Upcoming_features" target="_blank">what's new: 9.6 features</a>
<p><a href="https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5" target="_blank">What's new in PostgreSQL 9.5</a> (or at [http://en.wikipedia.org/wiki/Postgresql#Upcoming_features|wikipedia])
<br />
-->
<br />
<br />
<a href="http://www.db-fiddle.com" target="_blank">http://www.db-fiddle.com</a> A nice tool to experiment with different flavours of SQL.
<br />
<br />
<br />
<a href="http://www.postgresql.org/" target="_blank">PostgreSQL</a> / <a
href="http://www.postgresql.org/about/featurematrix" target="_blank">featurematrix</a>
<br />
<br />
<p><b>PostgreSQL Development:</b> git://git.postgresql.org/git/postgresql.git
/ <a href="http://git.postgresql.org/gitweb/?p=postgresql.git;a=summary" target="_blank">gitweb view</a>
<br />
<br />
<a href="https://www.theregister.com/2022/02/15/oracle_briefs_against_migrations_claim/" target="blank">feb 2022 OaaP - Oracle-as-a-Pest: "Expect sales reps' calls if IT wants to ditch Oracle"</a>
<br />
<a href="https://www.theregister.com/2021/12/06/mysql_a_pretty_poor_database/" target="blank">dec 2021 MySql is a pretty poor database</a>
<br />
<a href="http://2017.pgday.it/assets/Gaia_KN_2017_10_13_PGConfIT.compressed.pdf" target="blank"> (PDF) Gaia and postgres</a>
<br />
<a href="http://www.theregister.co.uk/2017/01/03/rutgers_university_oracle_cloud_foulup/" target="blank">
oracle cloud foulup (2017)
</a>
<br />
<a href="https://twitter.com/codinghorror/status/959583181841158144" target="blank">
CodingHorror Happy (2018)
</a>
<br />
<a href="http://www.theregister.co.uk/2015/11/13/postgresql_learns_to_walk_and_chew_gum/" target="blank">
PostgreSQL learns to walk and chew gum - First shot at parallelisation arrives
</a>
<br />
<a href="http://amturing.acm.org/award_winners/stonebraker_1172121.cfm" target="blank">Michael Stonebraker, initiator of Ingres and Postgres, gets Turing Award</a>
<br />
"Unbreakable" Oracle turns out highly breakable -
<a href="http://www.forbes.com/sites/thomasbrewster/2015/01/20/glaring-oracle-backdoor/" target="_blank">
glaring oracle backdoor</a>
<br />
<a href="http://www.techrepublic.com/article/postgresqls-hipper-feistier-self-an-interview-with-bruce-momjian/?utm_content=buffer9bc53&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer">PostgreSQL's hipper, feistier self: interview with Bruce Momjian (June 2014)</a>
<br />
<a href="http://www.reddit.com/r/PostgreSQL/comments/26u0wk/why_is_postgresql_becoming_more_popular_than_mysql/"
target="_blank">Because MySQL is the PHP of databases (reddit, May 2014)</a>
<br />
<a href="http://www.wired.com/wiredenterprise/2013/05/salesforce-tom-lane/"
target="_blank">War on Oracle (May 2013)</a>
<br />
<a href="http://www.theregister.co.uk/2012/12/04/open_and_shut_oracle/"
target="_blank">The gift that keeps on giving to Oracle ... is dying (Dec 2012)</a>
<br />
<a href="http://www.theregister.co.uk/2012/09/25/oracle_without_the_database/"
target="_blank">Why Oracle must kiss goodbye to its database past (Sept 2012)</a>
<br />
<a href="http://www.cio.com/article/717033/French_Government_Outlines_Plans_for_Free_Software_Adoption"
target="_blank">PostgreSQL / French government (sept 2012)</a>
<br />
<a href="http://www.spec.org/jAppServer2004/results/res2007q3/" target="_blank">PostgreSQL vs. Oracle</a> (2007 SPEC)
<br />
<a href="http://www.theregister.co.uk/2012/10/02/oracel_mysql/"
target="_blank">Oracle squeezing MySQL (Oct 2012)</a>
<br />
<a href="http://archives.postgresql.org/message-id/4ED5FD9C020000250004363C@gw.wicourts.gov" target="_blank">PostgreSQL vs. Sybase (Nov 2011, report of a Sybase->Pg migration</a>
<br />
<a href="http://tweakers.net/reviews/649/7" target="_blank">PostgreSQL vs. Brand "M"</a> (must you ask?)
(<a href="http://tweakers.net/reviews/674/8" target="_blank">more of the same</a>)
<br />
<a href="http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009" target="_blank">Why PostgreSQL Instead of Brand "M" 2009</a> (again...)
<br />
<a href="http://arstechnica.com/civis/viewtopic.php?f=20&t=92525">Is MySQL really this bad? (2008)</a>
<br />
<a href="http://www.bloomberg.com/news/2011-12-20/oracle-misses-estimates-as-clients-throttle-tech-spending-shares-decline.html" target="_blank">Oracle is in decline (Dec 2011)</a>
<br />
<!--
<a href="http://www.zdnetasia.com/news/business/0,39044229,62057752,00.htm">Oracle: vendor-lock-in (2009)</a>
<br />
-->
Oracle/RAC: <a href="http://www.my-idconcept.de/downloads/You_Probably_Dont_Need_RAC.pdf">(PDF) You_Probably_Dont_Need_RAC (2003) (PDF)</a><br />
<p>[http://datachomp.com/archives/top-10-reasons-i-like-postgres-over-sql-server/ | 10 reasons why postgres >> sql-server ]
<br />
<br />
<br />
<!--
-- DBD::Pg ppm (for windows):<br />
<a href="http://pgfoundry.org/projects/dbdpgppm/">DBD::Pg ppm at pgfoundry.org</a><br/>
<br/>
-->
<p>PostgreSQL has stored procedures in several languages. One of those languages is Perl.<br />See the [http://www.postgresql.org/docs/current/static/plperl.html|fine manual].
<br />
<br /><br /><br /><br /><br />
I've been doing Perl on and off for more than 20 years. Working
structured and using strict makes Perl lose some of that <a target="_blank"
href="/index.pl?node_id=62398">uncanny</a> ability to <i>understand intention</i>, but it is still easily the
best language there is.
<p>Somebody had to say it. ;)
<p>
<p>
<p>
<br />
<br />
<br />
TWIMC: [ http://www.tei-c.org/Activities/Projects/ |TEI encoding projects]<br />
<br />
<br />
<br />
<!--
<a href="http://www.cio.com.au/article/307446/aussie_skymapper_telescope_open_new_windows_exploration?pp=1">a 470 TB PostgreSQL installation (SkyMapper)</a><br />
-->
<a href="http://imgur.com/eMyw6">
<img src="http://i.imgur.com/eMyw6.gif"
alt="elephant hands down"
title="elephant hands down" />
</a>
<br >
<br >
<p><a
href="https://medium.com/in-beta/media-hacking-3b1e350d619c"
target=_blank>
media hacks</a>
2024-03-29 10:43:03
10177
399662
404069
%Y-%m-%d %H:%M:%S
553
on
85
<font color="red">&01; </font>