Skip to main content
24 events
when toggle format what by license comment
Jul 27, 2017 at 7:40 history edited GlorfindelMod CC BY-SA 3.0
edited body; edited title
Mar 31, 2017 at 17:56 answer added Shog9 timeline score: 8
Mar 31, 2017 at 8:36 comment added Oded StaffMod @JasonC - the main issue is indeed the confusion over the names in the data dump. The DB names in our production databases and in SEDE shouldn't matter to anyone - the only reason I mention that is that "naturally", the names would from from prod -> SEDE -> data dump.
Mar 31, 2017 at 3:02 comment added Jason C Hey, so, I'm actually a little confused, now that I think about it. Why is there an issue here? How is a site named "Software Engineering" using a database named Programmers any different than, say, "Motor Vehicle Maintenance & Repair" using a database named Garage and a domain/API name/SEDE URL mechanics? What about "Mi Yodeya" and Judaism? Is there any reason e.g. the database names need to match the site name presented to users? Why is this an issue to think about? Or is the main issue user confusion over the names in the data dump?
Mar 30, 2017 at 20:14 history edited Shadow Wizard
edited tags
Mar 30, 2017 at 19:19 comment added Adam Lear StaffMod @FranckDernoncourt That's a different kind of thing. We normally produce the final dump and attach it to the site's proposal in Area 51. Apparently that step got forgotten in this case, but it's a process completely outside the regular quarterly data dump either way at the moment.
Mar 30, 2017 at 17:36 comment added Franck Dernoncourt Also Why has the closed beta site "Big Data" no dump available?
Mar 30, 2017 at 16:58 answer added Adam LearStaffMod timeline score: 18
Mar 30, 2017 at 16:32 answer added Jason C timeline score: 8
Mar 30, 2017 at 16:17 comment added Jason C Also another thing to consider, which may actually break a lot more than the DB name change itself, is changing SEDE query link URLs from /programmers/ (which they currently are) to /softwareengineering/. I suppose you could solve that with some 301 magic on data.stackexchange.com. (Or a mass URL replacement in posts, although that wouldn't account for external links.)
Mar 30, 2017 at 16:14 comment added Jason C Also how did/will you handle the API site name change, just out of curiosity? It appears both programmers and softwareengineering work right now, as synonyms.
Mar 30, 2017 at 16:01 comment added rene Mod If I rank those in the category power queries created by power users I would simply adapt the scripts to use the new/expected name in the wild and use whatever database name you like on the internal db. That will also prevent down time for this and all type of unforeseen issues.
Mar 30, 2017 at 15:56 comment added Oded StaffMod @rene - will have to dig into that, and yes, only queries that reference the db name should be effected.
Mar 30, 2017 at 15:54 comment added rene Mod any rough estimate how many SEDE queries are involved that breaks existing queries using the old name? That will only be true for queries where users typed the dbname themselves, right?
Mar 30, 2017 at 15:52 history edited OdedStaffMod CC BY-SA 3.0
added 226 characters in body
Mar 30, 2017 at 15:26 comment added Oded StaffMod @Cai - not that simple. There's availability groups and replication to consider, two different data centres etc...
Mar 30, 2017 at 15:10 comment added Jeremy Staff beer to alcohol may be another case to handle, if a change is going to be made.
Mar 30, 2017 at 15:05 history edited JeremyStaff
edited tags
Mar 30, 2017 at 15:03 comment added Cai OK, another question... how much downtime? If it's 5 minutes it's probably worth biting the bullet and doing it... if it's 5 hours probably not.
Mar 30, 2017 at 15:00 comment added Oded StaffMod @Cai - leaving the core db StackExchange.Programmers means we have to have a mapping to StackExchange.SoftwareEngineering somewhere in the pipeline.
Mar 30, 2017 at 14:58 comment added Cai Does leaving the core db as-is cause anyone any problems? (or to be more precise; would leaving the core db as-is and updating the dump/SEDE db cause anyone any problems?)
Mar 30, 2017 at 14:49 comment added Oded StaffMod As far as I know, yes. But this might come up again in the future.
Mar 30, 2017 at 14:48 comment added Patrick Hofman Is PSE the only 'problem'? Are there any other sites with renames?
Mar 30, 2017 at 14:45 history asked OdedStaffMod CC BY-SA 3.0