You're tuned into the COVID-19 Community Report here on KDRT 95.7 FM in Davis, California. I'm Audemars Labbe Renaud and today is Tuesday, May 19th. We're sharing local news and resources focusing on what's impacting Davis and nearby cities in Yolo County during the COVID-19 pandemic. The show airs live at noon on Tuesdays and Fridays and repeats at 5 p.m. both days and at noon on Sundays. You can also listen online at kdrt.org. My guests today are Anne-Marie Flynn with Mutual Housing California and Gina DeLyden of Yolo First 5 and we will get to those interviews in just a few minutes. We are expected to surpass 100,000 deaths nationwide from the COVID-19 virus and it's going to be very interesting to watch numbers spike even as counties and states are reopening I'm willing to bet we'll have a clearer idea of that impact in roughly two weeks. So if it is within your ability to not mingle to remain sheltered in place as much as possible please do that and continue with wearing a mask and washing your hands and practicing distancing and this does remain the standing public health order until further notice. I have been getting questions about what's happening in the Lake Berryessa area so here are some updates and this information is largely from LakeBerryessaNews.com online. On May 16th Lake Berryessa reopened access to its boat launches located at Markley Cove, Pleasure Cove, Steel Canyon, Spanish Flat and Puda Canyon Recreation Areas. Cable Cove will reopen today May 19th and boaters will be required to have boats inspected for invasive species before launching. And yesterday May 18th access was opened for self-contained RV only camping at Pleasure Cove, Steel Canyon, Spanish Flat and Puda Canyon Recreation Areas. The following facilities and activities remain closed until further notice. Oak Shores Day Use Area, Smiddle Creek Day Use Area, the Administrative Office and Visitor Center and Tent Camping and Lodging is not yet allowed because while RVs have self-contained bathrooms, porta-potties are not on the approved for use list yet. You can call your favorite campground for details. You can also get more information by calling the field office and do-for-point visitor center that's on the Napa side area code<PHONE_NUMBER> and in case you were curious as of this weekend the lake level dropped to 430.6 feet which is about 9.5 feet below the glory hole and light rain brought the total for the season at Monticello down to just under 11 inches. Interestingly that's the lowest level in more than 22 years so I have to wonder what that says about our coming summer and fall. Elsewhere in Yolo County the following parks have reopened Cache Creek Regional Parks Upper and Lower Sites as well as Camp Haswell, Cape Pay Open Space Park, Esparto Community Park, Tulimem Park on the Lawn and Walking Path only, Valley Vista Regional Park, Vernon Nichols Park and Wild Wings Park. The opening of these parks and the ability to keep them open is, you guessed it, dependent on visitors following social distancing requirements and wearing a face covering when coming within six feet of other visitors. Please note all picnic areas, tables, playground equipment and sports courts remain closed for the foreseeable future. On another note Arts Alliance Davis meets via Zoom this Thursday, May 21st at 10 a.m. You can get the Zoom link at Arts Alliance Davis on Facebook or you can email me info at davismedia.org. I chair this group of artists and arts advocates and let me tell you this sector has been hard hit without the ability to run programs, services and classes through facilities and without the income from exhibitions, concerts and special events, etc. Most of us have spent the last two weeks pivoting, retooling, etc. and it's left little time to actually connect and learn from each other. So this meeting is important for that reason. You can also get more info at artsalliance.org. Let's take a minute for music before our first call and we'll be right back. The mission of Mutual Housing California is to develop, operate and advocate for sustainable housing that also builds strong communities through resident participation and leadership development. And here to tell us more is Ann-Marie Flynn, Community Development Officer for the organization. Hey there Ann-Marie, how are you? I'm great, how are you? I'm good. It's good to hear your voice. You too. Nice to be on with you. So I wanted to talk to you, there are a number of organizations devoted to providing housing for lower income individuals and families, but I've always felt Mutual Housing puts a really interesting spin on that. So let's start in kind of broad strokes with what you do. So we do feel like we have a little bit of a unique approach to our housing. It's reflected in our mission actually, I know you just read our mission and it has those two parts. And one is about the housing, but the second part is about building strong communities and the ways that we do that, right, and it says in our mission through resident engagement and leadership development. And those are the pieces that I feel like really differentiate us, is our very strong dedication to building community both on site at our Mutual Housing communities, but also the surrounding community. So we're really working with our residents to foster a sense of connection and to have people develop a sense of belonging where they live and in their broader community. And then work with them on what their own skills are that they already have and their strengths and their hopes and dreams and figure out how they can elevate those and strengthen them and bring them to the larger community to impact change. So it's going to be great for themselves, but also for other people who are their friends and neighbors. Well, it sounds like they really have a voice in how these communities develop, too. I mean, I know this is a fallacy, at least here in Yolo County. I interviewed Lisa Baker from the Housing Authority recently, and the fallacy is that low income housing is poor housing. It's poorly constructed, it's poorly maintained, and it's not well developed. And I don't think that's the case here in Yolo County, certainly. Definitely not. So what kinds of communities, because I know there are different types, does Mutual Housing California operate? Yeah, so we have over our whole portfolio right now, we have 19 housing communities, and those are in Sacramento and Yolo County. But five of them are actually in Davis, and one is in Woodland, and then the remainder are in Sacramento County. Our housing in Davis are five different communities. They're very in size from about 35 units up to 69, I think it's the largest one. And they're all family housing, right? So they're primarily families, some individuals, but a lot of families who are just like the rest of our community, but have much lower income, less revenue, and are finding it harder to find a place that they can afford to live in our pretty expensive housing in Davis. And then the community in Woodland is pretty special actually. It is a community that's specifically for agricultural workers. So there's a hundred apartments and townhomes. All of our housing is rental housing. So in Woodland we have a hundred apartment and townhomes, and it's a hundred percent agricultural worker housing. It's actually the only housing in all of Yolo County that's permanent housing for agricultural workers, which is pretty amazing considering our big agricultural emphasis in this area. That is remarkable actually, and I didn't know that. And this is why I like interviewing people because I learn something new every day. So with all this, you know, relationship building and community building that Mutual Housing does. How have you had to use a tired word now, pivot during the pandemic? How have you had to adjust and how are you making that work? Yeah. Well, just like everyone, of course, we're having to make pretty big adjustments to adapt to shelter-in-place guidelines and social distancing, but my team in particular is a very relationship-based team. I work with 16 staff that are out in the communities all the time in normal times working with people, meeting with them, holding community events, planning things, and having one-to-one conversations. So now that they're working from home, we've had to really switch it up. It's amazing both what our staff has been able to do and our residents in terms of adapting to this new normal of Zoom meetings, phone calls, texts, and so some of the big things that we've done are over the last month, we're really focusing on what do people most need, so two things that have come out big for us, well, three. One is that people really need food. That's one thing that we're hearing from our residents over and over again. We've been super fortunate to be able to partner with the Food Bank in Yolo County, which was a partner before this crisis and is stepping up even bigger, as we all know in Yolo County, and the mutual housing's been able to bring food to the doorsteps of our residents in our community. So it's delivered by the Food Bank, and then we take it and package it up and bag it and then make appointments with families and actually drop it off on their doorstep. So that's a pretty amazing thing that we're doing, and we're doing that throughout Sacramento as well. So in the month of May, we're doing 900 doorstop deliveries in the month of May with food. So that's one piece. The other piece that we're focusing on is like resource and referral. So if you go on our website, right on that website, there's a link there, and we keep it updated all the time for our residents of live links to resources out in the community that they can get to help them, right? So we're kind of doing that work of gathering resources together in one place for them, and we shared electronically, but we're also out there putting flyers and information on their doors in a no contact way so that we can connect with them directly. And then the third piece that's really actually the most important for me is that we're just doing that human to human connection. So we've had to switch up and do that by phone and zoom and text, but we're continuing to call our residents on a regular basis and check in with them and let them know, you know, we're here for you. What do you need? Sometimes it's just being able to hear another person and have a live voice that says, yeah, I care about you and how can I help you? Yeah, isolation has been real for so many during this process. And as I've talked to a lot of nonprofits, I've heard that over and over again. We want to make sure people don't feel isolated. They don't feel alone. We want to be able to gauge what they need. So. And of course, as a housing organization, we're just making sure that people can stay housed during this time. It's pretty precarious for people who are very low income to be able to figure out how are you going to stay in your housing and and pay your rent. And so we're busy, you know, making those arrangements with people who are not able to pay their rent at this time, really focusing on creating a sense of continuing that sense of belonging and community, but calm and information sharing and support for people that they don't feel that their housing and their families are at risk. Yeah. And of course, they have some renters have some protection. You know, they can't be evicted right now. But that still doesn't help them get caught up with the bills or, you know, pay the bills that come do later. So it doesn't. And I think it's a lot about tone and communication as well. Like saying that there's an addiction moratorium is one thing in all that legal language, but having explained to you, for example, in a language that you can understand if your language is in English, having it explained to you in a way that makes sense to you and then actually having someone broker that those arrangements with you in a caring and supportive way makes, I think, all the difference. Right. I wanted to touch make sure we touch on one other thing as I was preparing and reading on the website. You know, it's it's one thing to say that, OK, we're an organization that adds to the local supply of safe and affordable housing. But I think you folks are really going the extra distance. I'm reading a lot about, you know, green certification and development of really forward looking communities. Can can you speak to that aspect? I can. But before I do, what I don't want to leave off is that we're actually adding to the supply of housing right now, even during this time of crisis, and I don't want to let that go because we have a goal to double the size of our housing portfolio over the next five years. And we're actually able to start construction this fall on two new housing communities and one of them is in Davis. Excellent. So that's going to be 38 new units of housing that we're breaking ground on in Davis this fall. So that's following through on this really real commitment that we have to increasing housing supply. And you're right in all of our communities, we have this really strong focus on green and sustainable housing. Our community in Woodland was the first zero net energy rental housing community in the nation. That's right. Certified. Yeah, in the nation, not just affordable, but of all rental housing, it was the first certified zero net energy. And then what we're doing is we build that into all of our housing communities. And then we're educating our residents about how they can incorporate green practices in the things that they're doing while they're living on site. All everything from our landscapes to our paint, our materials, our water heaters, our appliances are all putting that green, green and sustainable land on everything that we add into a housing community. That's that's very Yolo County in a way. I know you operate in Sacramento County as well, too, but it's really good to hear. All right. So where can people get more info, both from the perspective if they just want to check out your organization and see the work you do and also if there's someone who needs, you know, might be in need of housing. Right. Couple places. Our website is www.mutualhousing.com. And that is a very good place to go for starters. We also are on social media, both Facebook, LinkedIn, Twitter and Instagram. So you can check out Mutual Housing on all of those sites and give lots of information and stories. And on the website itself, you can see there's a link that says find housing and there's actually information on there about how to get in touch with our property managers and actually apply for housing. And then there's also a link on there that says the mutual blog and has our blog posts regularly and there's some really both informative, interesting, touching and heartwarming stories and powerful stories of things that are going on in our organization. So both of the two places that I would really send people. Excellent. Well, thanks so much for making time to talk with us. I enjoyed learning more about Mutual Housing, California. Great. Thanks for having me, Otto. Take good care. Thanks. Bye. That was Anne Marie Flynn, Community Development Officer for Mutual Housing, California, and we will be back with our second interview in just a minute. All right. First five YOLOs mission is to assist our community to raise children who are healthy, safe and ready to learn, ensuring that public resources are effectively used and that all community voices are heard. Joining us now is First Five's Executive Director, Gina Delight. And hi there, Gina. Hi, Autumn. Thank you for having me. You bet. Great to hear from you. So your organization runs a whole lot of programs geared at meeting those objectives I just read off, raising children who are healthy, safe and ready to learn. And you do so in partnership with quite a number of other organizations. Could you highlight just a few of your key projects for us? Sure. Can I just start by saying that First Five YOLO is itself a funder investing in programs that we're about to talk about. And we're also sort of the program architect in many cases. And we work with our direct service partners who implement our programs on a continual basis for quality improvement and evaluation and really in a very collaborative way. OK. So our two largest programs right now are really systems change initiatives seeking to transform the system for vulnerable families with very young children, prenatal to five. And we're thinking about, you know, how does the system of care, whether it's health or safety or early learning and hope? And those usually all interact with each other, right? They intersect for families. How do they work for our families? Are there ways that we can better identify families and children who need support early because that's when support is most effective? And then how do we open access to programs that are best suited to those families and children? So our two largest systems initiatives are called the first one is called the Child Project Road to Resilience, or we call it for short, R2R. And that's a child safety and wellness program that identifies families who are at risk or in need very early. Many of them identified at the Perinatal Clinics at Communicare. There are lead partner on that project and then high intensity home visiting services are offered. And those are offered through behavioral health at Communicare and also through Yolo County Children's Alliance and their Healthy Families America program. And then Yolo Crisis Nursery is also a partner on that project supplying a different type of specialty home visiting called Attachment Biobehavioral Ketchup or ABC. And so that is our countywide project of about a million dollars annually, co-funded by First 5 YOLO and by Office of Child Abuse Prevention at the state. And then our second largest project is called Help Me Grow. And it is an early childhood mental health program that also seeks early identification and intervention when a child shows the need for developmental support or when mothers show a need for maternal health support. Right. And when you when you say at risk, those are the kinds of things you're talking about, right? Identifying people who are at risk for either, you know, physical health issues, mental health issues. And I would imagine behavioral issues, hunger, all of that factor in. Exactly. Right. Exactly. And we use in the child project, we're using some administrative data to help sort of highlight where we might want to engage with families. And that is based on a predictive risk model that was developed by Children's Data Network. But remembering, of course, that a model is only predictive, it's certainly not deterministic. And I think really the idea, Autumn, is to identify families who might appreciate some additional support and then all services are purely voluntary. So it's about finding the families, engaging with them and then being able to offer the services. And then when we see that a particular program is having a very positive impact, then we start to think with our partner agencies and other local governments, sometimes private funders, to think about how do we bring a program that works or services that work to scale so that families who require those services are able to benefit. Right. So the question I'm asking everyone is during the pandemic, how have you, and I think what I'm hearing from you is that it's really your funded partners and I'll use the Northern California Children's Therapy Center as an example. That's one of your funded partnerships and help me grow YOLO. How have they had to pivot to move from doing things in, you know, in proximity with people to doing things remotely? Yes. Well, this is a great example because Children's Therapy Center was able to move very quickly to virtual platforms, to, you know, telephonic touch with clients and they have developed some playgroups, developmental playgroups, they're actually called, that are on a virtual platform and they are attended because so many people can log on or join upwards of 150 I think they had in one of their last classes and they have music therapy groups and other choices and those are available to all families, whether or not the child needs additional developmental support, but then they are linked to help me grow to talk about the schedule that would be most appropriate for developmental screening for a young child. Right. And there are several other screens, including for the parents and a home safety check and that sort of thing. So help me grow has done a really good job of moving very quickly as we really have all of our partners. All but one first slide funded program is still fully functional, operating in ways where, for instance, home visitors or coaches of parenting classes are in touch with their clients via a numerous platforms, we're trying to match the client with what works for them and doing drops of supplies at their home in no contact way. And we're actually seeing, interestingly enough, an increase in the number of families who are willing to engage in services like home visiting right now. And we think some of it has to do with the need for support and not wanting to be isolated with a very, very young child, in many cases, a brand new incident. Yeah. And some of it just may have to do with the ease of connecting online and the demographic that seems to be as you know, new families who seem to be much more comfortable using virtual platform. Yeah, not everyone has access to, you know, broadband or those or computers or whatever, but it's great that so many do and can avail and goodness we, you know, parenting a child through the first five years is hard enough without a pandemic going on or isolation. So it's wonderful that you provide so many resources. Where can people get more info about your organization? Definitely go to our website at www.firstfiveyellow.org. Say we all of our phone numbers are working and I have to say, though we're definitely always concerned about access and who may have a personal computer, especially now that everyone is mostly at home, we have found that a lot of our young parents or new parents do have cell phones. Yeah. And so that website is mobile friendly. Great. That's a good reminder. And access from a phone as well and all of our phone numbers are working. And then of course, if they, you know, if they knew of a particular partner that they wanted to reach, they could reach out to that partner as well. But all of the information about the program is on the first five websites. Thanks so much for coming on calling in and sharing a little bit about what you do. It's important work. I appreciate it.


And in my role as special rapporteur, I have witnessed this firsthand Indigenous peoples from Fiji to Norway, whose lives and livelihoods are being disrupted by climate change and biodiversity laws. There is one clear path forward, which is to adopt a rights-based approach to all climate action and all biodiversity conservation actions. This has been proven scientifically to be the most efficient, effective and equitable way forward. And so I urge all nations in the lead up to COP15 and COP26 to ensure that human rights are at the heart of climate action and biodiversity conservation. Thank you very much.


What's up everybody once again is brand man Sean and this video is brought to you by brandmannetwork.com because I signed myself and as you can see I got a very special guest with me you guys some of y'all might remember Jio he's an artist also he's a teacher and we'll talk about how the fact that he's able to build and grow his artist career while he's teaching but you might remember him from the A wall United Masters talk that we had in the exclusive space of brandmannetwork.com go check that out if y'all haven't missed he had a lot of great insights Jio's just definitely a dope artist but still a thinker and thinking his way through the game and look here he is we're going to talk about him blowing up on TikTok because you guys have heard that you need to be on TikTok he's one of the people who've actually turned that knowledge into not just a motivational moment but took real action over a period of time and seen a lot of results currently he has what 61k followers on TikTok and counting and that's been in a pretty short period of time professionally considered to Instagram so let's let's go ahead and get to it man like and let's start here Jio where did you where did you know not where when did you first decide look i'm gonna go ahead and try this TikTok thing okay so um i first decided like end of august i actually um i had an idea i wanted to but i think that was around the time you posted the video on um on like six tips on being on TikTok like i kind of had an idea i wanted to do it but i didn't know how and those videos were just like crucially like genius and i love them because i watched all five of those videos so that that actually helped me like okay this i'm gonna tackle this um so i watched those and watched a couple tutorials and then being in a high school class at the time at the end of august um school year just started and a lot of some of my students were talking about TikTok but not like everybody and uh i just threw it out like jokingly like oh should i hop on TikTok and everyone's like oh yeah you should know you wouldn't like you know like everybody like doing that so um yeah i was just like you know it like watch the videos i was like okay so this is how i'm gonna tackle this so i actually spent my first three days just watching TikToks like watching people post so i can know like okay let me do my research what's actually trending what are people doing here and then i posted my first video and i only had like two followers because i was telling instagram like oh come follow my my TikTok nobody was coming nobody was coming so nobody's coming i had two followers and i had 10k on instagram at the time so i was like dang nobody nobody wants to go to TikTok huh so with two followers my first video got 800 views in the first day so um it was just it literally showed like and i think it was the power of like the students just being like oh my gosh my teacher just posted a TikTok and they're all sharing it so shares are yeah shares are a crucial thing on TikTok so yeah definitely man i mean in that that whole environment i always tell people because there was this one profile that i started on TikTok and literally i was just trying to figure out how to get the thing working and get it to record so by mistake i just recorded like the ceiling light and i was trying to figure out how to leave it couldn't figure out how to leave it and that got 500 views and like three three likes i'm like yeah i don't know i do what happens yeah yeah exactly yeah so the funny thing is like those um those videos of just like effortless like clout was all of like august september and recently in the most recently they got rid of something that's called share other cancel which is something that all TikTokers kind of became aware of so share other cancel was a hack that like i guess these middle schoolers figured out that if you click share go to other and go to cancel it would read as a share so people could do it 10 times and it'll think it's sharing it so because of this exactly so anybody could get clout and this was like an old thing so literally all you have to do is say like yo share the cancel or even like what actually still works is when people say oh slow-mo this on snapchat or do this because it reads as a share whenever you do that or like ashley sharing so like it used to just be like people could just tell sad stories like they can just go on there like hey i just my dog died um share other cancel so i could feel happier or like hey this like literally like it was just that crazy like august was crazy like you'll see like 30 000 follows and 60 000 likes off that like it's crazy so literally like like people would just be like oh this is the person that has the most clout in my high school help me out guys i want to beat them that's literally a bunch of videos that's all i saw i've seen some videos where it has been like yo that's it like they just yeah they didn't even really try but somehow it's on my for you page exactly yeah yeah so that that recently just ended so um like i've i've been helping some people get on tiktok as well because i got 10 k followers in my first two weeks and then i got 60 k or 61 k now and it's been a month and three weeks so um i've been helping people i've helped a friend get to my friend david he has 5000 in three weeks and um yeah there's still ways to work around it now that there is no share of the cancel you can't just ask for it so um some people don't realize that share of the cancel doesn't work anymore so they're trying to help you out because people are like oh this is how i support you i'll like it and share the cancel i don't need to actually share it but now it's now you actually have to share it so it gets that read and it really does you realize that it didn't work by the way um people started posting and you started seeing it like people started being like oh share of the cancel's gone and i noticed like it was right after an update so i'm assuming that that was what they did they got rid of the act and then you could yeah you could also check the analytics and when you share the cancel it'll show you like if your shares are going up and they don't go up anymore so got you yeah man that's uh the the beginning of new social media platforms they're full of little bugs like that right yeah because you're bound to when it's not completely evolved and mature right yeah exactly so my second video i used the bug i was just like i said i deleted the video but i was like hey my students just told me a trick it's called the gfo tt and i was like what's that and it's like the get famous on tiktok all you got to do is hit share of the cancel and something crazy happens and i ended the video so that way people would just hit share of the cancel that one got 14 000 views on my second video so i was like all right i'm already off the bat like i'm hitting this hard so then it became like okay instead of just trying to like cheese and beg for followers like i need to make content that is shareable that was like the crucial thing like not just content that's cool or or i like this or this is like slightly funny it like it needs to hit emotions like hard be funny like hard or be sad really hard or just like very intellectual something that's gonna make you want to share so that's how i approach like my videos now like what is this shareable like would someone want to share this with someone random want to share this not just like my family or whatever with someone random want to share this when they see this and that's how i create videos now and that's how i hit the for you page and get viral so dope dope what was it like i mean obviously you did play with a few things when you first got on you used the bug and and things like that but your first experience being on the platform was it kind of intimidating was it weird yeah at first it was like okay wow there's a lot of high schoolers i saw some people my age some people older because i'm uh mid 20s 25 millennial so like i saw people my age a lot of people older a lot of people younger howie mendel is already on there um but there wasn't a lot of yeah so there wasn't a lot of celebrities but howie is on there um he was definitely probably part of like you know tiktok's like deal when they get a lot of celebrities on there so but uh yeah so i was like i was on there and then many people know like i'm friends with like the professor so like i was talking to him about it and uh he was like yeah this looks like it's going every gary v's all like yeah everybody hop on hop on so i was like okay i feel like i'm a little early still so uh it was intimidating and then after watching your videos i actually really felt confident like oh i know exactly what i'm gonna do like so not even gonna lie it's like and it's not it's not a plug i'm telling you guys like you did not tell me to say that like real like i actually um everybody that like comes and asks me because literally i posted one day i said wow i post on my instagram i said wow thank you guys for 30k on tiktok this is crazy the next day i had 45 thousand and literally after that like i got like five six texts from actual friends like hey i'm serious now can you help me out and it's like some people wanted to listen some people were just like oh i'm not sure but first thing i did was send your video it's like i'm like start off with this and if you can't even watch these and have the time to redo a little research like i'm not gonna waste my time giving me a lot of energy you know so yeah yeah i know we're serious yeah and of course that's definitely attracting people once they see you moving they're like okay hold up hold up hold up why exactly exactly there's a lot of people there's a lot of people posting they're like yeah i'm doing this i'm posting every day because gary v says or whatever like i'm doing this i'm tiktok and they've had a tiktok longer than me and i'm like well you got to post content that's shareable it's not just about being consistent consistency is important but consistent and shareable is even more important let's go deeper into that for a second because man i've i've had people that listened to me just not even see even seen the videos just like yo i say go get on tiktok and then when i say that they'll be like well i tried maybe even before i told them and they'll be like yeah you know i posted some videos and they didn't really do anything i i couldn't really fill it out and i'm like what'd you post and they're like oh yeah i post the promo for my video i'm like bruh you can't start there you can't you just yeah that's actually crucial so when the first thing i do when i try to help people out stop posting instagram stuff stop posting youtube stuff on tiktok each entire app has its own entity make content for instagram make content for youtube make content for tiktok a lot of people come to tiktok like oh i know what i'm gonna know what i'm gonna post like and you haven't done those three days of research at all like i was watching the app i was seeing what was trending i was only liking stuff i liked so that only more trending stuff will come up and see like okay this is how people shoot this how people direct themselves this is how things will look on tiktok that way i can match that look because first thing i did when i did hop on after those first two videos i have three tanks of videos and actually they're still up where i posted just like my old covers from youtube and instagram i literally just shared the same cover on there and it's not full screen so you know it has a full screen format and have like these little box videos in there and those didn't do well i mean people were commenting and stuff and like oh wow these are good songs but it's like it wasn't viral material at all and then right after i hit it with the video like hey i was literally in my classroom during my free period i usually do this during my free period if i get one now i was just like hey um i'm a substitute teacher i actually didn't say words i wrote this all out on the screen like i'm a substitute teacher and i'm stuck in this classroom help get me out i was like i'm actually making music like go check it out i kid you not that got to like 50 000 views and then a bunch of people were saying i'm i checking out your spotify and then that triggered a spotify's algorithm and i went from like 4 000 monthly listeners to 7 000 monthly listeners like that and it was like oh my gosh like it was crazy so i'm gonna say this right here if anybody is listening it's actually not alarming it's amazing to me when it comes to tiktok it's the best platform i've seen in a long time in terms of converting people from tiktok to another platform it's hard to get people to go from instagram to youtube instagram to spotify even if you're running the ad yeah like people will go to your youtube page from tiktok they'll go to your instagram from tiktok it will go to your your spotify whatever it's it's crazy it's a different space it's directly there you could put your instagram your youtube i honestly just put my instagram because if you put your youtube and instagram it just has a youtube logo over it and people have to tap it so i just put the instagram that's like my own thing just so people can go there and i'm and also i'm not consistent on youtube right now i'm gonna get back into it probably really soon so um but yeah i just did that and spotify i don't even have a link people just went and searched me up and people were commenting like what's this username it's like oh it's the same as his his ad like just look like they're all helping each other out to find my music and like we're gonna help him out that's how it's a weird space man and look people are invested into yeah like especially middle schoolers like middle schoolers they have not seen anything like especially because all the millennials are hesitant right this is all gen z right now so gen z's on there and all the middle schoolers are just like oh my gosh this is talent like you could be pretty average and they'll still love it if you just got like semi talent like because it's like something new they haven't seen honestly but even with amazing talent now it's like wow like i really haven't seen this like you know so uh and it's crazy like i because i'm a sub so i'm over at different schools and uh i didn't realize the the tiktok cloud till i got to um one of the middle schools i sub at because i usually do high school and man they were there is that jail oh my gosh jail mr jail jail literally i thought it was just a one day thing i've been at this school for like a long term assignment 20 days every single day i'm like i'd be feeling like the man when i walk all these kids just like running like can i get your autograph like that's hilarious crazy that's that's crazy i believe you man look at the high schoolers probably recognizing too man they're too cool at that age yeah i might have a high school assignment after this and i'll see how it is but because i recently looked like cross-platform so that's really what like took me off so what do you mean by that when you say that what happened oh so uh i posted a video of uh i did a funny veil video like pov you're the barber and i don't lose eye contact so like someone oh yeah i saw that one so i did that and i honestly didn't expect it to blow up i was just doing a trend everybody was doing pov at the time so i was like no let me think of some povs that was one actually what i've done that's helped me i literally go to my phone and write like when i come up with an idea i've write it down and just have a list of tiktok ideas so anybody that wants to start do that at first it was slow i only had like two ideas or maybe even one but then you just start getting on a roll you'll see stuff and think of something else like you'll see something and think of something else to do you know so um yeah so after i um i have my list i did that idea that was the first video to go cross platform someone on twitter shared my barber video i don't even know of her actually and you said it was a girl on twitter you don't know how she found you would you say again yeah so this girl um her name started to see her i'm sorry i should have added her i don't have her name but yeah she just randomly found me i guess on tiktok and found it funny i don't think her following was that huge on uh twitter but it was pretty like decently sized to get this thing kick started she just decided to share it i'd even know like i don't i'm not active on twitter i do have a twitter but i'm not active at all so i mean she didn't tag nobody or anything but because it's uh tiktok's shareability it puts your at at the end when they automatically share it like it's always watermark so you always get credit in a way um they can go around it and crop it but yeah so they she shared it on twitter and it got two million views and uh i was starting to get hit up by like people from years ago like people i don't even know hey bro i saw you on tiktok like you know people that like oh you the fan bro like i'm like bro i haven't talked to you in like seven years man like and then and then it was like um a huge instagram page in me uh funny hood vids and they had 13 million followers yeah i know that one yeah they're like can we use this video i was like oh yeah like so then they share it and uh that got another two million views and maybe two point uh five million views on there and a bunch of people started messaging even still like oh wow like that's crazy bro like you're you're viral you're viral and then so yeah that happened on both platforms and the the one on it uh tiktok itself was only at like 1.7 million or not only but it was at 1.7 so i was like wow three platforms i'm like like that was that happened big like crazy i was already like three videos ahead past that so it was just like it was happening in the background and then um yeah i started getting recognized when i go hoop like all these against her like people know who you are they're like do the stare i mean that's interesting though because once again you start with the younger audience but then down that blows up and translates and it starts to age back up again and even when you look at the idea of your song and your music popping off on on um Spotify well your your monthly listeners increasing right that's eventually that effect might cause it to hit a certain playlist and then next thing you know you start to get discovered by older people again like that people have to really i think a lot of artists trouble and why they don't take advantage of a lot of opportunities is honestly like i call it the school effect right that educate that education system where you think i if i click see and it's the right answer then i get my immediate a here's your badge right you get a you get a b it's like no you can't just say i do this one thing and then i get the result you know you gotta be able to give to the community like you know and then once you get involved with the community it will come back you just have to be ready when it comes back the community wants comedy for me so i'm just being funny all of a sudden like i was never posting any funny stuff until tiktok but never no i know i'm like i don't even know this out of you yeah i knew i was funny just like i just never posted anything about it so i guess tiktok got to share my personality which is actually a huge point because um that that barber one was the first one that blew up and one of my barber friends who's like it's like all in the barber community he's like man everybody's talking about this video like they all know you and it's like i've known you for years he was actually the one that got me into singing and he was like man i've known you for years i was i was going to like say like audition for this choir you know so um uh he asked like man i was wondering like how do i blow up my like my barber page and all that and this goes for anybody i'd say like and that's why i learned him like pr and watching your videos man you gotta sell your personality stop selling the product like you can't just sell tapers and fades there's tapers and fades everywhere like if i really need to cut i'm gonna go down the street and get a taper and fade but if i buy into your personality like oh this is pj this is named pj8 this is pj8's cut like i'm gonna go drive a mile away like oh this is by him like oh he's that funny dude or oh he's that singing barber or whatever he is like i'm of golden i'm a buy into people's personality so people are like buying into my personality now so they're like oh i like this guy this that's that's a that's my teacher i'm gonna go check out his music like like you know like that's i was my sub so yeah literally yeah personality gotta sell your personality that's a huge point man as much as a lot of people don't like it right there that personality thing is real or some sort of unique vibe or like you might not have to do with your physical your personal personality there's other ways to create there could be a mysterious personality it could be any personality yeah yeah whatever it is but people have to have that attraction to it and the world is it's changing right where things used to be so distant people want to feel a lot closer to everything in these pages right these entities that we have is really more of a physical representation well a digital representation of us right it's like an avatar right a real walking walking avatar and they want to feel that versus necessarily seeing this huge superstar he just wants to see today know you and this is how they know you and that's why I think celebrities aren't doing so well yet at least like all the celebrities I have opt on like their views are very like they're though I've had videos that are higher views on them and they have a lot of followers because people transfer easily because they know them but as far as the content they get shared I don't think they understand the shareability part yet or even like just the personal like most of the videos are just high schoolers being real like those are just like most of the videos that's it and like my most viral videos are just me being real too like other than that like the next one that went viral was um I guess I copied a trend I literally just did a trend a trend that everybody does but I did it right I guess because it was like this mirror effect where you have half your face and like I did it to where I didn't move so it looks like I'm one person and I just like ate my finger and then like did this and like did the little I think but like a couple people done similar things but I like took everything that I thought was funny in it and I did it right and that blew up like I was front page of reddit literally a couple days ago front page of reddit like third or ninth uh video then I got uh just shared actually uh this huge instagram page just hit me up there probably about to share me a 92nd um nine gag that's 51 million followers yeah yeah they hit me like can we use this I was like oh yes please it's so interesting that these people actually ask yeah I'm like yeah there's only been one page that had like two million that didn't ask and I was just like um actually reddit didn't even ask um someone my uncle my cousin had to tell me because he's on reddit and he's like yeah you're on the front page of reddit so then I commented I got open my account my old dusty account I opened it and was like let me comment real quick and I just put a comment like hey this is me um I didn't get the credit for this but my instagram is at j other and then everybody started liking it like oh he should have got credit it was like like it was a community like it's oh they just bro that's that's yeah I think that that analogy right there yeah it actually instantly changes the entire way I see tiktok because I I deeply already understood I knew that tiktok is a community but I deeply understand how reddit works as a community and how they're serious about things they will support the hell out of something but they will also convict something you know they'll you know crucify something really really quickly if it's inauthentic right that's all fake or just trolling spamming and all those types of things exactly that's exactly what doesn't do well on tiktok if it's not authentic if it's like you're just rapping rapping rapping like no but if you're like oh I wanted to try something out like real quick like it's like and this doesn't mean like you actually generally have to be like like like oh man uh I mean I've I've seen videos where people are acting but like if you're acting good enough where it seems like you're just like it's like timid shy guy that's just doing it like it can work but like it gotta be authentic it gotta be real like people buy into that so you can't you can't like be fake you know so interesting I mean I think just through natural conversation that you've already given so many tips man and it's crazy once again I want to point out the fact that you've been shared across multiple platforms multiple times different videos it sounds like right and then right before we started I'll probably like take that little clip and edit it like play it right before the intro or something but you mentioned the YouTube page because you didn't even talk about that doing this yeah oh yeah so I'll just hit you up right before we started I was sending an email because um a YouTube page literally just shared me right now um it has six million uh followers a daily dose of internet they just shared my video and they just asked me about that so I was just emailing them back and stuff so yeah it goes cross platform how I do share my music I do do some singing videos and some trends in between on tiktok I do have those and these people know I sing and they're like wow you sing just as as good as you're funny or whatever they say like you know and um so I do slide videos in there but I share my personality is the one that's going viral and cross platform so uh you gotta be you gotta be seen so that's dope so because I definitely have seen those videos and it's like what you sing you don't necessarily like sing an original song you even sing a cover yeah I'll sing the songs that are trending or covers yeah or it'll be like but I've seen times I swear it was one video where you probably only sang maybe for like three seconds first like maybe as a part of the comedy where once again you were like hey let me show him I got a little bit of this yeah right this video is still about just serving the community exactly hey check me out you know exactly stop trying to flex on people like they don't they don't receive flexing real actually I just started helping I just started helping this girl who has a piece of a voice on the voice um uh and she's amazing of a singer sugar and uh sugar jungles that's her name so I literally just started helping her and I was like yeah don't flex on these people I know your voice is like amazing like Ariana Grande Beyonce like her voice is like top notch voice I was like don't just come and flex on these people show them your personality show them who you are be natural like you're gonna kill it that way versus being like yo check me out like you know like don't just like rip on on these dudes like you know come down here yeah come down here like do the songs that are trending there like if you're gonna cover that or do it in a different way do it in a funny way that makes you goes back to are people gonna share this why and why would someone share this you gotta put yourself in the shoes of a stranger seeing this like hey I just saw this video why would I share this and when you could do that when you can like put yourself in someone else's shoes to view your video then you'll understand how like content works got you now I was talking with another artist as a matter of fact uh Trey little and he was like um his when he started to do when he dropped his promo or I don't even know if you'll call it promo right but um when he would show his music side because he's a rapper he would do it 70 30 right 70 serving the community and 30 would you say that number is kind of yeah that's pretty solid yeah that's pretty solid especially if you're consistent like that's pretty pretty solid number like honestly like I'm not even at 30 but yeah I want to put more singing stuff I'm just trying to like see like I want to see the way I can do it where it actually works because I could put up a video and it does it doesn't matter how many followers you have like you can put up a video and it's still dud at least for your like ratio like I've seen people with a million followers and get videos that only have 2000 views or on the same page we'll have another video that got like a million views four million or whatever so it's like the video content has to be quality and then it'll get shared so it's crazy it is a combination of all these apps together it's like the youtube quality works like like watch time and quality part of that and then it's like the reddit community makes it like the instagram like yeah it's all like mixed together and you just like I use my knowledge of all that all the other social medias to like knock this one off so got you hey man I actually want to talk about that we'll actually talk about that after this interview but I with that whole back and forth right the volatility of a lot of people's tiktok pages because something might completely take off in the next video like you said so you'll have like 200,000 4,500,000 10,000 right that whole thing there's some ways I feel like there's some small things that I think make the difference between the people who are able to start to get to a point where it's consistent one number so you definitely have to talk about that because I think you're getting to that point and while I'm thinking about it though bro I hope I really hope your barber does a page because I feel like there's so yeah so so much there like so much comedy around that bro yeah yeah so the funny thing um my barber is actually like he works in admissions at a school he's not like a barber barber but my other friend is also a barber barber so I'm actually going to do a part too soon with my friend that's a barber and help him out and actually uh do it in a way that's not like too spammy not too advertising like we're gonna do it like we thought of just doing it where um my uh what is it called cape that you have has this at on it like you know something casual that's like I'm not I'm not like oh go follow him like you know like you don't need to do it spammy like it doesn't work like that gotta be natural so we're gonna do a part two I have a funny idea I'm not gonna tell you all yet but we're gonna do a part two with one of my barber friends helping you get started so stuff like that so there were any things that you want to just say straight up that you feel like you didn't get a chance to mention in terms of helpful tips things that you might have noticed um what would you say they are for the artists that are watching uh quality content and consistent but not just consistent quality and consistency and by quality I mean like high definition if you got an android I'm sorry that just does not do well but like I'm sorry but like I mean if you do have an android there are ways around it you gotta roast yourself honestly like it's iPhone community and people roast android users like they will make like there's digital effects or you can make the video blurrier so people will literally like do that and be like oh what my girlfriend broke up with me because I have an android and like the video I'm gonna just I'm gonna go on tiktok after this man and I'm gonna make an enjoy video roasting my my job exactly exactly like that works like that's not gonna work but um yeah so quality um my best tip is lighting lighting does very very well I've seen videos where uh someone would do an idea and it's in dark lighting or lighting bad lighting being like that comes from the top is bad lighting this is a little cinematography for you guys it's like right now for me this room is completely dark all the lights are off I'm just facing the window that is one of the greatest lightings you can get across the board black white Hispanic no matter what skin color natural skin skin tone comes from the sun and then it's not a ring light ring light and everything behind you just being dark that's going to be your best thing to get some good quality lighting um because I've seen videos like same idea one's dark one's light and the lighter one just goes off like because it looks better just yeah so that's actually way bigger of a tip than you guys might actually understand so I want you guys to take that tip seriously because trust me I've seen it yeah it does make a huge difference that cover photo all that stuff really really matters even the difference like so if you guys even want to get a difference and understand what he means look at his screen and look at my screen right my screen I have because I had to move into a different room I have a light above me and that's it so then like my eyes are a little hooded it's a little dark around it it creates shadows it's so funny because I'm like the most insecure people the most insecure people look a lot better in just like front lighting front lighting is always going to be the best like you could think you're ugly or not pretty it's earth's natural filter exactly the shadows will make you uglier like shadows don't look good on me don't look good on most people there's very few people that shadows look good on but front lighting gets rid of all those shadows it puts it behind your head and hey working people follow you obviously on tiktok but all platforms yeah so my youtube as well as at jio or jio that's me and I think that's my youtube.com slash jio that's me uh instagram is at jio tiktok is at jio my uh twitter is at jio that's me and yeah reddit I mean if you really care about reddit I'm dot jio but yeah bet bet um hey and as as always this video is brought to you by bram and network.com because I signed myself and any you artists who are not only interested in building your actual profile but are also working on specific songs you like to try to push and go viral uh i am working on campaigns for select few artists you gotta you guys gotta apply and the team will um determine if it's a tiktokable song you can check that out at bram and network.com slash tiktok other than that if you like this video go ahead like button if you like it you might as well share it and if you're not subscribed you know what you know what to do you know what to do hit that subscribe


maintain still some of the flat files system that should increase the speed. Before I actually start talking about that though I have to admit that my primary motivation for giving a talk was to try to force myself into actually doing the words that I'm going to talk about in the talk and in that regard I'm only slightly successful so I managed to do some of it but I've become too much of a professional procrastinator to be influenced by even giving a talk so but we'll see how this works out. So the first couple things that I'm going to talk about are just some general bug statistics. I enjoyed showing some plots. I'm going to introduce the basic architecture of dent bugs just to back up. Debt bugs is the system behind bugs.dent.in.org. So if you file the bug, you fix the bug, you've wondered what bugs exist, you've interacted with that bug. It has both a web front end and a mailing system. I'm going to talk a little bit about some of the new features that have been implemented that you may not know if you haven't followed along but I'm pretty sure most people here follow along pretty closely so that might be all old information for you. I'm going to talk about some planned features especially features that'll happen if I suddenly have two or three more people willing to help and hopefully we'll plea with all of you or people who are listening to this talk online or who may listen to this talk recording later to assist me in implementing some of these features. I'm a nice person. We have some nice people and I'd like to see any Perl hackers or CSS hackers or JavaScript hackers or people who want to write documentation help me so that's what I'm going to talk about. Okay, the goal of the BTS is to report bugs, track the evolution of bugs, fix bugs and hopefully reduce the impact of bugs both on maintainers and on users. This is how many bugs we've got versus time so as you can see our bug growth is roughly linear over time. It's actually decreasing slightly but we have a huge number of bugs. People like to track exactly how many bugs we have and Christian Perrier does some fun contest of guessing when particular bugs might be filed. For example, the 760,000th bug will be filed, I think, September 2nd and the 800,000th bug will be filed almost a year from now in September 15, assuming the linear progression maintains itself. Christian will enjoy that but he's not here so maybe he'll see it online. Anyway, that just shows the bug reporting rate. We average roughly 142 bugs filed a day and so you can see that's a huge number of bugs. This is the bug closing graph. It's actually technically not bug closures. This is actually bugs being archived but for the most part this approximates the bug closure rate with a lag time of about two weeks. So we close roughly 95 bugs a day. So from that you can imagine that the bug system is gaining 50 or so some odd bugs every day that are not being fixed. Unfortunately in this graph you can see that the bug closure rate is decreasing. In context with the bug reporting rate also decreasing, this is something that I've seen in previous posts that I've made on my blog. This is actually kind of disturbing. I'm not sure what that means for Debian as a whole, whether it means anything but I'd much rather see the overall rate increasing than decreasing over time. In this graph you're all familiar with, this is RC bugs which are the bugs that are most important. Luckily the RC bugs are those that matter for the next release are decreasing. So we're getting in line for a new release there. Of course there's always too many RC bugs. So that was enough fun graphs. Now I'm going to talk about the actual DebBug system and how it works. DebBug's two main components. There's a mail back end which is what you interact with when you email control at bugs.debian.org or submit at bugs.debian.org or a bug number at bugs.debian.org. That system runs on a machine called BuxTahood which has all of the files and processes your email. The other aspect of DebBug's is a web front end. That's what displays information on what bugs are in which package and the bug logs that you can interact with. It's also mirrored onto another machine called Beach so that it's ideally slightly faster to interact with. DebBug's interacts with DAC which is a software which is responsible for maintaining the archive. So DAC tells DebBug's who maintains which packages. So DebBug knows who to send email to if there's a bug in a package. It also tells DebBug's which packages are in which suites and which architectures. So DebBug's can calculate whether a bug is present in a particular suite. So for example, whether the bug affects unstable or whether it's fixed in testing or stable which is what was calculated in the previous graph I showed you. Brittany also is the testing migration software that migrates software from unstable to testing. It uses information from the BTS as well in regards to whether a package is becoming more buggy or less buggy by upgrading it. So the actual thing that does that is sort of attached to DebBug's it's called bug status and it provides a list of bugs and it also does the RC bug graphs. But it provides the list of bugs to Brittany. DebBug's itself looks like this. There's mail comes in. There's spam processing that happens on the first in. We try to throw out as much spam as possible. Blar's Barson who I believe will be here soon. I'm not sure if he's here yet is primarily responsible for keeping the bug tracking system relatively free of spam and de-spamming the few... Yeah. Expanding the few or sorry, expunging the little bit of spam that actually makes its way into the BTS. It does a largely thankless job but people who... So if you see Blar it's thank him for doing that. It's not a task that I would ever want to take on myself and so he's done a really great job. Anyway after the mail has been de-spammed then it goes to process all and so process is responsible for handling email that gets sent to submit and email that gets sent to bug numbers. So like if you send an email to 12345 at bugs.diamond.org that's where it goes. Service is responsible for handling all of control. So an email you send to control is Catalyst Service. Now with the advent of control at submit or control at any other time you want to these... This diagram has gotten a little bit blurred. There's actually an abstraction that service talks to that process can talk to as well but that's the basic idea. Then all of the information is stored in flat files in a DB-H directory which has a small hash function to split out the bugs and is indexed with a couple of flat file indexes and then the CGI scripts use both the index indices and the flat file system to display bugs to users. Okay so that's how dead bugs looked before I started working on the database. So the current plan is to add on and basically replace the indices with a database layer. And so I'm going to keep parts of the flat file just because that's a well-tested system. There's lots of things that already parts the flat files that know how to deal with it and add on top a PostgreSQL based database that the CGI scripts will actually utilize in order to display information to users. This will help both increase the speed at which you get results back if you're looking at complicated packages and also enable you to do more complicated things like doing bugs that actually affect a particular version without waiting for huge amounts of time for a query to complete. So for example if you wanted to look at all security bugs which affect unstable well that's actually a really hard query to do without a database layer doing that. So that's one of the major things that the database is going to do. And so the script that actually handles loading things into the database is called dead bugs load SQL. So dead bugs is written in Pearl so you don't like Pearl. I'm sorry but Pearl has recently come quite a ways in its handling of databases. Most everybody has adopted the Pearl idiom of using DVI in order to talk to databases. It's a fairly successful database abstraction layer. But anybody who's ever written code in DVI knows that it's extremely tedious to do joins and complicated statements where you're constantly writing SQL and dealing with escaping and etc etc. Or using placeholders but still it's something that you have to keep track of. So DVIX class is an extension that gloms together a huge number of Pearl modules into a really coherent database abstraction service where if you give it your schema it will build classes that enable you to talk to each of the result groups from your database. So it's a complete system. You can actually write a schema entirely in DVIX class that you can then convert into SQLite. You can convert it into PostgreSQL, MySQL, etc. In this case though I'm primarily interested in writing for PostgreSQL. That'll actually be the primary database backend. There might be an option eventually to use SQLite for testing but my primary goal is to deploy to PostgreSQL. I'm also using a bunch of classes that are specific to Debian. For example the Debian version extension to PostgreSQL that enables you to sort by Debian version because that's extremely important for the BTS. And that's something that's handled very well in PostgreSQL. So what I've actually done is I write the schema directly in SQL and DVIX class has an extension called schema loader which handles converting the SQL schema into the class declarations for DVIX class automatically. So you just write plain old SQL like you're used to and it automatically creates all of the database related Pearl classes that you use to talk to the results from the database. There's another module which handles deployment so it can do automated upgrades from different schema revisions so as you change your schema it handles doing both upgrades and new installs that a new schema which you can also it can also do downgrades and you can do other things in addition to just executing SQL alter statements you can also run Pearl code or anything else you wanted at the database at each upgrade step. So that'll enable much easier changes to the schema in the future. Finally the actual module in Debugs that sort of abstracts this all out is DebugsDB and so all of the database interaction classes in Debugs are under that SQL module. So this is the it's kind of complicated but this basically tracks all of the bug relationships it tracks who corresponded with the BTS has all the source package versions binary package versions and version dependencies so for example when you upload a version that was based on a previous version this enables all that to be tracked and it's I've taken the DAC SQL schema as as inspiration but unfortunately the Debugs SQL diverges from DAC and that's maybe something that if I was small it would be less but I think it makes sense currently so but anyway if somebody is a PostgreSQL genius or an SQL hacker and is interested in maybe offering suggestions where I could make these more identical I definitely be interested to talk to you about. Okay this is actually pretty easy you just call Debugs SQL bugs and it'll load them there are two different parts of bugs in Debugs there's the ones that you can actually modify and then there are the archive bugs so this handles dealing both with both sets of bugs you can also load versioning information this loads which packages are dependent on the ones and the dev info loads the architecture and source versioning information. So the SQL is actually working this is an example of a handwritten SQL query but you could also write this using DVI class and let me show you that this actually works well in theory here okay I'll just try it here and I'll show you the results so it'll be easier so I can run the select statement which is just selecting the count of bugs where which have been modified since I think that's June or July which are not done and sorry which are done and which there's an owner set and the answer is 521 currently so I mean you could see that's a full load of all the bugs in Debian and the actual SQL query I mean executes fairly quickly of course I'm replicating the same queries everything's been cached but I'll give you an idea that it's still relatively quick so I had hoped to have more of this done by the time of this talk but still a lot of work that's needed the log files currently are not loaded and so the log files are all the correspondence with the bug and so that's needed to enable full text searching of the BTS it also currently doesn't do status caching and so that's what will enable faster loading of the package report page and then it needs more work on the deployment to or I actually need to deploy it to the servers so you guys can use it and it's not just sitting on my development setup okay so that's the major work with SQL which is the major thrust of this talk I'd like to talk just a little bit about some of the new changes that have been done one of the more recent ones is using mail to link so let's pick a bug here let's do this one okay here's a nice bug so now there is a reply link which includes the subject the references header basically everything so you can click it it'll open up mod or whatever year MUA is that handles mail to links it'll populate the references the in reply to and will give you most of the message the question is why doesn't the subject also quote the bug number it probably actually should I think that's probably a bug it just quote yeah okay yeah yeah it probably should quote the bug number but it currently all it does is it adds read to the original subject and I was really lazy when I did that but yeah I should include the bug number in the subject of anyway it quote it quotes the original message and it does that for all of the messages in the bug log so you can go down and is the two always the bug number yes the two is currently always the bug number when you click on the reply link no that's correct it does not go to the submitter even if you're replying to the submitter so that's something that that's another long-standing problem that actually needs to be really fixed which I'll talk about what needs to be done in order to fix that okay so other things these are actually old well relatively old force meter merge now does the right thing you've probably or you might have seen force merge failing occasionally but it at least does all the operations that you would have had to do to merge them manually so it calculates what has to be done does it all for you the other major thing is control at submit time which yeah which you just you send any message you use control colon as the pseudo header and you write control commands as usual and at submit time the bug that you're submitting is negative one or the bug that you're mailing is negative one so you could actually same control commands that influence the whole set of bugs for example if you sent the same email to 10 or 15 bugs and used control colon I don't know reassign negative one to some package well you however many bugs that you email so you can actually use that as well to do multiplex control messages if for some crazy reason you wanted to okay this this is a set of the future features that I'm trying to work on status caching that'll come as a consequence of SQL work and so also enable you to do reverse status lookup where you could look up bugs by their status which you can't currently do you can only look up bugs in a general thing and then exclude on the basis of the status which is really slow and not good one of the other major things that I if I ever have enough time is better statistics so I mean I've shown you the plots at the beginning all those plots are sort of manually generated I had to generate them before I gave the talk today I'd be much nicer if huge set of statistics could be generated all the time hourly or even up to the minute so that people can see what's going on with the bugs and who's fixing the most bugs and which packages need more help because their maintainers not responding or who's doing a really good job triaging bugs so we can identify them and thank them and promote them all those sort of things are things that better statistics will help some other things I would like to implement a web-based reporting system not completely web-based but at least with submission of bugs using HTTP to some CGI with report bug or something else as the actual interface to that and that'll get rid of people having to have a working MUA or report but I wasn't currently require working in UA but it require or MTA but it does require that port 25 and 587 work so you can talk to bugs master unfortunately a lot of people's networks currently don't allow 25 and even more are starting to disallow 587 outgoing so but most people at least allow 80 outgoing so that's something that will need to be fixed the major reason why I haven't already implemented that is because I want to make sure that people who are submitting the bugs actually have a working email address now you can mail bugs without a working email address but at least that requires that you could send mail so I want to set that up so that people get an email saying hey you emailed that bugs click this link and once you do that once it won't ever ask you again but that's something that I want to do a second thing is I actually want to release that bugs again that bugs hasn't had a released outside of experimental and it in I mean since the entire time I've been working on it so which is a very long period of time and that's mainly my fault but so it'd be good to do that the third thing that's on this list is bug mailing lists actually in Debugs and so this is what's actually going to solve the submitter issue so the basic idea is that the submitter will be installed or will be subscribed to a per bug mailing list by default where they can easily opt out of it it'll do proper headers and bounce handling and by doing this in Debugs it can also avoid the same person getting the duplicate email so if you are the submitter and also the maintainer this will keep you from getting multiple duplicates of the email if you're also subscribed to the bug list or and the packaging list this will also help a little bit the packaging email you'll still get where from the PTS you might still get but this will at least help reduce the number of duplicates and it will also enable people to set up defaults BTS wide so if they never want to see submit emails to submitter or to bugs which they've submitted then they can opt out once and they'll never see them again or they can decide later to opt in and they'll be able to see that okay the other one is merged bug reports currently have two separate log files which you don't combine so anybody who's ever dealt with a merged bug knows that the history of the bug is sometimes difficult to ascertain have to go view all the bugs and if it's two bugs that's annoying but okay you could do that if it's 20 bugs that have been merged which sometimes happens it's now almost impossible to figure out which bug has all of the history in it which one's the most important so that's something big that needs to be done another one is threading in the email in the bug report view so you can actually see who's in response to you to who another major one is user categories currently cannot be easily duplicated or replayed so if a package has a user category or user tags that you want to emulate it's really difficult for somebody else to duplicate that unless you keep the email that you sent to the BTS somewhere and modify that there's no way to take what's currently in the BTS and pull it back out and replay it on so that's actually something that somebody who is interested in helping out could write that up just as easily as I could so if somebody's interested in working in Perl that would be a really useful thing to merge another thing is remote attachments there's an RFC that enables you to have email attachments which are not included in the email which you can obtain remotely it would be nice to not email out core dumps to people who probably don't want to receive a you know 20 or 100 meg core dump in their email that they're going to download from the BTS anyway eventually so if they ever want to look at it all so that sort of thing it would be very useful and the CGI needs smarter options so that the the query strings aren't as long and they do more the right thing all the time most some of these have actually already been done this is a little old but but there's a lot of places that need so if you're interested in helping and hopefully you or at least some of you are interested in helping please get in contact with me this is how you can actually get started all of the code through running on devian.org is on bugs.devian.org devian branch is the branch that is actually running yeah so the devian branch is the branch that's actually running on bugs.devian.org and you can check that branch out and the branches are also checked out as well if you just want to browse exactly what's running if you want to follow what I'm doing my branches that get done dot Armstrong comm slash dead bugs and I generally try to keep them in sync with what's on bugs.devian.org but sometimes I'm running behind the mailing list is devian.debugs.list.devian.org feel free to email that you can also email me I'm Don at devian.org there's also an IRC channel pound dev bugs on IRC.devian.org and I'm Don Dell-Carlo there so I'm friendly I'd love to talk to anybody if you have questions to BTS isn't working the way you expected it to versioning isn't going the way it should feel free to contact me on IRC or email me and you can also get in contact with owner at owners owner at bugs.devian.org as well owners the group that runs the bugs this is the team and hopefully you will join us so with that any questions I apologize I'm going to be disappearing relatively soon after this talk so if you have questions find me quickly or find me online I'll be at Burning Man the rest of the week so any questions or comments or complaints or do you have a performance goal on the on the update once you have Postgres running I mean what do you mean like when you do a query on an individual bug right now it's usually about five seconds yeah and that's kind of okay for some things but if you're using if you're doing discovery it can be really really onerous I mean it should be less than a second I mean especially for my for individual bug logs so for viewing an individual bug log that's a slightly different problem than the database there's an issue with there because it has to read the entire bug log in order to display it and I'm working on splitting out the individual message messages so the entire bug log doesn't have to be read in order to start displaying it yeah and fortunately part of the reason why I haven't done that yet is because I don't want to reinvent the wheel what needs to happen is some sort of milder like thing with some customization that also allows for detached attachments so that you can separate out a very very large attachment that you're never going to actually display into a separate file and I'm assuming somebody's invented this which is why I haven't actually sat down and done it myself so I've sort of been lazy trying to figure out exactly how that's going to work yeah so just quickly so I've done a lot of work with the historical bug data which you had in there is the database gonna erase this distinction between archived bugs and non-archived bugs so it probably won't erase the distinction at least as far as emailing goes so the major reason okay so the historical reason for archiving bugs was they were deleted at one point time and so then saving them was a brilliant idea and so they're now they haven't been deleted in a long time the other major reason why we archive bugs and why that's actually useful is because it means that they can no longer be mailed and really old fixed bugs primarily collect spam that that's all that goes to them so it's quite possible that the I haven't I mean I'm leading in this direction that I will disable email to really old bugs but besides that they will still be I mean you can still do control changes to them and things like that exactly yeah there'll be basically no distinction between them I mean yeah at least that's the idea so back to the bug at and bug submiter at this is something that has caused problems like people mailing the bug and the submiter not getting like asking the submiter could you maybe try something different and the submiter doesn't get the email I think the mailing list thing is like a great idea but it's probably a lot of work could it be possible to have a new address like dash all or something and get the link in the web page use this new address so that everyone gets the email so yeah the I mean it would be possible to change it so that like emailing the bug number that dash submiter would also email the submiter as well as the bug number currently all it does is email the submiter so I this is a change that's been talked about and I should have just done this already but but I always forget about it so so yeah so I'm going to change dash submiter to actually email the bug and the submiter no matter what even if they opt out in the mailing list eventually once that happens not separate from dash quiet okay so when you email so yeah so the question or the issue is that emailing submiter sets the reply to to dash quiet yeah I'll fix that that's that's dumb the unfortunate thing is there's a lot of things that made sense historically that have changed and some of the things that Debugs I don't even know that it does because I don't always pay attention to what it's doing so okay so I'll fix that try to get everybody one thing that I noticed it's a little bit different about how Debugs works and a lot of other bug tracking systems work is that there doesn't seem to be a way to close a bug as done but not actually done like won't fix yeah like you could do close but the policy seems to indicate you shouldn't do so is there a historical reason for that so you can just tag it won't fix and and close it if you're not gonna ever fix it I mean the the major reason to not close it is historical and it's also because it's easier to discover common bugs that you're not going to fix if they're not closed but yeah that that's largely historical thing I mean there isn't really a way to say that it's not a bug at all like the users is mistaken but you can I mean just close it in that case with a note aside from critical mass of you know 800,000 bugs what does Debugs offer as far as distinction from other bug tracking systems and why do we invest in our own solution I mean what what is it about Debugs that is unique for our distributions bug tracking needs this is a really good question there's two aspects to it the major one is that it's totally interactable via email which is a major thing the absolutely critical aspect though for Debian and why we couldn't use any other BTS system without a lot of work is that Debugs does versioning so it knows exactly assuming that you set up the found and fixed versions correctly it knows in the version tree which nodes have been fixed and which are not fixed and so that enables you to figure out whether a package is buggy and testing whether it's buggy and stable etc all that would have to be added on to any other bug tracking system that we used we were to switch it I just like to say thanks thank you did I miss anybody who had a question wave at me and feel free to ask me as well as well over email or whatever or you can even call me if you want okay thank you very much