Hello there, oh wow. Oh, that really hurt. I just bashed my elbow on the table. Those of you wondering why Chris is swinging his arms around in a podcast recording, you're right to wonder.
How? It turns me right to not just stipulate on a podcast given that no one can see me. Anyway, hello there everybody, and I'm being very careful of my elbows. Thank you for joining us and welcome back to episode 24 of DBAL, the Reghead podcast that's all about data and beer.
Of course, my name is Chris. My name is also Chris. Ooh, that never gets old. Oh, wait, it did about 23 episodes ago.
Hey, hey. Unsurprising. We've done enough takes on it. I think we keep it fresh.
That was a back to basics one one. Very much back to basics and also definitely not scripted the elbow bash there because that's definitely going to come through in the recording. I'll let the rest of us, which is all completely scripted to the word. Exactly.
Oh, hypo. Anyway, thank you all for joining us. I can't believe it's been 24 episodes. I remember when we turned 21 just a few months ago when we first went into lockdown, and now it seems like it's just flown by.
Anyway, we've got. Fingers crossed that lockdown is over by episode 56. Hello, and welcome to lockdown 12, where we actually help Saint VNHS. Anyway, that was my best, my best Boris impression there anyway.
It was almost as good as my locus's. Oh, that was so good for anyone listening. If you don't watch the Great British Bake Off, you should be watching the Great British Bake Off. It is a, it's on, I think it's on a few different streaming services at the moment, but you can watch the older episodes.
And then Matt Lucas, the English comedian, also did a really good impression of Boris Johnson. So if you care anything for UK politics, comedy or cake, then check out the Great British Bake Off. We're not being paid. This isn't a sponsorship.
I just really love cake. Right, well, we're being paid for some of the other things. No one told me. I mean, I've put it in a special trust fund for you for when you're grown up.
That'll be a long way up. I guess the big takeaway from that was, is it's gone or scone? It's gone. I actually can't remember what I usually call it.
I'm going to say scone just to be different. No. Anyway, yeah, anyway, the Bake Off is good, but back on topic. Yeah, back on topic.
So today, we're actually going to be talking about a very cool piece of technology, something really relatively new to the fray for you and I, but something's been around for some time. And it's in use by many, many people when it comes to database, well, change management effectively. That, of course, is flyway. Ooh.
Ooh, come flyway with me. Oh, you stole my title. I don't have that. Oof.
It's so dark in here. Oh my god, the sun has disappeared. Anyway, the, yeah, so in this particular episode, we're going to be talking about flyway or flyway DB, as some people know it. And we'll be taking you through the kind of who's, what's where's and why's with flyway, how to, how to work it, what it does, all of these sorts of good things.
But of course, this wouldn't be an episode of DBA. All without the beer. And fortunately, fortunately, this month has been, well, this month has been pretty crazy. Do you know why?
I mean, other than everything that's happened. Other than everything and the entire world being a mess. Yes, absolutely. So what has happened, Chris?
Specifically, we actually had two beer deliveries this particular month. We have two, there are just people who want to send us beer. Can you believe that? I don't know how we managed to achieve this wonderful divano where people just send us alcohol.
The pinnacle of everyone's, everyone's career. Exactly. And the thing is, you know, we've been sent more beer than we can drink on an episode of DBL. So I'll just be enjoying a nice, a nice cold one this evening.
And recreating one of my favorite TikToks, which of course is, did somebody say over our genome? Oh my god. So you've managed to shoot on TikTok into a SQL Server podcast? If it's not just SQL Server, as you will find out shortly.
Oh. Unfortunately, fortunately, if you are out there and listening and you do know what I'm referencing with, did someone say, over our genome, please tweet me, act plant-based SQL, did somebody say, over our genome? It would absolutely make my day, evening, month, week, year. 2020 would be so much better.
I'm 100% guaranteed that. There's like two people in that intersection of our podcast. I just want a string, a string of people saying, did act plant-based SQL say, over our genome? It would just be perfect.
Anyway, we have, yes, like I said, we've got two lots of beer that have been delivered. One from actually a previous Donator to DBL, the good Robert French, who is a wonderful and very, like super intelligent, wonderful to follow on Twitter person. But we're actually, we have to apologize to you, Bob, because as a second time Donator, we've actually gone with someone else for this particular episode. Don't worry, your beer is in safe hands and it will be drunk, or we will, for episode 25.
But this week, we have donations from the wonderful Stephen Manson, who is a friend of Regate. He's at Manz 048 on Twitter. Go and follow him, please. He's wonderful.
And he's donated, well, a box of beers. And in it is a rather delectable selection. So we have to pick a beer each for this particular episode. And just to kick us off, I've got here a West Darbyshire Brewery, Mr.
Chubbs session bitter. It's actually quite light, considering the beers I normally drink, it's about 3.4% ABV. And yeah, it's brewed in the West Berkshire Brewery. Oh, what did I say?
West Darbyshire, West, I'm so sorry, breweries. This is West Berkshire Brewery. This is all I'm doing, other beers in the box. Apparently, the taste is supposed to be of lemon, toffee and biscuit with a smell of malt, spicy hops, and floral.
So that was a fun combination. So I'm going to open that in just a second, but Chris, why don't you tell us what you've got? Well, I know very little about what I've got. All I know is that this is from a song called John.
It is a home brew. It is a single malt and hop. I'm very, very nervous, but also very excited about over in this. It has no label.
That's a good sign. So I'm actually looking at a bottle with a yellow bottle cap that has liquid in it. I don't even know what colour it is because it's a brown bottle. It's fairly light.
Who knows? It's going to be incredibly strong as well. Well, John, friend of Stephen, guess what? You're about to have your single molten-hot drunk live.
I say live? On a recorded podcast? Well, it's going to be drunk, and so is Chris. So are you ready, Chris?
I am ready. Are you ready? Here we go. I am.
I'm going to show one. Oh. That was miraculously quiet. Oh, oh, he was as excitable.
Always. For anyone who can't, well, for everyone who can't see what just happened to Chris Coorswell, unfortunately, his beer just spilled over. Was a little excitable? It's a very good job, but I'm not recording on my home office where I worked daily.
That would be very bad if I got all this beer all over my notes. Oh, that's a good sound. Oh, gosh, it's a big bottle. Oh, it's a pint.
Oh, my goodness. Look at the colour on that. It is brown. Absolutely beautiful.
It's so the Mr. Chubs has this very copper complexion. It's, yeah, holds up really nicely. Beautiful, beautiful head on top of the glass as well.
That's interesting. Interesting, good. It is bitter, but at the same time where it said it's got notes of toffee, I think I'm getting that. Really?
And definitely like a biscuit the aftertaste. Yeah, I've been craving a biscuit all day ever since. My wife said, oh, I can really go with a biscuit with my tea. And now I've just wanted a biscuit.
Now I'm getting that kind of almost like a crummy kind of biscuity aftertaste. Biscuit, by the way, for non-UK based people. I'm talking about cookies. In the UK we refer to cookies as biscuits and big biscuits are cookies.
Yeah, not something you'd have for gravy for sure. No, that's a dumpling, isn't it? Yeah, exactly. How's your home bring?
So, this is a very interesting colour. This is like a straw pale yellow. It's like a really hazy. Very hazy.
Very hazy. It smells like a bit. That's a good start. It was quite vigorous when I opened it as Chris described as sometimes.
I did make it through the UK postal system somehow. I don't know what to expect, but that was really good. I like that. The experts opinion right there.
I didn't know what to expect, but that's good. I like that. You'll find him in the next campaign for a real Aolbea guide. Chris Kurzweil, guest speaker.
So it's definitely a lot more sparkling than the drinks I think we're used to drinking on this. It's really quite good. It's quite refreshing. It's not got the strongest flavour, but yeah.
It's going to go down very easily. I'm kind of envious now. I feel like we need to chat on up a bit and try and bagsy ourselves a crate for the right price. Yeah.
I guess it's more akin to a cloudier hazy lager. I use the best way to think about it. Really? It looks delicious.
But I'm going to stick here with my Mr. Chubs just because I enjoy saying Mr. Chubs. I feel like that would be my DJ name if I was going to be a DJ.
Next up on the mic we've got Mr. Chubs. Yeah, exactly. Whatever that music then, kids listen to today.
Then kids and their noise anyway. So now we've got our beer, Chris. We do. It's about time we got down to brass tacks.
That phrase. Most people assume that is tax. It's not. It's not.
It's like little nails. Why is it though? What's the etymology of the phrase? No idea.
I just know that. What little snippet about it? If you know what the etymology of the phrase down to brass tacks is that I'm not going to Google. Again, let us know.
All of this to do with shoes. I feel like if you if you if you rip something apart. Then you take it down to its very bare minimum materials, the things holding it together. If only there was some kind of device we could use to look this up.
Unfortunately, hang on. Let me just let me just see what my phone says. Oh, I see. I was going to ask my phone if there was a device that could look things up for us.
No. Anyway, anyway, right. So today we're talking about flyway or flyway. So Chris, what is flyway?
What is flyway? There's a lot of different ways to answer that. I guess. Okay.
So you've got, let's say you've got no more. You're running past someone. Okay. You know, you're late for work.
You're both running for the bus and that person turns to you and they say, do you think we'll make it and you say, yeah, we're only about a minute away. And then they say, Chris, what's flyway? I would say. Well, stop breathing into the mic.
So flyway is it's basically a framework that allows you to deliver database change rates to testing production environments or development environments, I guess, as well. That's the best way I think about it. It's also so it's built in, built using the JBC driver. That's another kind of key facet to it.
And it is also, this is probably my favorite thing about it. Incredibly simple. Well, this is a thing I feel like. So I recently did red gate streamed, as you know, and as part of red gate streamed, we had a session on flyway, actually, with, it was myself and Grant Fritche or it was supposed to be myself and Grant Fritche.
But actually it ended up being myself, Grant Fritche, Steve Jones, Kathy Callenberger, because our party got crashed for some reason. We all ended up talking about it. And something that came out that I thought was interesting was the fact that flyway is very, very simple, but like onions or like ogres, whichever you prefer, it has layers. And that is, it is, it is most basic form.
Flyway is a command line executable that requires no install that connects to a target database using a JBC driver, and it executes and tracks migrations to evolve the version of the database. And it's got no frills. It doesn't generate the SQL, SQL scripts for you to migrate, but it's one hell of a line. Yeah, exactly.
And it doesn't do anything fancy in the sense it doesn't generate the migrations for you, because that's just way too much hassle. But the point is, it does give you that robust framework that people need to deliver their SQL migrations as a team to ultimately a target and it's very developer focused. But naturally there are a few, shall we say, feathers in flyways cap get it flyway feathers cap. Really terrible.
But there are a few feathers in its cap so does it only support SQL server, for instance, we spend a lot of time talking about SQL server, is it just SQL server. So that's the point of using JDC right but suddenly you unlock basically the capability to run the framework that we are used to a red gate for other locations and other environments. We can run database change management on a snowflake platform, which is kind of bad right, snowflake hasn't been around that long. No, it hasn't but we've certainly seen an awful lot of interest in it and we should point out again it's not just SQL server and snowflake but because it's predominantly using a JDC driver for these various different data based platforms.
Like flyway supports just well in advance of I think 20 relational database platforms, and that's for kind of the eccentric platforms like snowflake but also for environments like SAP HANA or is it thunderbird or firebird one of them fiber I think. So, I'm going to do MariaDB PostgreSQL MySQL, MySQL, all of them basically. If you think about that, that's just the officially supported looks like the whole point is by using JDC you can basically build your own integrations out, which given that it's open source means that people do that. And that's why a lot of those kind of integrations come from and it should be reasonably straightforward because you take a JDC driver as long as the JDC driver supports the connection you can figure the driver to work with flyway.
And then you can take SQL code and running it through flyway against those target environments. And it's not just SQL code though is it like I mean we're not just saying yeah it's a command line tool and you can run SQL scripts, you know, I feel like we haven't fleshed it out enough you do have a choice. You have the option of writing your migrations in SQL the flavor that's required for your database of choice and also you can write your migrations in Java as well. People are unsurprised by this given that we're leveraging the JDC here but you can write migrations in Java as well and that's quite nice because it means that you can also plug this database evolution process into your Java bill.
So you could build it into a maver or a gradle project there are plugins for those. So, you know, the sky is the limit really has a full Java API that you can leverage you can build it in you can use it standalone flyways just this super simple but incredibly flexible cross relational database management tool for like I said the evolution of the schema it's very, very cool. We yeah I think Java as well there's a lot of people are very comfortable using Java it's really handy something I didn't know actually this is something I've very recently learned but I don't know I guess when I thought of the big languages I didn't really think Java was one of them but I saw recently a snapshot of the GitHub code repository is what languages were written in there you guess what the number one was Python or go. Oh you're tantalizing the close in that you've given me number two and three.
Java script. Java script is number one yeah so number four or five was Java and it actually beats out and C sharp and C++ and San C which I don't know maybe says something more about the demographics of the people use GitHub but Java still a very strong with Oracle developers as a there's a lot of cross correlation. Yeah, interesting thing is as long as you've got the runtime environment to run Java and pretty much everything does right everything can run Java that's that's pretty much what it's intended to do is to just be completely portable so you know you've got most devices in the world that can run Java and the interesting thing of course is that again on this show we talk a lot about the use of Microsoft Microsoft technologies and all full art we talk about SQL server we talk about windows those common things but again that's another good thing about fly way is that fly way can run in windows it can run on Linux it can run on Android or iOS it can run gosh it runs in a container if you want to use the fly way docker container as part of a build process in a job you absolutely can you know just go to the docker registry and you'll find it right there along with helpful usage instructions. So many places and so many targets fly way can literally help you do anything.
It's really nice as well if you think about we have a huge team of developers at my company let's say and they work on all these various different data platforms how do we make sure that they're working in a unified way or a similar way how do we work in a run and so fly way really offers us the ability to start talking about those conversations how do we take development teams structure the way they work with databases this is how you place your code in a way that you're still controlled this is how you can start leveraging so kind of CI CD use infrastructure as code around delivery of code changes for all of your database platforms basically yeah it's very interesting stuff one thing I really like about as well because it's something that you can just very like the code base it's not a huge download but you can actually put it in source control alongside your code because naturally people would do that if you are taking open source projects and building on top of that of course you would but that means that if you want to say run a build of it you don't need to install it on the build server itself you just download the whole package and run the code itself from the source control that will and that's just really handy it is really handy and I think I think there's something that we should really think of you know when using flyways that yes there are a huge load of command line switches that we can pass to the tool and yes you know it does have specific syntax and locations and you've got you know if you think about the actual flyway zip file that comes down and I'm going to talk about that window that comes down and I'm going to talk about the windows that's where I've used it but when you unzip the flyway folder structure you've got effectively the locations for your JBC drivers you've got your Java migrations or SQL migrations and then the config file and this config file is super powerful like it's a super super cool piece of it's about a 300 400 line document and you can tweak and you can choose the exact behaviors of flyway so you can choose what developers have you can have config files for later environments you can pass environment variables to fly it does everything and it just allows you to run migrations but we talked a lot about where you can put it how you can build it how you can deploy these migrations there's two things that we haven't really talked about though and that's number one what kind of migrations can flyway run so and and what are the main commands in flyway so flyway interestingly only has was it six different commands seven different commands there's very very few actual commands that you issue to flyway yes again they have switches but you know you can very easily remember all of the commands passed to flyway also he says now is time for Chris Coswell tries to remember all of the flyway commands I'm not going to play against because I'm definitely missing some of what I did want to say on that though was what did I want to say on that you made me derail my train of thought excellent I'm glad I did I can't believe you're not going to play my game no cause I'm not well how about how about you tell us what my great what types of migrations are available in flyway then that was what I was coming back to so three different types of migration script so you have your standard down script you migrate your migrate command with that so you but you change for it then you name it in a way that makes sense so flyway uses flyway is a script make to manage the changes and deliver them in the right order put them in a folder you can use whatever folder structure you like because the manner the file name is the thing that matters so it'll plug everything out from the given folder that you choose again flexibility for but that's not just everything so we think about there being two use cases when it comes to delivering database changes in general there are the one one off scripts that you run and the other type are repeatable scripts so flyway we call them repeatable migration scripts they are scripts that will execute every time you run a migrate command and there's really two different use cases for those one is they don't run every time you run the migrate command only when they're checks on changes oh really I didn't know that there we go yeah so two use cases for that I thought that was an option to run every time there might be an option to run every time because you can use it's pretty in post scripts as we have kind of used it thank you have pre-empost scripts exactly yeah the second is of course things like still procedures functions views or just procedures if with programmable objects right yeah those things are perfect for repeatable migration so you can execute it when they change so you put your logic in so you're going to basically replace the object there when you need to and I was going to say something about ingenious simplicity but I don't know if you've done with this subject famous plug no I think you're absolutely bang on it's the three different types of migrations definitely have their place in the world yeah by the way we said the first two oh yeah I will leave you to mention the third one before so before I start talking about commands again so we have the migrate command or run the migration script but you also have the undo command and the undo command will run any up scripts and there's a lot of refreshing way of thinking about running change script management I guess with migration database rollbacks are one of the hardest things in the world to do I mean you know apart from climbing Mount Everest and there's lots of people who have done that but how many people have tried to rollback database migrations how many people have tried to do both that would be a fun if you've rolled back integration and been to the summit of Everest so yeah but it's quite simple like the way flyway does it simply say here's your up script is your down script so tell me what those are and I'll execute them in order and then you go up and down and later next up absolutely so we've got version migrations and they are appended with this kind of the naming principle of the for versions naturally and then you include the version number and the number that number can be in pretty much you know most formats right it could be V1 or it could be V1.1 or V1.1.0.1 however you do that and you can actually organize your various migrations as well as they're in that format you can also organize them into semantic version folders within the folder structure of flyway because it will recursively scan every folder and basically build up an idea of what migrations it has available anyway and then you've got the undo migrations which unsurprisingly have the you prefix so if we have version migration one dot one that adds the table cars then we would have the undo migration you one dot one relating to that version migration that drops that table but the point is you get to specify the steps if you're contributing scripts V1 through three and you specify the undo scripts you one through three you know that if anything goes wrong with that deployment and people need to rollback the database to a particular point they can undo all of those version migrations in a safe way because that is how you have chosen that they should be undone that's how you've written it as opposed to relying on some kind of technology to make a guess for us dropping an entire table. Yeah that's always fun crash and burn baby crash and burn. Indeed. Alright so the commands do you know the commands off top you know I think I do.
Alright it's already said to we said my great we said undo what you can you can issue flyway migrate and flyway undo to literally move up move down and that's why it's really handy in a development environment specifically because devs can go forward and back as much as they like. Yeah exactly. You've also got the most basic command as well which I think is the flyway info so flyway info basically lets you know it checks the scheme history table at the target to see what's been run against the run against the target and then you've got the flyway and then the flyway repo locally so that the basically the location is scanning for migrations and it's basically saying hey I've got these migrations these have been run against the target these haven't these are undoable etc etc literally info gives you the information. So you've got flyway validate which effectively checks the migrations that you've got locally and it's each whenever you run a flyway migrate that validates first as well and actually checks that the migrations you have locally match the ones that have been run against the target.
So if someone has changed a file for instance if we migrated V2 and then someone's gone in and altered the script then that will fail because it changes the checksum and the table at the target keeps track of the migrations that have been run the checksum when it was run the name etc. So if you try and run something that someone's changed it's like oh hang on a second this could result in unexpected consequences so but if you've just gone in and added a comment for instance well that will change the checksum but it won't change what's been run against the target. It's just a comment for documentation purposes so that's why you would need the next one the next come on flyway repair which will literally repair the flyway scheme history table in line with the local values they just updates the target table and says no no this is fine here's the new checksum basically. So flyway info flyway migrate flyway undo flyway validate flyway repair you can get it.
Oh dear. Have this in front of you have you pulled the list up. What happens if you validate something and someone's gone wrong how do you fix that. Oh that was repair.
Sorry that's not what I meant. Yeah you have got to do that already. Alright what happens if you want to start again. No I remember them now.
Okay so flyway clean. Flyway clean will drop every schema object leaving you with an empty database literally clean and it cleans it does a really good job cleaning. Yeah exactly completely empty schema. And that's really good for as we say starting again and don't worry I can imagine some of you out there thinking drop every object in the database no thank you not against production.
Fortunately you can disable clean against later stage environments using your comp file I already talked about anything with that comp file. And then if you try and migrate against a schema that exists already that hasn't had flyway run against it before naturally there will be objects that already exist on that database. So what you do is you can run a flyway baseline command the final command which will literally create a pointer which it says okay. I'm going to create the schema history table and where appropriate I'm going to mark the first the V one migration as it were the base version as the flyway baseline version and there's a specific name and convention for that.
But it would effectively create that starting point and say okay everything from now we're good to go. Yeah, you got him. Yeah, I'm your little prompt. Yes I I'm so embarrassed that I forgot about clean like the most wonderful command that I love to demonstrate and I forgot about it.
That's the one that you'd have to show up. Well maybe it's because I'm not clean. Yeah. Alright so flyway that is like probably the worst elevator pitch I've ever heard in terms of quickly describe what flyway is.
But that pretty much is a big brain done from the two of us on what it is. Yeah, and it's what's a great tool. What do people do gross if they really wanted to find out more about why. Well if you wanted to find out more about flyway then I would definitely recommend going to the fiber website which is flyway DB dot org that's FLY w a Y DB dot org.
And that will take you on to the flyway main site and fortunately there's a ton of different options there for you to learn more about it to download it and zip it gets started. Remember it's open source software so if you want to get started with the community edition that is absolutely free grab it. And you can do it. Do what you like and you can join the flyway community realistically I would say that your best shot at hearing the most amazing things that we have coming up with flyway is to sign up for the flyway newsletter.
Because then you'll get everything you need from there so if you just go to the flyway website you'll be able to sign up for the flyway newsletter and you'll be able to hear everything that we're doing and you know if you were already on the newsletter you would have found out that on the 1st of September we announced the flyway seven beta and just to give you an idea of, you know, what you can do with this beta version. Well, it comes with a whole host of new features like the ability to cherry pick which migrations get run against target environments, the ability to run arbitrary scripts during flyway migration so PowerShell bash command scripts Python files, etc, as you go. There's Amazon S3 bucket and Google cloud support J BBC properties and clients and even support the new databases like as your sign apps. So there's a ton of new cool things coming out as your sign apps doesn't really don't really count as a database I suppose but in itself I don't know if it does count as a database but, you know, sign apps.
So there's a ton of different options in there as well. Well I mean sign apps is what they're formerly data warehouse so I don't know where they go so there's a ton of different options available in there for you and the best way to stay up to date is of course to go and add yourself to the flyway newsletter so do a survey go and sign up and have a play. Thanks. If you go, let's say you're looking to implement something like flyway and you're not sure about so taking on an open source license.
Maybe you want to make sure that there is a dedicated support channel for you. What options do you have Chris. Well, fortunately, so we've recently acquired flyway and as part of that we've decided to essentially take the the Apache license and offer commercial license on top of that. So we've basically taken on the basically take on flyway and add that good old fashioned red gate support.
Yes capability to it. Yes, our support is absolutely incredible. We get so much great feedback about them. So now the combination of those two things you know there's there's a few bells and whistles that are reserved for the pay tier as well.
Most notably undo and drive runs that you haven't mentioned. No this is true that the drive runs and we didn't even talk how much about callbacks but there's so much you can do with flyway it's crazy. There's also things you can do with the pay tier but like we say, you know, it depends what you're looking for. Indeed.
So Chris I think that leads us on quite nicely to our fav well not our favorite segment not when we've been talking about flyway but it leads us on to the news. And then we've got a similar version of Star Wars the other day it was like ASMR Obi-Wan Kenobi in general grievous and it was like general. I was why I've already learned not to question you wouldn't I wouldn't I wouldn't yeah it's not wise. Can you imagine ASMR DBL.
It's so true though it's so true so Chris. Do you have a date of reach for us. I don't actually talk about the spot like I actually do have quite a good date of reach for us this time around actually so. There is a really interesting story that I only saw when when Troy Hunt treated it tweeted it on Twitter and this was August 27.
He tweeted Nigerian bank data breach and it was the it was unity bank in Nigeria and it's a really interesting data breach because it was kind of reported at the time and it just didn't seem like much was going on it didn't seem that much was happening so it was effectively a dot SQL file. So I dumped from a database and it contained the PII of 53,000 individuals. It was just the insert values I think and the interesting the interesting thing about it though is that it was reported on August 25th by a kind of a bank security specific Twitter account unsurprising called bank underscore security. I know and they tweeted about this this breach and it actually turns out since then towards the end of August.
It turns out that the the breach was actually of about 53,000 job seekers on unity banks job portal. And yeah, no one can seem to from all of the information I found on it. No one can seem to figure out what what the data really was for some people seem to say that it was for it was for I don't know reporting purposes. Some people said it was some past enrollment exercise but naturally it's sensitive information it's 53,000 people's sensitive information and it included people's names house addresses emails phone numbers the dates of birth and naturally this could be a problem.
But the interesting thing about it is that you know there is there is a lawsuit being raised against them at the moment and it was filed on the 28th of August. I don't know. No, no, well I mean 53,000 people's data just got breached in by by unity bank but the interesting thing is it wasn't just it wasn't just unity bank that had a breach there was also within the same kind of area there was also a couple of other breaches within within Nigeria. And there was a breach of access bank as well supposedly on the August 31 and then also a breach at team at which was a Nigerian FinTech company.
And it's basically basically I don't know they've all been playing down these breaches the most interesting thing about this is that when you look at the statement on the websites of the banks of the banks of companies affected and I'll stick with unity bank for this one. But when you look at unity banks statement they basically so here's what the statement reads so there's no doubt in our minds that the data came from unity bank. The Nigeria has a data protection piece of data protection legislation from 2019 and naturally it's a breach of that so soon has been raised against them. So everyone's under no doubt that this information came from unity bank.
And the statement that the statement reads tell me if you think anything's wrong with this. Our attention has been drawn to social media reports, purporting a data breach of our systems for the avoidance of doubt unity bank wishes to reassure all customers that we take the protection of their personal information very seriously in accordance with data protection legislation. The bank hereby reassures its customers and the public at large of the integrity of its systems controls of which are continually enhanced in line with best practices to force all attempts at compromising confidential data. We also implore all our esteemed customers in the public to be vigilant and not succumb to false and suspicious emails text calls messages devised to mislead them into disclosing their personal details.
So avoid the question. So avoid the question. Oh, systems, by the way, our systems are great and all customers you should all be very, very careful. So what they're saying is that it wasn't customer information, it was other information so it's fine.
They didn't even say that they didn't even say whether or not it happens just that their attention has been drawn to purported news of their systems being breached and they haven't said what they are planning on doing about it they haven't said if it's true if it's false, they didn't say no this is fake. It's really interesting statements drafted by lawyers for $400 please Chris. Yeah, absolutely. So yeah, I just thought that was a really weird, really weird occurrence that I'm not really sure what's what's going on there for honest.
It's like a sequel based, a sequel based data breach we don't really get many of those. We're giving our friend a girlfriend elastic search a break for a month. Okay, so other things we should mention the news I guess single bits. Yes, absolutely.
So sequel bits the biggest data show is going to be happening. Oh gosh, I should know this, but it's happening from the Saturday, the third Wednesday Tuesday. Basically end of September and then the first few days of October. So it's happening from the 29th of September to the third of October I have to click on it to double check because in my head I was thinking the first to the third of October and I thought no that's way too short.
Of course, naturally, if you don't know about sequel bits already sequel bits is Europe's greatest data conference it's. Well, I mean it is chock full of incredible speakers and sessions and it really is just an incredible event. And it was supposed to happen. They've got training sessions and they've got conference sessions and they do have tickets still available for a short time so if you're listening to this go and grab some if you don't already.
But the interesting thing is they do training sessions and conference sessions they have a virtual exhibition and it was because this was supposed to be earlier in the year this year, but unfortunately. They weren't able to run it because of obvious reasons so it's gone completely online completely virtual conference and you can register now. And there are some speakers there that we think you should buy that. Absolutely so we'll recommend a couple of sessions for you.
Chris and I will both be there as part of the exhibition representing Red Date Software so Chris what day are you going to be there. I'm there on the Thursday which I believe is the first on the Thursday and I will be there on Saturday the third and you know we should point out that this list is in no way exhaustive. There are a billion and one different sessions at sequel bits so if you're doing a session if you're listening to a session and we don't mention your session. But I've just pulled out a few really interesting ones that I think people should definitely go and watch if they get a chance or watch back if they get a chance.
So my three realistically and I tried to pull up Hamish Watson's Hamish Watson's particular one on why you can't achieve DevOps without the culture. Unfortunately the website wasn't letting me open it so I'm hoping that it's still going ahead but the three that I picked out just to call attention to. So server DBAs need to know about Docker containers I think that'll be exceedingly informative and insightful and that's Edwin Samiento so go check out Edwin's session if you haven't already. Another one is from our good friend the wonderful the beardy the DBA tools love in Rob Saul and he's doing a sequel notebooks in Azure as your data studio for the DBA so if you're interested in how you can use sequel notebooks installed in Azure data studio and using diagnostic queries, then that session is 100% must see it's absolutely and Rob is just such an incredible person and presenter that I can't recommend it enough.
And then also there are some fabulous sessions I couldn't decide on three so I got with four so two more sessions I'm sorry two more sessions I'd recommend the first of these is DevOps 101 for data folks. So that's the session that you should definitely check out I think that's on the Friday and also on the Friday is the new normal for database DevOps and that's Kendra little so she's going to be speaking about those DevOps as well. And yeah those four sessions just sound like worthwhile paying the ticket fee anyway, but it's not just those four sessions it's so many more like Chris. So we also have some record personnel presenting right and I'm sure the advocates of the specifically two sessions live by ground I think it'll be good because grands always worth listening to.
What personality. So he's got the session also helping DBA succeed with DevOps so that's what you know and another session around helping out or helping get to grips with sequel injection so how it works how to stop it. So I'm going to be removing the session. And finally I'd be remiss remiss that not mentioning that there is a certain somebody on this podcast who has his own session.
Oh fancy pants. So on the set I believe that you're going to be delivering a session. I am indeed yes I'm going to be delivering a session. I can't remember what it's called what it's called what what compliance means for development.
And effectively what I'm going to do is talk about the different some of the different regulations that are out there in the world and some of the commonalities between them why they are very very similar. And so as a DBA as a developer as a data professional. Despite whatever regulations you are whatever regulations you're trying to be compliant with. So that's on the Saturday is about 1130 I think so definitely go and check that out don't as Chris just did spill beer all over your mouse.
Yeah that was in case you're wondering what that noise and strangled cry was that was me lamenting what might be the death of my poor mouse is working fine. Yes, and apologies to John there for you wasting some of the hard-made beer, but it looks delicious But yeah, so I think the I think the summary there is hey go and check out sequel bits. It's gonna be absolutely incredible We can't wait and Your house yeah, don't worry about your mouse. So I think that's pretty much all we've got time for today So we've been through quite a lot of information in this particular one It's been an absolute schmorgasbord.
Oh you need it to know about flyway and several things you do exactly So just so recap then go and check out flyway DB dog and sign up for the flyway newsletter Make sure you check out sequel bits some incredible sessions from some incredible speakers feel free to get in touch with myself and Chris as well DB ail at DBL at red hyphen gate calm or at plant-based sequel on Twitter or at curse well Chris on Twitter And naturally will just be so happy to hear from you. We really do love it when people reach out We love it even more when people send us beer. So thank you so much Steven and of course Steven spread John for the home brew It's been absolutely delightful. Cheers or cheers Chris What is great?
Thank you beautiful. Cheers