Placeholder Image

字幕列表 影片播放

  • creating these classes requires equipment and service.

  • Is that cost money?

  • If you appreciate this education, please think about going to Eli the computer guy dot com and offering a one time or monthly recurring donation.

  • Welcome back.

  • So today's video we're gonna have a brief introduction to be my sequel databases.

  • So the question may be asking is what is a database and why is it important?

  • So all a database is is is a type of software that you install it onto a server that is able to store data for you.

  • So it makes it very easy to input in store data, and it makes it very easy to be able to retrieve data when you need it.

  • So databases are used as what is called the back end for many of the Web applications and even normal applications that you use every day s.

  • So let's say you have some type of invoicing software, so you use QuickBooks or use fresh books.

  • You something like that, right?

  • So you have you have customers, you have technicians or sales people.

  • You have different parts and inventory.

  • You have a whole bunch of different types of data that have to be stored.

  • Basically, that data is then stored onto some type of database.

  • So all be clear.

  • All the database does is it stores the data.

  • Then what you do is you build a front end, and so the front end is whatever application you're using to actually be able to interact with the data.

  • That front end is able to then communicate back with the database and be able to pull out the data that it needs or push data into the database when you need to store.

  • So let's say you're adding a new customer, right?

  • So you're adding a new customer, so there's a new customer form.

  • You type in the first name you type in the last name.

  • You take all that information into the form when you click, submit that information.

  • That data is then taken, and it's safe to the database.

  • If you then in the future, I need to do a report and see who all of your customers are.

  • You click the button for the report, your software.

  • Your application will then go to the database.

  • It will.

  • It will get all the information for those different customers and then the applications will print out all of that data for you, for you to be able to read as a report.

  • So one of the important things to remember whenever you're dealing with databases, whether it's in my sequel database or any other time of database, is all the database does.

  • Is it stores data for you?

  • That is it.

  • You're going to need some other front and application for you to actually be able to access and interact with the data and something that anybody would consider a user friendly fashion.

  • This is one of the problems a lot of people run into because many times people's first introduction to databases with something called Microsoft Access so make yourself access is a database application.

  • Basically, it's a personal kind of personal small business, a database application, But with that, you get the front end, you get the database component, you get the coding, you get the intelligence you get.

  • Everything is one package.

  • So when people download or they install my sequel for the first time, they're expecting, they're like, Well, how do I How do I interact with my new database?

  • How do I do anything?

  • Because as as always with a lot of things in the real world.

  • Once you install the application, all you get is a little blinking cursor, and you don't get any friend fancy front end.

  • So the important thing to understand is you are able to interact with the database from the basic command line.

  • But to actually create a piece of software, something that is useful to the end user, you're going to have to have a front and application built that will then communicate back with that database.

  • So that's the basic idea of what databases are.

  • But some of his clients will explain a little bit more about why you're gonna be using the my sequel database and a little bit about what you need to start using my secret database.

  • Now one of the first questions you may be asking is, Why are we learning about my sequel database?

  • Isn't my sequel some old, archaic, nasty, grotesque type of database?

  • Why aren't we using something like Mongo D.

  • B or no sequel database or something like that?

  • Why deal with one of these old old technologies?

  • Well, because the reality is in the I t world many times we deal with what are called legacy technologies.

  • Basically, what legacy technologies are is when we go out, we build out these massive infrastructures in order to build on a massive infrastructure.

  • You need a lot of different components.

  • You need a lot of different products to make that infrastructure work.

  • And so one of things that that's been out for a couple of decades now is in my sequel database.

  • And so my sequel has been built into the ah lot of the solutions that we're using.

  • And so one of the reasons that we need to learn about my sequel is because it's already being used and that is already being used.

  • More people are going to continue to use it.

  • And so, theoretically, even if there is a better solution out there, it's It's an inertia thing you gotta understand in the I T world is this.

  • There's an idea.

  • There's an idea of the I T world you know, every year it's new and it's changed and we forget about the past.

  • Let let me tell you the real I to world when you some really feel products, why do we use them really old products because, you know, they worked pretty well.

  • They worked pretty well.

  • We've already built our infrastructure based off of it, and so we're going to keep on going.

  • So one of the big reasons why you need to know about my Siegel even if you don't use it in the future for building applications or building out your infrastructure is because it is simply already used significantly.

  • So if you look at work word presses is built off of nice equal droop.

  • A was built off of my sequel.

  • So many off the shelf products are basically basically Web applications that you will download and host on your own.

  • They use my sequel as the back end.

  • So understanding my sequel is a very important thing, if for no other reason, simply because it is used so widely, you will run into it in the real world.

  • And so you might as well understand how it works.

  • Now, the next question answer is how to get your hands on my sequel.

  • So you decided to use my sequel as the back in front of her application you're gonna be creating, So how do you actually get your hands on it?

  • and get it up and running well.

  • The easiest way to get my stable up and running and simply to go to a share hosting provider by their lowest price share hosting plan and get me my sequel database that they give you.

  • So if you go to go in attica dot com host gator dot com Any of these Web these shared hosting plans, even there at least expensive one will generally give you at least one my sequel database with up to a gig of storage.

  • And so basically, you can simply connect to their my secret out of a servers you connect to your my sequel database, and then you're able to put down into that database and pull down out of the database.

  • And essentially, as far as you coding your application, it looks more or less identical to if you were actually running your own database server yourself.

  • So I will say, You know, I tell people on the times, instead of building your own server, a lot of a lot of new people out there they always want to build their own servers and, you know, start learning that way.

  • One of things that I argue is you go with a simple share hosting plan, then you don't have to worry about stupid ass firewalls you don't have to worry about.

  • I S P is blocking random ports.

  • You don't have to worry about CPU fans failing.

  • You don't have to worry that you turned on u F W and you didn't realize it, which is a Lennox firewall, right?

  • You don't have to worry about a lot of issues.

  • If you go with a simple, shared hosting plan, they will give you the database that will give you the connection credentials.

  • And then you're simply able to connect your application to that database.

  • And then you can learn from there when the big problems that I see is people try to build their own servers on when they build their own servers and especially their new Not only they're learning how to run my sequel server, but they're also learning Lennox and they're also learning hardware, and they're also learning that working so that can cause you a lot of problems.

  • So I would argue for a lot of people, the best bet is simply to go get a share of hosting plan use the my sequel database that they provide for you and then build your applications from that.

  • When you feel comfortable doing that, then you can go and build your own database server.

  • Beyond that, there is infrastructure is a service, so so eight of us offers a my sequel solution.

  • There's a lot of other Cloud based My sequel solutions out there were.

  • Basically you get the full size enterprise class, my sequel database.

  • You simply connect your application to it and they deal with high availability.

  • They deal with all the fancy things, that kind of thing then.

  • Beyond that, if you actually do want to install my sequel onto your own server, you can go basically, go to Oracle's website on Oracle's website.

  • There's a community edition of my sequel, and you can download and install that.

  • And again, it's simply a piece of software.

  • And so because it simply a piece of software, it has been ported.

  • You can install it.

  • There's versions for Lennox.

  • There's versions for Windows, and there's versions for Mac operating system.

  • Now the next thing that I got to talk about is where we get into a little bit of the weeds a little bit of the history of my sequel because there's also another option for you called Maria de Be So Maria di B is basically it is a fork of my sequel.

  • The reason Maria Di B is very important is because, as you heard before, I talk about, you can go to Oracle's Web site and download my sequel, and that gets a lot of people nervous.

  • The reason being is my sequel used to be its own company.

  • So way back when I actually took training from my sequel itself and my sequel was its own company.

  • It was a company dedicated to open source, and basically the way that it made its money was by selling training and bite by selling.

  • Consulting service is well, then, a number of years ago, a company called Sun Microsystems with floundering and it still had a lot of money.

  • It still had a lot of money, but it wasn't really sure where it's business was going, so it decided to go out and start buying a lot of open source projects.

  • So a open office it bought my sequel.

  • It bought a lot of the open source projects of the time, the idea being they will consult up.

  • They date them into Sun Microsystems, and then Sun Microsystems would become.

  • There's this major, big, basically open source corporation and everything.

  • What, everything be good.

  • The problem is, it didn't really work out too well for them.

  • They were bleeding money before they purchased all the open source companies, and they're bleeding money after they purchased the open source companies.

  • And so what happens when your company is bleeding money?

  • Basically, another big company comes in and buys you out.

  • The problem for Sun Microsystems.

  • Or I guess the problem for the larger community is the company that decided to come in and buy out Sun Microsystems was or a coal.

  • Now it's kind of funny oracles, one of those companies that slides under the radar because Oracle is a business to business company.

  • You don't hear about it a lot, so you hear a lot about Microsoft.

  • You know, you hear about how horrible Microsoft's business practices are.

  • You're about how horrible Amazon or Google or Apple's business practices are.

  • The weird thing is you never hear about horrible like normal people don't talk a lot about Oracle Well, I think is in the realize the world, the real enterprise world Oracle has a pretty crap reputation.

  • They they do some curious that let's just say that you some curious things and so oracles, mainly a database company.

  • So they create the Oracle database.

  • And so the issue is when they mop Sun Microsystems.

  • And then once they own Sun Microsystems they owned by sequel.

  • They own so many of these other open source projects.

  • You had a lot of people that were very nervous about what the future of products such as my sequel will be.

  • And so, since my Sequels open source of the time, what they did is they forked my sequel off and they continue development under Maria de Be So you will hear about Maria de Be every once in a while.

  • Basically, basically, Maria Davey should be what's called a drop in replacement for my seat.

  • With a drop in replacement Means is, basically, you should simply be a bill.

  • Install it.

  • You should be able to connect whatever software that you have that's most connect to my sequel database to Meridia be and everything should work fine.

  • So basically, if you code, an application and PHP that communicates with my sequel.

  • You should be a bit connected to Maria de B and have no issues.

  • You should be able to export data all your information from my sequel imported into Maria de B, and you should get You should have no problems.

  • So whenever you hear about things such as Maria de Be, understand these Air Force of that original my sequel, the idea being that people want to keep that completely open source because they are legitimately worried about what?

  • What Oracle will do with these different open source projects so that let's go over the computer so I can just give you a little bit of an overview of where you can actually get your hands on my sequel and some of the things that you need to be thinking about when you actually want to go out and deploy my sequel into your environment.

  • So the first and I would argue, the best place to go For most people that air, initially learning my sequel is again just to go to some someplace like Go Daddy o, our host gator or whatever else.

  • If you come down here you can see and have their different little hosting plans.

  • They have got a little more expensive in the years, but okay for so for them, $6 a month or $8 a month, all the way to $20 a month.

  • They give you all of these different things.

  • But if you come down, you take a look at what all plans include one of things that all the plans include is one gig database.

  • Store it for my sequel, Lennox s.

  • Oh, this is good.

  • So again, if you want to start building small applications, if you want to figure out how my sequel works, that type of thing, what you can do is you can simply pay that, you know, $6 a month.

  • Then you're able to actually create a database on Go Daddy.

  • And then you can go from there.

  • You don't have that.

  • Then you're not worried about firewalls.

  • You're not worried about CPU fans failing?

  • You're not worried about all that stupid crap.

  • You can focus on learning my sequel, and you would focus on learning the whatever code that you're learning or to connect to my sequel, and that's it.

  • Past that, though, if you do want to go larger, you have decided to build out some kind of large application, and you want my sequel as the back end.

  • Something to really think about is companies such as Scale Grid.

  • So have my sequel is a service fully managed my secret with high availability, performance optimization and disaster recovery on the best of my secret service for cloud, blah, blah, blah.

  • And so again, this is gonna be an important thing to be thinking about when you're going to be deploying databases into your infrastructure.

  • Not only do you have to worry about making sure that your code can connected it at a base, can send out a database to retrieve data from the database, but what happens in a disaster situation?

  • What happens if a tornado comes through and wipes out your your server room?

  • What happens if Daddy gets corrupted?

  • What happens in your database is sitting on a corrupted hard drive and data within the database that thing becomes corrupted, right?

  • These were some of the things that you really have to think about so realistically, just off loading this onto some kind of infrastructure of the service.

  • Some companies, like a scale grid, might be a good idea for you.

  • Now, if you really do you want to install my sequel yourselves?

  • You're like No, Eli, no.

  • I wanna put my sequel onto my own servers.

  • I will deal the disaster recovery and all that kind of stuff.

  • Basically, you can come and again.

  • You go to my sequel dot com products community and you can come here.

  • You can see the different additions for my sequel, and the one that you're going to be looking for is the my sequel, Community Edition.

  • And so, with my sequel, Community Edition, you can see all of this fancy stuff that you're able to get within my sequel communication.

  • The important thing to realize about this is that this is open source and this is free.

  • So basically there is no licensing on this.

  • You can create a little application in your home.

  • You can scale that out through the global application, and there's going to be no additional cost for you.

  • But do you realize if you want to use any give other fancy tools that my sequel has offer, you may then actually have to pay for it.

  • So again, this is where you know we talk about things like open source, and I get really irritated when people talk about open source because they always they always say, like it's free and you can view it like people have this idea of open source.

  • That's just not That's just simply not really just not simply not how it is.

  • So my sequel is open source, so if you want to use the free version, you can use the Mice Equal Community Edition.

  • But to get some of the other features and functionality that you may need, you may need to pay for one of the other additions, and we talk about paying for the other additions were talking about some real money here gets on my sequel.

  • Standard Edition is US $2000.

  • My sequel, Enterprise Edition, is $5000.

  • My sequel clusters is for clustering is $10,000.

  • So again, this is just one of those things to keep in your mind is, as as you build out your infrastructure As your company gets larger and larger, you may need certain features and functionality that's not provided in something like the community addition, and all of a sudden you go from what you consider a free license to literally an annual subscription.

  • That's an annual subscription of 10 that $1000 a year.

  • So that's gonna be one of those things to think about.

  • But again, if you're just playing with it, if you're just learning how to deal with this stuff on again, even even in business applications or reasonable business applications, the community issue will be completely fine.

  • Just realized that if you do have to go up in the world, it may cost you a lot of money.

  • Then, beyond that again, you go over and take a look at Maria de Be Again Goodbye Oracle, right?

  • That's a big thing.

  • A lot of people hate Oracle.

  • There's a lot of horrible haters out there, and so they're like, Hey, you, hey, an oracle Come over to Maria D.

  • B.

  • Maria Di B is basically supposed to be a drop in replacement for my sequel, but one of things that I won't will say, even with Maria de Be Again it's open source and one of the versions is free diversions.

  • This free right eso again.

  • They have a community edition, so their community edition has a lot of features and functionality, but one of problems you can run into again.

  • Even this is though this is open.

  • Source is if you notice under the community edition, you get replication and clustering, but you don't get automatic.

  • Fail over.

  • If you go down here, get shorting.

  • You don't get read.

  • Write splitting, encrypted buffers database firewall, query result.

  • Limiting right There's actually a lot of functionality here that you don't get with the community edition.

  • So if you need some of this stuff again, like automatic, fail over its huge automatic fail over.

  • If you're running your own database, servers is a massive thing, and so you may have to have to pay in order to get access to that.

  • So again, this is one of those things you really need to be thinking about.

  • A lot of people have this idea that if you're using our purchasing or I guess you're using open source software that for some reason that it's always free when in reality it can get very expensive very quickly.

  • If