Timeline for Data dump, Programmers and Software Engineering
Current License: CC BY-SA 3.0
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 |