[21:02:17] <TimStarling>	 #startmeeting RFC meeting
[21:02:18] <wm-labs-meetbot`>	 Meeting started Wed May 31 21:02:17 2017 UTC and is due to finish in 60 minutes.  The chair is TimStarling. Information about MeetBot at http://wiki.debian.org/MeetBot.
[21:02:18] <wm-labs-meetbot`>	 Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
[21:02:18] <wm-labs-meetbot`>	 The meeting name has been set to 'rfc_meeting'
[21:02:46] <TimStarling>	 #topic T164898 PostgreSQL schema change for consistency with MySQL
[21:02:47] <stashbot>	 T164898: PostgreSQL schema change for consistency with MySQL - https://phabricator.wikimedia.org/T164898
[21:04:33] <TimStarling>	 anyone here and interested in this topic?
[21:04:59] <Scott_WUaS>	 potentially yes
[21:07:06] <TimStarling>	 so far I've had comments on two subtopics
[21:07:29] <TimStarling>	 one is what schema abstraction is going to look like going forward, there have been previous proposals on this
[21:08:12] <TimStarling>	 currently our schema files are a kind of extended SQL
[21:08:46] <TimStarling>	 extended, but also increasingly restricted in what they can contain
[21:09:22] <TimStarling>	 if we go ahead with this change, then tables.sql files will only have CREATE TABLE and CREATE INDEX, and the CREATE TABLE statements will all be pretty straightforward
[21:10:23] <TimStarling>	 both mysql and postgresql will require type mapping
[21:11:01] <TimStarling>	 in postgresql there are (and will be) a few BYTEA columns
[21:11:30] <TimStarling>	 we can't use BYTEA for everything that MySQL uses TEXT/BLOB for
[21:11:58] <TimStarling>	 that is to say, BYTEA in the shared tables.sql will map to BLOB or something on MySQL
[21:12:50] <TimStarling>	 the other question I had was about switching from TIMESTAMPTZ to CHAR(14) since that seems like the saddest part of this proposal
[21:15:20] <TimStarling>	 anyway, there's not much point in me carrying on a monologue
[21:20:44] <bd808>	 I guess there aren't a lot of hard core postgres devs who are active or we wouldn't have as many schema issues to start with :/
[21:20:49] <Scott_WUaS>	 I'm not that familiar with these technologies.
[21:29:21] <legoktm>	 sorry for being late
[21:29:39] <legoktm>	 I don't think any of the postgres maintainers are really active anymore
[21:29:57] <legoktm>	 aude still is, other interested people were Tim L. and saper
[21:34:48] <MatmaRex>	 (saper is still around, or at least he appears if you CC him on a changeset. he'll probably respond if you email him or something)
[21:35:08] <TimStarling>	 I can email them I guess
[22:04:11] <TimStarling>	 #endmeeting
[22:04:12] <wm-labs-meetbot`>	 Meeting ended Wed May 31 22:04:11 2017 UTC.  Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)
[22:04:12] <wm-labs-meetbot`>	 Minutes:        https://tools.wmflabs.org/meetbot/wikimedia-office/2017/wikimedia-office.2017-05-31-21.02.html
[22:04:12] <wm-labs-meetbot`>	 Minutes (text): https://tools.wmflabs.org/meetbot/wikimedia-office/2017/wikimedia-office.2017-05-31-21.02.txt
[22:04:12] <wm-labs-meetbot`>	 Minutes (wiki): https://tools.wmflabs.org/meetbot/wikimedia-office/2017/wikimedia-office.2017-05-31-21.02.wiki
[22:04:13] <wm-labs-meetbot`>	 Log:            https://tools.wmflabs.org/meetbot/wikimedia-office/2017/wikimedia-office.2017-05-31-21.02.log.html