As many of the Social Tools depend on each other, they should probably support Postgres at the same time...
Description
Details
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Open | None | T87542 Social Tools Postgres support | |||
Resolved | ashley | T59761 Postgres support for Comments | |||
Resolved | None | T38153 WikiForum: No support for Postgresql (8.4 and above). | |||
Resolved | ashley | T59747 Support of PostgreSQL for BlogPage | |||
Open | Feature | None | T29732 Support of PostgreSQL in SocialProfile |
Event Timeline
Change 563596 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/UserStatus@master] PostgreSQL support
Change 563596 merged by jenkins-bot:
[mediawiki/extensions/UserStatus@master] PostgreSQL support
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
Change 567241 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/UserStatus@master] Some quick PostgreSQL fixes
Change 566368 merged by jenkins-bot:
[mediawiki/extensions/SportsTeams@master] Actor support, PostgreSQL support, documentation tweaks, random bug fixes esp. wrt. the UserStatus integration
Change 567241 merged by jenkins-bot:
[mediawiki/extensions/UserStatus@master] Some quick PostgreSQL fixes
Change 567376 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/SiteMetrics@master] PostgreSQL support
Change 567376 merged by Jack Phoenix:
[mediawiki/extensions/SiteMetrics@master] PostgreSQL support
Change 567379 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/AJAXPoll@master] PostgreSQL support
Change 567385 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/FanBoxes@master] PostgreSQL support
Change 567393 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/LinkFilter@master] PostgreSQL support
Change 567395 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/NewSignupPage@master] PostgreSQL support
Change 567396 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/PictureGame@master] PostgreSQL support
Change 567397 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/PollNY@master] PostgreSQL support
Change 567398 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/QuizGame@master] PostgreSQL support
Change 567399 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/Video@master] PostgreSQL support
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
Change 567419 merged by Jack Phoenix:
[mediawiki/extensions/SocialProfile@master] PostgreSQL fix for the DB query in Special:UpdateEditCounts
Change 567426 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/UserStatus@master] Quick & tiny PostgreSQL fix
Change 567426 merged by Jack Phoenix:
[mediawiki/extensions/UserStatus@master] Quick & tiny PostgreSQL fix
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. MediaWiki-extensions-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
Change 567395 merged by Jack Phoenix:
[mediawiki/extensions/NewSignupPage@master] PostgreSQL support
Change 567397 merged by Jack Phoenix:
[mediawiki/extensions/PollNY@master] PostgreSQL support
Change 567398 merged by Jack Phoenix:
[mediawiki/extensions/QuizGame@master] PostgreSQL support
Change 567393 merged by jenkins-bot:
[mediawiki/extensions/LinkFilter@master] PostgreSQL support
Change 567379 merged by jenkins-bot:
[mediawiki/extensions/AJAXPoll@master] PostgreSQL support
Change 567399 merged by jenkins-bot:
[mediawiki/extensions/Video@master] PostgreSQL support
Change 567396 merged by Jack Phoenix:
[mediawiki/extensions/PictureGame@master] PostgreSQL support
Change 570321 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/MiniInvite@master] PostgreSQL support
Change 570325 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/WikiForum@master] PostgreSQL support
Change 570321 merged by jenkins-bot:
[mediawiki/extensions/MiniInvite@master] PostgreSQL support
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
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
Change 570327 merged by jenkins-bot:
[mediawiki/extensions/MiniInvite@master] Run timestamp through Database#timestamp, for PostgreSQL compatibility
Change 570329 merged by jenkins-bot:
[mediawiki/extensions/AJAXPoll@master] Run timestamps through Database#timestamp, for PostgreSQL
Change 570824 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/VoteNY@master] Tweak the PostgreSQL actor patch
Change 570824 merged by jenkins-bot:
[mediawiki/extensions/VoteNY@master] Tweak the PostgreSQL actor patch
Change 570325 merged by jenkins-bot:
[mediawiki/extensions/WikiForum@master] PostgreSQL support
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
Change 588967 merged by jenkins-bot:
[mediawiki/extensions/UserStatus@master] PostgreSQL compatibility: run timestamps through Database#timestamp
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Change 617855 merged by jenkins-bot:
[mediawiki/extensions/LinkFilter@master] Wrap date() calls to be inserted into the DB in Database#timestamp for optimal PostgreSQL compatibility