padjo.org
Learning and science
sql teaching materials
SHOW HN2014
120points
24comments
#227of 2,272 in 2014
Top 10%of 2014 by points
How HN took it
LovedMost comments that take a side are positive
9 positive, 7 neutral or asking, 0 mixed, 0 critical, out of 16 comments about the project. Thread score +0.46.
Idea: 9 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Excellent, accessible teaching materials for data journalism
From 3 comments
This is excellent! I've taught a graduate journalism class in the past and <danso>'s approach here is inspiring -- I hope other instructors pay attention. Though note the class…
declan on HNIt's so great to see such accessible teaching materials for the next generation of data journalists. Almost makes me wish I studied journalism in college.
jedanbik on HNCool! It'd be great for more journalists to learn SQL. It was originally designed to let managers run reports without asking the programmers, so perhaps there is hope. I see you…
pjungwir on HN
Good idea to teach SQL to journalists
From 3 comments
This is fantastic! We're in a technological world now, and not knowing how to use that technology puts one at a severe disadvantage. I'm very glad to see other fields start using…
Alupis on HNCool! It'd be great for more journalists to learn SQL. It was originally designed to let managers run reports without asking the programmers, so perhaps there is hope. I see you…
pjungwir on HNThis is pretty cool - I had no idea journalism students had to know SQL. Thanks for sharing!
mceoin on HN
Objections
Course is for motivated students and may not suit basic journalism courses
From 1 comment
This is excellent! I've taught a graduate journalism class in the past and <danso>'s approach here is inspiring -- I hope other instructors pay attention. Though note the class…
declan on HN
Requests
Add HAVING coverage
From 1 comment
Cool! It'd be great for more journalists to learn SQL. It was originally designed to let managers run reports without asking the programmers, so perhaps there is hope. I see you…
pjungwir on HN
Teach regular expressions
From 1 comment
Did you learn regular expressions as well? I bet they'd be very useful for journalists / journalism majors.
wcummings on HN
Questions
Why MySQL and SQLite rather than PostgreSQL
From 1 comment
Why MySQL and SQLite, but not PostgreSQL?
illicium on HN
Alternatives named
Software Carpentry
From 1 comment
Have you seen http://software-carpentry.org/ ? I haven't looked close enough at what you are doing or what they are doing to pretend to make a comparison, but I guess it isn't…
maxerickson on HN
Regex101
From 1 comment
http://regex101.com/ is (I think) a really nice way to learn/use regex. It explains each piece, displays capture groups from the regex applied to sample data, and has built-in…
tom9729 on HN