stupid unto another movie reaction my name is Jeroen better known as Dutch Bond fan and I'm once again joined by my beautiful girlfriend Lirit hi today we are watching 1985's A Few to a Kill the final Roger Moore James Bond movie one last one last time we took a little detour by watching the unofficial Bond film that came out in the same year as Octopussy never say never again which wasn't necessarily the biggest success to you but I warned you beforehand are you excited to delve back into the official series and watch one more Roger Moore movie yes I hope it's never again I guess the bar isn't too high for that one so I hope at least that movie can be defeated in your view one last thing I want to mention about Roger Moore in this film he's very old he's older and you may notice he looks different than the six that came before this you remember the he always had like a little mole next to his nose in all of his films it's like a mole here he had that removed too so it looks it looks very different in this film because he got older he had a little eye lift so okay well it doesn't happen in this one so you won't notice it okay to me it was always noticeable that it was removed in this this film but anyway it's still Roger Moore and it's still an official Bond film so all the elements that you missed in never say never again are gonna be back the gun barrel the official music yeah you may and this is just a hint also recognize the main villain I'm pretty sure you are familiar with the actor that will play the main villain in this film so okay if you are interested in the full length reaction you can always go to my patreon page become a premium supporter sync your video up with this video and watch the whole movie together with us and also if you are interested in the SIS sure I'm wearing you can click the link in the description because I recently became the ambassador for the one of the ambassadors of the SIS training gear a really cool James Bond clothing line go ahead and find the link in the description all the way at the bottom if you are interested to wear this or many other Bond related clothing that they are selling it's really cool without any further ado let's now delve into a few to okay but he's fictional that's the point close Russia yeah so Siberia this James Bond yeah body micro chip micro chip we improve we imitate it looks a bit odd like this yeah the state of the art computerized robot bother to read any memo sent from my department you would realize that this is a prototype of a highly sophisticated surveillance machine highly sophisticated by an anglo-french combine Zorin industries that's a real industry no no that's why they put to this claim that it was not a real life because there was a real life company named Zara and they wanted to make sure that they didn't think they were basing it on them okay otherwise there was a war yeah no not a war but copyrights in a suspicion all right but you have exactly 35 minutes to get properly dressed up yeah what's wrong with this let's see if you recognize him yeah right in the middle but do you know the actor have you seen him before they can never fall names mayday mayday mayday but did you recognize him I think so yeah I'm sure we've seen let me put the most recent movies this is Christopher Walken you've seen catch me if you can where he plays the father of the Carpio but I know him like in older days when he's older yeah he's a much younger here and his hair is blonde in this movie yes Cobra she must take a lot of vitamins perhaps Pegasus does too perhaps because this does too we've been there also yeah mostly to Disneyland we've seen the Eiffel Tower in the Eiffel Tower this is a real restaurant there's a restaurant is it this one as well I don't know but there's a restaurant in the Eiffel Tower another excellent choice I'm pleased you approve since your pants you're busy you'll be dead poison yeah told you yeah mayday that's stupid of her all the way up oh she's we're gonna say that service in France oh this film the great villains singin smile is that it no no those are the sevens quarters stables over here no this is not a stable yes it is yes a really expensive one they recognize him like James Bond oh she she should yeah she should but she was mostly running from him right yeah but you know who's chasing you right yeah that's what you remember the face right you would think I would remember the face exactly this is a very good point I raised this in my review as well but she realizes later it's like oh wait a minute it was the guy so that's kind of stupid that she doesn't immediately recognize him I mean she's shooting at it yeah shooting at you and she was like throwing her yeah fishing thing to him welcome sir I'm Jenny flex of course you are fun fact about her she played the woman in Indiana Jones tree that was the Nazi woman come along Tibet stop wheezing well don't stand there panting Tibet start the unpacking here let me help yes look at the bed yes sir oh my lord tibet look at the state of my clothes in the box yeah they immediately are doing small talk oh my lord what the devil's wrong with these shoes is that there's a man I saw at the Pegasus stable maybe it's just a robot who the who the horse should certainly bear closer inspection we're on a mission it's a contrary on a mission I am expected to sacrifice myself it's part of the job no it isn't it's only a choice goodbye that way I have a pointless gadget right yes it's like it makes the glass less better to see through or something and it looks kind of stupid too yeah enjoying our little party mr. St. John's my immensely immensely a sentence my sentence my it's going to scratch you don't want to make a copy of it is that Louis Vuitton is that Louis Vuitton or maybe that was like a Louis Vuitton there was it yes a fellow sportsman what about fishing fly casting you know by the way the name is James singe and smile I'm English there's like a secret entrance or something like this quite a let down how was he here already you went in before keeping like a baby is triggered by a remote control transmitter small enough to fit into the tip of a jockey's whip or a cane during the race with the they give him the injections with the doping that's how he keeps winning without coming to the test so sad what's he doing afraid I wasn't much help don't worry it's all wrapped up no but she's wearing like those clothes it's not like practical to fight in that one well maybe he is she's like an animal yeah he was the man at the Eiffel tower he Raj Morrow is said when he when people say he didn't do your own sense he said well I did sleep with Grace Jones that was kind of a start you slept well a little less less but I got off eventually licensed to kill what should I say if they asked where I'm going I told them have to get the car washed you just washed the car all right make it dirty again no no no no there's going to time to get the car washed and where's she she's in the car she's in the car you think so yes she will follow him do you see she's with him in the car yeah did you notice he was gonna kill him no luckily he's James Bond yes yes in front of him activating the microchip this is not a horse friendly movie though it's not like never say never again where they jumped the horse into the water this is just acted it's not like he's really gets injected but at least it's believable to you so that's good so God for you let's get 007 killing to it was a mistake this is what I like about Roger Moore he's no jokes when someone's been killed he plays it serious don't to drown them it's not believable sorry well you could drown in a car yeah you could this is already he's I wonder if you could really breathe tire air and you're underwater Fort Knox has most of the gold where are most of the microchips in the silicon that's where apple computers is today you know all the technology but even back then this way zipline yeah so does anybody else want to drop out literally what a view title but it doesn't make sense and he was in Indiana Jones too the second one in the opening this guy yeah then dropped out of sight about 15 years ago about the same time with Zorin so Zorin is actually a Nazi experiment with pregnant women injected with steroids making them hyper intelligent but also psychotic oh my god now it's going to die no time to die no time to die hmm we'll let you run over james bond see you know what I always thought they should have used the actual kgb agent that he met in the spy love me triple x they should have used her here that would have been cool to reunite because he actually worked with her yeah and the russian agent this is just someone he's supposed to have met we never saw he didn't take from me beautiful it's a fake one crossbow test i want to show you i'm running late i can only see who's there it's the blonde girl from that he met at the horse it's the blonde girl oh yeah she that's her house or what yeah come out real slow just another zorin stooge you cut the line what's this loaded with rock salt rock salt i can tell you a few things about zorin i'd like to heal them i have to feed them are you hungry what are you serving whiskers ha ha ha again mayday you've been silver mine by the san angeles box luckily she didn't feel the documents i guess yeah but there she's she's too stupid to do that her accomplice came here to kill you yeah then they said fine the office i seal the crime what crime but that means i would have to dead dead get back is he bond is already looking for ways out but carly i thought she was going to die in the fire just stupid i knew he were gonna find her you know i i think she's my least favorite bond girl i made her in my weakest one is even worse than he's reduced and she started off so strong yeah at the chateau one star stars for her that's not a james bond girl she's it's in the movie isn't over yet yes thanks turn around look captain if you check with child oh no she's awake found his body in chapter actually captain i'm with a british secret service the name is bond oh and i'm dick tracing is still under arrest not enough to do that urban cops are always dumb in uh bond in movies in bond films remember diamonds are forever in las vegas opposite of it or even makes a joke about it like all of a sudden there's women's overall on your truck because it's a very big you have to dare but the bad guys would know and notice it right probably i got good points because he got out of the fire truck yes i never thought about that you know zoren just has to blast through the bottom of these legs to to flood the fault except except right beneath us is the key geological lock that that keeps the falls from moving at once i wonder if actress was aware of what she was saying no not at all but but in the movie i was thinking the same thing wait there goes the map yeah a convenient coincidence mr zharn those men are loyal to you he doesn't care nope what a villain right yeah he's killing his own guys killing you too he's crazy villain he's really a psychopath yeah like a natural disaster they're not quite increasing his value of his mind and we have to bring the whole thing up but how get on the rig i'll lower you trust her he has to he has no choice it's life or death now anyway if he wants to save like this she wants to save him as well yeah so she turns this is a bomb girl not the blonde one go away she uh she changed to the side of the switch to the side of good this is a real bomb girl she has really strong arms i'll make christ jones i think if i would arm wrestle her i'll probably lose thank god he has her not the blonde one suicide sacrifice herself as a big fuck you to max zoren because he left her cool death right yes like fuck you yeah you leave me i leave you this is your plan it's gone she rather dies than to succeed it's kind of a cool death five points for her great villain they're going to kill her she didn't notice a zeppelin sneaking up on her she didn't notice at all i mean i would be like ticker ever i'll just go to polo i even know what the russian one over the bridge with him under there but she's just sitting there watching it do something my god deserve your star she is she's gonna try something she's not completely useless she took out two of them no there's never a cab when you want one cleaning up a few details oh gee really good for one thing right that was the final time we saw roger more respond until we dance into the fire so that was a few two we've just finished watching it and um i would immediately like to ask you what did you think of the movie movie was a great one except the blonde girl yeah i think that sums up your thoughts perfectly yeah i'm super excited that you actually really thought this was a great one because usually this one is rated as probably roger more's weakest often um it's not my least favorite of roger more either i think my least favorite is live and let die which is a fan favorite but i i'm glad that you enjoyed it this this much they were like exciting stuff in it yeah i was like all the way into the movie and you said to me you have to react to it and i was like oh yeah yeah you were so sucked into it which is a good thing so uh a lot better than um never say never again previously the unofficial oh yeah yeah i think the bar wasn't too high but we succeeded in that mission i'm happy that it happened um let's start with bonds performance um what did you give four stars four stars once again for roger more despite his age um i didn't saw he had like plastic surgeon that's good in his face yeah so no did he look old to you no that's good because people always complain about roger's age in this film it's like too too old especially in the bathtub they always say no i think in the last movie octopussy wasn't right yeah he looked a lot a lot older than this one oh yeah well apparently the facelift helped to clean that up did you like what roger more did with it i mean now you've seen all seven of roger more's bond films just like the seven connery ones you've seen six bond films in one unofficial one so it's about time for a new bond next time it was a great last movie for him yeah i'm happy you said that because people always say it it wasn't so um yeah i'm happy so seven films of roger more are you gonna miss him as bond was it enough seven films yeah okay um i'm i'm not sure if that record is ever gonna be broken seven films with the same actor in the official series um so who knows if that ever is gonna happen again we're gonna move on to stacy sudden the bond girl i think you kind of already said it in the video but what was your final verdict how did you like stacy sudden i gave her no stars no stars for the first time in movie reaction history in our format she doesn't get a star just not even one um do we need an explanation of why you disliked i think it was pretty clear in the reaction but um you want to mention something about her um she wasn't like a bond girl for me um the most bond girls i saw would fight with him and not call for his help she's constantly she's constantly screaming right yeah it was like more damsel in the stress than a bond girl there are weaker bond girls in general that don't fight and usually they have brains she's supposed to have the brains but was it believable very suggestive question of course but i i i don't think it's like when she was reading all of the geological stuff it's like she's just she has a script on the table and she's just like reading she doesn't she doesn't but it's almost tanya robbins isn't necessarily the most convinced it's like denise richards but then worse oh yeah i think if the other girl i don't know what's there's what's her name grace jones grace jones if she told it that all those difficult words yeah maybe i believe it yeah and she's not supposed to be smarter she's just supposed to be muscle yeah yeah yeah no fair enough no stars for stacy sudden uh it's it's it's it's quite a coincidence because in my top 10 bond girl video you will find in my ranking playlist i mentioned her as my dishonorable mention and i did not tell you no beforehand that this is my least favorite bond girl i didn't say anything and tell the movie and then you saw i'm irritating it was your it was your opinion as well so it's not just me um but moving on to i think a far better category in a few to kill the bond villains what did you think i gave them five stars five stars so here's some big comfort compensation here for that score i think it's the first time i gave the villains five stars um i think i did it in indiana jones two the temple of doom oh yes yeah maybe yeah i think you may have given another one i'm not sure i'll have to check it out but anyway let's this is about these these villains so christopher walken as max max zorean and grace jones is mayday the two main villains what did you think of them well he always plays the bad guy he else he has that face for it right and um i think they're going to i think if you if you ask me tomorrow about the bad guys i already know where the guys are yeah these are memorable memorable yes and grace yeah she's badass but one thing she doesn't remember oh yeah that was one thing for tea like from from from from the pair to uh to the horse yeah she's like wait a minute he was the guy in paris but i can't place them yes you can girl if someone is chasing you you remember yeah i guess fans explain it like well she didn't really have time to look at him because he was running from him on the eible tower and and in the streets of paris flying well she threw that um fishing thing to him so she would have the time to be eye eye with him yeah i guess he was focused on mr over she to kill him no uh in the staircase yeah oh yeah then she also used to yeah she threw it like to him yeah did you like her sacrifice in the end though yes to uh when she's changed she's the change sides yeah i only missed like the middle finger to him but it's okay this is a bond movie you can't really do and well the symbolism is there it is a big f you to zorin like you don't you leave me here out toward your plans and then she just kills herself it's really uh i thought he loved me yeah no yeah but it's such a it's a cool character development and it's you don't often see pure evil bond girls switch sides at the very end yeah after she said that sentence i i thought he loved me and james won't nope yeah yeah there were more people he doubled cross he just started shooting everyone what did you think of any more comments on max zorin obviously you said he he always plays like the psychopath yeah brilliant i think yeah and also the horses i i hope they didn't like enjoy any horses in this movie i don't think so no moving on to the locations in a few to a kill i think some very iconic brilliant locations what did you think um beautiful the uk london paris san francisco an opening in syberia supposedly yeah um what what rating did you give the locations for every location one star so four stars four stars okay what did you think of how the yellow locations were used in this film well it was beautiful because you saw the eiffel tower right you know it's in paris and they filmed inside the eiffel tower exactly and also on the golden gate bridge yeah francisco so um there are not a lot of movies where you see that they're fighting on the golden gate bridge right they're like and they use the landmarks of these two cities that you know they're not you can tell they're in in paris because they're fighting on the eiffel tower you can tell they're in san francisco because they're on the bridge so and the car chase was on the hills in the in san francisco yeah with the fire truck yeah and also there was a there was a car chase in paris with the taxi that's playing half yeah when he was trailing the parachute of mayday yeah yeah no brilliant um so moving on to the story in a few two kill what did you think of the story this time three stars three stars very decent um did you notice this was kind of a recycled story of a previous yeah gold fingers yeah in a different jacket it's kind of the same at least the villain scheme is very similar uh what did you think of the story a very good one i'm glad yeah what did you like about it um his uh his evil plan yeah he wanted to blow up uh was it silicon silicon valley yeah crazy yeah yeah it started instantly enough with like the horse racing and figuring out what was up with the microchips then it turned into something bigger where you wanted to have a monopoly on the whole uh microchip market yeah okay three stars for the story three stars and i think always the most important one you're enjoying it what did you think of of youtube kill how did you enjoy it yeah four stars four stars again i'm very happy actually if you look at this list you pretty much gave everything a high score if it wasn't for the barn girl so that's what you say that's the only weak link to this movie yes too bad yeah so if she was like a badass barn girl i would give her more stars but yeah that was the weak link um but that still brings your total score uh of a few to a kill to three stars i'm very happy you enjoyed it yeah um so any more last thoughts you want to bring out and how you enjoyed a few to a kill or stuff we didn't mention before we finished off this video um well only too bad that that Russian girl wasn't that Russian girl i saw before yeah that's what i said they fought and then he said like oh my god pola even over yeah yeah if she was like that brown yeah i'm not almost that would have been better and then i was like oh my god that's a girl that's a girl yeah that would have been a great cameo yeah you know that and it would make sense that she would be competing for the microchips because they were they were competing for the microfilm in the spy you love me too yeah in the pyramids so um yeah mist i mentioned it as one of my missed opportunities in my video this that she she should have been brought back and it happens more often anything else no only one movie left and then i saw everything right yeah um that's true the living daylights which is the first timothy dolton barn movie is the only barn movie left that lyric hasn't seen but you may be thinking wait a minute or are you gonna leave the other ones out we're gonna do a movie reaction to all the other ones we've already filmed in the previous format meaning license to kill the casino reale and she did not see quantum of solid skyfall inspector yet but we prerecorded those before no time to die so those are also coming um but series shut up but um do you think do you remember everything about the pierce rosson movies and all the ones coming no i only remember if you say it like this right now uh i only remember well and so this is the good thing it will still kind of seem like a first time watching with her anyway when we delve into those but next time we'll say goodbye to seven roger more movies seven sean connery movies one george leisby and we move on to timothy dolton's first barn film are you excited about a new bond next time yeah yeah do you remember anything about license to kill the other bond film he did about how his barn was or no i only remember the bad guy yeah so we'll see next time in the living daylights timothy dolton's first barn film how lyric is gonna enjoy one of the greats i feel see you guys in the next video bye


I actually love the database. The database which is sitting at the back end. How many of you have loved that? I have a dba and I have always faced those people who goes at the database and eventually at the dba as well. But you know, I will talk a bit about myself. And this random guy looks exactly like one of you guys. Two eyes, a nose, just any random guy. And I started my career as an oracle and db2 dba. A bit of sequence server as well. Then I ended up in a job which was here in Zilagore with Ashnik where I started with Postgres SQL and later on a bit of MongoDB as well. And now I totally love open source. At Ashnik we do a lot of open source consulting and a lot of open source solutioning as well. So we work on end-to-end solutions which are totally built completely on top of an open source stack. That's my Twitter handle. So if you are a tweet about this session, if you like it, if you do like it, if you wanna curse at me, do that totally on Twitter. So even my boss can take care of that and all the people can also take care of that. Apart from technology, I love cycling. I go around in Singapore on my bikey, north, south, a bit of west as well. Those are the tracks that I have done so far. Long road biking. I love photography as well. So the only thing which restricts me is money. It will cost me good pictures because you need to have good lenses and all that. And here is why I love Postgres SQL. It is a database which is fully asset-compliant. It is a very vibrant and active community. There is an open user group where people discuss all the new features quite in public, quite openly. Even if there is a new change being pushed out to the code, it is being reviewed by people. The algorithm which is being used for sorting is discussed publicly. People can decide, people give their opinion and it is respected very well. If you want to get help, you can just shoot out an email at the user group thread and someone would look into that. Someone would come back and reply to you. You definitely are going to get help from the community. And that is one of the reasons why I consider Postgres SQL as a true open source database. Because everything is then open, you get help from the open source community as well. There are a lot of advanced features which allow you to scale up very well like multi-version concurrency control where it keeps multiple versions of the data so that you don't run into inconsistency issues. I will again not get into my GB issues and I won't bore you much with those features. It is very developer friendly and we have seen 10 reasons why it is so developer friendly. As it is built to be extended, we will see a couple of reasons why I say that it is built to be extended and why it is a very extensive database. So when it comes to developers, you are always worried about whatever I am going to develop, is it going to be supported on Postgres SQL or not or on the back-end database or not. So for that matter, all these languages that you see there are inbuilt connectors for them. Plus there are inbuilt connectors for lot more than these like you have got NodeJS connector. And it is supported on a vast area of platforms as well. So you choose a platform and Postgres would run on that because it is written in C language. So anywhere where you can compile C language, you can run Postgres. It is supported on ARM architecture. So how many of you have seen Raspberry Pi? You can run Postgres on that. It is also ported in Matiza. It can run on power platform risk architecture. It can run very well on X86 as well. It runs on Ubuntu, on CentOS, RunHat, Windows, AIX. I know people who are using it on AIX. I know customers running on AIX. So now I am going to talk about 10 features why developers should love Postgres SQL. These are those 10 features you will be missing if you are using any other proprietary database. And when I say proprietary, that is what I mean, or I can leave it to SQL server and then I might. So it has got JSON features. It has got data drive supports like money, time, Boolean, all these data drives which we are going to explore more. You can have foreign data wrappers here. Then you have got user defined operators. We will see what those are and how it works and how it is fulfilled. You have got user defined extensions as well which allows you to do more with your Postgres SQL database. An existing database where you can add features that you want to have. You can add them via extensions. And we will see a couple of examples of that as well. How people have done that. You can create filter based indexes. We will see what those are. More granular control on your parameters. So there are certain parameters which you can control as a developer. You can set certain parameters within your session. You can control those parameters at user levels as well. And we will see how those work out. Indexes can be used for gathering statistics in runtime. We will explain a little bit about why statistics are important and why this particular feature is that really helpful to you as a developer. Full text search and work upload APIs. So I will start with one feature at a time and then I will elaborate on that. Gears and features. Have any of you bought something from Amazon? Have you gone to the Amazon website? Amazon.com. Not AWS. Amazon.com where you go and buy stuff. That is where Amazon started from. How many of you have gone to Amazon websites? Not many. So you still go to the physical shops and buy stuff. You have gone to some other online websites as well. So when you go to Amazon website and you look for a phone. The features that you are going to find. On your left hand side pane there will be a feature filter. Where you will find that screen size, the camera, the operating system. Whether it is Android or the brand name. Samsung, LG, Apple. All these filters will be there. But when you go and look for shoes, you will find color. You will find size. Probably one of the filters. Brand, price range. All these kind of filters. Completely different set of filters. So can Amazon or any e-commerce industry who is trying to sell a vast array of products. Do you have a code to store all that in a relational database? No. You will end up either having too many fields or too many tables. Too many child tables. For that you need something which is flexible. That is where JSON comes in picture. So version line of earlier, one of the guys from Postgres community talked about. Satoshi talked about JSON features. So I will not elaborate much on that. But you can store JSON documents inside Postgres' scale. Two fields can be completely different. You can store eyes inside one of the fields and you can create genindexes on these fields. And these genindexes can be useful for doing searches for retrieving data from your JSON data stores or your tables. It also provides you Postgres, also provides you JSON functions and operators. Using these JSON functions and operators you can write a data access API. So how I look at it is I can write data access API and store my data base or my data in a JSON document format inside my database. As long as my data is not very formed up, my schema is not formed up. Once my schema forms up, I will translate those JSON fields into tables, fixed tables. And still I will have my JSON API returning data in JSON format. There is no impact on my actual application. My application still consumes data in JSON API or in JSON format. So that is how I can actually go agile as well. I can keep on adding fields in my JSON document or in my JSON text field as long as I am having the need for new fields. Once I have formed up those fields, I will translate them into columns and I will use JSON APIs to return data. You mean there is a temporary format for the data before it is covering to the relation of the database, right? Not really. It is actually an actual field that you are storing data. So today I know that I may need, so how it happens in agile development is you start with a functionality, right? You don't know what fields you are going to need, so you keep on adding new fields. But what constraints you down is the need to normalize, the need to have proper design of your tables, right? That is when you get a proper fixed schema. So what I am telling you is you start with a JSON field. Keep on adding all those data. Once you have got enough amount of data, once you have done enough amount of development, then you can see that these fields are what I am going to need. Other fields are not what I am going to need. Or these fields could be multi-value attributes. Or these fields are where I am going to have normalization requirement. Then normalize them. And since the beginning, return all your data in JSON format using APIs. Once even if you have made them into proper columns and tables, still going to return data in JSON format. So user data now sits in proper tables, but still the data return to application is JSON document, right? So there is no impact on the application, right? So your database could be as agile as your developer. There is vast array of data types which are supported natively, money, interval. So if I want to store like 5 minutes, this top duration is 25 minutes which I am running short on. So 25 minutes. If I want to store a duration, I can store that in interval. If I want to store time, this started at 2pm, actually 2-5pm. So I can store that in time here, right? So it allows me to store data in the way how my application perceives it. Plus I can create more data types of my own. I can define my own data types. So as a developer, I have a choice to choose more intuitive types for my data which is more compatible with my application. So I don't have to do a translation necessarily, right? There are databases who do not support Boolean. So how you at least store data inside your database is you store them as characters or you store them as integers 0 or 1. And then in your JDBC API or in your actual program, you do that translation. For active, it doesn't support Boolean for your table data types. DB2 as well I guess doesn't support Boolean as a data type for your tables. At least you have the versions which I have worked with which was 11G and 9.7 for DB2. So there is no conversion required here. You store data as you perceive data as you fetch data, right? Plus you can define your own data types and you can define your own indexing methods to deal with those data types. Like you want to store personal details and the structure. So you can create your own data type for that. Foreign data wrappers. Now this is something which I love. So you have a data store which is in MongoDB or which is in Hadoo. And you can access that data store and the entity is rather not the tables. But the entity is in those data stores as if they are posting this to your tables, right? So you can say select star from some, let's say, you know, customer details. And that would get data from MongoDB, you know. And that MongoDB would be a short end cluster. Now why is it beneficial to developers? Because you don't have to actually think about, you know, integrating data or replicating data from other data stores and pulling them together. You can choose a database of your own choice. Let's say for example, in a banking industry, you can have natural transactions which are running into your system every second or every microsecond. Each transaction is getting pushed down into your system. So those data or those records you can push into a MongoDB database. Because you're also going to do some kind of analysis of that or into a Hadoop database because you will run some offline jobs on them. But if you want to have a joint between those financial transactions and your account data, you can do that in PostVisitScale. And the good part is PostVisitScale can push the filter predicate to these data stores. So if you're not a query with a well class, that well class will be pushed down to MongoDB. It will not execute in the PostVisitScale layer. It will execute that on MongoDB. And in future releases, with further enhancements in 9.5, it is even better to push aggregates to the underlying data stores. So that is a real advantage of, you know, which you will have as a developer. You can integrate multiple environments in your system in your program itself. You don't have to depend on EVAs or you don't have to depend on a data integrator guy who is going to integrate all that data for you. You can build a logical data hub for yourself as a developer. This is another thing I work at YouthSquare extensively because my job also involves a lot of migrations, a lot of conversions. So you can define an operator of your own choice. So here, I'm defining a different meaning for equal to operator. And here I'm telling that it is going to do a wire care equal to integer. So I want to compare wire cares to integers or wire cares of strings to floats. If I want to do those kind of comparisons, PostVisit doesn't do that comparison natively. That is not facilitated by PostVisitScale itself. But the good part is you can write a very simple operator yourself to do that. And then once this operator is created, it is added in the library. Any kind of operation which matches these two data writes, it will be performing using the equality operator. That will be performed with this function will be executed and you can define your own rules there. I can also replace an existing function. So equal to generally just a string match where it is case sensitive. I want to do a case insensitive search on my database. So I can define a function and I can override the existing equal equality operator. So you can define operators of your own. You can define operators for a data type that you have defined yourself. It allows you to also do a lot of, it allows you to do a lot of migration stuff because I do a lot of migration. So if there is a particular functionality, for example, it is very funny. Every other database when you talk about any database, all of them use double pipe as concatenation operator. With an exception, SQL server. For some very good or bad reason, Microsoft chose to use plus as the concatenation operator. It always does concatenation that way. Now if I am migrating something out of SQL server to Postgres, or when I say SQL server to Oracle, I have to change my code everywhere. With Postgres as clear, I have the flexibility to define an operator plus which is the concatenation for me. So I don't have to change anything in my code. As a developer, I have choice of defining my own data type and my own operators for those data types. Plus I can create new operators for existing data type. User defined extensions. You can extend the existing functionality by adding your own add-on modules. These add-on modules are once you have compiled them and added to the database, they work as if it is like a native feature of the database. It is like a native Postgres SQL feature. I will talk about some of the popular extensions. PgPremom, we just got added in 904. Using this extension, you can preload the data in your buffer. So before you start connecting your application, you can load the data in buffers. So you don't have to face cold redo tissues. Then PgCrypto, using which you can have some encrypted data in your database. You can encrypt the data before you are storing. Particularly important for banking and financial industry. PgShart, this extension allows you to create a sharded cluster of Postgres. So you can have a distributed database. Some of your data could be sitting on one node, some of it could be sitting on the second node. And this is by hacking into the actual execution. So how SQLs are executed, that also has been extended in this particular extension. And this is provided by CitusDB. Postgres, sorry, that's a typo. No, that is not a typo. It is Postgres. Postgres, it is not just, it is GIS.  Then you can use, you know, there are other extensions to play around with the internals of Postgres, how buffers are stored, how dead, which rows are dead, all that information. Plus there are more enhanced text search extensions for fuzzy string and trigram matches. You can create partial indexes in Postgres SQL. So, you know, there are three times what you do. You don't actually delete data from your application. What you do, you do a soft delete. Just mark that row as deleted. You say N or delete is Y or no more or expired is, yes, something like that. You don't actually delete the data because of various, you know, regulatory rules and all those things. And whenever you access your data, you always access where is deleted is false or where expired is false. So, in those cases, these indexes are really helpful because I can create an index on my accounts table where I can say that closed is false. So, it is only on a cover these rows where closed is false. It is not going to cover any other row. Plus I can create smaller indexes on different datasets. So, I can say create an index on accounts table where account type is current. Another index where account type is savings. So, these indexes are going to be fairly small and those smaller indexes will perform faster. I can control the parameters at very granular level. So, I can control them at database level or at user level. So, within the same instance, I can have two different databases. One for reporting and one for OLTP and I can have different parameters for each of them. I can control them at user level. I can have a user who is going to run batches and I can have larger sort memory for that user. Or I can set consistency parameters to be low for that user so that I get a performance boost. I can set them in connection or session level.  So, which will give my bulk upload a boost. This scale can get all these statistics on the fly. So, why statistics are important? Because these statistics are a way your optimizer decides how to query the data. Like if your table has got 1 million rows, your optimizer will decide that it is not going to do a table scan. But if your table has got 10 rows, it will do a table scan. But let's say you have got a highly volatile table which grows from 10 rows to 1 million rows within 10 minutes. So, statistics are not going to get collected instantly. They are collected offline or they are collected, you know, once a sequence is run, right. So, that is where PostgreSQL helps you because as a developer, you don't really have to, you know, worry about collecting these stats after every bulk upload. So, the first thing which comes into my mind as a developer is if statistics are so important, do I need to do a stats collection after every bulk upload? Not really. You can actually rely on PostgreSQL's optimizer which is smart enough to do a quick check on the indexes. So, I will have some indexes on these tables. These indexes will store some indicative data about my stats as well. And checking the same thing on the table rather than checking on the index would be costly. So, I will do a quick check on the indexes to find out how many potential rows are there. And based on that, I will decide whether to do a table scan or index scan or what joint algorithm is to be used. So, as a developer, this is something which is integral to the system. As a developer, you may not see this very useful to you or tangible to you, but it is really helpful to you as a developer. It avoids that extra step of doing the, you know, stats update in your database. There is a JDBC copy API for PostgreSQL which allows you to do bulk upload. Copy is a command in PostgreSQL which allows you to copy data from flat files into the database. With JDBC API, you can programmatically do that. So, you can write a program which reads a file or which reads inputs from standard input device and loads it into the database. It is quite efficient, works better than the insert statements or even the parameterized queries, right? Because it does it more faster way, in a much more faster way. The last thing, which is again quite useful to you as a developer, you can use PostgreSQL's functions, operators to write an application which does full text search. So, PostgreSQL is capable of facilitating full text search. You can store your data, extra data in PostgreSQL and you can create GIN indexes on that.  It is, I don't really remember the complete explanation for that. But they are very helpful in creating indexes on textual data. It doesn't index the bold text, it indexes in a much more smarter way. And then you can use them to search your data, to do pattern searches like regular expression searches, which contains, let's say semi somewhere in middle of paragraph. That is where GIN indexes are really helpful. It makes your life easier, you don't have to deal with another component which does just full text search. You can do that in the database itself, in the database features itself. You can also do full text matches or sound text matches like SAM and SAM, they sound quite similar. You want to do those kind of searches. You have extensions for those, you want to do full text search, you have extensions for those. You can do trigram matches, you have extensions for those. If you want to explore more and more PostgreSQL, there are further blocks from various community developers. Joe's Purpose, Bruce Baumgärd, Simon Reitz, Manus Anjander. And then there is an aggregator, Planet PostgreSQL.org, where you can find logs being aggregated. So you can go and search for the feature that you are looking for. Another thing which I do quite often is search in the community threads. There are user groups, email lists, you can search through those discussions. A lot of your problems will get solved by just looking at the discussions. Because they get solved by problems not many times. Then of course the big book of PostgreSQL, the online documentation on PostgreSQL.org, that is always helpful. And if you have got any questions, just give me a few minutes if people have got any questions. What's the license of PostgreSQL? It is an open source license, it is PostgreSQL license. The license is PostgreSQL. It is pretty much like BST, it is pretty much like open BST. Yes, you can. Plus if you would like to have support, there are a lot of companies which provide support for PostgreSQL. In the 5G, 2nd quarter, there are companies based out of Japan as well, uptime technologies. So he is here. Plus we also do a lot of support for our services. I think the license is one of the reasons why many companies try to give us some resources. They don't give us a lot of resources there or something like that. So it is a good starting point for companies. There are a lot of resources there. We started in that case. So MongoDB is built for a completely different purpose. That is where you have to do distributed data. You have to run parallel or distributed computing. That is where MongoDB is meant to be placed. Whereas PostgreSQL is more when you have scalability in terms of number of users connecting, number of users writing or reading from the database. And you still want some consistent data. You want asset compliance in your publication. You don't want to push that asset compliance thing being built into the application. That is where you use PostgreSQL. So they are used for two different purpose. You define your reasons why you want a data store and what you want from a data store and then you choose one of them.