Hi @jcrespo. Please look into my new timeline and give me the final feedback before I submit my proposal.
Also, I have only concentrated on making my proposal and haven't made any contribution to the microtasks during this application period. Hope this doesn't effect much. But, I am planning to be active from now onward.
Thank you.

In T279442#6988699, @Gopavasanth wrote:

Hey @Ashitabattu

Thanks for showing your interest to participate in Google Summer of Code with Wikimedia Foundation! Please make sure to upload a copy of your proposal on Google's program site as well in whatever format it's expected of you, include in it this public proposal of Phabricator before the deadline i.e April 13th. Good luck :)

Thank you for the valuable feedback.

Hi @jcrespo and @Marostegui. Please go through my proposal and give me a feedback so that I would be able to improvise it.

Hi @jcrespo . Are there any microtasks I can contribute to, in order to get a better understanding of the project - 'MYSQL account metadata inventory'?

In T274636#6959869, @jcrespo wrote:

1)Is the database host("db1115.eqiad.wmnet") mentioned in script directly accessible from the public network or should I be using some VPN to connect to it?

The host is not publicly accessible, nor it will be made accessible for the student working on this project. This is a programming project, so no special access will be provided to people working on it. This is not something special about GSoC, not even most of employees and volunteers have access to the underlying infrastructure.

You can assume that the application will have direct access, and you should be able to setup your own database for development. Export of the several database is made available. Although we might be able to provide testing virtual machines (we did it last year) that may serve as "staging" for the project, to prove the project works on an identical environment to production.

2)How are entries inserted into instances table?

Right now, manually, using SQL. The whole point of the project is to create an interface to make that easier- both for manual operation and potentially, automatic too (e.g. for example, with a REST api). What writes to it is not in scope of the project, at least not at this stage.

How are new users created i.e how are rows inserted into mysql.users?

You won't have to handle that, that is infrastructure, so out of the scope of the project. MySQL and server setup is already "solved" through our configuration management. Authentication, configuration, server management, security are not part of the scope to solve. However, one is expected to use security best practices (eg. avoiding SQL injection, XSS, etc.).

4)Would I get access to the db instances so that I can have a look at the other columns?

Not sure what you mean with "other columns". A structure export has been provided already. I can provide example content if useful, but for a proposal the mockup should be enough to understand the kind of data that could be stored there. More details will be provided during the analysis/development phase. Again, no access will be provided to the student to any production resources.

5)How do I test things I've coded. Would there be a staging setup or should I test things on my local machine?

Yes, if possible you will have a development environment on your machine. But we may be able to provide a staging environment on WMF Cloud (we did it last year by asking for a couple of VPSs), including a very similar configuration management setup.

Hi @jcrespo.
For the 'MYSQL account metadata inventory', I have a couple of questions regarding it's relevant script.