This element of the program is framed as keynote dialogue and that's why I want to ask you the first question whether you have questions regarding each other's talks or some remarked questions you have there. One of the criticisms made of various kinds of big data is that there are problems if you rely upon just Google uses because obviously most many people don't use Google and what value you think there isn't just using in your case Google rather than all the different search engines and you mesh them together and whether that's an issue which we need to think about. Interesting question, I think at this point we haven't really thought about combining data sets from different search engines or providers and I think that at least from my perspective because I can still speak in my previous role at Twitter, the data sets for example that Twitter provides and that Google provides are a bit different because they are based on different user behaviors. So for example Twitter users express their opinion, express their emotions on Twitter. Users that go to Google to search are following a much more honest way to express their thinking because I would never go or log into my Twitter account and ask like who's Donald Trump. I would never do that because I would embarrass myself in front of my followers or friends on Facebook but I do that on Google and so the data sets that any company provides or can provide for journalists and academics are definitely different. It would be interesting to actually look at those different data sets and combine them and I think there is an opportunity especially around elections to see and to double check if there is a similarity or correlation. You have a question as well? Yes, I do have a question. So you mentioned that there is a shift in not only sociology, it's a difficult word. In academics, towards data driven research, how difficult do you find it to find the right data sets and what is there that you would wish? I think that is one of the key questions for social scientists who do want to use these kinds of new data sources and the answer is not straightforward. I'll give you an example of a project which I was very keen to becoming involved with which is what in my interest is inequality but also how inequality affects consumption and cultural activity and lifestyles and I've done various surveys on this. Of course surveys only a few thousand people and they give you much detail. We do know that in the British context one of the most interesting data sets you can have on this is a data set which is assembled by our supermarket Tesco with their loyalty card which records every single purchase. It's a very interesting story that Tesco became the dominant retail supermarket in Britain because they were the first to do this and develop this database which they then contracted to a market research company which they actually owned. This allowed them to have real world analysis of what was selling their shops. This is 20 years ago they were the first supermarket to be able to look at trends immediately. So it helped them to plan. Academics would love to have that data set and love to be able to say can we use this to look at social classes, certain classes like in certain kinds of products. Getting access to that data has been proved extremely difficult. Tesco even funded a research center at University of Manchester and there was talk about yes we might give you a bit of access but it was approved really, really hard. I think there was an issue really about private sector companies and I also think there are issues of ethics because I think most people who have a Tesco card don't really realize. I mean they obviously tick the box when they've got the card but they don't really realize this data is being used. I think in a way we should make a public claim that actually this material should be more in the public domain. Clearly not necessarily in a commercial sensitive way. So there might be a time bar on it but I think it is one level shocking that we are seeing huge amounts of data generated which could actually be used for all sorts of really important questions. Google is a bit different obviously because you're not operating like a supermarket but certainly in the case of Tesco it is a great shame at one level. This data is kind of lying on the shelf. If I can ask another question. Let me pursue that example of the Tesco card and what you could do with it. Because one of the criticisms made of that kind of work. I mean we never got access to the database but if we think through the principles and if we think through some examples of something similar. Some critics of big data would say well what you can do on that is you can kind of infer certain kinds of social characteristics but you don't really know much about the individuals. Because the Tesco card has your address. They may have your age but that's all. They don't know anything about your job directly. So for instance to go back to your Google you can't tell that doctors do these kinds of searches and lawyer drivers do other kinds of searches. And one of the arguments would be that limits your kind of analytical power. Of course the data that you can have access to at Google at the Google Trends site for example is anonymous data. And I think of course that's why it would be interesting to combine data sets. And if other companies like Tesco and your example would provide that data in an anonymous way. And combining that data would definitely give a much broader and much bigger and more concise picture or accurate picture. The question would be also from my side again. Do you think that in order to change the perception on big data from a scientific academic point of view. There has to be there have to be more examples on how impactful research based on big data can be or yeah. Yeah I do think I think that's how social science moves on is to see researchers using a new method or a new kind of data source to say something fundamentally new. As I was saying Piketty is I think he is now an exemplar. But he and he is using taxation data which is a particular kind of public if you like big data. So we haven't really seen an example I don't think from the more commercial world in terms of the access issues which we've been talking about. And that would be that would be interesting. I mean I'm very struck by you know we can see these fantastic visuals of people carrying their mobile phones around Manhattan and people moving around the city. And it is beautiful to watch but you can't think well and what we actually learn that people move around the city and they have these pathways from their home to their workplace. But I think we still struggle a bit to find a good analytical way of knowing how to use that for good social scientific purposes. I mean I'm very keen to do that but I think we still need to do more work. Okay. One comment maybe. It's good to see that's running on its own. We don't want to exclude you. No just ask and then I have a question for Mike as well. I just wanted to make one comment on your point and this just was launched today. It's been a really interesting project from the Berliner Morgenpost who got access to I don't know the exact data set that they got access to but it was a data set by the I think department of city development or urbanization and they created really beautiful maps on how Berlin changed over the past years since 1990. And you don't have to be a Berliner or you don't have to know Berlin quite well but what you could see is based on data and based on data that was made available. How the city changes and how different suburbs changed over time tremendously. And of course if you look at the visualization and you don't read the text below or on top of it you might think well beautiful map that's nice but I don't really understand the context of it. So in that way it was made in a really really nice way where journalists and data specialists work together. So and that was the kind of data that also for academics would be interesting. Great and I see that both of you see a lot of potential and doing analysis on big data. But I have some question marks still I must confess and one is coming back to the presentation of you Mike and at the beginning I had the impression and you use the term I think that it is a tool. But later on there was this bullet point saying that it is more important to focus on these sense that lies in the data itself than the theoretical framing the philosophical narratives and things like that. Isn't that a contradiction don't we need still the theoretical approach and things like that to come to see the question and that is the question we address to the data set. Is there a contradiction in there? I'm not sure if it's a contradiction or a certain different emphasis. I think you're absolutely right I think and I think data doesn't speak for itself that's the crucial point and the more data is the less it speaks for itself because the complexity of it becomes so overwhelming. So you do need theory absolutely I think but it's how you make the theoretical points and how you establish your theoretical argument and so I think the way that Pickett does it or Workings and Pickett do it are by assembling these visuals. So your theory isn't proceeding by reference back to philosophical a priori it's being done in a more inductive way in dialogue with the data. Isn't there a risk in there because maybe the data set is now dictating what academics find interesting. The data set I see when I apply this kind of analysis to this data set that comes a beautiful you curve and that's why I draft this article not because I see a phenomenon that I don't understand or things like that. You're absolutely right I think I think there is that danger and it's become a new empiricism but and I think you might say I think of those three studies I talked about the most criticised is Workings and Pickett. Epidemiologists many of them feel they've misrepresented data sets and they've essentially they have a very strong argument they want to make and they just deliberately trying to manipulate some of the evidence to support it. And I think the thing about Workings and Pickett is out of the three thinkers I talked about they are the ones who are least kind of critical of data itself. Whereas Pickett for instance and obviously absolutely he's the case that he would be his arguments are dependent upon the data sources and even income tax data is clearly not perfect because many people declare tax. But the interesting thing about him and I talked to him recently when he visited London is he's very aware that data is constructed. And so at one level he keeps a step back from data and is always asking the question well you know why do these things get measured in this way and not that way. So he is using data to make his arguments but he's using it in a way which he's also standing back from it and that also allows him to recognise I think some of the absences which might be. And I think also to that point I think it's two ways. So you could have a really compelling data set and then you dive deeper into it and you find a really interesting story that you can then elaborate on and write on. And sometimes it can be the case that you have a fantastic idea and a fantastic story in your mind that you want to base on data and you find data sets that are not working well with that story. So I think that's it's not always based only on the on the data set and you start with the data set is two ways. Okay I see. Coming to the data sets you are interested in and the news lab idea. We all know that at least in Germany there's not only friendship between publishers, journalists and Google to put it mildly. How is your experience as regards cooperation with journalists and publishers? Do they really want this tool? Do they make use of it? Is there a real dialogue or is it more like a selling process? What is it like? I mean I've been with Google for five weeks. So starting with that. And that said long before I joined there was a strong relationship and of course open dialogue between Google and publishers. And in April we launched this digital news initiative where eight publishers from around Europe and Google work together to really drive innovation and think about for example products that can be supportive for the entire media landscape in Europe. So the digital news initiative is exactly that step to deepen the relationships and to deepen the talks with publishers. This group of publishers and together with Google they even launched already a product that is available. It's called accelerated mobile pages. It's an open source product aiming to increase the speed of web pages and mobile pages. So it's not only about Google tools or Google products. This is really open to everyone. And then secondly there's this innovation fund where Google and together with publishers want to drive innovation in the start-up ecosystem. And then thirdly there's a news lab where we come in and we of course want to collaborate with journalists and give them access to the tools, give them access to Google Trends data. And the real reactions so far in the five weeks I've been here were very positive and they're interested in learning more about tools, trends, etc. Are you open to collect the ideas and put it into new products and analytic tools or is it just that you give access to tools that you have designed and that are available? So the news lab, at least I can speak for the news lab, the news lab started with really a listening tour, spending a lot of time in newsrooms and asking journalists what do you want, what do you need to do your day-to-day job. And so it's not only about collecting ideas and then nothing happens. Even tomorrow, so it's about really working together and collaborating. Even tomorrow we have around 200 publishers from around Europe in Berlin to discuss the challenges of media and also the solutions that we can work on together.  And a tool of course is a marvelous thing. You can do things with tools you can't do with your bare hands but tools come with affordances. If you only have a hammer then you're inclined to do things with nails to take this example. And doesn't that mean, we talk about power shifts here, that those who own the data and create the analytic frames get a little bit of power over the science in your case and the public communication in your example. Is that something that is discussed with Google and others and in the academic sphere? You're absolutely right. I think that's inherent power bias towards those who are most engaged with these kinds of sources will mean that there's a danger that certain kinds of people just are outside the frame of reference. And in a sense the more powerful you are the more likely you are to be part of this world of big data. And I think you see that very much in a way with the world of Twitter. People who are tweeting a lot are more visible. I was involved actually, I didn't talk about it today but just this week in Britain we published a book. We were involved in a project with the BBC called the Great Village Class Survey which was a big web survey of people's attitudes towards social class. It was a lot of public interest, lots and lots of discussion. Interestingly because it was a form of big data it was a digital web survey and a very large response rate. It wouldn't have been as much interest if it had been a normal survey but this was a very large BBC survey and it got a lot of interest. But this is the kind of difficult issue. If you were in the lower classes if you were kind of what we call the precariat which is people on insecure jobs not earning much you just did not do it. You would not go to the BBC website to do this quiz because you didn't think it was for someone like you. And then on the other hand if you were earning lots and lots of money and been to an elite university you were really very likely to do it. So you had a hugely skewed sample and basically the more money you earned and the higher educated you were the more likely you were to do it. So we knew it was out of the beginning so we deliberately didn't use that as a representative survey but it does pose that challenge. I think the way to address that challenge and to go back to what we were saying earlier on is to mash up different data sources. And also in our case what we did is we did some ethnographic work with the people who didn't do the survey. It's going to look at why they weren't doing the survey and what the issues were there. So I think you can get around it but you absolutely need to be very careful in looking at the absences and the biases in the survey and the data. Thanks. Something you want to add. Okay that's not the case then I will open up for questions now that we have enough time to do that. Please be kind enough to use the microphone and maybe stand up that people can see you and just give your name. Hi. Thanks very much. I'm always a bit nervous so it might be that the mic shakes. My name is Sevda Aslan thank you for your talks. I'm from Mannheim University and I wanted to stress a point that Mike has just mentioned before about the ethics. I was wondering you know if I do research I ask people do you want to participate in my research and usually I only take them if they say yes. So normally they get money for it or chocolate or something else. And I was wondering about the data that you suggested that we should use the big data from administrative places that is basically state surveillance or from Google which is a company that exploits their users to gain profit. I was wondering where do we really want to use this data just because it's there. And if yes where do we stop like if the NSA comes across and says hey we have so much data don't you want to find out more about society. Are we going to say yes so interesting. We should and they probably have nice visual visualizations too. So I was wondering where do we stop and do we really want to have this kind of data or is there something like a codex of I don't know for data something. Some some ideas on that is there an ethical discussion going on. Absolutely there is absolutely right. Ethical issues are huge and there's no easy solution to them. I think the issue of informed consent. I mean it said most of the conventional social science interviews and surveys use informed consent as the kind of gold standard and people not only have to give consent but you need to explain it very carefully and then you need to understand what's involved in informed consent. That does not happen in most forms of digital data. People don't realize when they're using the Google searches that the stuff is going to be analyzed. But of course if you want these days you need to use the Internet to access to do routine things in a way just saying well I don't want to tick the box. If you do that you are denying yourself lots of possible ways of accessing services. So in a way you know we have we have no choice really but to do these sort of things and but I would to I think they are really serious issues around that. But I also do think that you know there's no such thing as any kind of a search which doesn't pose ethical issues. And from where I'm sitting I'm really interested in kind of how we get at the perpetuation of privilege and power and that people in power often don't want to be interviewed and they wouldn't do these informed consent interviews at the time. And this is a way as Piketty's contribution he's put the spotlight on the very wealthy and the very rich by looking at data sources like income tax data. And I think you know so I think we do at times I think I have to think about if you want to ask challenging questions which are addressing really important social scientific issues. We do need to think about extending our kind of ethical range away from something you're saying and people don't want to talk to us and we just have to leave it there. Otherwise it's going to limit I think what we can really do. Yeah. The extremely interesting question we have to see whether we put that in our efforts with this series here because it's not only the ethical things you mentioned are not only about data protection and the classical data protection but the ethical way data is gathered and whether it's okay to make use of that. And when it comes to data protection if I may talk as a lawyer then you have the special problem that you can anonymize data in a state of the art way. But you can't be sure that they are analytic not analytic models that repersonalize these data sets again. And so the traditional instruments of data protection are really challenged as regards that there is another question. Okay. Sorry for that. I'm Stefan Rasmol from the University of Lugano in Switzerland. I think all of the researchers and all of the journalists in the room know that you can play with data and you can manipulate and I think all of us also know that large and powerful companies beginning with Volkswagen in Germany or with Exxon in the United States concerning data about climate change or talking about the cigarette industry. We all know that they have used data very selectively and manipulated in their own interest. Now my question is if Google and Facebook and other players are becoming similarly or even more powerful with all the data they have. Isn't there a danger that they will also manipulate all of us by presenting very selectively data which you have. And well you will present those data to us which help you for your business interests and you will possibly withhold those data which don't serve your business interests. And now you are even co-opting some of the most powerful media companies who should be your watchdogs and they become part of the digital news initiative and cooperate with you. Isn't that something well which shouldn't only frighten young researchers from London but maybe all of us here and elsewhere. Will you comment on that? I mean I can only comment on that from someone who just joined Google of course five weeks ago and I stress that again. So I can only speak from a news lab perspective. The data that the Google News Lab team provides and gives access to is of course open to everyone. And we not select because of a business interest but because of a editorial interest. So if you go to the GitHub page of the Trends team for example you see a various collection of data sets that range from football to politics to science to lifestyle issues. And there is certainly no limitation to that or no filter to that. So from a news lab perspective I think it's important to stress again that we provide the data but it's the journalist or the academic researcher who puts that data into context. Thanks. My name is Lena Ulbricht. I'm from the Social Science Research Center and I have two questions for each of you. One is for Isabel. Let's say well there is some mistrust in the data you provide but once we agree that you provide the full data you have I'm still interested in how academics and journalists can use it. The traditional data set was provided somehow in a transparent way. I had a code book where I could read the operationalization of variables. I could read the whole process of how the data was collected and so on. Now I'm interested in the data you provide for example about Google search. Do you also provide research about how the data is generated? Do you do research on under what conditions people use Google? When do they use Google? What does it mean when they ask Google questions? For example you gave the Donald Trump example. When I search Donald Trump does it mean that I'm in support of Donald Trump? Does it just mean that I'm somehow fascinated? Does it mean that I have no clue about who he is? Does it mean I want to see pictures and mark his hair? So how much do you know about how the data is generated? Because that means a lot to how we can interpret it afterwards. And if you do research about the context in which data is generated do you provide it to the public? And my question to Mike comes a little bit back to the question you asked when you published your paper in 2007. You were interested in what does big data mean for the development of social science? And now you've discovered that social science uses big data. Some people say that the big data hype is also an instrument of researchers just to gain funding. They claim they do big data because they know it's just the way you get funding nowadays. So I'd really like to know what do you think on whose expense is the expansion of big data? The traditional statistics in sociology? The classical surveys or more the qualitative research? Thanks very much. Challenging question so we'll start. I'm going to start. Good question and really interesting question. And I'll go back to the time where the team and that's again prior to my joining the team. Where there was no dedicated site to no dedicated Google Trend site where you can actually see trending stories or explore trends or explore topics based on search. And there was also no team who was working with journalists and academics. So the two ways we work now with journalists and academics is one we provide raw data and give of course context what the raw data means. And second we collaborate with journalists and academics. And you saw all these examples for example the measurable example. Measurable approach the team and ask them if Google would have data visualization capacities to help them to drive that story around the Nepal earthquake. So but it's a good point and I think I of course have to double check again with the team whether we plan to give more context if we want to collaborate with journalists and academics. But I think the goal and Simon Rodgers is leading that team. The goal is of course that we provide the context and give more information around what it does mean if you search for Donald Trump if you like his hair or if you're just interested in if he's attending the GOP debate. So definitely I'm taking up your point. Almost likely that you are interested in his last rant at some show something like that. Please. Yes I mean it's a very interesting question. I think we're in a very very fascinating time for methods and social science. And there's different tendencies at work different. Some of them link to big data some of them not really that directly linked to big data. So in terms of the challenge to existing methods. I mean my my view would be what's it may be different in Germany but in in the UK I think the sample survey which is kind of very widely used and also as is used by market research companies. There's real challenges to that. We saw it in the recent election in Britain when they all got the results completely wrong. And this issue is partly about you know if you're using if you're doing phone interviews people don't use the phone anymore. If you use mobile phones that's also skewed. People aren't at home. The sponsors are falling. I think what it doesn't mean that doesn't mean the sample survey will decline entirely. I think what is happening is and it's happening in the UK is that there's funding for the really big high prestige surveys the panel surveys particularly for people ones where people in the sense are invested into it and they will carry on doing it year by year because they feel they have to or feel they should do. But it's more difficult to get funding for a bespoke you know one off survey these days. So I think it's the big major surveys will carry on. But you know the more one off surveys will are going to fade away. I do think the in depth interview which has been a major method in Britain is looking really quite problematic because we are so saturated by interviews and my people are so used to interviews and it is actually a really interesting piece by the American Central to shame us calm about what you get in interviews is accounts and people are very skilled at getting accounts. And obviously it depends on your background and your cultural capital but nonetheless you get accounts but how that mapped on the practice is problematic. So I think those I think that those two are in difficulty. On the other hand I think ethnography the old old style in intensive immersion in a naval organization is actually very strong possibly getting stronger because it's actually extremely good compliment to looking at big data because you can actually see how it is being deployed and interpreted in particular contexts. So my sense is some quoted methods. I think I think one's probably getting a bit of a resurgence but the in depth interview by itself is declining. And I think that the I do think the use of administrative data taxation data is going to be very interesting to watch. We had this big debate in the UK about whether we need to carry on with a census which we've had every 10 years for the last 200 years. And there was one argument saying we don't need to do it anymore because we can just link together all the all the government departments records and that's much easier and much cheaper. In fact they are keeping going to 2021 but that's that debate is going to be had again. Thanks very much. I've seen three hands up and we have time for one question I guess and the final remarks. I'm very sorry. I saw that you have raised your hand here but you have the opportunity after that to talk with the panelists. So please this question and then a brief final concluding remark from your side and then we have to finish. Thank you. My name is Ricky. I'm from the University of Zurich also Switzerland and I thank you both for your very interesting presentations and I totally get the point of telling stories and about the power of visualizations. However I have to take up a point that our American colleague Rod Benson stressed at the ICA in Seattle two years ago when what he called new descriptivism. If we all go in this direction and if we all do that you know take those sets and do nice visualizations then I wonder what happens to explanation and maybe continuing on that what happens to critical research. So maybe you could say something like that. Thank you. Thanks for the question and actually I was in Zurich yesterday. I really enjoyed it. Great question and I hope I made the point that by showing beautiful visualizations not only the Nepal example or the climate change example or any other example. The data and the visualization is not enough because we might be all experts in a way that we are able to understand bits and pieces of those visualizations but definitely not the entire picture. And if you then imagine that a much bigger audience sees those visualizations embedded in a news article and of course they have no idea what they see there. So I think and you make the point. I think it's extremely important to still have that context and to analyze those data sets and those visualizations in that context. And I can't believe that any journalist or data focused journalist who's using data to innovate or to drive innovation and storytelling is only focusing on the data set. They will still do their investigative job and they will still do their research job which I think is absolutely crucial. And yeah and I think you made the point yourself and I haven't seen data stories that were lacking any description and any analysis. I'm very interested in the debate about description explanation and I think there's also ways of addressing it by thinking about what different models of causality and different descriptive strategies. But on the point you specifically made about being critical. I think when we can discuss what we might mean by being critical but actually I think there is one very important way which being descriptive allows you to be critical. And I think comes out very well in the work as a picket and the pickety is if what you're doing descriptively is to array a series of comparisons say the different nations of the world and you rate their health and your income. You can use that to kind of pull out the contingency of particular cases and say why is it the case that the US which is the wealthiest country in the world has the poorest health rates and things like that. So actually description done well allows you to be very critical I think and that's because he's the same. I mean by arraying trends of income inequality over time you can actually say well how is it in 2015 we are returning to the aristocratic order of Europe before First World War. It's a very descriptive point and I think a very critical point and I actually find this is perhaps an argument we can have later or discussion we can have later. When people say we must not lose sight of explanation that sounds fine but there aren't actually that many it seems to me really good explanations of things in social science. You know we aren't either very reductive you know it's all to do with capitalism for instance or fairly tautologically obvious and perhaps you got some but I think the thing about explanation is often weird out it sounds good but in practice I'm not sure it is such a powerful valiant coin. Thanks very much. Only very very few concluding and technical remarks but very important ones at the end. The first one a big thank you to our speakers were really fascinating and I think it's worth clapping our hands for these fascinating remarks. Thanks very much indeed. Thank you to the British Embassy of course has been an excellent host here and could be in this marvelous rooms to the Vodafone Institute which makes this possible and is an excellent partner in doing this. Thanks very much. And our organizational team of course Lena Ulbricht Christian Petzold and Larissa Wunderlich. Thanks very much to run extremely smoothly. I'm also thankful to the two speakers of the division sociology of media and communications and computer mediated communication of the German Association for Communication. Because they were so kind to accept that they do not have room here for welcome address and leave us more room for discussion so that's very very kind thanks very much. This conference is not only the starting point of a lecture series by the Vodafone Institute and our institute the Humboldt Institute for Internet and Society but also for conference on media and complexity that takes place tomorrow and the day after. And I hope this conference will be extremely fruitful and welcome to all guests that are part of these community. I think that's it basically. I've already talked about the series we have that means that we hope to welcome you to another event. If you have subscribed to our newsletter we will inform you when that takes place. It's in January and March but the exact date is to be announced. And I think that's the final remark. The last one is the one I like most. I invite you to drinks I don't have to pay for. So please please enjoy the hospitality of the embassy and the talks with the panelists and our team and with each other. Thanks so much.


Okay, hopefully you watched the first video in this little series. If not, there's hopefully I put an annotation up on the screen. And this is software that I wrote, mainly with the goal of calling overtime for firefighters because that's my day job, but I'm sure there's other areas that this can be used in. And today, previous video, I should give you a walkthrough. Today I'm going to show you how to install and get at least the database set up. And then in the next video, I'll probably walkthrough more of the code. So go to GitHub, my username is metalx1000, so github.com forward slash metalx1000. Click on my repositories here and find the one labeled overtime list. We'll go ahead and we'll click on that. And now you can download the zip file here. I'm going to recommend getting this HTTPS URL and using GitHub to get clone it. But whatever you find easier, if you've never used it before, the download zip might be easier. Using Git might be a little bit easier if you want to update it later on. Then in your shell, go to wherever your web server is set up, that type Git clone. And I will paste in the address, the URL that we just got, and it will clone down the whole project. It is really, really small. And as you saw, it took a couple of seconds. And it looks like it's 55 kilobytes. So very small. And so for this project, as I just said, you'll need a web server. I'm running Apache. And you'll use MySQL database is what it's using, as well as PHP for the server-side scripts. So those are three things you want to have installed. Also optional is PHP MyAdmin is what I suggest for maintaining your databases. And we're going to have a little look at that right now.  Use the package manager to get that stuff, get it up and running if you don't already have it up and running. Now I've logged into my PHP admin here. And just for testing purposes, I set the default username and password to root and root. Obviously, you wouldn't want that on your live machine. You want to use something a little different. So now we need to create a database. Now we can manually do this in here, according to my script, although you can change it. The database name will be overtime and it'll be two tables in there, overtime list and overtime log. Again, you can create those. Each one of those tables will have six entries in them. The entries will be ID, PID, name, rank, phone number. And then the last one will either be update, updated or date. So you can go through and create all of that. And I can walk you through that. I was nice. I made a script that already does this for you. So let's go in here real quick. And as you can see, we downloaded our script and it's inside a folder called overtime list. We'll go in there, we'll list out our files here. And there's this one called credentials. That's the first one you want to go into. So I'm going to use Vim as my text editor, but use whatever text editor you prefer. And I'm going to edit the credentials. Localhost will probably be your server unless you're connecting to a remote server, which normally you'll be connecting to a local server, localhost, if you're running a web server like this. Now you'll change your username and password right here. Again, I have mine set to default as root just for this tutorial. That's what it's going to say by default when you download the code. But you'll want to delete here and put in your actual username and password that has the proper permissions for creating tables and databases. So that's all you have to do in there. There's a script in here called connect. We'll have a quick look at that, which will use that credential script, but also set your database to overtime. And this will be basically in the head of all your connections. But what we want to do is we need to create that stuff. And I did create a PHP script called createDB PHP. So let's create DBB. We're going to look at it first here. It's kind of long, but real quick, just so you can see, it's loading up that credential. So it's loading up the local host and username and password. It's connecting. We'll check to make sure it connected properly. And that's going to create a database called overtime. Again, you can do this all manually if you wanted to. Here it's going to give you whether it was successful or if there was an error. Then we're going to load up our connect PHP and our tables PHP. There's two tables working with. The tables PHP will generate variables for you, table and table two. And here we're going to create those tables. And as I said, there's going to be a table called, our entry called ID, PID, name, rank, phone, and update in our first table. It will try to create those. And if not, it will give you an error message. And we will also create our second table here, which also has an ID, PID, name, rank, phone, but last entry will be a date entry. And again, it will try to generate that and give you a message of whether it was successful or not. So that's a quick look at it. How do you run it? It's really, really simple. Like I said, you have your web server set up. We're going to go to wherever your web server is. For me, it's local host, middle x1000 here. And again, overtime list. So here we are looking at the same code we were just looking at in the shell. There's one called create DB. We'll click on that. And look, it says database created successfully, table overtime list created. And the second one should actually say table overtime log created successfully. That's something I need to change in the code. It still creates the table properly. It's just giving the output wrong. So now if we go back into PHP My Admin and we click on databases, you can see that the overtime database now exists. So it did it all for you.  Obviously you're going to want to password protect some of these files so that you'll have access to them. And it created two tables here. The first table here, the overtime list. We can look at its structure right here. And you can see again that it has those entries we talked about. The ID one is an integer and it's an auto incrementing. PID is going to be a randomly generated individual number. Similar to this ID and I call it PID. It's just another individual ID that you can generate with your code on the go. And again, we have the user's name, their rank. Because again, over time you may be calling people for firefighter over time, driver over time, lieutenant over time, different positions. So you want to have that. My code right now doesn't really filter through that. That's something you would implement yourself based on your ranking, but should be very simple to add. Their phone number and then updated is going to be a UNIX timestamp. And this is how we rotate the list. So every time the button is clicked, it timestamps that with the new time, which will be a higher number than the old time, because the UNIX timestamp is the number of seconds since January 1st, 1970, I believe. So continuously grow every second and move that person to the bottom of the list when their name is clicked. Going back to here and clicking on our other table, this is our ongoing log. And the only real difference between here is besides the fact that it's not just updating each entry, it's actually adding an entry each time, is that it's structured. The last one, as you can see, it's a little bit bigger. I made it 100 characters, which is probably overkill a little bit, but it's going to be an actual date stamp just to keep things simple. It's going to say actually Saturday, November 5th, 2014, at 12 p.m. Eastern Standard Time or whatever. It's going to give you all that information. So it's a little bit bigger. So now that we have that, what we want to do, I'll give you an example here. Well, we can go in here and through PHP My Admin. Let me go back here to our databases over time and I'll click on our list here. There's no one in our list right now.  So let's go ahead and add people to our list. So we'll say insert. We'll leave the ID blank. It's going to automatically generate that. PID, we're going to give it a random number. So I'm just going to, you know, you're actually going to probably use some sort of script input in a lot of the information here, but we'll say here, John Smith for the name rank, I'll say firefighter. I'm just going to put everybody in as a firefighter because again, just an example here. 555, 555, dash 5555, updated leave it blank. Again, it was a UNIX timestamp right now where it will be blank. And as you click on their names or rotate them through the list, you can sort people through the actual interface when the time comes. Again, for the PID, we'll give it a random, whatever for their name. I'll just say Peter Parker rank. Again, I'll say firefighter, phone number this. I'll say 555, 555, 555, 556, whatever, and leave the updated blank. And we'll click go. And it has added those two entries. If we go to browse, you can now see those entries added. And we'll go back to our call list and hit F5 to refresh there the names. Now you notice again, right now the updated is a null number. If I click on the first entry there and I refresh this page, you can see that now there's an entry in there. If I click the next name now and refresh in here, you can see there's a timestamp. So each time I click it, it's going to update that number. It's going to be a higher number based on the date and time. So just to speed things along, there's another little script that I put into our code here if we go back to our shell. So if you just want to test out the program, you don't want to enter in all your employees, which can actually, hopefully you have some sort of contact list you can import it from. If we list out here, there is a test SH. Now you're going to want to modify one variable in it because right now I'm local host, but everything's in a folder called metalx1000. So you might want to change that if it's in your root folder, just remove that part. Besides that, this will generate random fake people for you. So I'll just say, I'll run it like that. Gave me some output telling me what it entered. If we come back here and I refresh this page, you can see that people have been added in. If I go to the call time list and refresh here, you can see a random name and number has been added in. So you can run this script a couple of times, this test bash script. And now again, if we come in here and refresh, you can see that we just generated a bunch of fake names and phone numbers in our database for testing. So if you want to test this out before we actually implement it and take the time of entering everyone's numbers. And again, we can click through the list here and that'll actually cancel or not zero everybody out, but give everybody a unique, well, sometimes unique. Again, it's based on seconds if I click the same name within a second, it's gonna give it the same name there. But that is getting it all set up. You're good to go. In the next video, we'll actually look at some of the other scripts and actually go into details on how they work. That way you can modify it. Again, I know where I live, there's different fire departments and each of them do things different, especially their overtime lists are all work different ways. And so, although this program is pretty much fully functional, you'll probably have to tweak it based on your rules, regulations, and or contract. So I'll give you an overview of the code so that you can understand how it works and modify it for your use. So that'll be in the next video. And hopefully I've remembered to put some annotations on the screen to that next video and probably hopefully an annotation for the full playlist for this software here so you can view it. I thank you for watching. Again, my website is filmsbychrist.com. That's Chris the K. There should be a link in the description. Go ahead and check that out. If you like this video, be sure to like, subscribe, and share. I truly appreciate it. And as always, have a great day.


FreeRTOS Configuration There are two main configuration files within FreeRTOS. FreeRTOS.h, keeping more advanced settings, and FreeRTOS.config.h, where we can configure most of the parameters and add or remove FreeRTOS components and functions. FreeRTOS.h file should be modified manually if needed. Using STM32Cube IDE or STM32Cube MX Code Generator tool, FreeRTOS.config.h file are available within FreeRTOS mode and configuration window at the configuration parameters tab, which is covering main FreeRTOS configuration parameters, what we can see currently on the screen, and include parameter tab, allowing us shrinking code usage by removing most used OS components and its features. Rest of the tabs is used to create OS components like tasks, queues, semaphores, mutexes and software timers. We will not find there neither signals nor event groups. Those components need to be added manually from the code. We will focus on this point in a separate section on this training. Let's start with use preemption settings, which specifies what kind of a kernel algorithm we will use with or without preemption. Some additional settings related to scheduler operations can be found within FreeRTOS.h configuration file, which should be modified manually if needed. Here we can see some examples of most important settings of the FreeRTOS available within config parameters tab and stored within FreeRTOS config.h file. All of the settings have their default values, which are correct for simple system. Config CPU clock hertz is configured automatically based on clock configuration of the MCU. T-grade is configured to 1kHz, which is the most commonly used value. Total hip size is a size of the RAM memory, which would be dedicated to operating system. Please notice that the total hip size is given in bytes, while stack size for a particular task is given in words. To last components are extremely important due to the coexistence of the operating system of the rest of the hardware resources of the MCU. Library lowest interrupt priority is set automatically to lowest possible priority value. In Cortex M3 and M4 and M7 based STM32s it is 15, while in Cortex M0 and M0 Plus based STM32s it is set to 3. This priority value is set for the interrupts responsible for the context switching, so for the SysTik and PentSv. Library max syscall interrupt priority is the maximum priority value for the interrupts, which would be allowed to execute operating system functions. One of the most common mistakes is usage of operating system functions from the interrupts, which have higher priority value than this one. Thank you for watching this video.


I'mma tell you so. EEEEEEEE Oh my god what is going on over here with this killer buddy? Oh my god. Oh! What?  Okay this is a little crazy. But it's like the guy who drill is the gaming here today we are back on the scary mansion. Oh no don't tell me chase me. Okay good. And today is Monday comment of the week starts today so make sure you want to win a robots code. Make sure to drop a comment below. Alright so let's see what's up with this scary mansion.  Oh, oh my god. Piggy's right here. What? Oh? All right, she's just playing games. Oh, can we vibe check piggy? Oh, we just smack piggy out of the way What is wrong with you? Oh my god, okay? Peppa Pig keeps coming back to us. No, don't buy check me vibe check Peppa Pig. Yo. Oh Didn't sound too good did it? Oh Gosh, we got pep of the pig over here. No, okay, we can vibe check it when we're on the ground. That is good No, get away from me great And we just got what they sent pep of the pig on the roof What is going on? Why is pep of the pig on the ceiling up there? Oh? My god. All right. That is crazy. Oh god. No now. She's coming this way. Oh No, we got to get a safety guys. All right, so let's go through the house Okay, I think peppa the killer is gone. Oh my god. That scary bacon is there. Oh look Maybe if we show this to Peppa the pig She will hold her horses Because I believe that's like sausage right in there. You know we need to have pig in it Of course, I say. Oh god. Who's the killer? Oh? We got a medicine killer on the loose over here. Okay, let's get the bike back Goodbye check back. I Think he's oh there he is. Oh Oh my god. Oh, all right crazy Easter bunny. Oh no recipe to my boy right here All right, let's go this way. What's up, Andy? That's the game creator right there.  Did you have a massive taco bro? Like where do you even get it from? Oh That sounds like a killer clown. Well, it's not a killer cat. Oh Is that like a YouTube or something you guys saw his face, right? All right, let's go this way We got let's see what else how many points we got we got 330 points we can give it that let's just get the simple stuff The skateboard should we get the skateboard? Oh, I hear the guy over here He looks so weird Oh Did I smack them it totally glitched? Oh gosh No, look at acts over here And then we got VY over here, too. Oh, no, everybody got slaughtered by that guy All right, so let's get this vibe check back. I think this is like the only thing that can protect us from the killers Oh, no, we got boss leader zombie and Peppa Pig at the same time.  Oh, no get away get away There you go. This is just by checking me, huh? Oh, that that's what you get that is karma right there Oh, we got each other great. Oh my god. Look at piggy. Piggy though Piggy's getting launched across the map. What? Oh, okay. Now. We're just getting smacked. Oh god, please don't Okay, so one thing that freaked me out about Piggy so much is like those horrible squeals that she does Like that. Oh, oh, oh, we made it on top of the house. No, and we fell down What's the guy with the taco? Oh, look the Chaco. I told you guys had him I keep looking at his taco and his inventory.  We got blazer here. He's rocking the merch. That's something Okay, why can I oh Jimmy Neutron What since when is Jimmy Neutron a massive murderer? Oh god, here he comes Why is he walking like that? Got a blast Hey, hey, it would have been cool when he said I got a blast his rocket came out You just started killing everybody with the rocket.  Oh, he sort of went to the moon Dude, he just launches all the way back. Oh He's getting smacked up. He's matching up back. So get out of here Jimmy Neutron go to the stars Now it's a vibe chef war out here. No Oh Why me? Hey, we kind of had the same outfit on. Oh, all right.  Okay. Let's just ignore that. But wait, let's see Alex. Oh My god, what just happened Who's Alex? Oh Alex is that tiny guy?  My god, I think he's on the phone. Yo Why did he breathe so heavy?  Let's have a talk now To just send me right straight up to the moon, huh? No Thanks a lot. You just got me killed All right, let's go over here That was a strange killer. I never seen it before it's not vibe checking me.   What?  I've never seen that before in roblox. That is pretty legit. Yo.  Let's get a look at his face Yo, oh my god boy big foot is getting bullied over there. He's getting tossed around No, somebody save me. Oh great. Oh, no Oh my god, I feel like 80% of the videos has been me getting He's smacked around they're flying around the whole map No, oh we dodges my check And now oh I have a gun This is worse than the vibe check back because I can I can spam this thing forever and ever and it'll just smack them God come on the way who's a killer? Let me fix my inventory. I want to have the vibe check second The vibe check second. I mean Uh-oh. Oh, it's that guy. It's from um house of spooky jumpers, right? I'm not mistaken.  Oh great. They're back fired on me Dude he has an actual car. Oh No, you need like 700 points for that car. It's insane. Why can I vibe check him when he's on the car? That is not fair Dude, what's up with that guy? Oh, there's someone on the window. Hello spooky ghost. Oh, all righty. Wait It's actually not anybody. It's just like an NPC. They're a mess. Oh, it is someone Well, I thought it was just like a mess there or something Who was the killer? I'm trying to see who the killer was and did not see anybody You just flung over here. Oh, there you go. Oh, it's peppa pig. Oh my god All right, let's let this time.  I mean, it's a red dress. So that's a girl. I'm mistaken. Yo You gotta chill out.    I feel bad for the guy The pale man. Oh gosh What what is wrong with this guy?  Help me.  Okay, we're still alive.  No Get away. Oh my god. No, he's coming this way Okay, up. Okay. No, I thought we were safe there for a second, but we are not He just flew over here. I don't think he killed you or anything Let's go and see for ourselves. Oh, actually I was wrong I am sorry. Oh My god, okay. He's stuck there nice. All right.  All right, you guys. Well, this was a scary mansion in roblox, but you guys Well, thank you guys for watching. Thank you guys for the basic support Oh great If you guys enjoyed the video make sure to slap the like button if you're new to the channel make sure to subscribe And turn that notification bell on and I will see you guys in the next one. Bye


Hi everyone, Joe for JaspysCaseRakes.com with 2021 Proceeds Football Pack Number 22. It's our last filler. Is this the only filler?  That's coming up in the next video. First the pack break. Big thanks everybody here for making this happen. There are the teams over here and let's roll it and randomize it six and a one seven times for names and teams one, two, three, four, five, six, and a one, seven and final time. Different dice roll for the giveaway part, six and a one, seven times, and a one, seven and final time. All right, there's the first half of the list right over here, second half of the list right over there, and let's just print and rip. No trade windows in filler packs. We just want to get to the giveaway part as quickly as possible. That's how I see it. Let's see what we got here. Jamar Chase Rookie Card. That's nice. Wadri Stevenson. All right. So nothing too crazy here. It's just commons. All right, it's just a retail pack, retail pack. All right, let's flip back over here and of course the whole, the whole thing right here. Let's gather all the names right there. The whole point of this is who's going to win those hip-rate spots. Therina's four, seven times again. So top 10 after seven, good luck, one, two, three, four, five, six, and seven then final time. Now from 11 on down, James, very close man, but not quite there in the top 10. Appreciate you're trying. Thanks everybody, but ultimately sad times. Happy times though for the top 10. Kevin is happy. Chad, Kenneth, Chad, Kevin, Jose, Mark, Jose, Ryan, Jose again. There you go. Thanks everybody. I'll see you in the next video for the break, jaspyscasebreaks.com.