Page MenuHomePhabricator

Social Tools Postgres support
Open, LowPublic

Description

As many of the Social Tools depend on each other, they should probably support Postgres at the same time...

Details

ProjectBranchLines +/-Subject
mediawiki/extensions/SocialProfilemaster+11 -11
mediawiki/extensions/VoteNYmaster+1 -1
mediawiki/extensions/SportsTeamsmaster+1 -1
mediawiki/extensions/Commentsmaster+2 -2
mediawiki/extensions/QuizGamemaster+2 -2
mediawiki/extensions/PollNYmaster+2 -2
mediawiki/extensions/PictureGamemaster+2 -2
mediawiki/extensions/FanBoxesmaster+3 -3
mediawiki/extensions/NewSignupPagemaster+1 -1
mediawiki/extensions/LinkFiltermaster+1 -1
mediawiki/extensions/UserStatusmaster+2 -2
mediawiki/extensions/WikiForummaster+116 -10
mediawiki/extensions/VoteNYmaster+1 -1
mediawiki/extensions/AJAXPollmaster+3 -3
mediawiki/extensions/MiniInvitemaster+1 -1
mediawiki/extensions/MiniInvitemaster+16 -2
mediawiki/extensions/PictureGamemaster+48 -3
mediawiki/extensions/Videomaster+28 -2
mediawiki/extensions/AJAXPollmaster+24 -0
mediawiki/extensions/LinkFiltermaster+36 -3
mediawiki/extensions/QuizGamemaster+77 -2
mediawiki/extensions/PollNYmaster+59 -4
mediawiki/extensions/NewSignupPagemaster+18 -1
mediawiki/extensions/FanBoxesmaster+50 -3
mediawiki/extensions/UserStatusmaster+2 -2
mediawiki/extensions/SocialProfilemaster+4 -1
mediawiki/extensions/SiteMetricsmaster+654 -122
mediawiki/extensions/UserStatusmaster+4 -4
mediawiki/extensions/SportsTeamsmaster+360 -225
mediawiki/extensions/UserStatusmaster+47 -28
Show related patches Customize query in gerrit

Event Timeline

lcawte created this task.Jan 25 2015, 4:42 PM
lcawte raised the priority of this task from to Low.
lcawte updated the task description. (Show Details)
lcawte added a project: Social-Tools.
lcawte added a subscriber: lcawte.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 25 2015, 4:42 PM
SamanthaNguyen moved this task from Backlog to General on the Social-Tools board.May 8 2016, 3:08 PM

Change 563596 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/UserStatus@master] PostgreSQL support

https://gerrit.wikimedia.org/r/563596

Change 563596 merged by jenkins-bot:
[mediawiki/extensions/UserStatus@master] PostgreSQL support

https://gerrit.wikimedia.org/r/563596

Change 566368 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/SportsTeams@master] Actor support, PostgreSQL support, documentation tweaks, random bug fixes esp. wrt. the UserStatus integration

https://gerrit.wikimedia.org/r/566368

Change 567241 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/UserStatus@master] Some quick PostgreSQL fixes

https://gerrit.wikimedia.org/r/567241

Change 566368 merged by jenkins-bot:
[mediawiki/extensions/SportsTeams@master] Actor support, PostgreSQL support, documentation tweaks, random bug fixes esp. wrt. the UserStatus integration

https://gerrit.wikimedia.org/r/566368

Change 567241 merged by jenkins-bot:
[mediawiki/extensions/UserStatus@master] Some quick PostgreSQL fixes

https://gerrit.wikimedia.org/r/567241

Change 567376 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/SiteMetrics@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567376

Change 567376 merged by Jack Phoenix:
[mediawiki/extensions/SiteMetrics@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567376

Change 567379 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/AJAXPoll@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567379

Change 567385 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/FanBoxes@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567385

Change 567393 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/LinkFilter@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567393

Change 567395 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/NewSignupPage@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567395

Change 567396 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/PictureGame@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567396

Change 567397 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/PollNY@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567397

Change 567398 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/QuizGame@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567398

Change 567399 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/Video@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567399

Change 567419 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/SocialProfile@master] PostgreSQL fix for the DB query in Special:UpdateEditCounts

https://gerrit.wikimedia.org/r/567419

Change 567419 merged by Jack Phoenix:
[mediawiki/extensions/SocialProfile@master] PostgreSQL fix for the DB query in Special:UpdateEditCounts

https://gerrit.wikimedia.org/r/567419

Change 567426 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/UserStatus@master] Quick & tiny PostgreSQL fix

https://gerrit.wikimedia.org/r/567426

Change 567426 merged by Jack Phoenix:
[mediawiki/extensions/UserStatus@master] Quick & tiny PostgreSQL fix

https://gerrit.wikimedia.org/r/567426

Wow, thanks @ashley ! 💌

Wow, thanks @ashley ! 💌

You're welcome! :) Hopefully in the future we can say that "Social-Tools support all the DBMSes supported by MW core" (which is MySQL/MariaDB, SQLite and PostgreSQL currently) and it'll be an accurate statement; right now e.g. Comments' PG support is a bit buggy due to the stupid table name issue (T153012) and all the (unmerged) patches listed here need slight tweaking to add the OWNED BY bit to the sequences (see Anomie's comments on my Echo patch @ https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Echo/+/565045/), but for now, I invite you to test these schemas out and try to break 'em!
Because while basic testing has been done and some issues have been fixed, I'm absolutely confident there are still some bugs when using social tools with a PG backend (as they were originally written for one DBMS -- MySQL -- only; SQLite as well as PGSQL support are literally afterthoughts instead of something that was a design consideration and thus a part of the development process).

Change 567385 merged by Jack Phoenix:
[mediawiki/extensions/FanBoxes@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567385

Change 567395 merged by Jack Phoenix:
[mediawiki/extensions/NewSignupPage@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567395

Change 567397 merged by Jack Phoenix:
[mediawiki/extensions/PollNY@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567397

Change 567398 merged by Jack Phoenix:
[mediawiki/extensions/QuizGame@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567398

Change 567393 merged by jenkins-bot:
[mediawiki/extensions/LinkFilter@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567393

Change 567379 merged by jenkins-bot:
[mediawiki/extensions/AJAXPoll@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567379

Change 567399 merged by jenkins-bot:
[mediawiki/extensions/Video@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567399

Change 567396 merged by Jack Phoenix:
[mediawiki/extensions/PictureGame@master] PostgreSQL support

https://gerrit.wikimedia.org/r/567396

Change 570321 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/MiniInvite@master] PostgreSQL support

https://gerrit.wikimedia.org/r/570321

Change 570325 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/WikiForum@master] PostgreSQL support

https://gerrit.wikimedia.org/r/570325

Change 570321 merged by jenkins-bot:
[mediawiki/extensions/MiniInvite@master] PostgreSQL support

https://gerrit.wikimedia.org/r/570321

Change 570327 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/MiniInvite@master] Run timestamp through Database#timestamp, for PostgreSQL compatibility

https://gerrit.wikimedia.org/r/570327

Change 570329 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/AJAXPoll@master] Run timestamps through Database#timestamp, for PostgreSQL

https://gerrit.wikimedia.org/r/570329

Change 570327 merged by jenkins-bot:
[mediawiki/extensions/MiniInvite@master] Run timestamp through Database#timestamp, for PostgreSQL compatibility

https://gerrit.wikimedia.org/r/570327

Change 570329 merged by jenkins-bot:
[mediawiki/extensions/AJAXPoll@master] Run timestamps through Database#timestamp, for PostgreSQL

https://gerrit.wikimedia.org/r/570329

Change 570824 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/VoteNY@master] Tweak the PostgreSQL actor patch

https://gerrit.wikimedia.org/r/570824

Change 570824 merged by jenkins-bot:
[mediawiki/extensions/VoteNY@master] Tweak the PostgreSQL actor patch

https://gerrit.wikimedia.org/r/570824

Change 570325 merged by jenkins-bot:
[mediawiki/extensions/WikiForum@master] PostgreSQL support

https://gerrit.wikimedia.org/r/570325

Change 588967 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/UserStatus@master] PostgreSQL compatibility: run timestamps through Database#timestamp

https://gerrit.wikimedia.org/r/588967

Change 588967 merged by jenkins-bot:
[mediawiki/extensions/UserStatus@master] PostgreSQL compatibility: run timestamps through Database#timestamp

https://gerrit.wikimedia.org/r/588967

Change 617844 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/FanBoxes@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617844

Change 617845 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/NewSignupPage@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617845

Change 617846 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/PictureGame@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617846

Change 617847 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/PollNY@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617847

Change 617848 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/QuizGame@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617848

Change 617849 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/SocialProfile@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617849

Change 617850 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/Comments@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617850

Change 617852 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/SportsTeams@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617852

Change 617853 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/VoteNY@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617853

Change 617855 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/LinkFilter@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617855

Change 617845 merged by jenkins-bot:
[mediawiki/extensions/NewSignupPage@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617845

Change 617844 merged by jenkins-bot:
[mediawiki/extensions/FanBoxes@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617844

Change 617846 merged by jenkins-bot:
[mediawiki/extensions/PictureGame@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617846

Change 617847 merged by jenkins-bot:
[mediawiki/extensions/PollNY@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617847

Change 617848 merged by jenkins-bot:
[mediawiki/extensions/QuizGame@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617848

Change 617850 merged by jenkins-bot:
[mediawiki/extensions/Comments@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617850

Change 617852 merged by jenkins-bot:
[mediawiki/extensions/SportsTeams@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617852

Change 617853 merged by jenkins-bot:
[mediawiki/extensions/VoteNY@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617853

Change 617849 merged by jenkins-bot:
[mediawiki/extensions/SocialProfile@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility

https://gerrit.wikimedia.org/r/617849