Posts

Showing posts from July, 2013

downloading folders from google drive.

I wanted to download some course material on RL shared by the author via Google drive using the command line.  I got a bunch of stuff using wget a folder in google drive was a challenge. I looked it up in SO which gave me a hint but no solution. I installed gdown using pip and then used: gdown --folder --continue https://drive.google.com/drive/folders/1V9jAShWpccLvByv5S1DuOzo6GVvzd4LV if there are more than 50 files you need to use --remaining-ok and only get the first 50. In such a case its best to download using the folder using the UI and decompress locally. Decompressing from the command line created errors related to unicode but using the mac UI I decompressed without a glitch.

Finding your friends on Wikipedia

Image
A segment of a social network (Photo credit: Wikipedia ) In my opinion, the most notable missing features of Wikipedia is the ability to network socially . Lack of social features conspire to minimise participants'  social capital (the expected collective or economic benefits derived from the preferential treatment and cooperation between individuals and groups). Lack of networking capabilities is in line with a pervasive attitude that ownership of contributions should be suppressed, external authority ignored and that knowledge matters in the project. Accordingly social costs of participation are growing. Participants in the project have great difficulty in acquiring social capital. The stakes of establishing world opinion tend to outweigh social stakes. Accordingly there is a growing gender gap, under-representation of cultural minorities and disrespect of real world authority. Currently users will try to establish social capital by listing on their user page their m

Tips on working with SQL Fiddle

Image
C-3PO vs. Data (137/365) (Photo credit: JD Hancock ) Trying to get help with SQL ?  Chances are that you could use the open-source web application  mysqlfiddle.  Usually questions asked on the web leave much to be desired in terms of precision. The good news is that with Sqlfiddle you can set up a copy of the relevant sql schema, add some sample data,  add your best attempt and and share these with the people you are chatting or corresponding with. Next follows an example environment I set up to explore on collecting editor sessionstatistics for wikipedia's undocumented revision_user table. Working with a full environment was not practical. Working with the sqlfiddle actually ended up as a big time saver since testing the queries on a live database would have taken hours. http://sqlfiddle.com/#!2/d2f02/22 It sometimes seems that setting up a Database environment is a bit of an overkill - especially when it is just to ask a question. However if you have a working fiddle it

Popular posts from this blog

Moodle <=< Mediawiki SUL integration - first thoughts

downloading folders from google drive.

AWS CloudFormation Pros and Cons