Live from Boston, Massachusetts. Extracting the signal from the noise. It's theCUBE, covering HP Big Data Conference 2015. Brought to you by HP Software. Now, your host, Dave Vellante. Welcome back to Boston, Massachusetts, everybody. I'm Dave Vellante of Wikibon and wikibon.com. I'm here with Kevin Goode, who's the director of platform engineering at Inmar. And we're here at the HP Big Data Conference 2015. Kevin, welcome to theCUBE. Thank you, Dave. So, we were talking off camera this is your first year at this event. Yes. What got you here? Well, the folks from Voltage asked me to come up and present and talk about how we use Voltage and our Hadoop cluster to do some of the healthcare data analysis that we want to do. Yeah, so that's going to be a good conversation. I want to dig into that. We heard a lot of conversations yesterday about Hadoop and all the big data hype and how Hadoop is not big data. So let's just have a little dig into some of that. Okay. As a practitioner of Hadoop, you were probably taking it back a little bit, but I'll come back to that. I want to talk more about Inmar. Tell us about Inmar as an organization that's been around for three or four decades. What's Inmar all about and what's your role there? Inmar started 35 years ago as a coupon processor, coupon redemption company, acting as the trusted middleman between retailers and manufacturers. And we've kind of evolved over the years. The retailers ask us to start handling their pharmacy claims as they all started to put pharmacies inside of the grocery stores. It was another type of receivable and they said, Hey, can you do this too? So we start doing that. And then we also start doing return goods for them. So the best way to describe return goods and reverse logistics is if you go into your grocery store on Halloween, you've got a shelf full of candy.  Well, all the candy has to go somewhere and it comes to a company like us and we count it and credit a store for sending it in, try and sell it off to the big lots or the dollar store or whoever just dispose of it. So mostly we've been a financial transaction middleman between retailers and manufacturers across three different early lines of business. It's a version of water falling in retail. Exactly. That's a fascinating story about a company who transformed from sort of a legacy old line business to a modern business. I heard a story this morning on the radio about Columbia records. You're probably too young to remember Columbia records. But when I was a kid, you'd get mail, all kinds of spam physical mail about, Hey, sign up for our record of the month club. You'd get for pennies, you'd get an album and every month you'd get a new album for a lot higher price. And Columbia records was a billion dollar plus company and last year they had revenues of 17 million. They just went out of business. In Mar, I didn't go out of business. Instead it transformed. I wonder if you could talk about that transformation, how it took place and what role you and your team played. Right. So we decided, our CEO decided about five years ago that we needed to transition from being just a business outsourcing company to really the data driven enterprise. And we started down our journey and I was tasked with going out and starting to look at big data, how we could leverage big data to take all of the transactions that we generate from our business outsourcing business and start to create insight. And so we started to go down the Hadoop path really about three years ago. Built a cluster, picked some vendors and we've started moving data over and hiring data scientists and data engineers and starting to drive insight. And we actually have products that are in production coming out of our Hadoop cluster, which I've found that a lot of people talk about POCs but never really get to, hey, we're making money doing it. One of the things Ken Rudin from Facebook said today is the big data is not just about insights. It's about being able to take action and actually take that action and affect business change. Five years ago, in 2010, most people didn't even know what Hadoop was.  That was Mike Stonebreaker being Mike Stonebreaker. And today, big data is not Hadoop. And while I would agree with some of those things, take us back to 2010. Hadoop changed the way in which you looked at data and were able to store and process data and the economics of data, didn't it? It absolutely did, yeah. So when I was looking at everything that we could go with for analytics, we looked at Knotiza, we looked at Green Plum, we looked at SQL Server Parallel Data Warehouse and all of those were in the multi-million dollar range just to kind of get started and see if it even worked for us. I built my cluster for around $50,000 and with another $50,000 invested in services from Hortonworks, we had something up and running and started to actually generate actionable items out of it. And Vertica was or was not part of that equation? We didn't look at Vertica at the time. So it was just pure Hadoop, white box stuff, shipping function to data, which is the epiphany of Hadoop.  Yeah, and we decided I wanted to spend my money on engineers instead of on licenses. So Hadoop in that sense was a profound catalyst for business change, was it not? Yes, it absolutely is. And so then, but then of course, I mean, and I think it's fair what some of the speakers are saying at this event, it's not just all about Hadoop, you probably found okay, there's more that we can do. Maybe take us through that journey. Right, so we're finding Hadoop is good at doing a bunch of crunching and doing the deep analysis, but it's not good for ad hoc, it's not good for folks who just want to go in and get an answer really quick. So we're finding that we will do this kind of big batch processing and push out to other systems like a Postgres or we use Couchbase and start to build APIs that we can then deliver as data products to the rest of our enterprise. So is that where Vertica kind of came in as well is trying to filter some of the data and put it to Vertica or did Vertica come in just more recently? So Vertica is something that we're considering, but really what kind of brought me into the HP fold was using voltage. Oh, talk more about that. So big part of what we do is this pharmacy claims reconciliation and so that's all HIPAA data. And we know that we want to dig into the HIPAA data because that's a huge, huge market. There's a lot of money out there on the table, especially with the Affordable Care Act and people needing to move away from fee for service to more of a performance-based metric system. So I can't put protected data in Hadoop and have my data scientists go through and start figuring out algorithms. So I need to use voltage to do reversible encryption so I can put de-identified data into Hadoop. My data scientists can do all of the stuff that they do, come up with their algorithms, come up with the results set at the end, then I can move that back over into a protected system, re-identify it and then we can act on it.  Where would an MPP database like Vertica fit in your architecture? It would probably fit more in the reporting side. So, you know, some of our clients, so Walmart is one of our clients. Whenever you use Walmart, your scale goes up by a lot. And I've considered using Vertica to load some of our healthcare data where they want to do reporting and they want to report by 40 different, have 40 different slicers on the data. That's just outgrown what we can do with SQL Server and I need to find something that performs better. So your main EDW is running on SQL Server today? Is that right? Right.  Yep. Where do you see the analytics piece? Where is that in the whole data pipeline? Is that sort of embedded into the database? Is it, have you built custom applications? We have traditionally built custom applications across the board because we generally set everything up as a multi-tenant. So, in our healthcare space, we have 90 clients and really don't want to have 90 separate databases and have people come in and connect directly to the database. So it's usually web apps that our clients can log into and then we handle security at that point and give them a consistent look and feel but inside the web apps, it's very analytics driven and you can have like 40 different filters and go find data however you want to find it. So, Colin Mahoney, I don't know if you saw his talk yesterday but he had a chart up there. He showed the ERP days, the original ERP days highly customized and then moving into packaged apps, you know, SAP and Oracle financials, et cetera, et cetera. And then I thought he was going to take us down a similar path saying, you know, big data's going to go the same way. It's highly customized today just like you're doing. And I thought he was going to say it's got to move toward packaged apps. But what he said is he used this notion of composable apps, flexible pieces that you can sensually put together to build what is a quasi customized app. Is that where you see it going? Yeah, that's really what we're working on is with the dashboards that we're building we're trying to make sure that everything is kind of widgetized, if you will, so that we can have the kind of toolkit so a power user from any client can come in and start pulling widgets onto their dashboard and get whatever kind of view they want into the data. We're really trying to treat what we're doing as more of a SaaS model. So, you know, we want to provide the dashboard, let you customize it. We can pull in whatever components you want to. So, obviously, big user of open source. Yes. A lot of it you're not paying for, which is great, helps with the economics. Yep. But then there's the support issue. So you're using Hortonworks distro. Are you a subscriber? I am a subscriber, if there's. And the reason we went with Hortonworks was because it is just a server subscription. It's not done having closed source pieces. And I remind my sales guide, Hortonworks, pre-regularly that I expect you to be a valuable partner and that we should have an ongoing conversation and we should be meeting probably quarterly and working as partners and not just you showing up once a year going, hey, can you cut me a check? Well, it's interesting to watch that whole sort of distro movement. It moves cloud air all alone and then all of a sudden Hortonworks comes in and then everybody had a distro. I think SiliconANGLE announced the dupe distro at one point for kicks. And you see the sort of big three, Cloud Air, Hortonworks, and MapR, all of them, proponents of open source, all of them contributors to open source, but the definition of open has short shifted and changed in the last 15 years, hasn't it? Yeah, it certainly has. When we looked at Cloud Air, I noticed that their manager, which they kind of touted as being their big thing, had closed source bits in it and MapR has closed source drivers for their file system that's really kind of what drove me towards Hortonworks. So you're a proponent of a, the more open the better, okay. But the flip side of that is, there's function and integration in theory that you can get from a closed source approach. Do you not buy that? Do you feel like open source has caught up or will eventually catch up? What's your thinking on that? I think there is some value there, but I really need to see the value and again I want to make sure that whatever vendor I choose if they are going to maintain some of his closed source is a partner and it is going to work closely with me and provide more value than just, well here's some code that's closed source that you can't use unless you pay them. Yeah, so obviously you work with a lot of proprietary software vendors and Microsoft as an example, but they're proven and so how do you make the decision open, closed? How do you make the decision in general for big data analytics in terms of what to buy, what to build, you know? My first inclination is usually to look at the open source stack and see if there is a reason that it can't work, that there's a reason that it's not able to fulfill what we want to do. And from there I'll start kind of branching out and again I don't mind paying a vendor as long as a vendor is actively engaged. I don't want to pay somebody a lot of money every year just to talk to them once a year. Mm-hmm. Now we've heard a lot of talk about Spark at this event, Kafka, big open source initiatives that are getting a lot of press and a lot of attention. What are you doing there? We're looking at Spark and Storm and Kafka right now for our digital platform, which we know that paper coupons eventually will start to fade away and the digital is kind of the future in that space. We want to do real-time streaming and so we are working on that front end application that handles the coupon redemption to turn it into more of a PubSub message-based system and then be able to stream that data down. We've looked at Kinesis through AWS because we are pretty heavy in AWS for our digital space and looking at Storm, since it is part of the Hortonworks stack and Spark, trying to figure out which one of those makes the most sense and the kind of crazy thing is if I talk to Cloudera, then Spark is the thing and Storm is terrible. If I talk to Hortonworks, Storm is the way to go. So yeah, we had spent a lot of time kind of weeding through the marketing material and figure out what really makes the most sense. It's interesting. So I mean, you have a lot of, essentially when you mention Amazon, so let me start there. So if you look at Amazon, Google and Microsoft Azure, it appears that they're building out a data management layer that's integrated and they're delivering it as a service. Amazon turned the data center into an API, essentially. But it's arguably less functional from a data analytics standpoint than what you could get through building, putting cobbling together open source pieces and putting in your own customizations. But the trend seems to be going toward a more integrated approach, even with projects like Tungsten. What's your thought on that? That sort of simplicity, integrated, cloud, but maybe a little less functional versus sort of the more bespoke, maybe a little bit more complicated, but more functional. I'm open to either one. I've actually recently kind of looked at Azure and at AWS for Hadoop. My CTO kept saying, how come we're not doing Hadoop in the cloud? GMR is there, you mentioned Kinesis. So I ran the numbers and it was costing me about 2,000 a month on-prem. And to do the equivalent cluster, out in Azure was about 11,000 a month and AWS was about 9,000 a month. And again, when you get right down to it, I would prefer to spend that difference in money on good engineers so that we can build good stuff. So was the cost a function of a lot of different things? Was it mostly bandwidth? Because you're moving data around or storage and- It really wasn't bandwidth at all because a lot of what we're doing is pulling the data from AWS down to our Hadoop cluster to do the analytics on the digital promotion side. So it was compute and storage. It was all compute and storage. And the pizza boxes that I bought three years ago cost is just about nothing. Wow, so that's a stark difference. Now, you're doing full total cost of ownership. You're including your people and the time. Yeah, rack space, data center space.  So I added all of that in and I still came out a lot cheaper on-prem. But you do use AWS for certain use cases. What are those? That's for our digital promotions network. And what we've really kind of decided to go cloud is when we have an app that needs to be up 24-7. We don't have multiple data centers. We have a single data center. So for the stuff where we're interacting at a point-of-sale system at a retailer, we want that up 24-7 high bandwidth and we found AWS does that best. So actually that's interesting. So the requirement there is higher availability, application availability. And the cloud is your solution there. Interesting. Last question, just this event, it's your first year at this event. Thoughts on what you've seen, what you're getting out of HP Big Data Conference? I've really enjoyed it. And I think what I've really gotten out of it is since I've been considering Vertica, being able to talk to some of the other HP customers that are actually running Vertica and say, what do you find and works well? What doesn't work well? What's your experience been? Has been the most valuable to me so far. Kevin, great segment. Thanks very much for coming on theCUBE. Really appreciate you. I always love the practitioner perspective, cut through the BS and tell it like it is. So thanks very much. Okay, well thanks for having me on. You're welcome. Keep it right there, buddy. We'll be back with our next guest. This is theCUBE. We're live from Boston, HP Big Data Conference 2015. Right back.


Hello everyone! This is a video tutorial from the Electronic Frontier Foundation to walk you through how to disable Facebook's new photo tagging suggestion feature, and to let you know about some other Facebook privacy settings related to photo tagging. The new tagging suggestion feature works by using facial recognition technology to examine photos in which you've already been tagged, and then creating what Facebook calls your photo summary or photo comparison information, or what we'll call your facial fingerprint. Using this information, Facebook will suggest your name to your friends when they upload photos that you appear in, and will invite them to tag you in those photos. In this video, we'll talk about three ways to get Facebook to delete your facial fingerprint data, and we'll show you a privacy setting that lets you ensure that you're the only person who can see tags identifying you in photographs. So, let's get started. First, select Privacy Settings from the Account drop-down menu. Then, click on the Customize Settings link under the Sharing on Facebook heading. Scroll down to the category of settings called Things Others Share. There, you will see a setting called Suggest Photos of Me to Friends. Click on Edit Settings. The setting will, unless you have visited it previously, be set to Enabled. Select Disabled. After you do this, Facebook will no longer suggest that you be tagged in new photos. According to Facebook representatives, it will also result in the deletion of your facial fingerprint data. In order to be doubly sure that the data is deleted, however, we recommend that you take a second step. Click on the Learn More link in the bottom left corner of the box. This will take you to the Photo Tagging section of the Facebook Health Center. Scroll down and click on the very last topic heading. How can I remove the summary information stored about me for tag suggestions? Click on Contact Us. And then, click OK to send the resulting message to Facebook. Facebook will then send you a confirmation email to let you know they've received and complied with your request. A third, much less efficient way that you can prevent Facebook from creating and storing a facial fingerprint of you is by untagging yourself in all photos where you have been tagged. Remember, though, you'll have to continue to remove new tags as they are added if you want to prevent a new facial fingerprint from being created. And there you go. You have now disabled the tag suggestions feature and deleted Facebook's facial fingerprint of you. However, if you are still concerned about the impact of photo tags on your privacy, we have one more tip for you. Although Facebook does not offer a setting by which you can prevent people from tagging you, there is a setting that can be used to prevent anyone but you from seeing those tags. So, go back to the Privacy Settings page. Click Customize Settings. And go back to that Things Others Share category. There, you will find a setting for Photos and Videos You're Tagged In. Click Edit Settings. From the dropdown menu, choose Custom. In the Custom Privacy pop-up, select the option for Only Me. If you choose this option, no one but you will be able to see tags identifying you in photographs. Note, however, you can also customize this setting so that only friends or only a subset of friends can see tags of you. And there you go. You've now disabled the tag suggestions feature, deleted your facial fingerprint, and taken control of who can see photo tags of you. Thanks for watching, and keep an eye on EFF.org for more information and commentary about Facebook and privacy.


talk is Legacy Admin. So thank you guys for coming. I know you had many other option. So thanks for coming to this talk, and I hope it'll be informative. And it's about InspectDB, which is a Django command that helps you reverse engineer a model from an existing database. Once again, my name is Victor Christopher Cabral, but I go by my needle name Chris. When I was practicing this, I ran a little long, so I'm going to speak kind of fast to try and get as much information in as I can. This is me. There's professional Chris and then regular Chris. So if you want to come talk to me afterwards, you know, you'll talk to regular Chris, not professional Chris. But right now it's a professional Chris. So some themes for the talk that I wanted to give are don't write code unless you have to. And my name is Chris, not Victor. That'll come up. And if you're doing something hard with Django, then you're probably doing it wrong. And this is something I realized when I started using Django initially. When I created a custom command to populate initial data, and then I realized that there were fixtures. So this happens a lot. When you like, when you start to work on something, you don't read all the documentation or you see some cool part of it that you want to do and don't realize that there's other things.  There's flash r slash Django. So it's, and there's a lot of like custom apps, templates, and they all have like their suggested ways of doing things. So Inspector V is one way that you save a lot of time if you're looking working with a legacy system. So Inspector V reads tables and columns not rows and our database and produces a model stop pie to standard out. So you don't have to manually write this code. And you could, you could, you know, create a class that inherits from model stop model and give it an explicit TV TV data like name. And you could go through every table in your database. But this just jump starts the process for you. And it's not perfect. So we'll go over why. What will you have to do afterwards? But it works pretty well. And when when you need this, and two scenarios have come up when I've needed this, I needed a, I have legacy, legacy system legacy database, and I just wanted an admin interface to it. So foreign keys are great. You know, primary key constraints are great. There's, you know, all these constraints that my SQL comes with. But in reality, if you have like an additional validation layer to legacy system that you want to keep in a clean state, you can, you know, reverse engineer model out a couple of validations, and you'll have this slick admin interface that Django comes with for free. And the other use case that I've come up with is creating management commands. So when you create management commands for going through a bunch of rows in the database and making sure that one field is less than another field, or you want to find all rows that have, you know, certain value, the ORM comes in handy for doing these things. And writing custom SQL is sometimes hard, particularly if like, you know, it's not designed to be a programming language. It's designed to do specific things in SQL. So that's another reason why this has come in handy in the past. So I've kind of created a fictitious scenario of why I'm doing this demo. And I have a legacy system with a legacy database, and I can't touch the code for whatever reason. And I need to be able to manipulate the data but still keep it in a clean state. So why can't you edit the source? There's a lot of reasons why you wouldn't be able to edit the source. You don't have the source. It's a third-party product. It's written in Rails. Or, you know, the source is written so poorly it's impossible to understand. So at the end of this demo, I want to be able to have an admin interface that, with as little work as possible, I want to be able to have my basic CRUD operations. And I want to be able to leave the existing database intact more or less. And we'll talk about how we break that and when we have to break that. And different ways to get around it. But I more or less want that legacy system that's interacting with this code to be the same after this. So, straight from the docs, inspect database, introspects the database, and whatever is pointed. So the first thing you'll notice here is that whatever your settings name is pointed to, that's what it's going to introspect. And it's also, in this statement, doesn't seem like it says a lot, but it actually says a lot. The script will inspect the database and create a model for each table. So something that you don't think about is that you'll often have more tables than models because of many to many relationships. And introspection doesn't understand that concept. And also the most important part of this is this feature is meant to be a shortcut, not as definitive model generation. So I created a fictitious model. So it's pretty basic. There's a user table. And I made a lot of egregious errors. Don't blame me. I designed this to be terrible on purpose so that we could understand what would happen if you designed a database that's terrible. Because you have to work with databases that are terrible. And when you're introspecting them, they're not going to be perfect. So I have a user table. It has one primary key. It's auto-incremented. It's not null. And it has a username. And then, of course, it has a plain text password field. We have a company table. It has one primary key. It's auto-incremented. It's got a name. And it's self-referential. So a company can have a parent company. So it's an interesting corner case. And then, this is what I was talking about before. A user can belong to many companies. And a company can have many users. And they're related by this. The user has company. Many to many table. So this relationship, if we're in Django, you'd have a user model that has a many to many relationship with a company or vice versa. But there's really no way of Django introspection to know this. So we're going to see what this actually produces in a second. And another thing that's terrible about this, in terms of Django, at least, is that it has two primary keys. So it has composite primary keys, which is going to be a problem for us, and we'll see why. But Django basically assumes that you have every single model. It assumes that you have one ID field that has primary key. And this doesn't fit that pattern. And then profile, just when you thought it couldn't get any worse, has a triple composite key. And there's a roll here. So roll is meant to be a foreign key to this table roll. But this is a VAR car, and the name here is supposed to match the roll in here. So it's like completely worse database design you can imagine. There can be so many problems with this. Absurd anomalies, deletion anomalies, like you name it. So that's my shitty model. And then just for fun, if we have time at the end, I'm going to go over this table because I created the worst field names possible just to see what they would produce. So the source of InspectDB, this is the source, can you, it's good size. OK, so there's two primary loops. The first loop uses connection.interspection table names. So connection.interspection is a connection-specific introspection function to get the table names. So depending on what database you're using, it'll use a different command to get back that list of table names. But then once it has that list of table names, it's agnostic. The rest of this code is agnostic to the type of database you have. So I looked at the source code for the different introspection definitions. So MySQL, Oracle, and Postgres all have them. And if you look at the documentation, it says MySQL and Postgres are pretty supposed to be first class citizens. And Oracle has the same introspection functions methods defined to introspect a database. So I didn't get a chance to test Oracle, but I don't see any reason why it wouldn't work. And I was looking online, and it seems like a lot of people have gotten to work. So maybe I can look up that later. And we can talk about that. So once you get a table name at that first primary loop, the secondary part of the loop or inside that loop gets the relationships, gets the indexes, and then it has a secondary loop that loops through all the columns. And at the end of this, I know I didn't do a good job of this screenshot. But at the end of this, it yields an output of the column name to standard out. So that's what we're going to use now. So this was a little quiz I made. These are the introspection specific commands that Django uses to get the table names. Somebody equals to show tables, select tables for Oracle. And something you'll notice about these is each of these commands is not guaranteed to come in any particular order. So show tables just gives you a list of the tables. It doesn't give you a list of the tables sorted by when they were created. It doesn't give you a list of the tables sorted by the name. And all of these are the same. So when it goes through that loop, it's basically going to get, there's just no way to guarantee what order it's in. So this is what we talked about before. We used the connection introspection to get the table names, the relationships, and the indexes, and the columns. But then we were kind of agnostic at that next layer to generate the models once we have all that information from our connection. And this is the many to many fail. Like I said, this should map with a many to many on either the user, the company field, depending. But this maps as three individual models. So let's take a look at what would happen if we did this. So Python managed up pi DB shell. So I created this in my SQL. So we'll take a look at this in my SQL. So these are the six tables we started with. And we haven't synced our database. So we don't have any of the Django specific tables. So the question is, do we want to sync our database, or do database introspection first? So database introspection looks at the database and creates a model from it. SyncDB creates, or syncs our database to the correct point that we're at right now, or whatever we have right now. So if we run our sync database first, we're going to create tables that Django needs to log in and hold our users. But then as we run and inspect database after that, those tables will also be in our database. And they will be introspective as well. And that's not really what we want, because those models are already defined somewhere else. So we're going to run inspect DB first. So like I said, it goes directly to standard out, which is not very useful. But you can take a look at it. So it tells you what to do, which is nice.  You can just read this. You rearrange out the models. You make sure that I think everyone has a primary key. And if you want, you can remove managed false. It doesn't really say what that's going to do, besides it's going to allow Django to have a lifecycle. And you're allowed to rename the models, but you're not allowed to rename the DB tables, which is like the meta option to explicitly state what the table name is to override the convention. And then there's this line, which I'm sure it won't be important. You'll have to insert the output of Django Admin SQL custom app name into your database, whatever that is. So let's go ahead and put this to. So I created a map for this. And let's see what we produce. This is the same thing, but we're just in a file now. And now we can run our sync DB. So the first problem that we're going to run into is related name collision. So let's add a related name to one of the namespace collisions. Let's see. So looking at our model, user has company user user. And by the way, MySQL Admin generated these field names, so I'm sorry that they're terrible. And I was too lazy to change them. But it has two foreign keys to user has company. And the problem with that is that the namespace will conflict, so the accessors to get the results that will be the same when it auto generates it. So added related name to one of them. And now let's try and sync DB. OK, so we can sync our database now. So all we had to do was add a related name, and it told us to do that. So that was easy enough. Here's my email if you want to send me something. All right, so we've run our sync database, and now we can run our server. So it worked now. It's running. So let's go to the Admin. Let's log in. So I added something to auto register all the models so we can look at them right away. We can look at our company and create a new company. So this is weird. There's a company ID, and I normally don't have to enter in my own primary keys. So let's look at what went wrong. And this is a common thing. The integer field has a primary key, but it's an autofield. And I know that it's an autofield because I created the data model. And company has auto increment, but I can somehow edit the auto-incremented value, which doesn't really make sense. So to fix this, we can add an autofield. All right, so that field disappears. Now it'll be auto-incremented in the background. And I'm going to create a company in my schedule. I'm going to save it just because that annoys me. Sorry for my use of lambdas. Now let's add a user. Also very annoying. So user name is going to be Chris. And my password is going to be password is taco. OK, so those were the two easy tables to map. They had one primary key. They were auto-incremented. It messed up on identifying that it's an auto increment field, but that was easy enough to fix. And even if we didn't, we could just enter a value there. The next thing that's going to come up is these composite primary keys. So we don't have a primary key listed here. So there's multiple ways to approach this. So related name, we talked about that. Do I normally have to add my primary keys? No.  So there's a way to fix this. You can drop the primary keys and keep the foreign key constraints. And you can add a new field called ID. And Django's model assumes that there is an ID field anyways. And you can make that not null primary key an auto increment. So you're adding this extra field to each table that has a composite key. And you're just reducing that composite key to this extra field now. So I did not memorize how to do that. So let's drop in the DB shell. So for the two tables that have composite keys, I'm adding a column ID into primary key auto increment. And before I did that, I dropped the primary keys that already existed, which were those composite primary keys. And I'm trying to do this quickly. And for the other table for this user has company, which is the same thing, there was some of my SQL bug that I had to get around by dropping the foreign keys. So I can re-enable those afterwards. But for the purpose of this demo, it doesn't need to be. OK, so I have a company. I have a user. And now I want to put that user in that company with that many to many relationship. Save it. Come back. And I'm going to create a role. And I know I want this role to be worker B. Now inside of my profile, if I want to create a new profile, I'm going to give it an ID. And it's going to be worker B. But I'm going to misspell B. So we wanted this role to be consistent with the roles even though there's not a foreign key relationship. And it's not going to allow us to do that right now because there's no validation on the role field. So that's not good. So we're going to check and see what we can do about that. So in our profiles, I'm going to add a validation to ensure that that happens. And I'm going to borrow most of this from here. Got to raise the validation error. So we're going to import validation error. We're going to import our roles. And if the text for the profile role does not match something that we have in our value list for the names, then we will raise a validation error. So we have one profile that's in a bad state. I'm going to add another one that's supposedly in a good state, worker B. So worker B, at first, I'm going to misspell it. So worker B is now being validated. And it says role is not found. So we can update it if we change it back to worker B, which is in our role stable. So that's a basic way to do validation. If something's messed up, you can still, you know, in Python, run some type of check. OK. And I also created a management command to kind of demonstrate what you could do. You know, this management command isn't specific to running a website. So if you just wanted to find all the places where you're interacting with your database, run a piece of code on it in Python, and find all the places where that role relationship is messed up, you can do that without text. Do not purchase. And it's called post sync. So I added my post sync, it has a handle. It tries to find bad apples. It lets you know it's doing it. It looks at all the profiles. And for every profile, it makes sure the role is in the name. So it found one bad apple, and the primary key was one. OK. So these are the two paths I talked about. So this is the one path I talked about. You can remove the primary key, add a new field named ID, and make that the primary key, and create auto increment field. And the other path that I didn't specify was that you can actually create a view and then change the dbtable name to look at that view, and then create a primary key in that view. But then it messes up your updates and inserts. So path one is what I took. And there's other ways to do this too. There's a Django app that does composite keys. I haven't tried it out. So if you guys want to take a look at that and let me know. So if we run inspectEV again, what's going to happen? It's going to generate models for all the stuff that we've already generated. It's also going to override all the code we've written. So this is only meant to be one time thing. So if you run inspectEV after syncedDB and inspectCreates models for my built-in Django models. All right. And this is a trick question. So if anyone wants to brave it, let me know. What will happen if I give this code to another developer? Does anyone know? Or anyone think they know? OK. So we have managed set to false right now. So Django won't create those tables because it's unmanaged. So if we gave this, so the answer is it depends. If they have a database that doesn't have those tables, then it's not going to create them for them. And they're going to kind of think like, what's going on here? And if they have a database that has those tables, then things will work more or less. So that's part of that SQL custom command. If you need to give this database to somebody else and you want to create those files, or if you want to take out the managed equals false part, which before we keep talking about that, I should show you, this meta option managed equals false. So if you want to take out that managed equals false, then the default value is managed equals true. So if you gave this to somebody else and you took all those out and you ran a syncedDB, for that next person, it would create these tables. And I wanted to do one last thing at the head. Oh, well, actually, you know it. And just for fun is this table I created. And as we know, every table gets mapped to a model and every column gets mapped to a field and Python. But what if the fields would conflict, or what if they would create things that are nonsensical in Django? For example, the field name pass, which is a varchar. Pass is a key word in Python. So what's going to happen? Underscore underscore is going to conflict with following foreign key relationships. So let's just take a look at what it does, just for fun. Just for fun, the fields get added. Like this underscore field gets added. And then since both of these, the underscores get removed from the next field, even though it has two underscores. And then the one underscore field gets removed. And then they just keep on adding these numbers to it so that none of the namespace is conflict. Then the number 12 as a MySQL column name is also invalid identifier in Python because it's just a number. So number underscore 12 gets added. And I think I'm out of time. Sure. So don't read code unless you have to. My name is Chris, not Victor. Come say hi. I'm a pretty friendly guy. And if you're doing something with Django that's hard, you're probably doing it wrong. So anyway, buddy, have any questions?


Thank you, Nicky. I have a power point presentation. I'll open up just to give a bit of context This research was conducted about a year ago, and I am not as familiar with the content to be able to present it without Following sort of script and outline. So I will be doing that to maintain time and Apologize for that in advance So much of the previous panels During this conference have spoken about specific strategies for economic development and industrialization in sub-Saharan Africa or they focused on market integration initiatives and my presentation focuses in this area and Specifically I analyze the impact of regional trade agreements on economic growth in sub-Saharan Africa and my case study is on ECOWAS Due to time constraints I will focus on the findings from the case study and I'll present less on the generic findings about regional trade agreements and their impact on growth so really briefly to Outline what I'll be presenting first is just introduction to the research Very briefly the theory that goes behind why these regional trade agreements are happening a Background on the rationale and drawbacks of these RTAs is what they're also called and then I get into more in-depth the case study on ECOWAS and Lastly if there's some time a bit of a discussion about what these findings mean So regional trade agreements RTAs and their outcomes for developmental purposes have puzzled economists and governments motivating a considerable literature on their supposed benefits and drawbacks At the same time the number of RTAs in sub-Saharan Africa has exploded a proliferation as you see in this map and called by the IMF and UN ECA as Africa's spaghetti bowl of RTAs and overlapping memberships between different RTAs Upon closer inspection these agreements take on various forms based on a number of variables including depth of integration The types of member countries there are reciprocal or unilateral application of trade liberalization policies And the growing number and diversity and complexity of these RTAs suggests the importance for impact assessments to analyze broadly Taking into account the context of other RTAs country-level differences and the region's position in the global economy within this context my Paper takes on a critical engagement on the theory and empirical evidence within this debate for both intra-african and north-south RTAs to apply to the case study of Ekoas the second side the economic community of West African states I Drive two main themes from this analysis first. I illustrate the methodological difficulties of impact assessments that aim to identify causal mechanisms of growth that result from RTAs in the context of these overlapping Arrangements Second it distinguishes between RTA impact on increasing trade and Increasing growth for which the literature has proved unsuccessful in substantiating the link to the ladder Really quickly regional create regional trade agreements are a policy tool To promote free trade which in turn is suggested to promote economic developments today We know I think I usually fall into the trap of beating a dead horse But I think today we've realized that these market liberalization agendas cannot be a blind endeavor and that They should be used strategically with prudent state involvement in the economy to direct a dynamic comparative advantage Not a static one that can drive National economies up the value chain. So those are just some broad critiques of the the original free trade Theories So now with these basics RTAs are a policy tool to facilitate free trade There are a number of theories and concepts used to understand the impact of RTAs on increases in trade However, assessing the aggregate impacts of RTAs It's just said that it's an it's an ambiguous impact what it really comes down to is Whether more trade was created rather than diverted as a result of an RTA being instituted Very briefly to review the rationale and the drawbacks and strengths and weaknesses for our Well, RIAs are what I are what I use as a term within Sub-Saharan Africa It's so it's a regional integration agreement and they're used this term is used because usually these are agreements within neighboring countries One of the biggest strengths of an RIA is that it does bring together a group of countries Some of which are landlocked and some which are coastal countries which give market access to the landlocked countries to build export out of their region Some of the issues though that William did already discuss are that there are behind the behind the border or non-tariff barriers to trade including infrastructure issues Which I don't need to review and Also, there are other issues That arise from the incomplete implementation of these RIAs that result from Obstructed there are obstructed by weak state capacities fears of losing state sovereignty and the complexity of states being party to multiple overlapping RIAs Lastly There has been evidence within RIAs that RIAs that are among lower income countries have Sometimes the impact of having income divergence between the higher income parties of that RA and the lower income parties of that RA and That was said to be due to lacking complementarity of factors of production My brief review of the strengths and weaknesses of RAs in sub-Saharan Africa Indicate that the linear progress process of market integration has been inefficient and or insufficient For the region while the linear model focuses on tariffs and border barriers It misses the main impediments for successful intra African trade such as behind the border issues um Unktad proposed a more holistic strategy called developmental regionalism and we've already been discussing this earlier panels today And they describe this as sequence trade liberalization Alongside conscious and planned policy actions aimed at building productive capacities of member countries and promoting industrial restructuring Including alleviating supply side constraints by using industrial policy Development corridors special economic zones and regional value chains In this way unktad supports an understanding of the concept of economic growth that I propose for my own analysis As a sustainable and inclusive growth following from structural transformation that can offer Sub-Saharan Africa a more substantive role in the global economy So therefore when I'm doing my analysis, I do not merely I Characterized gross growth as GDP figures, but I include other figures That I will be discussing later including poverty inequality export structure and inter-regional trade share I will not discuss in depth the Weaknesses and limitations and strengths of the north-south arrangements, but just know that within ECOWAS There are also north-south arrangements with the EU and the the US that are impacting how ECOWAS has growth impacts And I can get into that into the presentation of the fields of the case study findings So very briefly ECOWAS is a regional arrangement of 15 states in West Africa Initiated in 1975 to promote economic and political integration through linear integration based on the EU model While ECOWAS has not yet accomplished most of its integration goals in the treaty some progress has been made including regional conflict prevention and peace building And some describe it describe this as a free trade area that has significantly eliminated Tariff barriers and allowed for the free movement of citizens, but some people still disagree about the FTA designation for ECOWAS in terms of composition ECOWAS is politically and economically dominated by Nigeria Constituting nearly half the population and GDP of all ECOWAS states additionally ECOWAS ECOWAS's makeup is characteristically divided between landlock Sahelian countries and more human coastal countries then divided again between two sub RIAs One is francophone countries in a currency union called WAEMU with a common currency of the Sifa and another anglophone block called The West African monetary zone WAMZ They don't have a common currency within that zone yet, but that was a proposal The West African region mainly exports a limited range of agricultural commodities and most economies are characterized as a net oil Importers except for Nigeria, of course the World Bank says that this kind of makeup Exacerbates trade policy as fluctuations and oil prices on the import side are often combined with commodity price shocks on the export side Very briefly my case study methods. I did this as a disclaimer. This is not using a gravity model or regression analysis Given the definition I give to growth is being very multidimensional and comprehensive it would be it would be a Something new in the literature to be able to do a model such as those with these Definitions of growth, but what I do Use our economic econometric data over time on measures of GDP poverty inequality Export structure and share in the global economy From various sources to show how ECOWAS's countries have been able to Deliver on economic growth over the period Very quickly from the literature ECOWAS's impact on growth has always been elusive in literature and also There have been more recent articles that have shown that ECOWAS has had a impact on increases in trade and then other sites that show that increases in trade do have a Expand explanatory power on increases in GDP However, those studies don't attribute the increases in trade or GDP to ECOWAS So there are some distinctions between those findings of what I'm trying to show here Let's get this okay, so to go over the the meat of the presentation and the work that went into this paper is a statistical analysis Really briefly to frame these stats I use stats on a range of indicators to offer a deeper analysis of ECOWAS's effects on growth from the available data Four aspects of this paper's definition of growth have been quantified including GDP figures Which is a GDP per capita and GDP growth rates and then increasing role in the global economy Which I use ECOWAS's GDP as a share of world GDP And then sustainable growth via structural Transformation I use the share of exports by product grouping including higher value added products manufacturers are an example of those and then inclusive growth So I use the World Bank's poverty and inequality their variables This is graph one and as you can see it demonstrates a share of trade between ECOWAS members Shown by the inter-regional trade share and the purple dashed line So this line as you can see it goes from 1970 to 2010. It's fluctuated considerably but it has Behaved inversely with the regional GDP per capita meaning that the share of inter-regional trade increased during the 18 1980 to 2000 growth slump, but decreased after 2004 when growth in terms of GDP Increased I assume this is likely indication of the region's dependence on commodity export prices Which dominate its international trade and we're driven by this commodity supercycle Graph 2 I'm not going to review because I'm still questioning How to interpret it? Which maybe I can get some of your help on or questions a graph 3 Shows the absolute value of intra intra regional trade And I have sub-Saharan Africa in the darkest block at the bottom and on top of that is within ECOWAS And on top of that is within WAMU, which is a part of ECOWAS So focusing on ECOWAS, which is the blocks of purple This data shown in the in these bars Presents an optimistic narrative that the absolute value of intro ECOWAS trade has increased substantially in the 2000s however the percent as shown by the purple dashed line and the and with the boxes Has shown that the share or the percent of inter-regional ECOWAS trade has decreased slightly over the past 20 years This was showing that ECOWAS has not substantially facilitated regional trade Inter-regional trade At the same time this graph 4 shows that ECOWAS exports have become more entrenched in the primary commodities vis-a-vis all forms of manufactured goods And this is comparing the light purple bars for primary commodities to the small dark purple bars for manufactured goods at the top If structural transformation is a condition for growth these findings present a negative outlook But on the other hand as you can see from the dashed lines. This is breaking up these manufacturers into different levels of Value added and the highest value added under the high skill and high technology intensive manufacturers Has increased the most but this is a very small proportion of the economy. So it doesn't demonstrate a whole lot Additionally while the share of GDP from manufacturers has remained low and stable in many West African countries from 2004 to 2012 graph 5 here illustrates the Significantly higher and wide-ranging changes in the contribution from the services sector in different countries Shown in the dashed lines. This may highlight a structural transformation in countries like Ghana and Liberia driven Not by industrialization, but by informality which according to McMillan et al. 2013 can negatively affect growth due to shifting labor from high to low productivity sectors and increasing unemployment in the last section of the paper I Do case studies of eight countries and echo us On various variables of GDP per capita. Actually all the variables. I'd already discussed And so these two this is an example of one of the eight case studies This is Burkina Faso and I split the indicators into two graphs one showing the GDP per capita and And growth the growth rate and then the poverty inequality variables on the other side So when you see increases on the red graph, it's a good thing for GDP and when you see decreases on the other side It's it's they're saying that that's a good thing. It's decreasing poverty poverty head counts and inequality rates In the past two decades GDP per capita has increased substantially Along with high GDP growth rates for most echo us countries However, when any quality however when inequality variables and poverty are included in these profiles Growth has been less uniform Examples such as Nigeria and Cote d'Avore indicate increasing inequality and poverty head counts Well in Ghana and Senegal inequality levels remain stable and both the poverty head counts and depth of poverty decreased And only countries and the only countries with reductions in inequality We're also those with the lowest GDP per capita Burkina Faso, Guinea, Mali, and Niger are the examples To offer a better grasp of what these intra echo us findings mean for growth I do go into the paper. I don't have much time left anymore, and I'm going over But I do contextualize these findings within the other arrangements such as a north-south agreements Which is the everything but arms agreement with the EU moving into the EPA agreements and then the US agreements The African Growth and Opportunity Act So overall I can conclude By saying that Growth has been very elusive in the literature But regardless showing that these findings showing these findings to you today do demonstrate That the growth that I'm describing an inclusive and sustainable growth and echo us has not been achieved Regardless of echo us and so you can't necessarily blame it on the agreement or lack of implementation necessarily But there's definitely a need for a more comprehensive approach to regional integration And I think some of the suggestions we've had from the other panels of very nicely put forward some Some strategies for that. So thank you for your time and I can address any questions at the end of the panel. Thank you


Welcome back to the trade hacker mindset.  It requires The trade hacker mindset All right, so let's jump into our discussion of why I think it's okay not to trade sometimes to give you a little bit of a context why this is on my mind and why I think it might help you is the time of this recording is Friday, July 30th and Today, I just decided not to do any trading and when I say trading I'm talking specifically about day trading today every morning. We day trade we stream live to our community For the first 90 minutes of the market open from 8 30 a.m. To 10 a.m. Central time and in that time I'm calling out trades. I'm actively trading executing trades right there in front of the community and so I Love it, but today I decided not to trade now. I can't just Decide I don't feel like it because I have an obligation to my community But what I did is we still stream live, but I did not personally execute any trade So I still called out the setups. I still called out the trades, but I didn't execute any trades And there's a couple reasons why One I this week I've just I've just I've had this weird head cold which has created kind of some brain fog I have a little bit of fatigue a little bit of tiredness You know and part of that is you've got to continue to take care of yourself You got to continue to take care of your body now. I typically get enough sleep. I stay pretty active But at the same time I'm Constantly going hard meaning, you know, I'm waking up at 4 a.m. Every morning. I go work out I get ready. I'm in the office. I'm preparing for the trading day. I'm trading. I am Doing other things for navigation trading whether that's creating content courses classes Presenting doing videos and then I have kids and so, you know after I get done with all that I get to go do kids stuff, which is very active in sports and all kinds of other activities, right? So I think part of it was, you know, sometimes you just go so hard go go go And finally your body your mind is kind of like, hey, let's let's take a little break And so I think that's part of what what's going on The other reason that I didn't trade today is because in my day trading on two so today's Friday on Tuesday Wednesday and Thursday I had three losing days in a row So I had three red days in a row and when you get in a situation when you're going through a little bit of a drawdown Sometimes it's best to either just I've talked about this before just scale down your position size really small or in this case Just don't trade and so that was that was part of the decision The third reason that I didn't trade today is because I just I have a lot going on and if you have distractions outside of your trading that can impact your decision-making when you trade Sometimes it's best just not to trade and so, you know, I've got a lot of stuff going on with with navigation trading on Thursday We presented we redid our entire options basics course. So I presented that on Thursday So I was doing a lot of preparing and presented that on Thursday We were in the final stages of getting to ready to roll out our new Trading platform to our members. So we're doing a lot of stuff there So I've just got a lot of stuff going on and it kind of took me Really being self-aware and focusing on the fact that hey, I do have a lot of distractions I've always got a lot going on and I feel like I'm a very good multi-tasker and I can handle it a lot a lot of times But I think today I just I just kind of woke up and I said, you know what? I'm just I'm just not gonna trade I just am not mentally there, you know We talked about in the intro of this podcast that to have the trade hacker mindset you have to have total and complete mental and Emotional control and if you are not Laser focused if you are not dialed in and you lose that focus while you're trading it can cost you money It can cost you losing trades and so that's why I decided not to trade today You see when you're when you're trading you have to be in the flow of the market You have to be trading in the zone You have to have this mindset that you can Emotionally go with the flow of the market if you find yourself budding heads with the market or if you find yourself at odds with your trade making decision then then that may be kind of a a red flag That maybe you need to take a break or maybe you just need to sit out for a while and watch the markets and and until you get Back into the flow of the markets Most of the time I can't stand not trading right I hate when we have those long holiday weekends. I don't like long weekends I don't like holidays when the markets closed because I love trading so much I love to be active in the markets But you also have to be self-aware that if you're having a losing streak or if you don't feel good If you don't feel like trading if you have outside distractions, then it's okay Just to not trade One of the great things about the business of trading is that you have total control Over when you enter and when you exit trades, right? We can't control the market We can't control what the market does what we can control is when we enter and when we exit trades If you're somebody like me who's just absolutely obsessed with trading you're obsessed with the market It's really hard to be self-aware To to tell yourself. Hey, you know what? It just may not be the best idea to trade today And it's very rare that I ever get to that point. I I don't remember The last time I had this This this feeling where I just didn't feel focused enough to trade it just it very rarely happens But when it does and I'm you know, it's one of those things that you have to be self-aware of It's one of the it's one of those things that I want to Continue to focus and be more aware of you know every morning Before I trade I always write down and try to be very self-aware of how I'm feeling Did I sleep good last night? How is my home life? Did I get in an argument with my kids or my spouse? Am I distracted by all these other things? And so when I wrote those down this morning It was very clear to me that hey, you know what? I probably should not be trading Based on the way I'm feeling based on all these other things that I've got going on And so so making that decision not to trade while it's very difficult to do It's something that sometimes you have to do now You know, you might be thinking well, that's not a big deal for me if I don't want to trade I just don't trade it probably could be a little bit different for me because I do have an obligation to our community Right. I can't just not trade because that's what our membership. That's what our community is all about But if I can still fulfill that obligation and at the same time be self-aware enough Not to put myself in a position that's going to be detrimental to me financially from trading and placing losing trades And if I'm not mentally in the game, then that's something that has to be done from time to time Now I I imagine when I come back in on monday morning I'm going to be fired up to trade, right? I didn't trade friday I'm not going to be able to trade saturday or sunday because the market's closed when the market opens monday I'm probably going to be itching for that opening bell and excited and and can't wait to get in so I imagine that will be the case But hopefully this helps In if you ever have that feeling if you ever get on a losing streak or or you ever get in a mental framework Where you just don't feel like trading. It's okay to take the day off I think one of the other things that that works against us Why it's so hard for traders like us who are obsessed with the markets to take the day off Is because I think a lot of times you have this fomo, right? You have this fear of missing out if I don't trade today I'm going to miss out on the potential profits that I could have had and and if you have We've talked about this in a previous podcast But why I think it's a mistake to have financial goals like I want to make 10,000 a month I want to make 20,000 a month trading if you have those financial goals Then it's going to make it even more difficult for you to take the day off If you're in a mental state where you shouldn't be trading Because you're going to think that you're missing out on a day that could get you closer to that goal Remember we are all human, right? I mean you look at I mean you look at what just happened with simony biles in the olympics I mean she had so much pressure that she quit the olympic team And couldn't perform now. I'm not saying I'm going simony biles and and I don't I don't feel like I I feel like I can handle the pressure and that so I'm not I'm not trying to compare myself But at the same time I mean you see you know all these elite athletes or all these celebrities and You know if you look just at their instagram profile, you would think that they never have a bad day You would think that they never need a break you think you would think that they are Almost untouchable invincible and that's just not the case. I mean we are we're all humans We all need to be self aware Of what we are doing and and what we're what we're thinking and and how we're performing and if if you need to Step away and like I said, this is a great thing about trading is you are in total control You don't have the Obligation to be trading every single day. So if you need to take a break, I hope you do I hope this was helpful Just it was on my mind So I wanted to share it with you all so if you've ever found yourself In this same kind of state of mind that you would understand that that everybody goes through it And it's part of life. It's part of trading and you can only do what you can do And the great thing about navigation trading is that you don't have to do it alone We have a community of traders Interacting on a daily basis that are helping each other out with not only the mindset stuff But sharing trade ideas with the sole purpose of helping each other become better traders So if you haven't checked it out go to community that navigation trading calm It's free to join. We look forward to seeing you on the inside or we'll see you in the next episode


What is the ideal Christian nation? You can't just cite Augustine here, cherry picking the ones that most match this liberal secular modernist view that you advocate on your channel. Show us within the Bible, what are the principles of just governance and this ideal Christian nation? There's no concept. It's Muslims who regard this as a problem. They think of their prophet as coming to take over the world, whereas Jesus said his kingdom is not of this world. Jesus isn't here to establish the ideal Christian nation. Jesus is here to build the church.  Muslims, we have a solution. I really hope Christians can see the wisdom of the Sharia and Islamic law at least through this lens.


Thanks for checking out this video. So this is another one of my haul videos if you guys saw the last one It was giallo giallo blu-rays and this one is basically giallo blu-ray part 2 Which I'm very excited about so This is actually from Best Buy. I actually try usually not to purchase from bigger stores like that I usually like to go with something like a Severin or a vinegar syndrome. We're like a Zavi even is small or that's where the ones from we're from last time Or you know like diabolic DVD stuff like that Just because I'd like to give my money to smaller operations, but every now and then if I'm looking for something specific I have to go a little bit larger. So it just happens. So be grudgingly a bit. I purchased these from Best Buy I didn't know that they actually have a pretty good giallo blu-ray selection there So if people are really looking for some certain giallo titles check out Best Buy So I have six here. I'm gonna go over the first three will be ones I've not yet seen but I have read are quite good as far as giallo goes So I definitely wanted to see them so I just purchased them And then the last three are ones that I've seen and there are reviews for them on my channel now Also on that note I have an entire playlist on my channel that is all giallo film reviews if you are interested in that Hopefully you are because I would love to get nerdy with you about it comment on those if you like them all that jazz But I'm not going to read the backs of these because especially for the ones that I haven't seen yet I don't want to know anything when I go into giallo. I want to know nothing about the story. That's how I experienced these films So yeah, anyway, so the first one is by Francesco Barilli and it is the perfume of the lady in black This one actually is the only one with an actual slip cover and actually I Think it's of all the giallo blue rays. I have not a single one has a slip cover except this one So that was interesting I'm excited about this one This is on the list of you know ones that you should definitely see if you're into giallo So I'm excited and I forget what the website is But I had just kind of like googled best giallo films or something like that And it was some sort of site that was talking about kind of the most important giallo films throughout history So it hits like the first giallo film it hits, you know All the phases and like the best giallo films throughout each phase of of the giallo subgenre Which I believe ended in like 1974 I think is when all the Kind of hype about that subgenre dried up in Italy and abroad So yeah, so this one will be interesting to watch and when I have watched it There will be a review on my channel The next one is another one that I had heard is kind of a must-see and that is umberto Lensies seven blood stained orchids have not seen this one yet either. I love that cover art by the way It looks super super cool really interesting. Plus. I love the name a lot of giallo films I just love the names of them They're a bit long and that's one of the things that my wife finds funny She's like all those titles are so weird and long And the next one is actually the longest and she knows about that title. So she's just like random So anyway excited about this one Once again, there will be a review on my channel after I've watched it and This is the last of the ones I have not seen yet And like I said, this is the one with the longest title now This is my Sergio Martino and if you haven't been checking out my reviews and my videos lately I've been really digging the way Sergio Martino Martino has done some of his films. So I'm getting more into that. So this is Your vice is a locked room and only I have the key now. This is an arrow release obviously Which Best Buy actually has a decent amount of arrow stuff, but if you're looking for other arrow stuff Zavi has it Who else diabolic DVD has some? Vinegar syndrome actually has some arrow So just so you know, but yeah, that's you know, not the best cover art. It's a little vague looking but Once again, it was on that list of kind of the important ones and I'm excited to check this one out So yeah, again once I watch it, there will be a review now Let's get to the three that I already have reviews for on my channel and It just so happens They're all from the same director and this is a director that I got into recently thanks to shutter Because shutter put on a ton of their films and they have a bunch of films that go over into the giallo genre So our subgenre so yeah, so here we have Evil eye also known as the girl who knew too much and that is by Mario Bava Bava, I love the way he directs the cinematography all that stuff Amazing visuals. I feel like Bava was really ahead of his time for when he was alive and doing film I don't know if anyone else feels that way put some comments down here But this is considered to be the very first giallo film ever made it is in black and white Ooh, actually has this one been colorized? I hope not. I want it in black and white or maybe I have options because on the back It's kind of showing It in color, but it looks like it's actually a drawn picture.  It looks stunning. I've seen this film. It's very good I think it might still be on shutter when this is going up But yeah excited about this one. I prefer the title. I don't like evil eyes the title I like the girl who knew too much which is actually printed down here, so all right, so that's and then Based off what I said people would know the next film is also mario bava and that is a bay of blood This one is considered to be the film that inspired friday the 13th and that entire franchise In fact, some of the kills from this film were lifted directly from it and put into some of the Friday the 13th films if you watch this and then you watch the friday the 13th You'll see or if you have watched it and you know enough about it You'll see this and you'll be like, uh, yep I see the influences there and the lifted kills too. There's one in particular That's very easy to figure out that it was taken directly from it. So Watch this movie a few times in my life three or four times at this point So I figure I got to own it. It looks great. It's mario bava. I really enjoy it. It's fun It is a lot of fun. So glad to have that and the last one is mario bava and this one I think this may have been The first giallo film I ever saw potentially and it's it's definitely the first giallo movie review I did on my channel So that one's a little bit disconnected from the other ones if you check it out But this one is uh blood and black lace By mario bava. I remember really liking this. It's been a while since I've seen it So I really do need to rewatch it and just looking at it. I'm like I kind of feel like maybe I'll watch it tonight Actually, I do love how with this cover it's all in yellow because that's kind of a callback to where giallo started from giallo Literally means yellow in italian and it refers to the yellow covers that they would have on the books That I had the giallo stories So that was I mean the movies were based off of all these books that were created because giallo was a book genre Or book subgenre before it was filmed So whenever in giallo films you see a lot of references to to yellow or a lot of the color yellow popping up Uh, the case of the bloody iris actually does it a lot. That is a nod to the origins of giallo So this looks really cool. Um I'm so excited to watch these. So anyway, that's it. That's all six of them. That's not the end either I have some other types of movies coming in on blu-ray that I will be doing haul videos for But I also have some more giallo coming in now I think I might wait until the rest of it comes in and do that all in one video But I'll take a look, um If it's if it would be that I'd like break it up and it would be like, you know Three and three then I'm not going to do that. I would just do six or You know, I'll figure it out. But there there's at least one more giallo related haul video coming up and I'm just excited to own these and to get to the ones that I haven't seen yet But I would love to talk to you about giallo. Go ahead and put some comments down here. What are your favorite ones? What am I missing thus far that you think this is a must? If you have not seen this giallo This is a must. I love to hear that stuff from you guys and like I said, whatever your favorites are So let's get nerdy, but do me a quick favor hit that Excuse me hit that subscribe button for me if you can I get so excited about this.  I like it. Here you go, buddy Yeah, so subscribe and then if you could also hit the notification bell Because then you'll know whenever I'm putting up a new video and it helps that when a video goes up People watch it give the thumbs up to it and everything helps it gain traction. But you know regardless Thank you very much for taking your time to watch this and until next time keep it brutal


Humanity and technology are at a turning point. During the pandemic, the world has seen what digital technologies can do and how they can transform our future. Emerging digital technologies in fields from 5G and the Internet of Things to AI and cloud computing are pushing the boundaries of what's possible. Like other breakthrough technologies before them, there will have a profound impact on our future and that of our planet. Great possibilities come with great reasonabilities. Close to 3 billion people are still unconnected with the majority of them living in developing countries, especially in rural areas. Gender, generational, and affordability gaps also remain. Equitable access to digital technologies isn't just a moral responsibility. It's essential for global prosperity and sustainability. This includes the more than 1 billion people aged 60 years or older at the center of this year's celebration of World Telecommunication and Information Society Day. This group of the population, which is growing larger and larger, has greatly contributed to the social and economic achievement of our time. With time passing, they are now facing new opportunities and challenges that deserve our care and help. Observed on 17 May, WTISD marks the founding of ITU. We are focusing our efforts this year on digital technologies for older persons and healthy aging. As part of ITU's ongoing efforts to support the decade of health aging launched by the World Health Organization and the United Nations. I'm calling on you to share with us what has worked and what else can be done to help older persons become active participants in and valuable contributors to the digital world. With WTSA, WTDC, and PP 2022 all taking place this year, 2022 represents an unprecedented opportunity to break cycles of exclusion and accelerate digital transformation for all. Let's make this year a count. Let's do it for the sake of humanity and the sake of the world. I sincerely wish all senior citizens a happy, healthy life empowered by the benefits of digital technologies. Thank you.


A civil rights organisation under the ages of policy and legal advocacy centre on Monday hinted that the delay by President Mahmoud Buhari to sign the Electoral Act Amendment Bill 2021 could be a major threat to the 2023 elections. The organisation also expressed fears that except measures we are taking to stem the tide of stifling civil space, Nigeria may be returning to the dark days of military regime. The Executive Director of PLAC and Human Rights activist Clement Warkwa raised these views in an interview with journalists. It was during a dialogue session on closing civil space and its effect on advocacy and freedom to participate in governance. you