Hello, my name is Tim Davies and I work with the Worldwide Web Foundation running a research program called Exploring the Emerging Impact of Open Data in Developing Countries. And I'm looking forward to being at the Frick Hutherford Conference in July, where I'll be running a workshop on getting open data into use infrastructure's ecosystems and actions around open data. It'll be a participative hands-on workshop where we'll be exploring the different roles that data owners, geeks, researchers, policymakers, practitioners, activists all play in helping realize the impact of open data. We'll be mapping out the difference between the infrastructure's open data, the foundations of an initiative, and the ecosystems of apps, reports, advocacy we use that emerge around data sets. And we'll be thinking about what sort of actions can be taken to foster strong ecosystems to support reuse. In that, we'll be looking from a global perspective, drawing on examples from across the world, from civil society in London, from budget monitoring in Brazil to education in Kenya, or global initiatives like one I've been heavily involved in, the International Aid Transparency Initiative. So ring along ideas for data sets or issues you want to discuss and I hope we'll be able to explore them in that session alongside the Frick Hutherford Conference in Bangalore.


The first huge mistake that I see a lot of food entrepreneurs make is creating food for themselves. They end up creating something that they themselves want, but neglecting what their customers are wanting and needing. At the end of the day, what we're creating is a vehicle, a solution to someone else's problem. If this solution does not fit the problem, then no one's going to employ us, no one's going to buy our product. And sometimes we see that people can actually attain success by creating food that they enjoy. And that is mostly by luck because they themselves represent a bigger demographic of people out there that might need the same solution. So this applies only if you're strategical and only if you know why you're creating the food the way that it is. And if there is enough demand for it.


and this is where the pegs are going. We've got another two full courses then the pegs are gonna start so we need to cut back some of these devil branches. All right, I'd better start rambling now. I'll, oh, yeah. Don't you see that line there? I can't see myself on the camera. So after today, we've run out of blocks. So I get Father's Day off. Good morning. Back on the giant shed slash workshop slash living space. As you can see, we're, what are we doing, Dad? Pruning. Pruning. And we've been affected by the curse of the no materials. Yeah, we're a bit, we're dry on stuff at the moment. So, and this is where the pegs are going. We've got another two full courses then the pegs are gonna start so we need to cut back some of these devil branches. It's becoming a trend now, isn't it? Cutting these. And if there's the curse of the conifers? Yeah. But that's the goal today. Lintels have arrived so we can get the windows and doors done. Waiting for trestles. Waiting for trestles, yeah. So then we can get our pike in and then whatever else we can get blasted out today maybe start one of the sides. But yeah, we're waiting on, the cones have arrived. We're just waiting on more block and the trestles like Dad said. Alright, and the burst of rambling now. We'll, yeah. Will the Makita saw not be good for this? Yeah. Do you need your hands for it? No, it's for the guard. Right, watch out. Timber, beautiful. Alright, it's coming up for half nine. Still waiting for these trestles. We can't really start without them. We can build that end up, but if we build that end we've got to bring everything through there. We should just make it different for ourselves. Nice big doors but it's tight. It's a quarter to ten. So as you can see, trestles have arrived. This side's up and we've got plenty so we're just going to put this return on and we can run that section in there as well while we're at it. But we have enough to do the back and the side, up to the expansion because we're doing it in sections so we've broke it down into six sections. So we're not going to quite going to reach the top of there so we're going to have to put a hop up at the top. So that's a couple of blocks. But while we're waiting we've set the timber up with the markings on it and the top of the pike on it and that's here how that's going to reach. It's up in the tree, the nail, way up there. I might just be able to see it on the camera actually. That's it, that's how the pike's set out. So we're just finishing off setting the trestle up grab the coffee and then I'll get a mix in and then we're going to start loading up. Alright, I'll get a brick under each leg. There we go, sorted. So we've got to see that. I might just see that line there. I can't see myself on the camera. Maybe we can have it today. Anyway, we've got two course of block course of commons which takes us to Lintelheight which is 2100. We're slightly high because we're doing these Imperial. So 9, 18, 27, 36 which lifts our gauge up slightly which means we'll have a bit of a split underneath the door just to raise the door off the concrete. But at this end it'll be same as a bit of a split. So with the split on the door threshold it'll give them about 60-70mm to put a floor down inside this area. They're not bothering this side. This is just like a storeroom come shed cupboard. So that's the plan. And as I explained before we've got enough block next to the van there and about 20-odd spread around to get that done. We've got the side loaded but we don't want to build that because we don't want to block our way in. That's last. And yeah, that's it. So after today we've run out of blocks. So we'll get far as they are. Yeah, that's it. We don't want to take those blocks from there because they're already loaded so we should have enough for these. We can pinch these to get this box off today around to there and then that back a bit for the lintel. That's it. That's nine. So course of brick and my lintel and then we can start thinking about more plates and pikes. There's our top of our pike. So quick dinner now and then get this pike up today and then perhaps set the scaffold up for the next section. No commons going on these pikes. No need. So this is going on now. I've marked the 150 on. So let's get it up. Right, you grab that let's gauge it and level it. Grab hold of your end and just like hold it until it doesn't sink. Man, it's really quick now. Real quick. Back to the normal services resume. Now you can let go of it. Nice close up of the bubble. YouTube style. Look at that. Just slow motion then you do a bubble like that. Simple as all shape. Right, let's get this lint now and get the rest of this block working. So there's nothing to go in here. Colours are finished now. Wall's finished. There's just lines over the top. No, there's not. Wall plate goes over the top. Is it commons next to it? Next to it, yeah, but the wall plate sits on top. Yeah.  Line can come down here, can't it? Yeah. So this can come off. Now we can set up the pipe line now. Getting to the top of the pipe now. Profiles run out. We're above the profile. So here's another way to use a fits brick. Obviously I can't get the line any higher. Get into the two grooves. Lift it up. Let me do that again. Here you can still see. There you go. The two grooves at the top, it lifts the line up. There you go. The line's above the profile now, but the fits brick's holding it up in place. Now I can just run these last couple of blocking. Great. I think I'll put you up here now. You've got the other one. Please. Anyway, it could be one of the profile buckets. It could be in the yellow bucket. This piece seems a bit upset with me. This piece seems a bit upset with me. Once you've done these cuts, everything else can go away then. What did you say? Get ready to do these cuts, but get everything as much as you can put away. Like all that should be in the van now. I can't put anything in the van yet. The mixer needs to go in first. The buckets can go in the van. Everything can go in the van. Mixing it all in anything. It is because the back of the van is way more packed. I'm just going to pile the back up. I'm just going to pile the back up. I'm just going to pile the back up. Just organise it a bit then. I can't do all that with the legs in there. Two cuts of time. I might see these two. Are you on a rampage against all the tools today? Do you remember if I booked tickets for Blackpool or not? Yeah. Are you fucking? Are you sure? All that's done with. All the profiles are done with. That was a tough build. That's getting trimmed off tomorrow. Doesn't look much but that's how I'd work that. I need to hop up on top of the trestles to get the top. 25 courses but so many cuts. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14. 5 courses but 14 cuts because of the shallow pitch. So I just need to get over now and try and joint the outside. I'll have a quick recap when we're done.


I'm Saskia Leverijsen and I'm the project leader of the Longa Via project. Because of technological innovations such as smart meters, IoT and sensors, a lot of data is available for the managers of our vital assets like the bridges and the dykes. However, very often the data is not used in a very efficient way to make these infrastructures perform better. Within the Longa Via project, we investigate what are the main barriers for making use of data to help these infrastructure operators to improve the functioning of their vital infrastructures. We do this from the legal perspective and the organizational perspective. We are working together, therefore, with five infrastructure managers, including Alliander, Wietens, Rijkswaterstraat, Progril and the Port of Rotterdam. They are also partners in our research project. I'm looking at it from an operational management perspective and we are looking at two specific things. On one hand, we're looking at how organizations and their direct partners can use data and there we see that data is not only about collecting data, but also making sure you have access to the right data that you can actually transform it correctly. And on the other hand, we're looking at the whole sector as well and how operation management view could have helped policy makers in making better decisions. In terms of scientific impact of my research, I would say that I'm adding to legal scholarship in the area of data regulation. At the moment, most of the scholarship is focusing on how data is used by big tech companies in the private sector and very little attention is given to other actors, like very important actors like infrastructure operators, which are also becoming data driven. With my research project, I hope to help infrastructure managers but also policy makers to ensure that data is being better used by infrastructure managers and that they are also being able to actually utilize digital technologies to fulfill its potential. An example could be related to recent floodings that you see that we've seen that there are some weak spots in the dykes and we're hoping that by helping infrastructure managers to better use data to prevent floodings or preventively make those dykes stronger. In terms of societal impact, what has been really interesting of this project is that we've been able to share our research insights, also the ones from the legal perspective with the project partners and we can see how they are embracing these insights, being more aware of the importance of sound regulation and clear legal rules in their processes and the way they go about with data. And also we've seen that they are actually using these insights from our research to adjust their data sharing policies and also contracts, for instance. One really fun thing about the research project is that it's not only academics and we're not looking at academic results but we're also working very closely together with infrastructure managers in the public sector. As such, I'm not only taking data from them, I'm also actively involved with the processes, I'm working at the offices so while doing research I was also able to help them and to give them insights into how to organize the relationships with current contractors. The next step will be that we do not only look at how data governance and data management within the organizations can be improved but also how these operators can cooperate together to make sure that they can share data with each other and that they can operate as a systems of systems meaning that all relevant data can be collected in a central platform to which, for instance, new companies can have access and they can develop new services for consumers and for businesses. I think the Longavia project is quite unique by combining the perspectives from researchers from Thijsum and the Law School. This is a combination that normally is not pursued and it's been very interesting to work together and see how, for instance, legal aspects influence organizational aspects and the other way around.


Hey guys KFC chicken here And we got the shy guy over here rubbing around smack at people silly All right, today we have joined the scary elevator because they have added the five nights at Freddy have added a Chica Freddy Fazbear and Bonnie they added all three of them They should have added Foxy to make like the full squad, which I don't know why they didn't it would have been awesome Yeah, we're back this game. We haven't played it in like a while if you ask myself and we're here with tweeter Say what's up, buddy? There you go little fella, and we're here with the whole G squad man. What's up everybody? Oh my god Oh, we got no lingo here. Oh Ronald Ronald's always a classic floor, right?  Oh My god, what is a rat doing here? That's a funny Right, let's go over here. Oh look. There's drumsticks here. I'm a drumstick. There's a drumstick Maybe I'm the dad drumstick my little children. What have they done to you? Oh, no, they bit them too.  I'm gonna take you guys back home. Come on jump in my pocket Right, let's get out here. Oh, we got Duolingo ordering something. Hey Duolingo May I take your order? Wait, but this is not a Spanish lesson Maybe Duolingo needs to take lessons on how to order a happy meal Because he does not know how Right. Oh gosh. Oh, he has that uh, what is that gear though? And that makes you levitate That was pretty neat. Oh basement Wait, which is basement? I have forgotten what floor this is. Oh, it's this one Wait, can we fight the killer back here? Oh, we don't have a weapon. Oh Who is it? Oh my god, it's Michael Myers. Oh Gosh, dude, he is slashing and dashing and he was over there crashing All right, let's get out here. Oh god We do not want to be around for him to slashes. What are you okay up there? What in the world is going on over there? I think J.R. Frost was having a party of their own. Oh, no That was way too close Oh gosh All right You cannot hide from me Well, I'm not trying to hide man My god, that was creepy. Oh off his classic one of the new floors. Oh wait, what's that? It is one in the new floors They updated the floor. No. Oh my god. It's Chica.  How did she not kill us?  They actually talk. All right, let's see if he has a jump scare Cockle duty do Oh gosh, did that jump scare though Not in line. That was a pretty cool jump scare All right, let's go back. Nice. We got the new floor in the recording. Wow. I am impressed We managed to get the floor Because we usually have to wait for like ever and ever to get the floor and we got it fairly early this time Who's the killer here alleyway? Probably S.P. Knight.  And they're chasing you and you're running for your life Right, isn't the red key right here for you guys that didn't know the red key always spawns right here right about here Hey, look there's a red key I don't think anybody wants it Because it's in the rusted truck It's in the back of the rusted old pickup truck Hey, hey What's up y'all Oh my gosh, stay inside. Oh, that was a free um the free gear they gave right Who locked down stay inside with a coincidence if you ask me, right? Oh gosh. Oh, no, it's chucky. It's thick chucky Where is he at?   Oh, no blazer run drags. So we got blazer axel brian john frostle christie rose My god, we got a lot of the yeet squad here, man realistic fan Yeah, you just code realistic g like my boy said. Oh, wait. You look at that mr. Slabby. Oh, no, he vanished Oh look all the collection here And to speak of goons, I just started watching it on netflix again not so long ago with my nephew We're having like a marathon watching the netflix um goosebump series.   Oh my god talking about small people.  Wait, where'd he go? He just vanished. Oh, there he is Where's he at?  Let's go back over here Let's try to make it through the hatch one more time Oh, uh, we're not gonna make it a third time. Are we? And No, we're not But some of that laugh at the end It's like a derpy laugh All right, and we're here at the library. Oh, it's a oh only Where the purple kool-aid man Why is he doing why does it look like that bro? He's just like so hilarious to me And that's like one of the laziest models They just like took a png of a picture and they just printed it on his face And they expect us to be afraid of that. Come on, man. You guys got to do better. All right, let's escape All right. Nice. We made it out of there safe and sound Oh Nice we survived that Hey Hey, oh no the grim reaper. Please don't take my soul grim reaper. Okay The grim reaper with the fidget spinner. That is so funny. Oh bedroom You're close to 10,000 points. Am I really where's my name on 9284? Wow What if he what if mr. Nassau hero resets it before I get to 10k points? I would totally rage at this game He always reads he used to reset it. Good thing.  Jeff the killer always remains creepy as always Oh my god Dude, can you like blink for a second? You never blink Like how in the world do you not blink? Like if you were to have like a blinking contest against jeff the killer You would definitely lose guys. What? Oh, somebody's dressed as him I was about to say how was he to the elevator?   Where is this guy at? My god Bro, you need a girl man.  That had to be a baby. Oh no, I was about to die to the evil baby That would have been embarrassing Oh, no, that's a kitty song You know what this kitty song is growing on to me man. Could you always hear it when we play this game? I used to make I used to um I used to say it's gonna make my ears bleed because it's too peaceful for this elevator But now that I just hear it it's nice peaceful Do you want to play hide and seek? What?  We got stuck in here. That is so messed up. Yo Yay Right. Um, I don't know what's going on where I guess we're trapped here Right. Well at least she has a spirit and she's dancing Right, let's get lit We're trapped in here forever. Right.  All right you guys. Well, this is a scary elevator We only managed to get one floor and we got the chica. We got chica on it, which was pretty awesome And I don't know if we're gonna get another floor right now. Hopefully jack. Oh, no, that's an old floor Right. Well, thank you guys for watching Thank you guys for the support if you guys enjoyed the video make sure to slap the like button If you're new to the channel make sure to subscribe and turn that notification bell on and I will see you guys in the next one. Yay


Welcome to today's Postgres Conference webinar, What Next in Logical Replication? We're joined by Amit Kapila, who will discuss the basic architecture of logical refuelcation in Postgres, and then cover the various ways in which it can be helpful to others, including new enhancements and improvements related to logical replication that are currently being discussed in the Postgres QL community for future releases. My name's Lindsay Hooper. I'm one of the Postgres Conference organizers and I'll be your moderator for this webinar. A little bit about your speaker. Amit is a Committer and Major Developer in Postgres QL. Over the course of a 20-year career, he's developed deep expertise in not only Postgres, but also Oracle and in-memory databases. He works at Fujitsu as a Senior Director. Welcome, and with that, I'll hand it off. Take it away. Hello, everyone. I am Amit Kapila. I work with Postgres SQL Open Source Community as Postgres Committer. I work for major features, development of major features, and I participate as an author, reviewer, and Committer in the community. And I work as a Senior Director in Fujitsu. Today, I am here to present you about logical replication, like what next in logical replication you can expect in Postgres SQL. So the basic agenda of this presentation is that I will first start with logical replication basics. Then I will go into some use cases for the same. Then I would like to highlight the key features developed for Postgres SQL 14, which is due release in September or so. And then I will talk about what could be there in Postgres SQL 15 and beyond. One thing to note here is that Postgres SQL 14 work is yet not released and community is entitled to revert or change some feature which is getting released. And Postgres SQL 15 is still just started. So all of this is based on what I could see being proposed in the community at this stage, but nothing is promised what could be done for Postgres SQL 15. So to start with logical replication is a method to replicate the data selectively unlike physical replication where data of the entire cluster is copied. So it works basically on the publish and subscribe model. Like one node will publish its data and other nodes can subscribe to it and receive all that data. The node on which publication is defined we usually refer it as publisher and the node where subscriptions are defined we usually call it as subscriber or subscribers. So then we could also allow to build the cascaded replication system here where the data pulled by subscribers from the publishers can be republished and it can be allowed to fetch by other subscribers. In general, the subscriber database behaves as any other Postgres SQL instance and can define it own set of publications. Now let me try to define what is publication and subscription. A publication is a set of changes generated from a table or group of tables. And in future it could be group of objects like sequences or for schema like this. So basically publication is a way to generate the set of changes for defined group of objects. And each object or table could be added to multiple publications if required. And then we can also define which combination of operations or which operations data we need like insert, update, delete, truncate. We can either want the data for all the operations or we can define which operations data we need on the subscribers. Subscription can subscribe to multiple publication and it initiates the connection to the publication node. One of the things we have to note is that we don't have DDL replication at this stage which means schema definitions are not replicated and users need to manually create the schema on each of the subscriber nodes. So the object here we are talking table must match on both sides using a fully qualified names to allow replication. Here fully qualified names means the schema in which it is defined should match also on both sides and the columns also should match on both sides. So how the basic replication works is that it starts by copying the initial snapshot of data from the publisher. And once the initial data is copied, the changes on the publisher are sent to subscriber as they occur in real time. Basically once we get the initial data which is there in the publisher before our replication starts, we get data change by change based on each operation. Now, sometimes as I have told you, subscriber is an independent node. Applying while applying the data on the subscriber can generate conflict if it violates any constraint like primary key or any null constraint or anything like that or any check constraint, sorry. So basically it is quite possible that while we are replicating the row, somebody on the subscriber has already inserted that row, in which case it can violate some constraint. And as of now, a conflict will produce the error and the replication will be stopped. So such an error needs to be manually resolved at this stage. In future, we might want to build a system where such errors could be resolved automatically as well. So a setup of logical replication is really, really very easy. The only thing parameter you need to change is ball level logical equal to logical in PostgreSQL.conf file, then start the server, connect to a database and create publication for required tables. The simple example is with this command, create publication name, then the tables for which we want replication to happen. And then on the subscriber, no separate setting is required. You just connect to a database, create the subscription for required publication with a simple command like this. The above will allow the replication of users and departments, table data to the subscriber node. So here I have given the example of one publication and one subscription, but there could be multiple publications, as I have told, and one subscription can subscribe to all the publications, which internally means all the tables or the objects publicized by those publications will be replicated on the subscription. Now I will briefly mention about the use cases for logical replication. So it allows us to send the incremental changes in a single database or a subset of a database to subscriber as they occur. And we can also consolidate multiple databases into a single one, which could be used for analytical purposes, OLAP databases kind of thing. And we can also replicate between major versions of PostgreSQL and we can give access to replicated data to different groups of users. One could also imagine to build a read-only or write multi-master database based on the logical replication. Next, I will talk about key features in PostgreSQL 14, the release which we are expecting to come in September or so. So one of the major features we have developed for PostgreSQL 15 is to allow the streaming of in-progress transactions. Prior to this for large transaction, there is always a big apply lag as we only replicate the transactions at the commit time. So if the transaction is very large, we don't start even sending the data to the subscriber till we encounter the commit. So this will introduce a very big apply lag. Now, because we start streaming the data to the subscriber after a certain memory threshold, this allows us to send incremental data for a transaction on the subscriber. So how it helps is that earlier the data of large transactions were spilled to disk even when we don't need it. So this feature saves a lot of disk IO required for such transactions. For example, the transaction could contain the data of multiple tables and one of those tables is not even publicized. So all the data will get rejected but because we don't have a way to find out, the data gets accumulated and we need to spill it to disk. So this feature saves a lot of disk IO required for such transactions. The performance improvement is proportional to the data of such transactions. We have seen the performance improved by two or more times due to this feature for large transactions. And now this feature also adds various APIs to the output plugin. So that not only the built in logical replication but the users of the decoding output plugin or the people who have written their own output plugin can also stream the in progress transactions. So the main APIs are stream start and stop. So each set of changes are sent between start and stop. So say we are sending 10 changes. So for each of, say there are total 100 changes and we decide to send them in chunk of 10. So for each of the 10 changes there will be a stream start and stop so that the subscriber can recognize the boundaries and it can accordingly take action for those messages or changes. Similarly, we need to for the commit and abort we need to send stream abort and stream commit. And then for each of the change, the message, the stream change API and stream message and stream truncate APIs are introduced. So this is mostly about this feature which is the streaming of large transactions. So apart from this, we have done a performance improvement in logical decoding where if a transaction contains a lot of DDLs, we improved the CPU usage and decoding performance of such transactions. It has been observed during our tests that decoding of a transaction containing a truncation of a table with 1000 partitions would be finished in one seconds, whereas before this work it used to take four to five minutes. So you can see how big difference this creates. The basic idea was that instead of doing the invalidations on each change, we do the invalidations at the command level. So this reduces the overall number of invalidations that gets processed, which helped us in improving the performance. So next, like while introducing these features we also came across the requirement where we want to allow user to see the performance of logical decoding. Like right now there is no way for the user to know how many transactions are streamed or how many are getting spilled. So sometimes it is difficult for the user to see why it is taking so long a time. To allow users to administrate the logical decoding, we have introduced a new view, which is PG-STAT replication slots. This will contain one row for logical replication slot showing, which will show the statistics about its usage. So here there are two type of statistics. One is spill statistics and other is stream statistics. So I think I forgot to capture here. We also capture the total bytes that are sent. So spill stats tell us about the amount of data that gets spilled to disk while we are decoding. Now why data gets spilled is we have a memory limit that if the changes crosses that memory limit, we spill it to the disk. And stream stats tell us that when the number of changes exceeds a certain limit, how much data we have streamed to the subscriber. So yeah, this is about this view where users can really administrate their logical decoding performance. Then the other key improvement we have done is in the initial table synchronization. If you remember, I have told in the beginning of the presentation that the first step of logical replication is to initially synchronize the tables. So the initial table synchronization involves copying the initial snapshot of table. And then the table is brought up to a synchronized state with the main apply worker by applying individual changes. So here while doing this, all this work is done in a single transaction using temporary replication slot. So this, that mechanism has a few drawbacks. For example, for the whole duration of the copy and the sync in the table sync phase, we will hold the wall till it is complete on the publisher. And any error during the sync phase will roll back the entire copy, which is really very painful for large copies. And then there is a risk of exceeding the CID limit because even the multiple transactions get merged as a single transaction during this phase. So we have solved all these drawbacks by allowing multiple transactions in the table sync phase and by using permanent slots and origin to track the progress of table sync. So this work helped us to improve the table synchronization mechanism. As such, users might not see some user visible difference, but some of the users who have large copies or large data table synchronizations might see these drawbacks get removed. So this is mainly about this improvement. So next I will talk about, we have also introduced a way to transfer the data in binary format among logical replication nodes. So the users need to provide an option while creating a subscription or if they can alter it afterwards so that the data from the publisher be sent in the binary format. By default, this option is false and the data is sent in the text mode. Also, sorry, even when this option is enabled, only data types that have binary functions for send and receive will be transferred in binary. And this mode is generally faster, but it has a slight drawback that when we are doing cross version replication, if the subscriber lacks binary receive function for the data type, the data transfer will fail, which users need to be aware of. So yeah, next important thing is, in this release, we are also going to allow decoding of prepared transactions. So this also in a sense reduces the apply lab. For example, earlier, the transaction data is only sent at the commit time. There could be a lot of difference between prepare and commit time. So users won't get the data till commit, but with this feature, they will receive, they can receive the data at the prepare time. And this will also allow the plugins to decipher the transaction at prepare time and routed to another node if required. So I will cover in future slides how this feature could be used to build better, sharding system or a better multi-master system where the read-only data or the read-only queries could be scaled. So some of the miscellaneous features we have added in Postgres SQL 14 related to logical replication are, like we have added a new syntax to add and drop a particular publication. Earlier, we don't have a way to add or drop one publication. User needs to use the whole list of publications, which they want to keep as part of subscription while changing it. And then we also enhanced our internal to get the messages via PG output. So we have provided a new option messages to the PG output plugin. This allows decoding messages that gets generated via PG logical emit message. This is useful for PG output plugin users that use it for change data capture. So this is mostly about the features which you will see as part of Postgres SQL 14 release for logical replication provided none of this gets changed or reverted by community due to some reason. But this appears to be a very good list of features which I think will help many users of logical replication via Postgres SQL 14. Next, I will talk about some of the features which we are discussing in the community for Postgres SQL 15, which will happen next year, but there is no as such guarantee or any, you know, word from the community side that these all will be released by Postgres SQL 15. This is based on my observation on what is being discussed in the community. So first we will allow the inbuilt solution of logical replication to stream prepared transaction. As I have mentioned few slides back that we have started allowed decoding of prepared transactions in the Postgres SQL 14. In 15, we will see that those transactions are going to be streamed on the subscriber. So this will really help us to build a conflict free logical replication because now if there is any conflict that happens on the subscriber while applying, user can get a chance to roll back its transaction on the primary. This will help us to support two phase commit via logical replication, which I think is a very big win aside from just supporting, aside from just getting the benefit of apply lag. Now, as I have mentioned earlier, another use case with this one can imagine is to build a solution for scaling out reads. Because of two PC, we can ensure that on subscribers we have all the data committed on the master. So this means one can design a system where different nodes are owners of some set of tables. And we can always get the data of those tables reliably from different nodes. And then we can have one external process that will route the reads accordingly. The right can always happen on the master or the publisher node. Then the next bit feature we are discussing is to allow the publication of schema and sequences. As of now, users, if they want to specify publication for all the tables in the schema, they need to specify it one by one. But with this new, excuse me, but with this new option for all tables in schema, users can actually give the schema name and get the replication for all the tables in that schema. Similarly for sequences, and the beauty of this syntax is that users will be able to mention the schema as well as the tables which are non schema specified. So various objects could be specified in a single publication with this syntax as well. Now, allowing to publicize schema will help users to logically replicate all the tables in a particular schema. And similarly, once we allow the replication of sequences, this will reduce the manual intervention by users where they need to keep sequences in sync on the subscriber. So I think this will be again a big step if we are able to achieve this for PostgreSQL 15. The next thing we are discussing from quite some time now is to allow logical replication from physical standby. As of now, if the publisher nodes goes down, it is not easy to set up the data from the publisher node. So if we allow the replication from physical standby, users, it can automatically switch over to the standby, physical standby, and the replication will continue to work. This will allow existing subscribers to connect to physical standby for existing publications and get the data. And this feature will also provide a way to continue logical replication after the standby is promoted as master, which is not possible as of now. Or users need to manually do multiple things to achieve this. Then the other feature we are discussing is, we call it as row filtering for logical replication. So you can imagine that for any table while specifying the publication, users can specify the where clause to allow only those rows to be filtered and sent to the subscription. So this will help us to again reducing, to avoid sending the data which is not required by a subscriber. Or in other words, we can say that this will help to further replicate the selective data. And I think this will also help in sharding the data at various nodes. One can imagine that one table could be sharded to different nodes using this scheme. Now we are also discussing for the column filtering for logical replication. So one can imagine a syntax where a particular table's columns could be mentioned and we will just send those columns data. This will help us in replicating when the target table doesn't have the same columns as the source table. And also for the cases where the source table has some sensitive information which they don't want to replicate to the subscriber. So the last but not the least feature which we are discussing is in some way will help the conflict resolution on the subscriber. As I have mentioned a couple of times during this presentation as well that while applying the changes on the subscriber there is always a chance of constraint violation. And this will allow the, this will stop the replication. As of now, users can resolve the conflict manually by either removing the conflicting data or by skipping the transaction which cause conflict via PG replication and origin advance. But both of these are options are not so easy for users to follow. So the new option we are trying to provide to users is to specify the transaction ID for which they want to skip the transaction on subscriber. This option needs to be carefully used otherwise users can cause replica inconsistency. And additionally, we are planning to show the error transaction information via the stats view that will help users to easily identify the conflicting transactions. So thanks, you can contact me anytime at amit.capila16 at the redgmail.com. So this is all I have for today.


Good day everyone Konichiwa. I'm Rumi from ultra Celsius You all have all of you known Celsius mean except maybe if you are from the imperial system, but As you by the name we are focusing on temperature Especially cold temperature here now We started our company based on the problem that we face like In many countries especially underdeveloped countries 30% of the meat products are lost because of their lack of cooling system or even if there's any cooling system like a fridge or a freezer There's no electricity to run it 24 hours often blackouts But even even in the developed world It's very expensive to run the freezing system a freezing system will easily cost like Typical fridge a refrigerator will typically cost like a hundred dollars a year to operate So many companies are focusing on reducing energy consumption and Going green because it's costly to operate a freezer system But we now we develop a system that could solve both problems not only for underdeveloped countries, but also for energy savings We develop a freezer that could work in Without power for a hundred hours and keep food Cold even below refrigerator temperature So it can work it saves energy and also work with limited electricity access So what's the secret of our freezer? Our freezer has a chemical compartment embedded inside the freezer This chemical compartment has a chemical sauce. We have a proprietary chemical sauce and proprietary Technology which we are in in the process of patenting So this chemical will save excess energy and Will star and it will use it when the electricity is off. So a regular freezer a regular freezer Works on only by the cooling system the evaporator without the electricity There's no there's no way There's no system that could store energy Inside a free regular freezer. So once the cooling system is off the cold energy the will go out and will exit the cabin and Food will start to increase the temperature So if you keep it for more than one day, the food will perish will easily perish While our technology We our chemical will absorb energy will absorb energy when the freezer is on and Once it reaches a certain temperature it will automatically turn off and it will release energy to keep the food cold This is our test The light blue area is when the freezer is off We started for like the day four and it lasted until day eight It for four days. It was still in Cold condition is still below zero degrees Because once it start on a zero it will start on and it will only take 36 hours to Re-freeze the chemical. So it's based on this is equal to 274 percent of the time is off and Here on the left side you can see In a regular freezer meat will at 18 hours. It will go to zero It will start to deteriorate while here in a hundred and three hours the pink line is the meat It will still be at a hundred zero degrees Celsius so it's still good condition Furthermore our technology could be used could be scaled up into a more industrial scale We are testing it on the cold storage in a four-star hotel in Yogyakarta and the results are quite good so far so Hopefully, thank you for very much for the time and hopefully we can scale it up and help a lot of people with this technology Thank you Thank you very much. Yeah. Thank you so much Big applause So I hope no one is feeling too cold in here now. It might have just taken the temperature down a couple of notches I am here at all week. Thank you very much And now we will move on to the Q&A. Yes, and I hope it's not a frosty deception. I'm done. Thank you Thank you. It was freezing What is there a price difference on your technology or what's the okay? Of course, okay, so basically we did a research on this and we did a Small scale for our prototype we developed and we count the extra costs compared to a regular freezer is around a hundred dollars however it To operate it I said it's a hundred dollars a year electricity for a regular freezer And if you save 30 percent to 40 percent the payback period is three years So the lifespan of the freezer is five years, but accounting life, but it's more than five years So it's still beneficial for the customer Thank you. Thank you. What handed it ours is so cool And I have two questions. Do you have what is your chemical compartment? What is your chemical compartment? And do you have some patent for that or some IP? Okay, for the system itself the cooling system that we have a chemical compartment in the freezer We we register it to the patent and we are in the process of the PCT process and so far there's no problem and So far we are in track of getting the worldwide patent Okay, and how much side do you can do you bigger? Sorry, how much how bigger? Oh You make that okay, so for the Cold storage that we are testing in a four-star hotel in Yogyakarta We are testing it in a room the room is around two meters wide three meters Long and two meters high. So it's basically It is a small room for and it keeps the temperature below zero for so far for 12 hours without electricity Because we are talking about the chemical. Yes, you've done like independent third-party Audits if it's actually harmful for the food, maybe or not. Okay Actually, the chemical is 99% food food ingredient so it's totally safe even if I Swap eyes unfortunately, I don't bring it, but I can swallow it It's totally safe Thanks, do you have a working product and are you ready to do mass production? Yeah, we have the prototype We have to work in working prototype now in Indonesia but for mass for mass production We are looking for a partnership with maybe major players and we will look to sell and license our IP So we don't need to compete with the big players Thank you very much. Thank you Thank you. Thank you very much. Thank you so much. Okay, you can go


We're here between Dawson Creek and Taylor today and at the Spectre Energy plant where we're celebrating a big big expansion of the capacity for processing here. It is a great day I have worked with Spectre I have a great deal of respect for this company they do a good job and they're always willing to come to the table to sit down with not only our government or local governments but the people around where they operate and I think that's the single most important thing I can say about Spectre Energy. It's a superb site it's well buffered from the community so that landowners around us are protected the noise is minimized and the site conditions are kept in in pristine order so we're we're very very proud of this plant. It could become a trillion dollar industry and companies like Spectre have been here for 50 years providing thousands of jobs for people over those years and the opportunities in the future for this to happen are just to grow are just almost unlimited.


We're taking a break, this is not a clickbait video guys, this isn't a prank, this isn't nothing, like what we're going to be talking to you guys about is something serious. We didn't want to make this video sad, that's not what this video is about, this video is kind of explaining what's going on. You guys know everything that's been going on in our lives. I've been so stressed out. What is getting most fun? Welcome back to our channel, you guys already know. We started off the video with our pink dreams. We didn't have to say anything, they already saw them in our hands, we are freaking addicted, but that's okay.  Yeah, and it's got good energy and okay, it gets me going, it gets me motivated. We're starting the video a little late today, it's two o'clock in the afternoon in Florida and it's 92 degrees out so we need our caffeine. It's been a little crazy here in the Marvel house, but guys, I know you guys clicked into this video for a specific reason. Make sure you guys are watching all the way through because we will be explaining what we mean by that we're taking a break. This is not a clickbait video guys, this isn't a prank, this isn't nothing. What we're going to be talking to you guys about is something serious. Make sure to stay tuned and comment down below what you think about what we say after we tell you what's going on. Yes, I want you guys to comment down below your thoughts and what you guys think about it all because we're human and we'll explain everything. But guys, make sure you go ahead and hit that subscribe button and give this video a big thumbs up and I have a challenge for Bill. Is that why you wanted to start the video right now? Yeah, Mariah's been asking to try a challenge out, so what is it? Okay, so what are the odds that you jump?  Fully clothed? Wait, I can't even put a swimsuit on? No. Just wearing this stuff? Wearing all that, what you got on right now. What, one out of ten or one out of five? One out of ten. Can I just say no, I don't want to do that, I just got dressed. Well then guess the wrong number, you haven't done your hair, you didn't showered today. Okay, just because I didn't showered doesn't mean my hair isn't clean. Okay babe, ready, we're going to do it, what are the odds, ready? Because we get two shots. Wait, that's two times. Yeah, yeah, yeah, that's the whole point. Okay, ready? Three, two, one, five. Six. Alright babe, we got one more shot. Ready? Three, two, one, nine. No, I am not jumping in the pool. I am not jumping in the pool. We're not jumping in the pool. No, before I get on with jumping in the pool, because I guess I lost the would you rather, whatever Mariah, I'm over that now. Just get ready for that, but can you all explain to me, do you see this? Me and Mariah are in argument right now, this sink does not have a garbage disposal, but she continues to put stuff in the sink. And then she goes to tell me that's what you're supposed to do. If you have a garbage disposal, you just dump all your food in the sink. And then you go, it goes in and you push to the button and it goes urgh and it brushes it up and it goes down a sewer. That's what it's made for. Mariah, no, okay, but why? This one doesn't have, so why is there cereal in there? No, I'm just lazy and don't feel it.  Tell Mariah to pick up after herself, because I'm sick and tired of seeing food in the sink.    You wanted to call your mom and ask her, but you know I'm right. Babe, we have a garbage disposal at my house. There, go urgh. I will call her right now. Go do it. Calling mom. We're settling this argument right now. You guys are literally dead at seeing us argue right now. Me having a garbage disposal. Mariah doesn't think I have a garbage disposal at my house. You don't. Yes I do. Do you have a little button that you press? Yes I do. Where is it at? It's by the sink. Okay. Alright I need you to settle a debate really quick because Mariah is telling me that we don't have a garbage disposal. Do we have a garbage disposal at my house? Which house? Your house. Yes and I use it all the time. In fact I get to clean it because it was getting so full. Thank you so much for settling that. No, wait a garbage disposal. You have a thing that you flip up a switch and it goes. Yes that's what a garbage disposal is. That's a garbage disposal. Yes. But why do you have a trapper thing? Exactly. Yeah but that's what the garbage disposal is. No. What about a knife falls into a fork? Exactly. Point proven. Alright thank you mom. I'll let you drive. Alright bye. See I told you. This girl wants to argue with me even though I know I'm right. I know that because all I've seen here. Whatever. Whatever thing. Whatever Mariah. We're over that. We're done with that. I won the argument now. Oh jump in the pool. No I get to wonder the odds. Mariah. What are the odds? I have to jump in the pool with my clothes on right now. What are the odds you jump in the pool with your clothes off? I'm not doing that. You have to. You have to. Alright try right? I'm doing mine. Ready? Out of 10. 1, 2, 3, 2. 4. I get you tries though. Okay. Ready? 1, 2, 3, 7. Dang it. Yes. Yes. Alright baby the moment of truth. Go on in. No, no, no, no, no, no.  Socks are on. That's the whole point. You lost so keep your shoes on. I had my clothes on. Keep your socks on. Keep your socks on. And jump right on in. Get a nice swim. Clean your nasty booty. Okay. You didn't shower today.  Go on in. Oh my god. Go on in. This is the second day in a row I have to do this. Go on in. I'm going in. Now 3, 2, 1. Go.  Is it cold? My clothes are not hot.    No.  Guys cue the sexy montage.  Alright guys. Let's go talk. We have some talking to do. We have a lot to talk to you guys about. And I gotta dry off. Yes. Pardon me. I'm a little wet here guys. I wonder why.  No. Exactly.   But anyways what is good guys. Welcome to our channel. We could finally sit down and talk. This is the part of the video that we're going to explain the reason why you clicked into the video. The thumbnail and title. We didn't want to make this video sad and you know whatever because that's not what this video is about. This video is kind of just explaining what's going on. As you guys read by the title we are taking a break. There's been a lot of things going on that you guys well know aware of. Like you guys know everything that's been going on in our lives. We're going to explain them in a minute. Everything that's been going into the move. The house hunt you know filming and everything. We just want you guys to connect with us and know that we are in human and that it's okay to get stressed out or things happen sometimes and we just want to be open with you guys because you guys are our family. But as you guys know me and Bill did just move down to Florida about a month ago which was the best decision we've ever made in our entire life. We are the happiest we've ever been. I can't believe it's already been a month. Dude it's literally well it's not a month ago yet but it's almost a month. By the time you guys are seeing this it's probably a month ago. Guys if you did not yet go click the link in our bio and get yourself some moving across country merch our limited edition merch. It's still up right? Yes it's still up. It's still up it's still ready. There are some products that did sell out already but make sure to go check that out. Oh and we weren't expecting to find a house like as quick as we did like the house stuff. Like that came so fast. It's supposed to be a while. It's supposed to look at some houses going back and forth. I don't know if you guys noticed but the house market has been booming. Like when I mean booming like someone puts a house up for sale. And it's gone that day. The house that we found that we actually own where we're going to own. We're moving in very soon. We put an offering after one day of seeing it. Insane. The first day it was on the market we looked at it. Second day put an offer in and we got it and now we're about to move in. It's so close you have no idea. Less than two weeks? Less than two weeks. Oh my gosh. It's insane. We can do anything in this house. We can paint it. We can do marble stuff. We can. And with that being said of what today's video is about I'm just going to start the video as you guys can see I'm breaking out. Like I have never broken out like this bad. It's actually like not okay but it's because I've been so stressed out. I'm in like that adult time where like buying a house and doing all of these things. Even though we're 20. She's 22. I'm 20. I turned 21 this month. It's definitely been really overwhelming and then making sure that we're putting cons now for you guys five times a week. It gets like really overwhelming because I feel like we can't ever like just relax and like you know just enjoy life you know I feel like we're like we're doing all this stuff. We enjoy filming though. We love filming. Filming honestly doesn't even feel like a job. Like even though it is our job if you do not know that we film for literally a living like you guys are able to support us and we're able to support you with content but it is getting like I understand where Mariah's coming from. See I'm I feel like on the type of dude that just I could work day and night. It is so easy going. With that being said we are taking a break with in this aspect of we're posting less which means we're gonna be posting Monday Wednesday Friday three times a week instead of five that may change you know we might post four videos you might post five videos but for right now until we like get into our house we get settled and we kind of just like get going and get our motivation back because I'm not saying like I'm not motivated but when you're not in your house and you can't do things you can't change things or just like it's really hard to get the motivation there because you're not in your own home and we can't even have our own freaking cat here I know it's not my parents it's my uncle you know allergies and all this crap we can't keep our cat in literally this house and like it's just like we feel like we're just like trapped trapped even though we're in Florida I know we're in Florida the only thing is like we know we have a house and we can't just we can't go to that house yet and and I'm not saying we're not great but we're so blessed be able to have a house to live in and you know in this meantime like we're really really thankful we don't want to feel like we're being ungrateful but knowing that you're almost about to move into your house and like we don't even have half our clothes in here we don't have half of our items in here it's sitting in a metal box in the driveway for the past month like it literally just stresses me out because I feel like all of our stuff is crammed in this house and we're not we don't even know our stuff and like I hate being unorganized and it just my stress levels have been over the roof and I feel like once we get into our house things I feel like will be different I feel like we'll get our motivation back we'll get our just our like energy there because we're doing so many things in a day that it's like our heads can't handle it right now and I want to say something okay now we're done with the stress and I think where we've managed and covered most of that part I also want to tell you guys the reason I know you might be like oh no don't post less the reason why we're only going to be posting for now Mondays Wednesdays and Fridays is because we want to have more time to expand our job and also expand what we can do for you we want to start up our YouTube membership club where we can give you extra content extra perks for being a subscriber if you join the membership we have some cool things for that coming up guys we're starting a company that we want to you know do also this company that you guys would love we're just going to tell you guys straight we're not going to tell you what it is yet no but what we're creating right now what we're getting all handled is about to be something that everybody like everybody in the world can connect with and vibe with and like I'm so excited for you guys to see this we're in the works of that right now we want to be able to focus on more things in our jobs and grow ourselves we're not saying we can't grow ourselves posting five times a week but I mean we're obviously growing more doing that if you guys don't know our channel when you post where we've been doing challenges we don't we want to give content out for you guys that's the best we can get and it's really hard to do that five times a week because like you know challenges they take all day every day like these are like in depth videos and we want to put our all into these videos we want to make sure we're getting you guys the best content we can because you guys are our life we love you guys so much and we don't want to throw out a video that we're not happy with I'm also always pushing Mariah to be you know more energetic even though she you know had been stressed lately and have I not been wanting to better our videos like you have better the videos are good I love our videos and I know you guys the feedback that you give us you love our videos but like imagine the amount of work and things that we can put into a video over the course of like two days instead of one day where we have to think about a video film a video and everything I want to put much more into our videos and make them way crazier and bigger than they have been I think posting three videos a week will let us put so much more effort into those three videos then we already have been and they're going to be so much better for you guys and it's just it's good all around be awesome and you know this might not be for a thing we might go back up to five times we might even go four times we don't we might do seven times yeah we might be vlogmas come on baby a vlog we gotta do vlogmas but once we get our house and you know we get things settled I think that there's gonna be a lot more things coming like there's so much that we want to do but we can't do yet vlogmas that just reminded me our vlog channel Marble Vlogs if you have not noticed me we've been slacking on that a little bit only because now that one of the extra days that we you know aren't posting on this channel we're going to be filming for that channel so then that channel also gets a feel of like more vlog style type videos just like behind the scenes stuff yeah so not bad news like actually good news the only bad news is two less videos we're gonna take a break for now we kind of just want to get our mental health backing track because it really is for me when I'm doing all this stuff and I'm like and I'm very anxious waiting to get in this house and I just I'm my mind's not on anything else but like this house and I just feel like we need to cut down a little bit get ourselves back on track and then come back stronger and I'm sure you guys can understand everybody goes through you know life struggles and I want you guys to know it is normal to go through it it's okay to feel stressed we've done videos like this before yeah but this one is literally like legit like where you know we just want to we want to talk to you guys and be get more close to you like everyone watching new or old like no matter how long you've been subscribed if you guys are supporting us we literally love that and we want to support you guys and just better at all of our experience on this channel we want to just be open with you guys share life time stories if we can do like story times I have a lot of things in my past that I could talk about with you guys and I'm sure so many things I feel like my past is boring she got a more unique past yeah I do have a unique past I just have my family situation your family isn't divorced my family is divorced so it's like that was sad that's not a bad thing like no but we just want to be open with you guys and do more of these type of videos to make you guys feel like you guys aren't alone in this world and you know our life is perfect everyone goes through stuff and you know look my hair my hair look at that what about I wore my hair like that my videos guys what's up marbles it looks like I just got like smacked in the head yeah sorry Mariah just messed it all up today yeah I made him jump the pool nobody's perfect no big deal and you know that's it yeah we just want to be open with you guys comment down below what you guys think you guys like their posting last you guys wish we posted more I just want to hear you guys input I'm sure you guys are gonna be very understanding you literally are so grateful our marbles one of you is the best squad and in my eyes obviously it's our squad like you guys are so amazing and we are so grateful for you and we just we just want to do so much and we cannot wait to show you all of this stuff coming up in two weeks about how we're about oh my god that's why we're so stressed out because they want to do more for you guys but we're stuck right now we can't I know we're in a freaking house I want my cat that hashtag bring snap back we want to see him again let it out that was letting it out it was like a zombie yeah but thank you guys so much for watching this video art is you got everything I think it's everything I want to give a notification shout out to a couple people from our last yeah cuz we haven't been doing post-migration shout out and that's another thing we forget sometimes to do that so we got to keep doing that was okay the first notification shout out goes to Jasmine Connichie Hazard oh so shout out to you and I should have said that right but shout out to you she said we need to get them to two million subscribers guys that is our 2021 goal two million subscribers guys let's get it we're a quarter of the way to the next million one thousand two hundred fifty you guys are insane thank you for all the support also one more shout out goes to Marvel com stuff so shout out to you and also shout out to Brianna Z and a rivet Kelsey Fenwin guys are awesome all of them are saying team bill is so awesome like all of them they're saying like team Mariah is a no team bill is a yes and that's all that's all that's all you new subscribers need to know team bill kills and in these videos I just noticed our ring light has been in the mirror that whole time well hopefully my head was covering it but yeah hopefully it wasn't like glaring for you guys before you leave make sure to like this video up that is how we know that you guys are loving the videos I want to see all you guys like the video before and make sure to check out our recent video because we just did a dare challenge and oh my god guys if you want to see a crazy video go watch that all right we will see you in the next video but until then peace love you guys


Hello everybody, so today we're going to talk about how cells communicate with each other. And I'm definitely a fan of communication. So I thought, oh, I'll go onto Wikimedia and see if I can find a picture of someone communicating something. And I learned that there is an entire category of images in Wikimedia that the title is People with Handheld Megaphones. Who would ever need this picture, like ever? But that picture is so awesome, I can hardly stand it, so I just had to include it as the beginning of today's lecture on how cells communicate with each other.  Keep your focus on me, I know that guy with his handheld megaphone is really awesome. But I want you to think for a second about our pathways that we talked about in anatomy. When you learned anatomy, you learned a whole bunch of structural components to neural pathways. And our structural components included like a sensory receptor that receives information and then an afferent pathway which is usually some sort of nerve that takes that information to the central nervous system where it's processed in some part of the brain, usually some kind of integrator. The message goes back out through an efferent pathway which is another nerve effector which is something that does something. The central nervous system as the integrator and what we'll learn here in this class is that the central nervous system is an important integrator and the endocrine system also plays a role in integrating that information coming in and out from the environment. But that, all those anatomical structures that are carrying information around, those really in the end are made up of cells. And physio is how do those cells deliver that information? How? How does it happen? Does the light stimulate an electrical message that travels to the occipital lobe of the brain? How does that happen? Well, that's what we're going to look at in this entire course. There are a few communication mechanisms or communication tools that we have to look at in more detail in order to move to the very next lecture which is on the endocrine system and the nervous system. That's where we're headed next to our big integrators. And how are they going to communicate information out to the rest of the body so that they can coordinate body systems so that body systems can maintain homeostasis? So this lecture is going to give you some tools, some strategies or some techniques that you can put into your toolbox that will enable communication in various places. And then we're going to look at, okay, what if you add this in? What if you add this in? What happens if we have this receptor over here in this strategy? So let's look at strategies first. Let's start out with looking at four different types of communication between body parts, between cells, between organ systems in the human body.


All right, so who is going to be the next net coach and a lot of the stories I read they list the The contender so to speak but one name jumps out of me that I think would be the worst idea that the Nets could even think about Exercising that's to bring Jason kid back. When is it ever worked out with Jason kid? He was with the Knicks Knicks actually had a good season with him. He got the most out of Carmelo And then he retired suddenly got the net job and then he wanted one more money after one season They let him go he goes to Milwaukee because they gave him more money and then he makes a power play and wants more power He's probably the most disappointed guy in LA that Frank Vogel actually has the Lakers playing great basketball.  He doesn't settle. He always wants more more more more more And I'm sure that when he took that Laker job, he said mogul affair. I'll get the job So you want to bring him back to the Nets? He's gonna be angling for Sean Marks's job that they do well the first season. He's gonna want more money That's what Jason kid is. Why would you get in that cesspool again? Well, but here's the question Michael What if that's what Durant and Kyrie you want?  I completely 100% agree with you. I wouldn't touch him with a 10-foot pole But you think it's easy for them to say no To Durant and Kyrie if they want some point you have to and I said this yesterday I truly believe it if it continues to go the way we assume that it's going that those two guys are calling the shots Through the owner Joe sigh Sean Marks is gonna leave right Sean Marks would get a job in a second Anywhere the job that he's done in Brooklyn. That's why I was surprised that he gave in to them When it came to the coach and why he's insisting it was his idea But all of a sudden if you bring back Jason kid not only a Guy who's not loyal, but will is a GM killer Who wants more more more more more when he just does his job? I'm sorry. He lost a job in Milwaukee He could have one there for a long time Because he makes power plays. That's what Jason's about But this is the way it can probably go down All right, they start you have to incorporate those guys in your your coaching search you'd agree with that, right? I mean you I would say you were you certainly you consult them You've set that tone now where you're gonna have to like run names by them kind of have them work in Unison with you if you're Sean Marks Jason kids name comes up Absolutely not can't do Jason kid. We tried that didn't work. We don't think that he's somebody that fits in here Don't let the door hit you with the good Lord split you that whole deal, right? And then Joseph sighs says well wait a minute. This is what they want then you're right Sean Marks can go okay. I resign and now he's gone So that's the power play how much power do you allow these players to have you already dictated who the Coach is by getting rid of Kenny Atkinson You're gonna make them part of the process and who replates Atkinson's Where do you put the foot down when you know that if you put your foot down if you're Sean Marks? It's probably gonna cost you your job So what do you do? I think you put your foot down and see if the owner sides with you and then if he doesn't you I can't imagine That the owner is gonna do anything but sigh with the players that he's spending all that money on Well, then that's not the owner that Sean Marks wants to work for I All the things you're saying are right, but it's it's harder. It's a tough spot to be it because It's not a question of I'm not gonna allow the players to have the power You've already given them some power we can agree with that So how much are when are you willing to put your foot down and what cost? I think it's here because you know if you give in to them on Jason kid you're gonna lose your job anyway. Jason kid's gonna come for your job It's a nice one lose it with your head held high I don't know if there's any relationship has anybody done the homework to see if that's somebody they would actually want I understand the fans bringing it up because even though it didn't work out with a coach He's still one of the great players in the history of the organization But but he left them high and dry There's no question about that and he leaves everybody high and dry I mean it just it doesn't work out with him Like you said it'd be a power play where any bit of success he'd be going after Marks's job in or he'd parlay it And trying to make more money someplace else He would be the he would be the parcels guy that during the parade is negotiating with another team the ball He'd be he'd be the Mike Keenan Pat Riley, right? He'd finally win a championship for Brooklyn and during the games seven of the finals He's on the phone with Sacramento trying to get money out of them


In Animal Crossing New Horizons, you finally get to bang the animal. Animal Crossing New Horizons is a perfect experience for veterans and newcomers to the series. Returning players will be happy to hear that all debts for previous games carry over into New Horizons. Additionally, this time around, players will finally be able to bang the animal. The newest entry into the Animal Crossing series is the most impressive and ambitious to date.  While you're friends in the business sector, Tom Nook controls the means of production, you can use the all-new Nook Miles tickets and your political influence to travel to other islands and leverage them for their natural resources. Remember that nature is yours to exploit. For the first time, exercise the power of eminent domain to move pesky homes out of the way for projects such as rivers, cafes, and boxing rings. Make society in your image just as God made man in his with Animal Crossing New Horizons. It is your right. It is your might. I am man that doth reign over the animals and this time I will get to bang the animal. In Animal Crossing New Horizons, you don't get to bang the animals, although if you take a look at Francine, she kinda looks like a human and low-key. I'm trying to fu-


Byddon expected that again. Is there any challenge I suppose because this is going well on Saturday? Yes. It's still coming off the back of a win which is an important win for them, which is against a good team in Millwall. They have still got some good players we should have known. It's a fantastic stadium and I'm sure our players will enjoy that because many have not played up before I'm sure that we'll have a good following as we do and you'll get right behind the boys, as you always do. So, dyna'n ei gwybod i gynllun o'r wych. Dao'i gynllun o'r cyftaith o'r drafodaeth. Rydw i'n cael eu hyn yn gweithio'r maes yn y casu hyn. Mae'r cyflwyno gyda eu hunain iawn i'ch cymryd ynddo'n ei gwneud, a'r fawr eich cyfryd yn gwneud am hyn. Ond, rydw i'n gwneud o'r maes, rwy'n dweud eich sylfaen hwnna'n iawn. Diolch yn cymryd i'w gwyro!


Public school student myself and as someone who worked with so many of you in this room on air quality and environmental health issues since 2008 we know that we have to do better for our air and our hearts and our lungs So since 2008 we've been working at this We knew then that New York City burned a billion gallons of heating oil every year and that just one percent of the buildings Generated more soot than all of the city's cars and trucks combined think about that for a moment So we passed stricter regulations and a lot of policies to clean up our air But this administration knew that we still needed to go further Because every ounce of toxic pollution that we removed from the air We breathe prevents premature deaths and heart and lung disease And we know that children and communities thrive in healthy environments We're tackling upstream and my team is so Fortunate to have so many agency partners here today who share that perspective the school construction authority is here Department of Education Department of Citywide Administrative Services Department of Environmental Protection our deputy mayors The New York Power Authority and especially the person that I would like to introduce now Mayor Eric Adams, who will take us off on this historic investment So much, thank you kids. You know just for your work in this area. What grades are here? What grades over here? Let me hit the second third third and over here Fifth so we have second third and fifth right Fourth and fifth I did I remember being here with your amazing Principal and team When I was bar president, I think you have a great food program, right growing healthy food and talking about food This this has always been an amazing school. Do you know who the school is named after?  Yes, who was he? Wow, you know even that And and and to the educators that's here, you know people often talk about the power of school naming and Why is it important to have schools that are named after significant people in the communities that students can understand? That is the answer to it, you know Every time a child comes into the school and walks into the building and they see that name They want to ask who is he and what has he? Actually carried out to allow himself to be named last week. I named a school two weeks ago I named a school after David Dinkins, do you know who he was? Who anyone knows who David Dinkins? He was okay over here. I see your hand, you know Who was he? Okay, you know back there? Yeah, all right He was the first The first African-American mayor in the city of New York. Do you know who was the second? Oh, who was the second Ha ha ha close who was a second, right? You know love it love it, but uh, uh, that's That's that's that rich energy You know and those you those are you who are educators, you know, teaching is a calling You you yearn for that energy every morning Even when our scholars don't get it 100% right that experience of growing that they get just by asking and answering questions Means a lot and the lesson plan must not only be the academics But what would make them emotionally intelligent and how do we develop their full personhood and this school does it so well I was so proud of the school when I was the Brooklyn ball president because it was innovative It was always cutting edge. It was always stating that we could bring quality education Into our communities this school gave our children a private school Education in a public school facility and we need to give it up for the entire team I'm just believing Just believing And so I want to thank Kizzi Kizzi spent so much of her energy on environmental justice And she's just a real leader in this area and that's why we're here At ps5 and bedside bed for stylus and I live near here On Lafayette Avenue. And so I know the school so well This is about how we deal with climate Chaos around the world. You have two mothers I like to say you have the mom that gave birth to you and you have mother earth And we must love both of those mothers because one gave birth the other sustains us and each time you see These storms that you're seeing you saw what happened in florida Is because of global warming you saw what happened Of last year when we had the heavy rain is global warming So part of what we are doing today is to make sure we create an environment for the future At one time we will have these hurricanes like hurricane ida And others they will come every hundred years But now they're coming often over and over again. So we have to be better prepared Both proactively and also to prevent and be prepared for the future It's clear we must make big changes And how we protect our environment our children our future and our families Today we're announcing A leading the charge a four billion dollar program to electrify Our city schools. This is so important four billion dollars Is more than four million That is a whole lot of money. It buys a whole lot of Gameboys, you know, it's a lot of money that we're spending and therefore main Foundations to this new program education environment equity and our economy Education every new york city school we build going forward Would be Fully electric no more boilers No more burning dirty fuel No more Contributing to asthma anyone has asthma in here Yes All this is connected to the environment and that is why we are here because there are high rates of asthma That's in this community and we chose this community first We will create a healthier learning environment for our students. How many of you knew That bad fuel contribute to asthma problems Right That's so important. We have to connect the dots Connect the dots The environment impact will be major. That's the second phase Education was the first the second is environment Our city Will never again build a new school that burns fossil fuel never again This will be the single most impactful energy initiative under this administration To reduce emissions For city government operations. This is so important. Your school is first That we are doing it in give yourselves give yourselves a hand What we are going to do in our school system is the equivalent of removing 26 000 cars From the road cleaning our air cleaning our environment and the third is equity It is also part of our agenda New York City will complete or start the conversion of 100 existing schools to all electric heating by 2030 That is so important and it's an important initiative Replacing harmful fossil fuel burning boilers. I was just in the downstairs in the basement The boiler is loud. It burns fossil fuel Which is causes a bad environment. We're going to replace that system And we're starting with this school. Dr. Ronald McNair school elementary school. We are starting here first The McNair elementary will become new york city first Existence school to eliminate the use of fossil fuel And provide all electric heating We're going to ensure that cleaner air Help the environment for our students and our communities because not only does it impact the school It impacts the community that we are living in right now like my neighborhood on lafayette avenue This would keep you and our hospitals Of from you having to go to the hospital and it would save lives So the whole concept of leading the charge will boost our economy expand the green workforce And we're going to continue to support the training and development for the next generation Of the green workforce by the time you graduate from school They're going to be jobs in the green environment that many of you are going to be experts in We're going to add a 14 million dollar program to hire and train a group of skilled trade workers Some of your family members. How many you have older brothers and sisters? So they're going to they're going to be ready to do this job in the green market. We're excited about it So this is more than new schools and building retrofits We're making big investments in our future our children and our health We already committed two billion dollars to get this work underway We're excited about it and I want to just thank all the agencies involved particularly The new power authority and their president ceo. Justin driscoll Justin, thank you so much. You guys are continuing ladies and continue to lead the way and we're we're doing something that's important We're honoring Dr. McNair Who this school is named after? He was an astronaut the second african-american man to go to space That's so important. How many of you want to be an astronaut because of that? Love it. Love it. Look at that He was a pioneer devoted his life to signing the quest for knowledge His mission was not just to explore space and break barriers but to protect the earth listen to his quote We should allow this planet To be the beautiful oasis That she is And allow ourselves To live more In the peace she generates So today we honor him But most importantly We not only honor him We honor you We say that you matter You matter by having strong educational leadership You matter by having the tools in your school And you matter by ensuring the environment is cleaner for you Just as we love and you love your mothers We all love mother earth And we're going to protect her now and in the future So I thank you for allowing us to start here At dr. McNair's school. Thank you very much Goodness gracious Thank you, mr. Mayor for your leadership and for understanding and pushing us right the prevention is better than the cure That's what we are here to do I want to repeat something you just said mr. Mayor because it is so important Every new school we build moving forward will be fully electric Our city will never again design and build a school that burns fossil fuels This is a big deal Until recently would not have seen possible to electrify a school system that not too long ago was burning coal What's different today is that we know that the climate crisis requires us to stop investing in equipment and infrastructure That hurts our health and hurts our planet and that is why we're leapfrogging our investments And we're going to focus on delivering the next generation of green clean and healthy school buildings We're also leading by example Building on the work that we did with the clean heat program We will face out the use of number four fuel oil in our schools four years ahead of what's required by local law Without any capital investment in prolonging the life of those dirty boilers We are starting with environmental justice communities to improve the air in areas that suffer from high rates of asthma attributed to air pollution This is a huge step forward in decarbonizing our buildings and will help us reach our ambitious climate goals While also creating healthy and comfortable learning and working environments in the near term It will also help us grow our green workforce as you heard for the future and lead by example In how we're going to focus our capital investments on climate smart solutions and environmental justice All people regardless of their race their disability status their age Their socioeconomic background have a right to live Work play and learn In communities that are safe and free of harmful environmental conditions To the students in the room. I want to say We got you This administration is taking our role in fighting the climate crisis very seriously We got you i'm proud that your school will be the first one to take the step to stop using fossil fuels To our agency partners in the room. I say thank you I know this was hard. Thank you for the long sessions working through intricate details to make this historic commitment happen And to our community partners and our advocacy organizations. I say we hear you Thank you for your tireless efforts on behalf of our communities. We appreciate you We can address climate change in our city with a focus on justice and health Thank you for your leadership mr. Mayor And now I will pass the mic to none other than the principal meslina gaze Good morning First of all uh to our mayor honorable Eric adams and his staff To our superintendent brendan mims who is here with us today To all of our elected officials in the building To our community representatives and to our school construction authority who helped this to happen to ps5 today And to our wonderful teachers and staff. We want I want to say good morning And thank you Thank you for the opportunity to bring this project here to public school five the dr. Ronald e mcnair's school What this project is going to do for us first of all It's going to make sure that this environment where our children are learning Is going to be a safe and clean environment for them For our community it's going to clean up the air in our community also providing a safe and safe environment for our community And what it's going to do again for our schools It's going to help us to begin to teach our children and instruct our children about what this whole project means About clean air about what their future is going to be like when they take on this responsibility These are the children that's going to pick up this project and they're going to move with it Move with it. We're doing this for them. Thank you very much We we are going to open to a few questions, but before doing so Today this morning We lost a real giant In our city Dr. Calvin Butts of Abyssinian Baptist Church He was not only A spiritual leader. He was a dear friend and mentor He was struggling with cancer and he transitioned this morning And throughout my entire journey Dr. Butts Has just mentored me in some of the most difficult moments In the city speaking him with him recently as we dealt with the issues around the Migrant crises and other crises. He has been a constant A leader and so the city lost a real giant And our hearts go out to his family And it goes out to the members of the Abyssinian Baptist Church not only in a village of Harlem But throughout this entire city Well, thank you very much. Welcome to a few questions Always good Katie Students that's katie back there Hi Thank you for the question anthony fiori department of citywide administrative services So the total cost of the project To retrofit a hundred schools To improve the lighting improve the ventilation. We're committing four billion dollars as the mayor said over the next several years Retrofitting these schools There it's a difficult task, but we are set to do it We've spent many many hours Amongst all city government operations and I have to say I've been in city government for 23 years There's never been a moment where city government has come together like it has now It's an all hands on deck moment and we're coming together to effectuate these projects Yes, um students that's steve. He comes to all my press conferences He's on radio. What station? Wcbs, you know, uh, so when you hear his voice, you're going to say we know that guy um, uh, 100 is the start And what we did was we looked at those areas like here that was dealing with real Asthma issues and other health issues related issues to come up with the first 100 But our goal is every school every school. Um, as I stated about 2030 That's the goal, but this is just the start And our goal is to continue to move forward Okay, okay. So students This is the time I should have all you students come up here next to me Because this is the time that people like katie asking me difficult questions This is called off topic They enjoyed his parker. This is the time they get to beat me up You know, so I want you all to watch the off topic So when you have to go in front of the classroom and read a book report on essay, this is how I feel right now.  Love it, okay No, and smart on the part of the new york city police department. We monitor social media. We monitor Communications throughout the city whenever there's chatter That indicates that something is going to happen. We like to place officers on high alert If there's an incident that happens in another city somewhere and we pick up chatter We like to use that intel to place our police officers on high alert and it appears as though there was some chatter by extremists Organizations and group that gave an indication That they wanted to do something that's disruptive and so the police department was on top of it So, you know, that's what we do all the time. Um, if there's an incident, we like to stay on top of it right away Without licenses How big of an issue is this and what plans does he have to address it? You know, when we legalize marijuana Some people didn't get their actual memo. They believe that you can just start selling it openly And there's a clear plan on how you can legally sell Cannabis and what we are doing now we have to catch up to the law that was that's on the books To what is happening in the store in the stores like a police officer can't just walk in and uh conduct A you know a apprehension on arrest or confiscate the item. There's a process So we are partnering with the marshals the sheriffs and and going in The head of the sheriffs Anthony Miranda has been doing a series of things On going and doing out an issue purchase making sure you build the case So we could go and crack down and shut down these operations now in in january We're going to go back to orbit albany And modify some of the laws that we can go in and not have to go through these long procedures That we could immediately confiscate and in those cases where you have habitual offender abusers of the system There would be apprehended, but it's an issue. It's not at a crisis level We're going to address it. We we targeted those trucks that were selling on the streets Using the marshals using the sheriffs and we're going to continue to crack down on these crack down on these locations We're asking people who identify shop to immediately notify the local precinct so we can start our operation there You know, I like this guy We saw recently that private security has been hired to go into the subway system and look at fare evasion I want to see how much that's costing the city and how do you reconcile your your cause that the subway system is relatively safe when we see extra security going down Because as I stated that we are we're dealing with two issues We're dealing with the actual six felonies. We have a day We want to turn those six felonies into no felonies We're also dealing with how people are feeling We have 3.5 million riders and I'm gonna keep saying this over and over again 3.5 million people use our subway system and they get to and from their destination with no problems at all But if you are seeing disorder if you are seeing people loud disruptive of Cursing acting disorderly it's going to play into what you're feeling And one way of making sure you feel safe as well as going after those who commit crimes Are the uniform presence of people have stated when I'm on the subway. I'm on the subway a lot I was on all this week. I'm going to be on today People stopped me and they say we feel better when we see that uniform officer walking through the trains We see some former security personnel. You have a number of mta police that are with us We put a thousand new officers on on the trains And so we know that uniform allows people to feel safer and we want to do everything possible I heard new yorkers. They stated that erig yes. I use a subway every day Never have an incident, but I feel unsafe based on what I'm seeing And so we have to address what people are feeling and that's the goal now. What's what's fascinating Is that the last time we had Real ridership was in 2019 our Index crimes are lower than 2019 2018 2017 and the last 10 year period So the numbers bear out That the officers are doing an amazing job But that means nothing if people don't feel safe and the best way to do that is have the omnipresent of our officers Yeah, yeah, come on man. I said I love uh, I like you. I didn't say I love you I mean Do you have any reactions to what could be uh We should never use that company again in the city of new york and really I believe in the state of new york I know that we won't be doing that Uh, that that company caused a great deal of anxiety in the city in all of our nitra facilities and General but specifically in the reshouses. It was unacceptable. All of us remember that weekend Of the constant uncertainty they're having to deploy the resources are there So we're drilling down exactly How did this take take place? And you know, I I just really hope we get to the point where nitra is fully under my control I want to be held accountable for it And to make sure that we can hire and have the right people there. We're looking for a new chair a new head of nitra Uh, and we're going to find the right people in In partnership With the oversight that's in place right now to make sure things like this does don't happen again These are my favorites, so I'm just sort of Oh Jessica cat's my chief housing officer She's doing a review and nitra is doing a review And as soon as we get it, we want it wanted to be thorough as soon as we get it We're going to make it open to the public so folks can see exactly what happened during that incident I'm sorry. What happened? It was closed. It was to what is it called key space? Yeah, that should not have happened unless it was a real imminent safety hazard Let me look into that. We're clear those that are abandoned or those that are dangerous There's a Sign that's placed on them with a warning and then of those who own them have an opportunity to repair Or to dismantle I have to look into that because if someone came in and removed it without notification That is not the procedure of my understanding, but I look at I thought you said it was kinky shed Pinky, okay pinky. Okay. Okay. We just didn't want anything kinky going on inside that shed Yes Thank you first go ahead students who has a Yes I would love to is it you're gonna take me there You're you're going to take me to the aviation is this is where you learn how to simulate in flying? I would I would like to I know you I would like to do that, but I know you find it hard to believe But I used to have hair that long Okay Thank you all the five boroughs our goal is to look at all of our schools and electrify all of our schools So all of the five boroughs not just brooklyn. Okay. Thank you