Page MenuHomePhabricator

prnk28
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

User Since
Sep 11 2015, 3:16 PM (205 w, 6 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
Tesselate [ Global Accounts ]

Recent Activity

Aug 26 2016

prnk28 updated the task description for T143494: Endterm evaluation for "Accuracy review of Wikipedia".
Aug 26 2016, 4:55 PM · Accuracy-Review-of-Wikipedias, Google-Summer-of-Code (2016)
prnk28 added a comment to T143494: Endterm evaluation for "Accuracy review of Wikipedia".

@prnk28 I am still waiting for
https://www.mediawiki.org/wiki/Accuracy_review/docs to be updated with a
non-technical preface for reviewers, and http://tools.wmflabs.org/arowf/
needs a paragraph summary of that. Also /ask should be just before /inspect
there, to emphasize that reviewing is the primary use?

Aug 26 2016, 4:55 PM · Accuracy-Review-of-Wikipedias, Google-Summer-of-Code (2016)

Aug 15 2016

prnk28 updated the task description for T135670: Weekly Reports for Accuracy Review of Wikipedia.
Aug 15 2016, 7:17 PM · Google-Summer-of-Code (2016), Accuracy-Review-of-Wikipedias

Aug 14 2016

prnk28 closed T141841: Decide on initial set of questions for user testing as Resolved.
Aug 14 2016, 8:16 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T141841: Decide on initial set of questions for user testing.

There are now 5 different types of questions:

  1. Neutral Point of View (NPOV) - Backlog category with section tags - code
  2. Article needing updating - Backlog category with section and inline tags - code
  3. Articles containing the word 'recently' - code
  4. Articles needing copy-edit - Ranked on the basis of Flesch-Kincaid readability score and pageviews - code
  5. Student edits - ranked on the basis of edit size and pageviews - code
Aug 14 2016, 8:16 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T140683: Make the question creation scripts POST to /ask as Resolved.
Aug 14 2016, 8:02 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140683: Make the question creation scripts POST to /ask.

All question creation scripts have the functionality to POST to ask. They have been commented for now. If someone else sets up an instance on their own private server, we can help them out by loading questions into it with POST to /ask.
Commit is here.

Aug 14 2016, 8:02 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T141899: Create questions from student edits as Resolved.
Aug 14 2016, 7:59 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T141899: Create questions from student edits.

I have used the Special:Students page for obtaining student contributor usernames who have made recent edits. I then obtain their most recent edits information such as pageid, revid, size of edit, etc using the Usercontrib API. The final rankings are based on a high value of pageviews and edit size. So bigger edits on frequently visited articles are higher on the list for reviewing.
Code for this script is here.

Aug 14 2016, 7:59 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T142041: Update all the question scripts to use pageview data as Resolved.
Aug 14 2016, 7:53 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T142041: Update all the question scripts to use pageview data.

All scripts now use pageviews data for ranking purposes.
The associated python script that every question-creation script uses is here.

Aug 14 2016, 7:52 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T140781: Implement an archiving mechanism for completed questions as Resolved.
Aug 14 2016, 7:51 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140781: Implement an archiving mechanism for completed questions.

There is a new directory /logs for logging.
There are two types of log files:

  1. activity-yyyymmdd -- logs info such as token, ip, qnum, qtype, request method after every GET and POST request in /ask, /answer, /recommend
  2. results-yyyymmdd -- logs qnum, all associated qtypes with modtimes after POST on /recommend

commit is here

Aug 14 2016, 7:51 PM · Accuracy-Review-of-Wikipedias

Aug 8 2016

prnk28 updated the task description for T135670: Weekly Reports for Accuracy Review of Wikipedia.
Aug 8 2016, 5:02 AM · Google-Summer-of-Code (2016), Accuracy-Review-of-Wikipedias

Aug 7 2016

prnk28 closed T140785: Optional registration system as Resolved.
Aug 7 2016, 5:08 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140785: Optional registration system.

This was a big task. Apart from the the deliverables of this task, I have also added username and email validation. Sub-tasks completed are the following:

  • Wrote the register() function and register.html templates. Functionality for sending salted SHA-512 of the email address to registered reviewers, which they can use as a token while answering questions
  • New directory called 'registered' with filenames as token for each user . File contains user info and files he/she worked on
  • Set the token in the session key
  • Appended tokens to files when token is set in session key
  • Username and email validation. Checked if clashes in the existing registered users
  • Checking and setting tokens in new end-point /token
Aug 7 2016, 5:07 PM · Accuracy-Review-of-Wikipedias

Aug 3 2016

prnk28 created T142041: Update all the question scripts to use pageview data.
Aug 3 2016, 8:51 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T142038: Add error page templates as Resolved.
Aug 3 2016, 8:31 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T142038: Add error page templates.

Commit is here.

Aug 3 2016, 8:31 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T141842: Link each GET endpoint from "help" to documentation .

commit is here

Aug 3 2016, 8:25 PM · Accuracy-Review-of-Wikipedias
prnk28 created T142038: Add error page templates.
Aug 3 2016, 8:16 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T141842: Link each GET endpoint from "help" to documentation as Resolved.
Aug 3 2016, 8:13 PM · Accuracy-Review-of-Wikipedias
prnk28 updated the task description for T141842: Link each GET endpoint from "help" to documentation .
Aug 3 2016, 8:13 PM · Accuracy-Review-of-Wikipedias
prnk28 updated the task description for T141842: Link each GET endpoint from "help" to documentation .
Aug 3 2016, 8:07 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140684: Handle caching.

@Jsalsman did you have time to look into this?

Aug 3 2016, 1:27 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T141842: Link each GET endpoint from "help" to documentation .

@Jsalsman is it really necessary to have separate pages for 'review' and 'tiebreak'? I have added the necessary information in the page for 'answer' itself. Too many pages with the same info might be redundant and confusing.

Aug 3 2016, 1:25 PM · Accuracy-Review-of-Wikipedias
prnk28 updated the task description for T141842: Link each GET endpoint from "help" to documentation .
Aug 3 2016, 1:22 PM · Accuracy-Review-of-Wikipedias

Aug 2 2016

prnk28 added a comment to T140684: Handle caching.

I was reading up more on browser caching and it turns out there's more to it than meets the eye. After pulling the updated code to ToolLabs, I realized that autocomplete=off doesn't fix the problem on ToolLabs (it only worked locally) and it might not work on all browsers.

Aug 2 2016, 7:26 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T141842: Link each GET endpoint from "help" to documentation .

@Jsalsman What's answer-i and answer-r? As far as I know, we have answer-e and answer-o for endorse and oppose respectively.

Aug 2 2016, 7:04 PM · Accuracy-Review-of-Wikipedias
prnk28 updated the task description for T141842: Link each GET endpoint from "help" to documentation .
Aug 2 2016, 7:03 PM · Accuracy-Review-of-Wikipedias
prnk28 created T141899: Create questions from student edits.
Aug 2 2016, 5:39 PM · Accuracy-Review-of-Wikipedias

Aug 1 2016

prnk28 added a comment to T140684: Handle caching.

Pressing on back reloads the question because the nextrecord() function returns and subsequently displays a new question. So we will have to erase the answer for another question that was entered. For this to be removed, we have to put an autocomplete="off" attribute in the form tag. I'm verifying whether this works under all circumstances and in all browsers.

Aug 1 2016, 6:12 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140785: Optional registration system.

Use a secure hash of their email and a salt, I.e. Base64(SHA-512("some 'salt' string"+emailaddr))) and store it in the session cookie like the "flash" messages which show feedback, and use it to populate a new field in the /answer form so that once they enter it, it stays until they clear or change it.

Aug 1 2016, 6:09 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T141295: Improve the UI design of the Accuracy Review of Wikipedias Flask app.

No, it didn't. It was the same uniode decode error which went after setting
the system to default to using utf-8

Aug 1 2016, 4:39 AM · Accuracy-Review-of-Wikipedias

Jul 30 2016

prnk28 added a comment to T141295: Improve the UI design of the Accuracy Review of Wikipedias Flask app.

@Jsalsman , I have now fixed the error.

Jul 30 2016, 6:46 AM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T141295: Improve the UI design of the Accuracy Review of Wikipedias Flask app.

@Jsalsman , I reverted back to the earlier version to check if the UnicodeDecode error still persists. Like I said earlier, it still does.

Jul 30 2016, 6:18 AM · Accuracy-Review-of-Wikipedias

Jul 29 2016

prnk28 closed T138953: Datetime analysis as Resolved.
Jul 29 2016, 6:21 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T140560: Script to generate questions from poor readability scores as Resolved.
Jul 29 2016, 6:21 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140560: Script to generate questions from poor readability scores.

The script extracts articles in articles needing copy edit. It then computes the Flesch-Kincaid readability scores as well as gets the page view counts of them. It then standardizes each of these two adds them to get the final contribution. Final rankings are based on high page view counts and poor readability scores. Top 20% are retrieved and made into questions.
Commit is here.
Related python scripts are:
copy_edit.py - main script that does the computations and generates questions
syllables_en.py - helper script to get syllables in a piece of text
utils.py - helper script to get words in a sentence, syllable count, sentence count, etc
copy_edit_ranking.pkl - generated pickle file of final article rankings. This is stored in the form of an ordered dict like:
dict[title] = [link, pageview, fk score, added standardized score]

Jul 29 2016, 6:20 PM · Accuracy-Review-of-Wikipedias

Jul 25 2016

prnk28 updated the task description for T135670: Weekly Reports for Accuracy Review of Wikipedia.
Jul 25 2016, 7:44 PM · Google-Summer-of-Code (2016), Accuracy-Review-of-Wikipedias
prnk28 triaged T141295: Improve the UI design of the Accuracy Review of Wikipedias Flask app as Low priority.
Jul 25 2016, 7:40 PM · Accuracy-Review-of-Wikipedias
prnk28 created T141295: Improve the UI design of the Accuracy Review of Wikipedias Flask app.
Jul 25 2016, 7:40 PM · Accuracy-Review-of-Wikipedias

Jul 19 2016

prnk28 created T140785: Optional registration system.
Jul 19 2016, 4:08 PM · Accuracy-Review-of-Wikipedias
prnk28 created T140781: Implement an archiving mechanism for completed questions.
Jul 19 2016, 3:55 PM · Accuracy-Review-of-Wikipedias

Jul 18 2016

prnk28 added a comment to T139261: Hyperlink URLs from form input with <a href="URL">URL</a> after escape()ing.

@Aklapper , we were wondering how hyperlinking of urls is handled on Phabricator. It seems to catch most urls. I am looking for a regex pattern that's stronger than the one we are already using in our project . Could you direct me towards any useful resources in this regard?

Jul 18 2016, 8:42 PM · Accuracy-Review-of-Wikipedias
prnk28 created T140684: Handle caching.
Jul 18 2016, 8:38 PM · Accuracy-Review-of-Wikipedias
prnk28 created T140683: Make the question creation scripts POST to /ask.
Jul 18 2016, 8:35 PM · Accuracy-Review-of-Wikipedias

Jul 17 2016

prnk28 updated the task description for T140560: Script to generate questions from poor readability scores.
Jul 17 2016, 8:37 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T140568: get pageview counts from the pageviews API as Resolved.
Jul 17 2016, 8:32 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140568: get pageview counts from the pageviews API.

The script that accesses the API and displays page view count for the past month can be found here.
Run it as :

Jul 17 2016, 8:32 PM · Accuracy-Review-of-Wikipedias
prnk28 updated the task description for T140560: Script to generate questions from poor readability scores.
Jul 17 2016, 3:51 PM · Accuracy-Review-of-Wikipedias
prnk28 created T140568: get pageview counts from the pageviews API.
Jul 17 2016, 3:47 PM · Accuracy-Review-of-Wikipedias
prnk28 created T140560: Script to generate questions from poor readability scores.
Jul 17 2016, 1:18 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139260: Run instances on labs, heroku, PythonAnywhere, and Google App Engine.

Labs instance has been up and running for a while : http://tools.wmflabs.org/arowf/

Jul 17 2016, 1:07 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T140559: Write a script to generate articles containing the word 'recently' as Resolved.
Jul 17 2016, 12:53 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T139077: Write scripts to populate /ask from wp backlogs as Resolved.
Jul 17 2016, 12:53 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139077: Write scripts to populate /ask from wp backlogs.

This task was for generating questions from WP:Backlogs. I have created a new task for the next task: T140559

Jul 17 2016, 12:53 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T140559: Write a script to generate articles containing the word 'recently'.

Task completed.
Commit can be viewed here.

Jul 17 2016, 12:51 PM · Accuracy-Review-of-Wikipedias
prnk28 created T140559: Write a script to generate articles containing the word 'recently'.
Jul 17 2016, 12:50 PM · Accuracy-Review-of-Wikipedias

Jul 12 2016

prnk28 added a comment to T139077: Write scripts to populate /ask from wp backlogs.

Is there any way to get a list of all article names in Wikipedia? I need to test the script on a huge bulk of articles to find the ones containing 'recent' or 'recently'.

Jul 12 2016, 5:26 PM · Accuracy-Review-of-Wikipedias

Jul 11 2016

prnk28 added a comment to T139260: Run instances on labs, heroku, PythonAnywhere, and Google App Engine.

I'm asking around for help. Will let you know as soon as I get it running.

Jul 11 2016, 4:06 PM · Accuracy-Review-of-Wikipedias

Jul 5 2016

prnk28 updated the task description for T135670: Weekly Reports for Accuracy Review of Wikipedia.
Jul 5 2016, 2:37 PM · Google-Summer-of-Code (2016), Accuracy-Review-of-Wikipedias

Jul 4 2016

prnk28 added a comment to T139077: Write scripts to populate /ask from wp backlogs.

@Jsalsman , what else needs to be done here?

Jul 4 2016, 11:51 AM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139261: Hyperlink URLs from form input with <a href="URL">URL</a> after escape()ing.

This task is done.
Code here
https://github.com/priyankamandikal/minireview/commit/24c9be8fa6979ec912674762823f6fbfd58b72fe

Jul 4 2016, 10:48 AM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139078: Display diffs and permalinks in an iframe in /ask.

This task is done.
Code here
https://github.com/priyankamandikal/minireview/commit/24c9be8fa6979ec912674762823f6fbfd58b72fe

Jul 4 2016, 10:48 AM · Accuracy-Review-of-Wikipedias

Jul 3 2016

prnk28 added a comment to T139260: Run instances on labs, heroku, PythonAnywhere, and Google App Engine.

I'll work on this task after a few others are completed.

Jul 3 2016, 12:43 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139260: Run instances on labs, heroku, PythonAnywhere, and Google App Engine.

My Labs request got accepted.
https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Prnk28

Jul 3 2016, 12:41 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139079: Summary statistics for /inspect.

@prnk28 also please consider printing a table of dates for {all, q, a, e,
o, t, d} X {oldest modification date, newest date, mean date, median date,
standard deviation days, how many have different creation and modification
dates}

Jul 3 2016, 12:40 PM · Accuracy-Review-of-Wikipedias

Jul 2 2016

prnk28 added a comment to T139077: Write scripts to populate /ask from wp backlogs.

BeutifulSoup is a python library that makes it very easy extract data out of html
https://www.crummy.com/software/BeautifulSoup/bs4/doc/

Jul 2 2016, 10:28 AM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139077: Write scripts to populate /ask from wp backlogs.

I updated the script to reflect the changes. It now extracts articles from a given backlog category and month and makes questions out of all of them
@Jsalsman , is there anything else to be done to mark this task as complete?

Jul 2 2016, 7:50 AM · Accuracy-Review-of-Wikipedias

Jun 30 2016

prnk28 closed T137639: Wikipedias Accuracy Review Meeting 3 : 11th June 2016 UTC 4am as Resolved.
Jun 30 2016, 7:11 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T136536: Wikipedias Accuracy Review Meeting 2 : 28th May 2016 UTC 4am as Resolved.
Jun 30 2016, 7:11 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T135662: Wikipedias Accuracy Review Meeting 1 : 10th May 2016 UTC 5pm as Resolved.
Jun 30 2016, 7:11 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T136290: Generate partial dumps of wiki articles as Resolved.
Jun 30 2016, 7:05 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T136290: Generate partial dumps of wiki articles.

@Jsalsman the datetime analysis is part of task T138953
This task was just for refactoring wikiwho to obtain dates for each revid. Since that's done I'm closing this task as resolved :)

Jun 30 2016, 7:04 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139077: Write scripts to populate /ask from wp backlogs.

@Jsalsman Here's a simple script that scans a backlog page and outputs all article titles along with links on that page.
https://github.com/priyankamandikal/minireview/blob/master/backlog_script.py

Jun 30 2016, 6:59 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T139077: Write scripts to populate /ask from wp backlogs.

Just to be sure, why do we need the script to be run via ask(). Ask can just handle user-typed inputs and render them in iframes
Can't we just run the script externally, so that queries directly form question files in the records directory so that they can cater to answer()?

Jun 30 2016, 5:29 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T136290: Generate partial dumps of wiki articles.

@Jsalsman , should I close this as resolved? This refactoring has long been done.

Jun 30 2016, 5:11 PM · Accuracy-Review-of-Wikipedias
prnk28 created T139080: Handle race conditions.
Jun 30 2016, 5:03 PM · Accuracy-Review-of-Wikipedias
prnk28 created T139079: Summary statistics for /inspect.
Jun 30 2016, 4:58 PM · Accuracy-Review-of-Wikipedias
prnk28 created T139078: Display diffs and permalinks in an iframe in /ask.
Jun 30 2016, 4:56 PM · Accuracy-Review-of-Wikipedias
prnk28 created T139077: Write scripts to populate /ask from wp backlogs.
Jun 30 2016, 4:53 PM · Accuracy-Review-of-Wikipedias
prnk28 created T139067: Internationalization and localization of message strings for Accuracy Review.
Jun 30 2016, 3:32 PM · I18n, Accuracy-Review-of-Wikipedias

Jun 29 2016

prnk28 updated the task description for T135670: Weekly Reports for Accuracy Review of Wikipedia.
Jun 29 2016, 3:21 PM · Google-Summer-of-Code (2016), Accuracy-Review-of-Wikipedias
prnk28 added a comment to T138953: Datetime analysis.

I converted all dates to Julian dates (inspiration from here https://github.com/phn/jdcal) and found the mean. (I ignored the time though)
I am now working on finding the median in an efficient manner. A search suggested that https://en.wikipedia.org/wiki/Median_of_medians and https://en.wikipedia.org/wiki/Selection_algorithm work in O(n) time.

Jun 29 2016, 2:58 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T137739: Solve database schema (SQL/NoSQL) related issues as Resolved.
Jun 29 2016, 2:43 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T137739: Solve database schema (SQL/NoSQL) related issues.

Completely shifted over to file based data management.

Jun 29 2016, 2:43 PM · Accuracy-Review-of-Wikipedias
prnk28 closed T137638: Create user profiles and add functionality for editing the profile as Invalid.
Jun 29 2016, 2:42 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T137638: Create user profiles and add functionality for editing the profile.

@Jsalsman wrote: we aren't going to require user registration or logins. Reviewers participating in reputation management systems will sign their review comments with a unique identifier. The failure mode of impersonation can be overcome by having that unique identifier be, include, or point to email to which confirmation is sent.

Jun 29 2016, 2:42 PM · Accuracy-Review-of-Wikipedias
prnk28 created T138953: Datetime analysis.
Jun 29 2016, 2:39 PM · Accuracy-Review-of-Wikipedias

Jun 27 2016

prnk28 added a comment to T136290: Generate partial dumps of wiki articles.

The wikiwho code now outputs the time for each revid as well (in json format)
Check this particular output file for an article called 'Kendhoo'
https://github.com/priyankamandikal/wikiwho_api/blob/master/out.txt

Jun 27 2016, 6:33 AM · Accuracy-Review-of-Wikipedias

Jun 26 2016

prnk28 added a comment to T136290: Generate partial dumps of wiki articles.

Hadn't we decided that I'll work on this once the review system is ready? Right now we are working on tasks that fall in the July 4 - Aug 3 category in the schedule here T129536. So 'obtaining article dumps' and 'manual list based input' have been pushed to post whatever we're working on now.

Jun 26 2016, 12:57 PM · Accuracy-Review-of-Wikipedias

Jun 23 2016

prnk28 added a comment to T138300: Midterm evaluation for "Accuracy review of Wikipedia".

@Jsalsman This design makes a lot of sense in vlermv! I will start coding this. I will get the review system completed before the password and username part that you mentioned in a later email.

Jun 23 2016, 8:02 AM · Accuracy-Review-of-Wikipedias, Google-Summer-of-Code (2016)

Jun 22 2016

prnk28 added a comment to T138300: Midterm evaluation for "Accuracy review of Wikipedia".

@prnk28 you do have a labs account, right?

Jun 22 2016, 4:16 PM · Accuracy-Review-of-Wikipedias, Google-Summer-of-Code (2016)

Jun 14 2016

prnk28 added a comment to T137739: Solve database schema (SQL/NoSQL) related issues.

Are the links provided the only place to learn more about this database? I searched the web but couldn't find any other sites for reference, including stackoverflow. Although the db might be good enough for all the points that you listed, I'm afraid there isn't an active developer community built around it. Where do I look to if I run into errors? And what is the guarantee that this db will have support and maintenance in the future? Or is there good enough community support that I'm not aware of? Experimenting with a software that is at its nascent stage for something as big as a database might be a little too risky. Your thoughts?

Jun 14 2016, 11:29 AM · Accuracy-Review-of-Wikipedias

Jun 13 2016

prnk28 added a comment to T137739: Solve database schema (SQL/NoSQL) related issues.

Could we not move from SQLite to MySQL? The error is only due to SQLite's limitation, which will not move over to MySQL.

Jun 13 2016, 7:20 PM · Accuracy-Review-of-Wikipedias
prnk28 created T137739: Solve database schema (SQL/NoSQL) related issues.
Jun 13 2016, 6:52 PM · Accuracy-Review-of-Wikipedias
prnk28 added a comment to T137639: Wikipedias Accuracy Review Meeting 3 : 11th June 2016 UTC 4am.

How do you feel about switching to NoSQL? I can see that will solve a huge number of your schema problems. Please let me know your thoughts on http://stackoverflow.com/a/2581859

Which format of NoSQL would be suitable? Document, columnar, key-value or graph type? And why?
I was going over the use cases of SQL and NoSQL. Apparently, NoSQL is really helpful for scaling out and if we have a lot of data. SQL on the other hand provides more consistency and makes it easier to carry out indexed queries. Please see http://stackoverflow.com/questions/2559411/sql-mysql-vs-nosql-couchdb

Please reply here with commented INSERT TABLE statements for the SQL schema you have so far. Moving to NoSQL will solve your schema upgrade problem. I will help you refactor to NoSQL. I promise I will put in as many hours as that takes this week and/or next.

Jun 13 2016, 6:47 PM · Accuracy-Review-of-Wikipedias

Jun 11 2016

prnk28 updated the task description for T135670: Weekly Reports for Accuracy Review of Wikipedia.
Jun 11 2016, 3:46 PM · Google-Summer-of-Code (2016), Accuracy-Review-of-Wikipedias
prnk28 updated the task description for T137639: Wikipedias Accuracy Review Meeting 3 : 11th June 2016 UTC 4am.
Jun 11 2016, 3:46 PM · Accuracy-Review-of-Wikipedias