I have used many a git client but for the last year have been using fork Fork - a fast and friendly git client for Mac and Windows[^]. You have to pay for it these days but it’s well worth it in my opinion.
Mark Jerzykowski
Posts
-
Your preferred Git UI (if any)? -
Anyone here used CUDA?I used Cuda in my Masters for simulating spiking neural networks. Ended up using cudafy (.Net library) as wanted C# familiarity. Certainly allowed me to run my simulations far quicker but don’t underestimate the amount of effort required to tune (and get right - debugging 1000s of threads isn’t fun) non-trivial algorithms.
-
Cloud Wars - Amazon v. Rackspace v. Microsoft v. GoogleHaving deployed several .Net applications to Azure and AWS (standard type of web app with asp.net, sql server, some background services, some queuing, blob storage, caching, CDN) I'd say that if you're in the .Net world then you'll get a lot more productivity out of Azure (unsurprisingly).
-
Dapper -
Count (Distinct) with left join and group byHi, Pretty new to Linq and struggling to get my head around it a bit. Here goes.... Survey Tool with a simple (database) hierarchy of: Categories > Sub Categories > Questions > Answers and then another table called SurveyAnswers which basically stores a list of AnswerIds for each survey response. The questions are all multiple choice so you only ever get one SurveyAnswer for each Question (for a particular response). Now, I want to count the number of questions and the number of questions answered for each sub category. In sql:
select c.CategoryId,
sc.SubCategoryId,
COUNT(distinct q.QuestionId) as NumberOfQuestions,
COUNT(sa.AnswerId) as QuestionsAnswered
from Category c
join SubCategory sc
on c.CategoryId = sc.CategoryId
join Question q
on sc.SubCategoryId = q.SubCategoryId
join Answer a
on q.QuestionId = a.QuestionId
left join SurveyAnswer sa
on a.AnswerId = sa.AnswerId
and sa.SurveyResponseId = 1
group by c.CategoryId,
sc.SubCategoryIdAny help with showing me how to do this would be great. I can get to the left outer join bit but the select and group bits defeat me! Thanks.