So it's a it's great to be here. My name is Matthew Radcliffe and Radcliffe on triple.org A little bit about myself. I was first introduced to the postgres SQL database management system with postgres SQL 8 Well distracting sorry I've been around the community for several years You may have seen me around at some triple cons in the North America. I was at Munich, but generally can I keep to myself? so I was first introduced with postgres SQL 8 and Doing an ERP migration from Oracle 8 in 2007. I It really informs me at that point I have to start taking into consideration other database management systems And so when I approached the Drupal module development I tried my best to support as many database management systems as possible I consider myself a hobbyist contributor when it comes to PG SQL and postgres SQL I'm not a database administrator, but I've learned a lot just with Hacking on core over the years. It is my first time to speak at a large conference. I Don't often get up to speak. I prefer to kind of sit back in the background and code but This this discussion needed to be had again, so Here we go. I'll try my best This session this core conversation is gonna Go as follows we'll briefly review the past I'll say briefly because we don't really want to get hung up on on the past situations and then detail what the Current situation is with the PG SQL driver for people who want to work on things now and And and so go over the issues and then we'll look at Reviewing options for removing from core and and then finally At that point, I'd like to open up the conversation to looking at the future of Postgres SQL and database abstraction in in future Drupal versions Here we are again, this isn't really the first time we've had this discussion Over the years, we've you know Postgres SQL has been Has worked on and off again people have it's not it doesn't satisfy the 80 20 argument of of weather of Users so the majority of users use a my SQL or my SQL like database management system We have bugs in Drupal 7 and some people consider them critical bugs enough to just not use Postgres SQL Right now unless Someone has made a commit in the last hour Postgres SQL driver is completely broken in Drupal 8 So yeah, just it's a no-go. You can't use it So the question is should we continue to support Postgres SQL? and And why should be supported if we are gonna support it and this kind of leads into database abstraction in general and Database abstraction is a is a challenge. It's hard to get right. I'm not sure if there is any Framework out there that implements database abstraction database abstraction layer perfectly And it's a challenge not just with databases, but with platforms in general And programming language standardized libraries frameworks. They're all complicated System they all have Issues that need to be solved and the cost to port or maintain, you know platforms and standardized libraries and database systems is is pretty high Sorry, I say I'm the one So frameworks database Abstraction layer makes it possible for us as developers to choose a suitable database to use for applications and Each SQL implementation as we know is uniquely powerful and implements the SQL standard in a certain way and And so many but many database abstraction layers only implement the most common concepts And so this is the first problem. It's I call it the common denominator problem and that we often see database abstraction layers going for that that database agnostic approach and This leads to the first criticism of database abstraction layers in general being that They're no good many people Not many but I jokingly say that database abstraction layers has made some people very angry and has been widely regarded as a bad move But in defense of database abstraction layers We It's not just about the You know, whether you support one system or another you have code reuse and other benefits to using a database Abstraction layer and so The common denominator or the database and agnostic approach is just one way of implementing it back in 2006 I believe we have the the four types of database abstraction layers that was defined But in a blog post One is just providing access to a database Two is providing a common interface to different software Three is actually writing portable code so that you know, you can you can make that intelligent choice And four is just is the object relational Mapping or warm or M so In our case, I would consider Drupal still type two in that our code is importable in all cases and Where it is implemented? The spec the specifications are pretty in just in general, you know, we've gone with that database agnostic approach Rails active record You know implements an ORM if you're not familiar with that Doctrine's DBL also implements an ORM so the the next issue with database abstraction layers is That and and this is very particularly to Drupal is that frameworks Implement them for a completely different reason than we implement them you know if you think about architecture and as a developer and you're you're coming up with a Solution to a problem from the ground up you're going to make those architectural decisions when developing and then choose the best tool for the job and So abstraction layers present in frameworks are really suited for that purpose there's But when you deal with Drupal, which it comes out of the box We have to think about you know, we basically were forced into thinking of things in a database agnostic approach and so Our architectural decisions are probably different than what you would get with Doctrine or rails as a framework and Finally the the third challenge of database abstraction is of course business value Is their value in having support for different systems Primary value is code reuse and it saves time To use a database abstraction layer in most cases But you know some customers want the best they can get from a system So when they're evaluating a system, they're going to say well Drupal may have performance issues because it's using database agnostic approach and thus maybe I should just go with a custom solution and For this reason we see More recently backdrop has dropped support for both PostgreSQL and SQLite and they were considering getting rid of What database abstraction layer they had in core and In and basically evaluated as such It did not have enough business value So with that in mind, I kind of you know as I researched the and I've been looking at PostgreSQL driver for a couple years I've developed my kind of my criteria for keeping PostgreSQL in core or not Or room or removing it and that is we should remove PostgreSQL driver Support from core if it provides small value to the Drupal community And if it is given low priority to fix critical and architectural issues with a storage interface And I think you know Well do is I'll approach this you know both of these these things throughout the next slides Well first let's take a kind of a look at the past and I guess Holly isn't here But I hope she's listening and she'll watch this later. So what what is PostgreSQL if you're if you are Unaware it is an ancient strict free open-source relational database management system. It's been around for decades it follows strict typing and standards and here adherence as Only an open-source database management system would do and it's free and open-source so it's It's got the PostgreSQL open-source license, which is Managed by the PostgreSQL development group, so it's it's pure open-source software Maria DB is probably the only other one other than SQLite Being in the public domain So we first got PostgreSQL in Drupal 4 and And this was of course if you're not aware of what we were doing back then we just basically had okay You can you can do queries right And then in this involved over the time over time so in Drupal 6 we got the schema API so we could then you know Provide a generic type for column Management and table management and then finally in Drupal 7 we you know We we got that the next step in database abstraction with the DB TNG and a real abstraction layer And so PostgreSQL's use use has evolved over time You know there was high hopes back in in Drupal 4 and Drupal 5 that we would start You know we'd start increasing the user base of Drupal to include PostgreSQL users but in in my mind it really has Evolved into basically a litmus test for whether In an alternative database system can be used with Drupal And that's pretty much the reason it's still in core And I'm gonna say that that test has consistently failed We know that PostgreSQL is broken or our driver is broken You know you say we failed you know Why did we fail well for one PostgreSQL is strict and so If you only test against the database system with the you know loose adoptions of Standards you're gonna run into things like the autocomplete bug and this is was present for a while in Drupal 8 If you would go to User slash autocomplete it would load the access callback For user slash percent user so the user access callback which would then Try and do a user load on the string autocomplete. This is garbage We should not be trying to load a user with this with a string identified by a string if that database Schema says it should be an integer So this was a bug in in menu get item or in the menu routing system somewhere I believe it's no longer the case in in Drupal 8 and But in our defense We have lacked the tools such as automated testing to discover these failures and fix them so It's really you know we failed but you know we really didn't give it a chance So it's kind of depressing. You know we failed whatever the current state of Drupal of the Drupal database abstraction layer is it's pretty much almost a straight port from Drupal 7 We've added some some some methods on classes we brought views in the core which deals heavily with with querying databases and then finally we've the only other changes We've abstracted storage in the way. We're a handling schema management away from the database drivers and into systems like cache and config and entities and field storage and with these things we get to how PG sequel is implementing Implementing them and the in the way is implementing them is poorly so Really we can boil that down to kind of one decision In the last couple years and that was the issue 1167144 and Is it not a bad decision? You know we decided that and the cracks of this issue was okay. We have a cache system and We don't necessarily want to always have a storage storage for that cash system In fact, why would we want to create database tables for cash if we're not going to use the database for cash? so the what what happens in in in the cache database back-end is it it will try and delete and query for for the cache and if it receives an exception it will then Try and see if it can create the table and if it's if we're using the database back-end And we're doing this in a transaction. So the the the main issue there is That postgres SQL will just roll back and stop Whereas my sequel or Oracle should we'll do implicit commits a couple other issues with our storage system is More recently this was fixed for postgres SQL, but there's a follow-up bug for SQL server We have the content entity database storage class and so we this is Another good thing we we have removed Drupal write record and that was doing you know, we've deprecated that I'm not sure if it's actually removed But it's deprecated and so they just had a lot of logic for how to handle Serial fields in in drill. So we basically if you remember dribble write record you you send it in an object just a standard class object And what would happen is we would just unset Properties and then send that to the database. So this is kind of like It's not great. You know, we want to use an entity And and call save on it and then have that go to wherever storage is necessary either config and and in the config storage system or into the content entity storage system and And so we're not handling serial fields properly and in in SQL server And to digress basically if you do an update in SQL server You cannot you put the primary keys and try and set the values of primary keys and so that that actually was we found that the the new SQL serve Module maintainer as you know found that out Just last week so we created an issue for that So the the other thing is we currently Don't have an official testing infrastructure for for postgres SQL on QA dot drip a lot of work so anything we're doing is Untested I'll get to that moment. It's not quite untested anything that the rest of core is doing is untested And also, you know, we're missing functionality because we have because we have a broken driver You know, we we're lacking things that are really cool that postgres users want and that's schema support You know, we only support the public schema We don't support a JSON type. We There's cool things that buzzers like post-GIS and we don't support that One of the reasons why you might want a schema other than public is to reduce your vulnerability for PCI compliance And just to if you're really stickler for for how you want permissions to be set up for applications accessing a database To remark on the testing infrastructure. We're making really good progress last year You know Jeremy Thorson over there Had the goal to provide test We had this goal to provide testing infrastructure for platforms languages and database systems So not just postgres SQL and SQLite, but also testing against PHP 5 3 5 4 5 5 and You know, who knows other other platforms operating systems and so Really, you know after some good progress We're you know running into difficulties because our testing infrastructure From Drupal 7 just wasn't going to cut it. So that kind of morphed into the goal of let's just re-architect our testing infrastructure Little work was lost but and so we had to start over for a postgres SQL and I think within the last three months since Austin Is that three months? four months We've we've really made some some strides there for being able to handle Different database systems in and platforms and spin things up So I kind of an exciting ground with things is yes, you can help Even if you have never used postgres SQL or SQLite before just For you know us a little straw pole here Raise your hand if you have ever participated in a core sprint Also, if you had if you have not raised your hand, I highly suggest that you come on Friday If you need any help whatsoever Core mentors, you know, we're happy to help out Raise your hand if you have worked on postgres SQL or SQLite or an alternative driver at a core sprint five people and I was gonna include his next little question, but I That I think that we'd get the same number of hands, but up until yesterday. I had never Worked on a driver issue with anybody else in the same room It can be a little depressing when you're only you're the only one working on drivers Just just because there are other issues going on other movements that have more momentum so One of the things is if you've never installed postgres SQL Or SQLite do it and get it on your development environment. I think any anyone who's working with core especially if you're reviewing things should have Have these drivers have database systems set up on their development environment and It used to be kind of difficult, you know, I don't you know, who knows how to set up postgres SQL here a lot of people, okay Well, that's not not a really good poll, but a lot of people don't you know, that's they're complete I don't know postgres SQL. So To make it easy for you and for people who don't know how to do it I you know, we have vagrant we have puppet we have you have methods of solving that problem It's solved now in the last couple of years. Thanks to the DevOps movement So I have an environment if if you want to use it It's debbie and based You know whatever I'm not a debbie and fan particularly but you know, that's kind of what I I forked off with someone else is Jubilee dev environment So with that said We have one meta issue about supporting postgres SQL and so that's that heading up there and A couple of issues the first one is just briefly Our index key length is too long So if you try and create a field that has a really long name by default Drupal is going to use the the field name is the key and So in postgres SQL it's limited to 63 characters and So if you have a really long name, it's going to do try and use it's gonna truncate it and try and possibly Try and use an index that's already already exists and you're gonna get an error So there's a path for that probably needs to be reviewed. I think that yeah the patch actually needs work You discovered yesterday doesn't pass our tests The next issue which is now in green needs to be committed is our transaction handling But this could you know, if we wanted to start thinking about the future of storage there there are follow-ups for this and the Transaction handling is all about handling the the faking out and handling implicit commits in postgres SQL So what what the patch does is it wraps all queries? That are in a transaction in a save point to emulate the behavior of my SQL Might be a little performance issues on this, but I haven't really noticed too much on on recent versions of postgres Our current status is RTBC unless someone's committing it right now They would do that wouldn't they And and the reason is so this is our current blogger if you have this patch Are the postgres SQL test spot that Ricardo Amaro is has has up on his personal site We'll reveal that we have 208 other Exceptions going on instead of not being able to find any so so this issue really is is the the first thing to solve You know other issues that are important, you know our case sensitivity on column names And again, these are some of the issues that are in the meta the next one would be the The the goal of providing test bots for everyone on the new infrastructure, so that's really important So it's not related to postgres but You know I as I was making this you know editing these slides I noticed that that we're gonna have sprints related to the test spot infrastructure and the goal of getting it all set up this week So you should probably learn more about that Jeremy and Ricardo session tomorrow at 1045 Modernizing the test spot feature triple dot org automated testing Finally, you know feature-wise if you wanted to work on non-public schemas. There's an issue for that Another issue that slipped by is is all the other drivers and it I think I think sequel I did this Maybe they they have a dummy one But the other drivers in core implemented the copy table method and this was not done in the postgres See what driver for whatever reason? the There is no reason to use copy table and core and so I think CHX has Said that we possibly could remove it But I mean it contrib might want to use it So there might be a valid reason just to implement it in postgres finally The file list view in Drupal 8 is broken because of an ambiguous column And this is not to deal with the file system, but more to do with views So there's there's an issue going on deep within views and on on when it's doing group I And it has to do with file managed and File usage if I recall correctly So this is a this is kind of exciting, you know We have we're on the brink of just having postgres SQL work for the most part And being having it testable so Let's talk about the not so distant future Drupal 8 and beyond And I think we should ask ourselves is should we continue to use postgres SQL as a litmus test For a Drupal database abstraction layer and supporting alternative drivers in triple and if it if we do want to Have it remain core. Can we actually prioritize? our driver alternative driver so they're not having to play catch up but First let's let's look at just what it would take to remove postgres for core and and maybe you know remove Moving it to contribe so One of the things that you know as a problem with Drupal is you know We're we have that database agnostic approach So we we haven't optimized our architecture for my sequel and my sequel like drivers We have PHP things in in our code. We're working around PHP quirks like No and default being different in postgres SQL We could be using my sequel specific features We could remove the hacks that are increasing our code complexity that we've added over the years and Finally, we could just start analyzing all our queries To see what we can do better for my sequel and my sequel like Such as your MariaDB. That's that's what I mean by my sequel like So backdrop CMS already did this it wasn't that hard But we have to ask ourselves a question is is when my sequel and and Maria or or the other forks start Really branching in in features What will happen then in in terms of how we support things and well, we'll probably be in a similar situation The next benefit of removing from core is that can truthfully doesn't have the same constraints as core I mean We can rewrite everything we can extend classes and in triple eight gives us his power specifically say checks Krell they worked on issue to to basically give us a mechanism for overriding storage classes So we can we can rewrite or we can extend the cash storage the entity storage the field storage all the storage and and get rid of Or redo the way that entities are saving things and You know all the contrib drivers are gonna have to do this to some extent Oracle SQL server MongoDB specifically And I think it's it probably is increasing our burden on security just because we're rewriting subsystems of Drupal And and we're just kind of we might be changing the way things are behaving But this is possible. We love alter, you know, we love to do this. I Love to do it. Is everyone else love rewriting things Extending classes. I like I've done it. I think some other cases The installer we could look at making it better and we might be hacking the installer I don't think we should do it but Again with some of the reasons why we have our transaction problems is because of the Drupal installation lastly We don't need to test all of Drupal if it's in a trip and we can focus on just testing what we need to we can Basically storage only tests take a set of queries and shove it through all the methods That we're trying to so to emulate things like The the the serial fields being set in a certain way to emulate Drupal sending an array when we should be expecting a string on our in our column definition and and this is very similar to how doctrines DBL unit tests and You know, if you're not aware of that project It you know, it has unit tests for both my sequel and postgres and sequelite And it runs about 30 minutes for for all those tests and it does my sequel about Three times and postgres about three times for various versions So the These tests are going to require infrastructure and if you're we're just in contrib We really need to have testing infrastructure Available to us to in order to test these things Maybe that means going to GitHub and then and working with Travis CI so just a risk of going down some risks of moving into contrib is is we're playing catch-up and Removing from quarry isn't going to change that. It is kind of difficult to change for that's that's up for debate The whole idea that we're supporting querying against tables that don't exist is weird It's kind of hard to change our our complete just start rethinking our storage doing that I mean that would take a lot of work in addition to maintaining a contrib driver Again, we have to work around this and decrease performance We run to the content entity database storage systems where issue where you know when you update in Postgres SQL when you update a primary key field or Sorry, just a sequence field your you want to set default sequel the sequel default type and The way you do that in PHP is different from the my sequel PHP driver and the Postgres SQL driver. So we have you know certain PHP issues And again, we might run to the same things in my sequel with my sequel later on Yeah, we're playing catch-up. So we're still gonna be playing catch-up and We're just gonna have to make more workarounds and possibly decrease performance any more So if you were using Postgres and sequel and core or sorry as a as a user Would you still use it if it was in contrib? I don't know It's gonna be more difficult to introduce things like the JSON schema type And we're gonna have to have to cooperate with a lot of contrib developers directly As they'll have to write if you wanted to have JSON storage and have a JSON field type You would have to code around the case where you install that on my sequel If you wanted to be a good contrib developer, I Don't like installing having my module fail when it's used on in different situations But yeah, you know things like post-GIS, you know, it's gonna be difficult to implement those things in contrib I in my opinion As we you know, we we don't have we're not in core and we can't provide fallbacks for other for other drivers But we know we could probably get that into contrib a lot easier And lastly, you know Moving from core would further marginalize the Postgres SQL user base. However small and it is I think, you know, we don't see many Postgres SQL users because the experience of using Postgres SQL is not great You know, I wouldn't want to use a driver that Has these issues. So I probably wouldn't install Drupal on Postgres SQL and we see that again and again as Postgres SQL enthusiasts Try install Drupal because it's supported find out that it's really it's broken in many cases and then just stop you know Stop using Postgres SQL for that project and use my sequel So this is discouraging For users, it's discouraging for for people who work on the issues. I asked You know where I was working on a core issue and I asked a Postgres SQL user friend of mine to review and he got frustrated with the whole process and use some language that I can't repeat That's that was kind of disappointing to hear from him actually So it's it's difficult to regain trust and rebuild confidence once it has been lost Just from a consumer standpoint, you usually if you have a bad experience at a restaurant, you probably don't go there again So that's all that's left are altruists and dabblers and that's That's really not gonna You're really not gonna see any there's no really need for Postgres Drupal in that case But if we want to do it, how do we get there? Well one again, it's pretty easy to remove Postgres SQL support We have the patch, but I would also like to see some responsibility taken for our failure of not supporting Postgres and Maybe a blog post or something from the Drupal Association saying hey, here's the situation We don't want to lead you into false pretenses. Here's what we're doing. We're gonna move it into contrib and Possibly help the contrib maintainers or of any database system with infrastructure and testing and Then I think we we should keep the dialogue open for a triple nine in case as we look at database abstraction And our database abstraction learning and how we're improving it and how we're approving our storage For for ideas and that that leads me to the the not so to to beyond There's been one Proposal of keeping the database agnostic driver for for tests and making it more strict and and then Basically, I think CHX came up with this proposal and then then having more performance Drivers do specific things for SQLite Postgres SQL probably not SQLite I'm not sure of what you can do there. Maybe you can pair it off with some other driver of some sort And then also for my sequel we probably you can do it. We want to do it for Percona and So this really takes into this approach was I think we first discussed right after triple con Austin and In this year And it's it's based on the our current functional QA approach So, you know, we have our simple tests and we run them run them against a database agnostic driver And that's how we do our our thing. So this would be more code to maintain but it does fit the criteria of Having you know of prioritizing our database drivers if we're gonna do that There's a there's a session about this very thing tomorrow in this room at one About the future of Drupal functional testing. So I think the when we discuss how we're how we're going to How we're gonna proceed with you with this approach it really depends on our How we're gonna proceed with testing in general Lastly we could switch to doctrine slash DBA. Oh They support more than just those three drivers They support Oracle although they only have tests for my sequel post-credits sequence of light DBL has code that's technically discouraged a lot of our patches For doing workarounds we're all Usually at first go into string replaces in reg X and we discourage that although that's up for debate because A lot of drivers do that outside Drupal And In ours in in our defense our database abstracting layer has some things that are kind of nice the transaction system the storage abstraction So it may be another approach would be to take doctrine doctrines kind of set up and split all of our drivers away from core or have you know Drupal slash DBL and then have just a specific team working on database abstraction You know this again, this is probably not for 8.1 We have to solve other issues like composer I think this this has some You know again, we have to look at what we're doing for testing for that In any case, I think you know Go go back in the future of post-credits equal rest in that it must be prioritized or else history will repeat itself We need testing infrastructure We need to be a little less selfish about our patches and taking other systems for a spin and that that's not just for progress and We need to make our database abstraction layer and storage abstraction layer more maintainable and So in my opinion if I think we're on the right track We have the initiative set up to to improve our testing infrastructure If we are prioritizing post-credits equal then then that meets my criteria, and I think it we should keep it in core But if we don't prioritize it then by all means let's let's get it Let's let's remove it. We you know if we're not going to prioritize it. Let's get it out So I would that I'd like to kind of open the conversation up and in case we want to talk about questions about post-credits sequel currently or The future of database abstraction if you want to talk about what we can do in our storage in our storage layer and If you are not busy you can fill out the session evaluation while you're at it Yes, please use the microphone so first first a couple of comments and then maybe a question Comment first in Drupal 7, you know we talked about the dismal state of the post-credits driver It is actually mostly usable with a few patches I'm one of those crazy people who has production sites in a running You know high-traffic sites running on post-credits and running quite well I've got one site in particular It's got over 20,000 nodes and it runs really really well on post-crest So don't don't think because it's not perfect and because you know the post-credits driver second certainly been a second-class citizen That it's not possible to run on post-crest at all. It is The second command is is with regards to testing I'll give you a preview of some of the things Jeremy's going to be talking about tomorrow I want to give away all the secrets But we have done a lot of work over the past three or four months to revamp the testing infrastructure I'm one of the people who signed up and said hey I want to make sure the post-crest runs better and so got got sucked into the Into the test bot world and learning things. I never thought I was going to get into but but you know we But my point there is that The only way we're going to be able to know what's the right path whether to Improve it and core or take it out of core is to measure Have a measurement of what's failing and what's not failing and and that comes back to testing So testing is obviously an important part of that So I guess my question is is a question to everybody in the room Who else is willing to step up and help do testing help? You know get get some of these issues fixed and so that we can get them committed Or or as everybody consigned to the fact that it's always going to be a second-class citizen So I'll just I'll just leave that out there for you to think about So your question is is anybody willing to in this room even with the limited number of people we have in this room went to to do a little bit more effort in their core development and take postgres sequel for a spin work on some issues and patches and Just in general You know whether we should be treating Postgres sequel as a second-class citizen and I'll start I think that if With the improvements that we're making a We probably Aren't going to be treating postgres sequel and sequel light as second second-class citizens And if we think about the future we could probably start thinking about all the database management systems as as equal Just to the to some extent Can you step up to the mic, please? And make sure I'm not I wasn't sure if the mic picked up everything that you had to say I mean I heard it, but I'm not sure if the mic picked it up. I Just wanted to say Squirrel light is a requirement for droop late. We can run tests without a skylight So it's a first-class citizen postgres is a questionable actually so I think the actually what needs the Describe the state it's a there's no Features or profit that postgre could provide Most of the there's no Big crowd around because people doesn't understand the Features the profits that what postgre could get could bring also postgre has a object model so it's a Plus one for country because we could ever write in droop late a lot of storage beckons To make them really fast for one postgre so So I I'd like to Hear a proposal any proposal how we can allow Storage driver That supports just simple operations in core to provide altering of controllers at least Providing altering of control you repeat that was you could save entity by using a variety of storage controller To reusing the storage model of postgre you can make a Clone of records So it's a different storage model for entity Right to summarize Wait when you said the first thing you mentioned was that there is little value To having postgres signal in core right now and the reason why is that one signal light? We depend a lot heavier on SQLite, so it has value to core developers I Think you know just in terms of core development. That's that's true right now. We we don't have Much value for it other than being a as I said a litmus test of what's possible But I think we we could have value in postgres SQL But again, you said you you think that it should be in contributes so we can get that value first and then as we go And I think that's perfectly a valid scenario The second thing you said was is that one of those values I think is what you said one of the values is to to use post is to be able to use postgres SQL As a document storage and a document storage model. I think actually I was talking with Damian turn so I can't pronounce his name With commerce guys and he was mentioning it. He wants to work this week on Trying to use postgres SQL as a as a dot in a kind of a document storage model By supporting the JSON This week. Yes. I yeah, I was like, oh, okay Maybe just wants to play around and and look at the possibilities if you're not familiar if we supported the You know if we had a table that stores in JSON We could do things like storing the entity, you know in JSON and then querying the properties of that JSON object. I Think maybe I I'm not too to experience with with doing queries on With the JSON type in in postgres SQL nine one, I think we're nine two But yeah, it that it has a lot of value As a end user if if we were to keep supporting that and it's a little harder to get that support in contribute in my opinion and last one think I Want to mention it's a postgres community we looks interconnected from them they very open and Wish to help Drupal to evolve driver and storage and The I need to the conference Some days ago So they said The Drupal should use object model and they wish to help So it's another resource and another value So you're talking with the with the postgres SQL community Recently and they were suggesting that we switch our whole storage model to to being document object the document object model Has its advantages. It also has its disadvantages as it's denormalized, but and the other thing you mentioned was was that the The community was offering to help us in the Drupal community accomplished that so that that is a Really cool proposal because you know in the past we you know, we know some of the comments that Some core developers have had is that where is the postgres SQL users? Why aren't they in the issues? and so It would be really awesome to see and have that discussion and and in in the issue queue about about ways we can improve Drupal for for the net, you know in as we start changing or you know As we start thinking about Drupal 9. I think that would be the appropriate Discussion there or or how we could do it in contrib I think it would take it'd be a really big module in contrived to do that So you're thinking about you know have a You know to start with maybe having keeping the core driver as he is and then then working on a Contribute I think that's great. Does anybody else interested in that one of the comment I wanted to make about about one of the the pros of not splitting You know the postgres driver often to contrib but I got thinking about was other third-party modules one of the problems I have had with with Drupal on postgres is Is not necessarily with core but there are a lot of third-party modules that that obviously don't care about anything But but my SQL and I'm afraid that if we split the driver off into a contribute module that makes other Modules say I don't have to worry about it anymore. It's not in core That's not really a you know if I write a sequel query that doesn't work on postgres I don't have to worry about that because postgres isn't in the core anymore And that's that's one thing we should also think about right so they yeah the fear There's a fear that if we remove it from core It's not going to receive the same attention from other contrived drivers and I'll counter that with examples of From the contrived space. We have MongoDB driver. We have a sequel server driver and Contrib is still open to supporting those types of Scenarios and the database systems Yeah, it's gonna depend on the contrived developer You know if you're an altruist and developer you're gonna say yeah, that's great I'll and I'll try and support it and do my best But some people will forget I mean I think that's that's I mean that's how it is for other contrived drivers So I think there's an I mean an easy answer to make it a first-class citizen right which is that the tests run on all the Supported database backends and you don't get patches committed if there's failures on any of those. I mean that's Unfortunately, I mean not having had the infrastructure has been You know preventing that I think I think in a way it's sort of like Unfortunately, it would have been an easy technical solution, especially if it had been implemented a while ago And we had it through the whole cycle But the same thing with contrived like if you Turn on test spot for contrived and all the patches are tested against all the database drivers, which should be the default than why We get a lot better. I mean as a contrived author. I've certainly Included stuff that for whatever reason broke on postgres, you know, even for a trivial reason. It's just Yeah, I'm not gonna test every single patch locally I'm postgres or even test my modules if that's not this, you know, not the stack I actually deploy on So it'd be nice just to have that automated feedback and I think that would Dramatically improve the quality of support Yeah, so I I don't think it's I Guess for me it looks I mean the the hard part is that we're in a bit of a hole until we can get to the point Where every it passed on all those all the tests passed on all those drivers and that's and that's sort of the Hard part if we got there, we would I think we would be it'd be easier to maintain There'd be relatively little friction maintaining a long run once we got to it being Supported on all and tested on all for every passport went in. I think I think the mic picked it all of that that went up so Yeah, I think that the tests having a testing infrastructure available for for all database systems is is gonna be really important going forward it just as a just for For for all the other contribute drivers as well I think that is one of the first steps to getting these other database supported And I know there is some core contributors that want it to work on these other databases because I was talking to son He was talking about having it work on other databases, so There's people in core that are interested in supporting them I think once we get that test infrastructure there Developers that want to see it happen Yeah, so yeah, there is support for using and being able to test against all database systems so yeah, I think the The important thing right now is getting that testing infrastructure finished and at least we have right now We can see what else is failing and it's fairly close to dribble seven There's some some critical issues. You probably Want to either patch out you know as drip place release I think we can continue supporting especially if we get the transaction issue committed, which it probably will be It's our TPC so It'd be great if it's before beta but So maybe a show of hands What do people think about keeping Postgres SQL in core for a Drupal 8 at least for 8.0 0.0 That's a lot of hands Maybe our population is skewed. I don't know If we Yeah, so the anybody reviewing this video could you know you probably take that into your account But the majority of the room says we should keep it in core again 8.1 Maybe if if if we're seeing That we're not really making progress. Maybe we'll remove it in 8.1 or 8.2 Probably safer for 8.2 as I think migrate comes in an 8.1 if I recall correctly or Some you know the other issue All our migrate stuff is probably broken That's another big thing. I guess that's it Thank you. I'll try to get the slides up If you want to read all the blog posts, there's a references slide with links In the last page here, but I'm not gonna bore you with bibliography


Hey guys, how you doing? This is your boy Rich from Rich TV Live and you too can join the club at richpakesdaily.com where you can learn how to win and trade. Hi, how you doing today? I'm your host, Rich. Here we have a Rich TV Live with our very special guest, the CMO Chief Marketing Officer of Emergent Health Corp, Marvin Siegel. How you doing today, Marvin? Rich, I'm doing great and thank you for this opportunity. Hey, my pleasure. Excited to have you on the show and excited to learn more about your company. So maybe you can tell us a little bit. My first question is about who is Marvin Siegel? Tell us a little bit about your background and what is your individual past track record of success? Maybe touch a little bit on your business and entrepreneurial success. Sure, I have been in marketing and sales pretty much my whole life from out of high school selling Buick's to standing next to my father when QVC went live the very first night as my father is the founder of QVC. So I've been really following his DNA and really trying to start companies and do things that I always say that are different, unique and better than the competition. And I have done this successfully whether I've been in real estate, I was Realtor Associate of the Year, I'm a past president of the Builders Association, the oldest in South Jersey, actually in the country. And I also won Marketing Director of the Year for the whole country for the National Association of the Builders. So whatever I've done, I've tried to do it really well and very detail oriented. I'm also a licensed commercial pilot qualified as a captain and three different jets. And I think that gives me this interesting combination of being creative but being very detail oriented at the same time. I always say, Rich, when you walk onto a plane if you look to the left and you look in the cockpit and you see stuff all over the place, get off the plane and leave because that's where you gotta be buttoned up. I love it, I agree with you 100%. Congratulations on all of your success. You're obviously a go-getter. So how are things going today with the company and what is the role that you will be serving? Well, what I wanna do is when I spoke to the CEO, Jim Zimbler, it was the opportunity to apply what I have been applying for the last couple of years which is what I call content-based shopping which is 180 degrees of what QVC is and old TV shopping. It's based on a quick, you see it, you buy it. They're not really kind of being warm and fuzzy per se. And I believe the future is about engaging with content using influencers, using social media. And if you while you're enjoying the content using technology, you can buy or learn more about that product that's being featured. Way back when I was at Shop NBC, we did a show with a company called Griot's Garage, very famous company that does all the car care stuff for Pebble Beach. And literally what the camera saw, I was ahead of my time, was available for sale including the paint on the floor. That's a, it's just a crazy world right now. And I agree with you 100%. Obviously influencer marketing, social media advertising, it's blowing up and it's only gonna get bigger. So I agree with everything you say there and being an influencer myself and putting out content every day, we live in a world where content is king. It really is. I mean, look at Netflix, look at Roku, look at companies like Roblox that are putting out content for kids even to make money, helping develop games and this is the new world. So you have to embrace it. I think you really need to embrace it. It seems like you guys are. Now, can you define the problem that your company solves? Yes. When you look at all the brands or companies that are under the emergent health umbrella, these are all problem solution products. And that makes me feel very good because you're improving people's lives. And I'm very passionate about one of the companies called PharmaZoo. I think that is a total white space owning a little multi-poo and the problems that I see on social media which drive me crazy that people will post a video of their dog throwing up and asking for help because the vets closed, they don't know if they should go to the ER. Well, PharmaZoo is gonna solve those problems because you'll be able to absorb the content and then they will be able to sell you the products at the same time. But all the products that are on the site and not to get ahead of ourselves, I want to have it based on content where you can learn. So if you're clicking on a product for weight loss, it's not just a weight loss pill, it'll be a product that actually via content will show you how to do it properly. Same thing, whether it's a wrinkle eraser, which is obviously very popular, but it's basically how to improve your skin's health via content. And again, we will use influencers in this space, not just, and I don't want to give anything away yet because the deal's not signed yet, but we have some very, very credible people in these spaces that I will be phenomenal in my opinion. I can't wait to see who you guys have. Why is your company's culture unique? Well, again, it's unique because of, especially what I'm gonna bring to the table is these will be products that will be studied, they will be clinically shown to do what they're supposed to do, and there will be videos, again, showing how to use the product properly and how to do other things to improve your health across the whole emergent health platform. What are your key milestones for the next 12 months? You know, that's a great question. It is to improve the product lines and the information that the consumer will see. I have already, and it's only been a couple of days, I've engaged with a company to start to revamp the website. I want it to be very video-centric. Again, every time you click on a menu button, you don't just get what I'm gonna call a old school drop-down menu. You get a video telling you what this category is about and what this product does and it will make it very easy to buy while watching the video and or learn more about the spokesperson, about the product, and then other products, if you want, when you want to engage, to me, that's the magic. And there's some technology that we're gonna be using that I think will really kind of revolutionize what is going on. You know, when you mentioned influencers before, a number of years ago, when I was even more active in the TV shopping space and a group made a run at one of the TV shopping channels, I had a PowerPoint slide and in the slide, I had every major show host of the shopping channels and my daughter. And you may go, what's that about? The crazy thing was my daughter had more social media followers than any show host on any TV shopping channel. And if that doesn't tell you where the problem is, that's my point. Yeah, I agree with you 100%. We're living in a new world where essentially any influencer could be bigger than the largest news and broadcast station. I mean, that's just the reality. So it's a different world.  So I think you're definitely on the right track. We're excited to see Emergent Health Corp grow and evolve. Thank you for joining us today. The CMO of Emergent Health Corp, Marvin Siegel. Thank you for joining us today, Marvin. Rich, thank you very much. Always a pleasure. Now I must remind everyone that Rich TV Live is strictly for information, education, and entertainment purposes. Please, do your due diligence, do your research before you invest in anything we talk about or discuss here on Rich TV Live. In saying that, we love to identify undervalued, underappreciated, undiscovered opportunities in the markets. We believe EMGE needs to be put on your radar, put on your watch list, Emergent Health Corp. If you like the video, please smash the like button, comment down below, share the video everywhere and subscribe if you're alive. If you're not winning, you're probably not watching because we bring you the winners and we bring them to you first. Thank you for watching, everybody, and have a nice day.


Hello and welcome to Daily Debrief brought to you by People's Dispatch, I am Pragya. Germany has decided it will send battle tanks to Ukraine. Reports say it aims to change the scope of the Russia-Ukraine war and will reshape Germany's role in Europe. We go to Lebanon next where an investigation has resumed after a 13 month hiatus into the blast that killed 220 people in Beirut. And finally, as fans returned in masses to football stadium after COVID-19, football clubs gained, says a ranking of football clubs by Deloitte. Nearly a year after the Russian attack on Ukraine began, Germany has decided to send 14 Leopard tanks to Ukraine. It will also allow other countries to send their tanks. The US is also expected to announce dispatching its Abrams tanks. It would seem Germany has overcome reluctance to ship tanks into that battle front. These concerns stemmed from its relationship with Russia and the role it saw for itself in Europe over close to a century. We talk to Prabhupur Kaisal about this development. Right Prabhupade, thanks for joining us. Prabhupade, Germany's decision to send tanks now they seem to have cogitated and agitated over it for a while. What finally seems to have swung it one way? Well, you know, Germany was saying that, okay, we'll send the tanks provided the United States also sends its Abram tanks. So that is one part of the issue. We'll come to that in a minute. The second part is, is Germany worried about the escalation with Russia to the point that it will lead to a ground war in Europe? And the consequences of that could very easily escalate to a nuclear exchange. And of course, we know what will happen after that, the fact that it is a destruction of civilization as we know it. Happen in Europe, but it will affect everybody in the same way. It is not going to be restricted to Europe alone. So I think to some extent it was also a worry of that. And so part of it is also the Green Minister, the bareback, actually making the statement, yes, we'll allow Poland to give Leopard 2s, Germany will allow that put him on the spot that he was the one who was the holdout. And also therefore made it even more difficult for them to say, okay, Poland can give Leopard 2s, but Germany can't. So all of this was one part of it. The other part of it, and I'm always a little skeptical about all of this, is that there is an export market and Germany Leopard 2 tanks are sold widely to its allies, of course, to others also the global market, because American tanks are pretty expensive. And because of the expense of the Abraham tanks, they are not such a hot item for sale. Now, if they go to war, Leopard 2 goes to war, and Russia destroys them reasonably easily, then of course the export market drops. Now the Abraham tanks then become the dominant player in the market. That might be a consequence. They say, okay, we'll send Leopard 2 tanks, but you send your tanks as well. So if we suffer, both of us suffer the same market blow. So it could be also a marketing issue, because let's face facts, 50-100 tanks is not going to change the course of war in Ukraine. These are tanks which are going in with not so much of trained manpower behind it, because Germans and Americans and Polish personnel are not going to be in those tanks unless they go as mercenaries. So it is going to be Ukraine people who are not so familiar with the tanks. They are more familiar with the older Russian tanks, T-72s, and the various versions thereof. This T-72 is the main battle tank, so are these two. So is the T-90, the latest version that has come out of Russia out of the old T-72 tanks. So in that sense, they are not familiar with these tanks. So Russians use of these tanks could also mean that, sorry, the Ukrainians use of these tanks. Therefore, the Ukrainian use of these tanks might mean that they will suffer losses and relatively early losses. So given that, I don't think it's going to make that much of a difference to the war itself, even if they were run by Americans or Germans, because we have seen that the German leopards as well as the American tanks have suffered badly in various wars. Turkey in fact had leopard two tanks. ISIS hunted them down with relatively not very expensive weapons. You had also, we have also seen the Abraham tanks being used by Saudi Arabia. They were also, the Houthis took care of them. So none of these tanks in current war are invincible. It's not like the old second world war scenario. Anti-tank weapons work and therefore if they come on to the battlefield, I don't think they're going to be a qualitative change to the war scenario. It's still going to be a slog between the two armies. It's still going to be largely a ground war and the tanks would have a limited impact. Don't forget, Ukraine has, this is the third tank army they're trying to build. They had the tank from earlier times, which was Ukraine's originally, they had something like 700, 800 tanks. They lost that in the first set of battles itself. Then the European countries replenished with their Soviet-era tanks, which is Poland, Estonia, other countries. They gave them a bunch of tanks, which as I said, the old Russian tanks, they also, that was also lost by Ukraine. So this is the third set of tanks now they're going to get, some from Poland, other two again, some from Germany, some from the United States. So this is the third lot of tanks they're going to get. The third tank army they're trying to build. What will happen is that, yes, they'll have some success initially, but it's not going to make a qualitative difference. The numbers are too small. Russian tank army is much bigger. They're the T92 tanks, which are quite the same caliber. We will take a little. So I don't think this could change the, it will go to change up anything in the battlefield in any significant sense. So that's, that's where it is. So I think the issue is of the tanks as more of optics and the fact that Ukraine feels that without this, they really have no recourse, no ability to capture for the ground. And therefore, they desperately need this to keep, if nothing else, the spirits up. Right, Praveen. Thank you very much for joining us. A trial has unexpectedly resumed in the blast that occurred in Beirut's port area in 2020. The investigation stalled as various political factions in Lebanon contested how to go about it. These being investigated include top Lebanese officials. Some arrested after the blast were also recently released. More than 220 people died in that explosion. We go over to Abdul from People's Dispatch. Abdul, what is the latest on the investigation into the blast at the port in 2020? As per the reports, it seems that the judge Tariq Bitar has basically charged, formally charged former Prime Minister Hassan Diyab and some of his cabinet colleagues, former, of course, former ministers in his government, along with the state, higher state officials, a number of them, more than a dozen of them. And all of them have been charged with homicide and held responsible for the blast in which more than 200 people were killed and thousands of the Lebanese were injured. The fact is that the state's Prosecutor General has a question, the discharging by Hassan Diyab, who was basically, according to what the Prosecutor General is saying, that he has been suspended. His inquiry has been suspended pending the court cases in the for last almost a year and a half, which was filed by Hezbollah and other political groups accusing Hassan Diyab for bias and opposing political agenda instead of doing investigation. So on that particular note, despite the fact that the courts have not given anybody on those cases and despite the fact that the state has not revoked the suspension, on Monday, Bitar suddenly resumed, announced the resumption of investigation. And on Tuesday, he basically filed the charges against Diyab and other people. So it is a peculiar situation in Lebanon as that this moment where, of course, there are thousands of Lebanese who are seeking justice, who are seeking accountability for what happened in 2020. But there is a legal issue. There is a question of the legitimacy of the so-called inquiry process and so on. So the charges framed against Hassan Diyab and his colleagues look sensational, but actually do not have any legal value. Can you talk about, Abdul, how this case actually came to be in a state of suspension and also how it came to be revived? Well, as I just mentioned, after the blast on August 4, 2020, there were massive public, there was massive public outrage. People demanded some kind of accountability. This will not go where more than 30,000 people were displaced because their homes were destroyed or another infrastructure was destroyed. They lost billions of dollars of property in those blasts. And someone, of course, should be held responsible. So with that, those public, under the public pressure in the state at that time, Prime Minister Hassan Diyab constituted an inquiry commission, which soon had to resign following the allegations by Hezbollah and other political groups, some other political groups in Lebanon, which questioned who questioned the legitimacy and the processes which were adopted by the inquiry commission at the time. Then finally, with Gitar was appointed in December 2020, he was again accused of passing political agenda, in fact, Hezbollah claimed that he's passing US agenda.  There are sections which are considered to be pro US, there are sections we are considered to be anti US aligned with different regional players and powers. Therefore, it becomes quite normal, which in other societies will be quite absurd to assume in Lebanon, it becomes quite normal to accuse each other of pursuing a foreign country's agenda. So Hezbollah and other players accused Hassan, sorry, the judge, Bitar, that he is basically doing politics instead of doing investigation and he's biased against them. And they went to court, filed cases. Those cases are still pending because the judge, which was hearing the cases, got retired or removed. And there has been no new fresh appointment at his place. So the case is still pending. And despite and the public pressure is still there, there have been demonstrations held again and again demanding accountability and justice. So it seems that Bitar's move on Monday is a part of that it can be interpreted in either ways that due to the public pressure or due to some kind of pressure from somewhere else, which basically led to the resumption of investigation without a state sanction on Monday. Alright, Abdul. Thanks a lot for that update. For the second time in a row Manchester City generated the highest revenue involved football clubs. That's one of the findings of the Deloitte Money League Ranking of Clubs for 2023. It clocked a revenue of 731 million euros, a 13% jump over the previous year. We talked to Siddhanta about whether there are any other surprises in the report. Siddhanta, thanks for joining us. Siddhanta, what does the report say actually about the state of football, football clubs after COVID-19?  It was called, I think, survival of the richest. And football, as we've said many times on various platforms where we bring our perspective to sport is a microcosm that pretty much reflects what's happening in the outside world in at least this regard. So the top 20 earning clubs in world football generated a revenue. This is of course for the last season that's gone by, which finished about eight months ago. A total revenue of over 9 billion euros, which puts the industry as such back at pre pandemic levels. So the positive in that sense from a very, very broad perspective is that the football industry is back to where it was before the pandemic. But if you go into the details of this report, it tells us what we already know, which is that much of this revenue goes to very select group of clubs in very select leagues, all of which are in Europe. Like you were mentioning in your intro, the figure of 731 million euros for Manchester City, a staggering figure. And we talk about how this compares to women's clubs a little bit later on. But even clubs like Tottenham and Arsenal, both clubs based in North London, and traditional rivals who haven't won a major trophy since, you know, God knows when generating revenues of 400 and 500 million euros every year. Now the interesting part in this, because we talk so much about how much the game is driven by fans, and all of that is that only about 15% on average of revenue generated by these big clubs comes from match day activities, which means the sale of tickets, programs, food and beverage, that kind of stuff on match days. The rest of it, which would be what 75 odd percent comes from commercial activity. So essentially, advertising and broadcast revenues. So the entire game is a television game. And we were saying this also during the pandemic that the top clubs are actually pretty happy with not having fans or the media in stadiums at all, because it's a lot less effort for them compared to what they get back in return in terms of money, which is what these clubs are. Most of them for profit clubs, they are being run as businesses, and they are very much a part of the entertainment industry, which is how we should look at big sport today. So you know, that there was this whole debate going on about the super league, a breakaway league that was hoping to entice some of these top 20. We say that if we are earning the revenue, let us keep the profit also, forget about this whole complete idea of any kind of trickle down economics at all, you know, to help with the rest of the leagues. That is happening anyway, pretty much is what we are seeing from this report. This is of course, one report generated by Deloitte, and I think Deloitte's UK branch. But but there are a series of similar reports studies done by FIFA, UEFA, various other entities that all point in very much the same direction that at the grass roots level at the mass level, the sport is sustained by community activity, people's participation, volunteer activity, all that kind of things. While these few big super rich clubs generate ridiculous amounts of money and then circulate it in various ways amongst themselves. So in that sense, football, men's football, particularly, provides a really interesting bite sized chunk in which to analyze how global financial systems and capitalism had had large actually functions. So so the idea that football is this mass sport, and you know, everyone has the hope of climbing up the pyramid and eventually earning as much money as Manchester City.  Forgive, forgive my language. Because the domination of these clubs is absolute. And the way the structure has been built for generations, and most mostly because it's dominated by by European broadcasters, and essentially all Europeans. It will remain this way unless there is some kind of revolution which no one is really asking for, except the richest who want an even bigger chunk of the fire for themselves. So that is in essence, the summary of this report, at least from my perspective. Right, right. So Dan, so Dan, what about the state of women's football? What does the report say? It's actually pretty damning, Pragya. I mean, you can look at it from the perspective that there are marginal improvements. Firstly, this is, I think the first time that any study at all is being done of this kind to look at what clubs in women's football are actually doing. But FC Barcelona women, which is the top revenue generating women's football club in the world, generates about 7.7 million euros, which is a hundred times less than the figure we talked about with Manchester City's men's team. So that is the difference in terms of money. And largely this comes because mostly men in suits run the system in terms of marketing, broadcasting, all of that. And therefore, there's this belief that no one watches women's football, so why spend any money on broadcasting it why telecast it to, you know, why telecast the women's Premier League to Asia, who cares, nobody wants to watch it. So it goes a step further actually, whether you talk about the number of women who are present on the boards of these money clubs, right, the figure that let around the 10 percent mark, which is if you look at the let's say the FTSE 100, which is which is the index, the UK index. There you have 40% representation of women on the boards of these FTSE 100 listed companies. So football is really lagging really far behind in terms of bringing women into the into the game. And it's really bizarre to understand because on the one hand, so many of the global leaders of the sport are fighting to increase revenues. On the other hand, you're ignoring half of the world's population and not even trying to seriously engage with them. So even from a pure capitalist point of view, I really can't find them why that's happening. And and this also extends to ethnic diversity, by the way, many of these clubs, including clubs that claim to be global football clubs have, you know, abysmal numbers when it comes to ethnic diversity representation on their boards and in senior leadership. So while the the teams that they feel might be diverse, might be players from all over the world, different, every different continent might be playing for one club in Europe. But when it comes to decision making, when it comes to the guys who are calling the shots, it is still largely white men that are doing those jobs. All right, so then thanks a lot for joining us. And that's a wrap for today. Thank you for watching daily debrief. Do come back to us tomorrow. You can find our stories on peoples dispatch.org and our social media updates on Facebook, Twitter and Instagram.


Alright, ready? I'll clap. Alright, should be good. Hi guys, welcome to a collaboration episode of, I can call it the life of Sev and Alex. So you'll find the backdrop of Beautiful Perth with some bit of palm in the scene and also we're in the suburb of South Perth, is that right Alex? And today's efforts are really just about getting used to doing video stuff and working with the locals, helping their businesses out and going from there and just really getting confident and showing the world what we're doing and going from there. So Alex is behind the camera and he's got his lapel mark going and he's going to fire away some questions at me in regards to what I'm doing, what my business is and then we're going to swap it around and reverse roles and go from there. Go for it. So Sev, thanks for coming down mate. No worries. Great spot for it. Great day. And look, first question I have for you. Tell me a little bit about yourself, who you are and how you came to be. So about myself I was born in Russia, migrated here when I was seven and with the in between long story short I ended up being a high school teacher which I absolutely love teaching mathematics and during my time at uni I picked up a camera and started enjoying it a lot more and now that I'm a full time high school teacher I've got the stable income which is a bonus for me really because I love my job and I can go out after school, before school, on the weekends and on the holidays to just do the photography as full time as I possibly can and now here I am now doing an interview about myself and who knows where this can take me and us and everybody involved. Great mate. Could you tell me a little bit about your photography and specifically Sev's pics. Tell us how that came about. The whole Sev's pics thing, it was just a funny name that I thought I'd put up and straight to the point it's a bit different I didn't want to say Sev's photography it's still unique but I thought Sev's pics nice and fast and quick in relation to Aussie slang everything's quick but the photography side came about for the Instagram and Facebook and all of that I just started out with landscape enjoyed doing landscape and taking pictures of birds and now I'm touring around Perth the state and even sometimes overseas just taking photos and getting people to tag along and here we are and then all of a sudden all these people have come to I've come to know me and now we're hanging out doing things together enjoying the hobby together and creating content for each other's businesses Really mate? What are your favourite spots in Perth for landscapes or your favourite spots? Favourite spots would be anywhere there's a lot of people in particular Fremantle I love Fremantle I'm partnered with the the limelights and street photography and lots of dogs I love taking pictures of dogs but specific locations in Perth would be Claesbrook Cove very iconic and new landmarks that are dying to get their photos taken over and over again and then also the new this has got a lot of potential there a lot of people, a lot of shapes a lot of architecture and abstract stuff and then also just the beaches probably less now than before but the beaches are always a winner in Perth especially if you have real estate there Now some of your favourite pictures that you have taken that could appear on Steve's pics tell us about some of your personal favourites the ones that are candid of people the ones that are not as popular to the masses those are my favourites my classic response would be there are no favourites because I haven't taken them yet a new favourite is the latest one I take that's my favourite but the old time classics are my black and white stuff that's where I really thought about it a little bit more there's more of a narrative behind the photo in particular probably there's one in Amsterdam where I went there and I was under this bridge in a tunnel under the canal and there was a walkway and there was also a bike path and it's very contrast black and white before you even take the photo I took the photo and it looks like two images have been put together and it looks surreal but that's actually what it looks like in real life during the week a lot of people wouldn't know that you're actually a high school teacher tell us about that and how you find being a high school teacher how that relates to your life and where you can see that going it's a shock to me for where I am right now being just over a year out of uni and already having a full time permanent job as a maths teacher as well I didn't go through uni to teach maths it was all PE and science and then I did some relief at another school and they threw me into a maths class and I did very well and then I got my confidence up in it and now I'm full time maths teacher and I love it and it's not just about the maths it's about teaching kids how to problem solve anything and relating that back to maths and getting the young students who aren't at all the big fans of maths to really enjoy it and yeah, go from there it's so fulfilling and how do you wish to inspire people this one, I think about this one a lot I just want to set by example be a good person myself and show other people how to be a good person that's how I want to inspire them and you know go through and do my thing, share it with people share my successes but more importantly share my failures so that if you're in the same situation you can deal with it in a similar way or a different way maybe you can help me but more times than un so far I've helped other people and that's so fulfilling about a month ago, month and a half ago the balance wasn't quite right and I'm still trying to figure out and work out all the kinks but I feel like I'm getting there slowly nothing's perfect, there's always ups and downs and sacrifices that are needing to be made I feel like right now I can sacrifice more than later but I'm always keeping myself in check and my friends and family are always keeping me in check in the most supportive way so it's really more my family and friends that are keeping me saying hey you look like you're overdoing it maybe and I'm saying yeah you're right or saying no it's okay, it's okay but I always listen so right now I wish there were about 48 hours in a day instead of 24 I wish I could live off no sleep but at the same time I'm very very happy with the progress I'm making and it's only been the fifth month of the year and I've done so much already so lots more to do but a lot of relaxation is needed how do you see yourself in 5 years time? again another question that I've asked myself and I've changed the answer too many times so at the moment I see myself further down the track of portrait photography and getting more into my videography but also public speaking too I really like to stand in front of a crowd and just tell them how I feel about things based off of my experience and if people can resonate to that I can do that more and more and more that's where I see myself for kids and for people my age and for the older crowd too so finally do you have any advice for younger people that might be listening? this can resonate with anyone but if you're younger and you're still starting out you're not sure what you want to do just do it, just give it a go you can fail at 30 you can fail at 40 but the most amount of times you can fail is when you're younger because you've got more time that's the best advice I can give you have so much more time than someone who's 40 but even then if you're 40 you have so much more time than someone who's 80 so prepare to fail but also learn from your failure and why you failed because it's not really a failure, it's just a learning curve if you can channel that into a thought process all the time you won't fail, there's no such thing thank you do you have any other final words to say mate on this story Sunday? just be a good person if anything happens in your life that's negative, take it as a learning curve and carry on things will get better but at the same time when things are great keep yourself accountable and always always learn, always develop always keep growing because if you're standing still even if you're at the top there's always something that's higher awesome, thank you very much very good


Hello, Didier Stevens here, senior handler at the InternetStorm Center. One of my diary entries is about Yara and Cybershef, so Yara rules, pattern matching. You can use that with Cybershef too. In my diary entry, I give a simple example with a Word document with macros and then a rule. I also posted the recipe itself, so you can just copy paste this. And then you are in Cybershef with the Yara rule here. And this Yara rule is a simple rule that I made to detect Word Office documents, OLE files that contain VBA macro, compressed VBA macro. Now this rule, like many detection rules, is not perfect. It's not 100% guaranteed. For example, this one here, you can bypass it detection by stomping the VBA code. But that's not the subject here. Here I want to show you how you can use Cybershef and Yara. So I have my Yara rule here, that's my recipe. And then here I have a document that I drop here. And as you can see, there is a match for the OLE VBA rule. You are not limited to one rule here. You can put in different rules. For example, let me copy this rule and say rule 2. If we see, for example, Word. Let's call it Word then. So now you have two rules here working on a single document. You can also work on more than one document here by adding extra documents, even opening a folder of files. Here I'm just dropping a second document. And so what is displayed here now is first document still with its output. And here we have a tab for document 2 that I can click. Now as you see here, it doesn't detect. Now in my experience here, when you're working with multiple inputs and multiple outputs, so tab it, it's best to explicitly do the recipe here, bake. And as you can see here now, we have a detection. So this works here on OLE files. So if you don't have the Yara tool itself, which is a command line tool, if you cannot run that on your machine, you can do it here online with Cybersurf. It can also work with files that you have to transform. For example, let me remove this. And let's say now that we are going to work with a zip file that contains that Word document. Now this one here a bit special. I'm going to make another video about this. What is here is just a zip file that contains one file. So there are not several files inside that zip file, just a single file. And if I run this, you see no detection. But if you take the unzip command here, then the file is unzipped and then the Yara rule is run and then you see the detection. It will work on zip files that contain more than one file, but you will not have the expected results. It depends on your Yara rules. And I will explain that in another video.


Making people feel comfortable with you. This is what I believe. I'm sharing that with you for nothing.  Your success in real estate and in business and in life is going to come down to just one thing. Making people feel comfortable with you. Making people feel comfortable with you, with who you are. Now I could have said all kinds of things right there. And you probably thought I was going to say several different things. The cliche things, right? It comes down to I could have said working hard. Being a hard worker. I could have said your success will come down to being professional. I could have said it comes down to being honest. But let's be real. If you're in this room right now and you want to be, you're here because you want to be a top producer. How many people here want to be a top producer? Okay then, everybody.  I shouldn't have to tell you that you need to be honest or professional. That should be automatic. What I want to do is share something with you that maybe you haven't thought of. Why? Because I want to help you. I want to bring value to you. And I want to open up your mind to maybe a different skill that people don't necessarily talk about all the time that could really help you. And that is making people feel comfortable with you. If your client or your prospect feels comfortable with you, there's a good chance you're going to do business. On the other hand, if they do not feel comfortable with you, there's a good chance that you're not going to do business. So how do we make people feel comfortable with us? The most simple way that I can explain it, to make someone feel comfortable with you, all you have to do is be comfortable with them. If you're comfortable with them, they will feel that. And they will in turn be comfortable with you. If you're nervous, if you're scared, if you're trembling, if you're not relaxed, if you're tight, they feel that energy, they feel that nervousness. And if you're nervous, now they're going to be nervous. And they're going to say, I don't know if I want to do business with this agent. They're scared, something's going on here. However, if you are calm, cool, collected, tone of your voice, speed of your voice, body language, if everything is lining up that you are comfortable with them, that's the first step to making this person your new client. So at my workshop Wednesday, we did an exercise. I want to explain the exercise to you right here so that you can start to try to apply this in your day to day to be comfortable with strangers, because not everybody has that. And so what I eventually came up with, and I kind of created a term, it's called FE. And it stands for friend or family effect. And the idea is that we want them to feel like they're a friend or family. We want our clients to feel like they are our friends and family. Okay, so how do we translate this? Next time that you're talking to your mom, your dad, your brother, your best friend, somebody that you feel really, really comfortable with, I want you to just pay attention to that conversation. I want you to really think when you're talking to this person that you feel so comfortable with. You can tell them anything, they can tell you anything. They're comfortable with you, you're comfortable with them, everything's great. That's what you need to emulate with your clients. That's how your clients need to feel.  I want you to take that moment in time and just think about the tone of your voice, the speed of your voice, your body language, are you tight, are you loose?  It will not happen the first time, maybe not the second time, maybe not for a week, two weeks, a month, but maybe in a week, two, three, four, a couple months later, maybe you start to feel a little more comfortable with people and you see their reaction of how they're comfortable with you because of it and then you start doing it more and you do it with more clients and more clients and more clients and before you know it, you have a huge army of clients who all see you as friend or family.


Today we're officially starting the construction of a multi-function training centre, a scenario village and two firearm ranges. We make a promise to our police that we will provide them the best possible resources and the best possible training and this facility truly is one of the best in the world and will deliver on that promise. What a wonderful, wonderful thing for our organisation to have and to be reminded every day as they walk through the front door of that facility because it will have Bob Atkinson's name on the foyer, out on the front facade of that building. The most important thing that police do in my view is provide for the safety of the community. They can't do that without putting their own safety at risk, it's impossible. So it's critical that they have the best available in terms of training equipment and tactics and this facility will provide that to give in the edge in doing the work they do on a daily basis.


Tantor Audio, a division of recorded books, presents When She Finds You by A. J. McDyne. Narrated by Danielle Cohen. Prologue I am slumped on the bus, head resting against the window, my hands clasped around the hold all on my lap. Outside people go about their business, oblivious to my impending ordeal. An old woman shuffles along the pavement behind a scuffed brown shopping trolley.  B. D. I.'d pigeons watch the bus trundle past from their rooftop eries.  Ready to continue?