Yn y gyfnod rhaglen gennym, ond y gyfnod rhaglen gennym wedi cael ei ei ddweud â'r Ffondi Llywodraeth Llywodraeth yn y ddadw i'r ysgol yn ddiweddol. Felly, when the first generation of young broken-hearted companies started, they ran a competition to try and encourage use of cloud infrastructure and we offered a prize of certain amounts of infrastructure to be used by the winner for 12 months. Our next speaker is that winner, Devyn Gaffney, who is a research assistant of Masters Candidate at Oxford Institute. Oxford Internet Institute and Devon is going to be talking about the work he's been doing under that, well I think under that prize winning anyway. So ditching the dowsing rod, why prescribed analytics fail to deliver? Well I was going to do the introduction but I guess that's all done with. So the best way that I can explain how I came up with how to explain this whole work I've been doing can be done with the following situation that transpired a few months ago. This is my friend Hugh and on February 15th he wrote this tweet that said, I got you this giant teddy bear wearing a vampire costume. And then a few days later the data scrubbers over at clout had deemed that he was in fact influential in vampires. And I think that you know we can use those sort of common sense to say like the context of this tweet, this picture of this man like probably reasonable to say that he is not influential in vampires. And so I started thinking about this situation and like thinking about what sort of factors lead to something that's so hilariously wrong put out by some company that is so hilariously rich. So in order to answer that question you have to kind of go back to the original Web 2.0 model. As you all know the basic idea is we create lots of data online and have users put on all this information. And this is all you know coming about as a result of technological, economic and infrastructural conditions being right at the 2000s. It's nothing special about the 2000s internet. It's just that's when it happened. And the model basically says let users create a lot of stuff and let users check out all the other stuff that people created and show advertisements on the margins of all that content and make your money that way. But then we have this sort of derivative model which realizes advertising is really bad at what it does online and you know building content for people is very bad at what it does online. So we start looking at well what have these people been doing over the last decade. Can we use that to sort of train our system to create better advertising or better content targeting or whatever. And so what you get are these sort of top down easy models like web trends or people browser or cloud or social flow. Which basically say I have a model that describes activity on the internet and can help you target all of your content better than any other model that exists. And I can't tell you how it works but I can give you a two digit number that will tell you how you're doing compared to other people. And it's not how that's not how that's not how research is done. You don't do research like that you you have a question and then you consult a literature you look for a methodological practice that that you know sort of jives with the question that you have. And then you get your data and then you ask your sort of home bird question to that data. In fact if you look at all the research that the sort of social science and internet research people do. All the big papers usually have some completely new sort of analysis that they do to a sort of novel data set collection. That isn't sort of just a you know reiterating the same model over and over you have slightly different variations. And if you're not in the research community you're basically just left with those tools. And if you have a question that even kind of doesn't match clouds system you you you don't have an answer. And so I've been dealing with this problem specifically on Twitter for about three years now which is kind of weird. But what I've come to is that there's a few basic problems here specifically in the case of Twitter when we were building our original system. We were kind of taking the cloud route of kind of building a few analytics allowing people to put in data to our system and then we would deliver data and analytics as a result. But then Twitter came down on us and said that you actually can't give raw data to people and due to Twitter's API limitations you can't collect data retrospectively. So we can't go back and ask for data that occurred a week ago or something. It's completely impossible to do easily. So what what we had was these two sort of constraints at that point. We can't look at data in the past and we can't share raw data. So we have to come up with a system so that we have some way of covering most of the content that comes through Twitter. That's interesting to the internet research community and also coming up with a system that allows us to ask questions in a very flexible way. And so what we've come up with is a system where you have lots of researchers joining in on a single site that come from many different practices and many different backgrounds that have sort of social science research questions around Twitter. There's actually a lot of people that do this and then you have a system that makes it very easy to add new analytical questions and a very flexible system to add new questions into the system. And you keep all the data that's been collected over time so that in a year if there's a new analytical question that we can ask to an existing data set we can go back and ask that. So this is the view for one of our pages which is the system that creates new analytics. You basically type in this information, type in what the function name is, what language it's supposed to run in and then you add some sort of metadata for users to be instructed as to what it does. And at that point you're able to add variables dynamically and add dependencies or sort of in order for this analytic to run. Another analytic must run before it so that you can chain together multiple processes. And then once that's all done the user is faced with this page that basically lets them append the analytic to the data set. And any researcher can request any analytic to be done on a data set regardless of if that person, that researcher, the owner of that data requests it so that the researcher that collected this data can kind of walk away if they don't find anything interesting about this data and other people can come and pick it up. And then at that point we have a basic view page that you can write that's completely extracted from the system that we run internally that lets the developer of this analytic define how the results are going to be shown. So this is again just this sort of basic user statistics one and this is some data that was collected the other week on the French election. And so you have this sort of very transparent system that shows you exactly what the numbers are and the code is all open source and available so that if you have any questions about the system you don't have to trust a secret sauce algorithm or something somewhere else on some other website. You can actually just look at it and you know run a simulation yourself and all the code itself is completely usable for someone on their own local machine. And so this is all sort of in the effort to deal with this you know this sort of problem of the secret sauce approach. And then since we're running on this cloud system now we're moving towards it's kind of difficult because I'm not an amazing programmer but we're moving towards being able to have a very scalable system so that when we're not having a lot of activity we don't use any resources because Twitter is a very sort of temporally constrained system sometimes you have an immense amount of data coming through and most of the time you don't have really anything interesting going on. So what's the most interesting thing to me about all this though is that this basic idea of having two different types of users on a site. One is the sort of researchers who have questions and one of the other is the sort of developers who can answer the questions that researchers have. Coming together into a sort of platform that doesn't do analytics but sort of facilitates the process of analyzing data or analyzing data from the web is generalizable. You don't have to do this for Twitter you can do it for any of the other sort of sites that the sort of social science researchers are looking at these days or you can do it for the web in general. You can start building systems that just crawl the web and you have you know these two groups of people one that wants answers to questions and one that can answer those questions. And so we start stepping away from that sort of short term benefit of giving this sort of satisfying two digit number to you that makes you feel better but doesn't tell you anything about what's going on and doesn't have any sort of knowledge of the context you're operating in and can actually start moving towards generating automatic reports about the type of things that we're interested in in a way that you know the researcher actually has agency in the process instead of basically just being passively accepting of any system that gives them any form of data which is what we currently have so thank you.


Welcome to the course on Python Interfacing with MySQL. I am Mayur Sonar and in this course we are going to see variety of topics. So in this course we are going to cover following things. First is the introduction to the database programming in which we are going to talk about database programming. Then we will cover why Python is used for database programming in which we learn the different Python features which makes it convenient to use with database. Next we are going to see the different SQL connectors. So to interface Python with various databases we require various SQL connectors. So we will cover that also. After that we are also going to study about the cursor object which is generally used in Python for database operation. So basically we will focus on the MySQL connector, how MySQL is installed and then how the MySQL cursor object is used. And lastly we will cover the most important operations called as a CRUD operations which stands for create, read, update and delete operations which are performed on the database. So once again welcome all of you in this course and hopefully you will understand how to do the Python interfacing with MySQL. So thank you and looking forward for your joining. Thank you. So in this we are going to discuss about the database concepts, the introduction part and why we need databases. So what is a database? So database is nothing but an organized collection of data. When I say organized collection of data it means that it is generally stored into some kind of organized form. Generally when it comes to relational databases the data is stored into a tabular form or in the table form where there will be rows and columns. Rows generally indicates the records whereas the columns generally indicate the type of values which are being inserted. So you can consider any company query whether it is a large or small in the world of globalization all these companies today are storing their data into the database. So they can use various kinds of databases. Here in the diagram you are able to see as we are considering Python as in programming language. So we are able to see the generalized form of interface of Python with the SQL databases. So here we can consider that there is some kind of a Python code which is written and this code or the application is trying to interact with the database. Here we are taking an example of a MySQL database. So there are number of databases but we can consider the MySQL database in our case. So by using a query language by using a query language through the applications we are able to get the data from the database. So there will be a request which is coming from the Python application which will go to the database and database in return or in response will send the data to the Python application. So for that to write a query we use SQL. So SQL is what? SQL is a structured query language which is a query language and it is not a database. So there are various examples of databases. So there are various examples of databases. Oracle, MySQL, MongoDB, PostgreSQL, SQL Server, DB2, etc. So there are a lot of databases in the market. One of the most popular databases is Oracle which is highly used by most of the companies. The second popular database is the MySQL database and that one we are going to focus on. There are other databases also MongoDB, PostgreSQL, generally used in the Linux operating system, SQL Server which is created by Microsoft and DB2 which is the database created by IBM. So there are a lot of databases but for our course we are going to consider MySQL database. The Python standard for database interfaces is the Python DB API. So when you want to make an interface or when you want to interface Python application with the database there are various APIs that is the application programming interface is that we need to use and the standard for the database interface is the Python DB API. So hopefully you have understood what is a database, why we are using the databases, what is SQL which are the different database examples and what is the standard database interface that we are going to use for interfacing. So thank you for watching. We will meet in the next video. Hello everyone. Welcome again. So in this video we are going to talk about why Python is used for database programming. So as we are trying to learn Python interfacing with MySQL should first address a question, a very important question that why should we use Python for database programming. So I have listed some important advantages of using the Python for database programming. Let us see them one by one. So first one is programming is more efficient and faster compared to other languages. So previously you may have heard about the languages programming languages such as C, C++ and Java where programming was easy but it was as compared to Python it was not faster as you have learned some basics about Python that we are able to use the idle we are able to download the Python shell and we are able to execute one line of program also whereas it was not possible in C, C++ and Java where to write any program we need to create or we need to import various files we need to write the main function then compile it and then execute it whereas in Python you can write one line at a time and you can execute it immediately by using the Python shell. So automatically Python becomes more faster than the other languages as it is more faster it is also efficient to write the programs in Python so that is the first advantage the second advantage is portability of the Python programs so Python programs are portable we are able to copy or port the programs from one operating system to another operating system or from one computer to another computer it also supports the platform independent program development so as it is portable it is also platform independent so you can develop it on any platform like windows linux macOS you can use any of the operating systems and you are still able to write programs using Python the next one is Python supports SQL Curses which is one of the most important advantage so as previously said SQL is nothing but the structured query language and it has a concept of cursors and these cursors are being supported by Python and as we are going to see in the coming videos we'll be using these cursors to perform different operations on the Python Python also takes care of open and close of connections so unlike other programming languages where we need to explicitly open and close the connection in Python it can do it automatically also it can open the connection and close the connections so that is one of the biggest advantage of using the Python. Python supports the relational database systems as you are aware that there are various database systems there is a rdbms that is nothing but the relational database system then there is a o rdbms that is object relational database system and there is also o odbms that is object oriented database management system but out of all these three the most famous or the mostly used database system is the relational database systems and Python supports the relational database systems so in the relational database systems we are having we are storing the data into a table form the table is made up of rows and columns of course we will be learning that in the coming videos but that is one of the biggest advantage of using the Python and the last but not the least porting of data from one dbms to other is easily possible as it supports large range of epis for various databases so we can take an example that we have already seen that there are various databases which are available in the market oracle mysql sql server db2 and so on and so on and python is actually supporting all these databases so let us take an example that if i'm having one application which is using the oracle database and the other application which is using the mysql database so if i want to import some data from oracle to mysql so it is generally very difficult but when you are using python which is supporting all these databases it is easy to port the data from oracle to mysql so that is again a very biggest advantage provided by python and because of all these things python is very suitable for database programming hopefully you have understood this thank you everyone welcome again to the course in this video we will talk about sql connectors in brief so what is mean by sql connectors so structured query language connectors are used for retrieving the data from the database as we have already learned that python supports a wide range of databases which includes oracle mysql sql server db2 etc each database is unique to access each database we need to use a database api so when it comes to python we have to download a separate database api module for each database we need to access so let us take an example that if i am using oracle so i need to download a oracle python oracle db api to access the oracle database same goes for mysql database so if i want to work with the mysql database i need to download python mysql db api so through the mysql db api i am able to access the mysql database so please remember this thing that for each of the database you want to use with python you need to install or download a separate database api and as we are going to use the mysql database in our course will be downloading a mysql db api of python so next question comes what these apis that is the application programming interfaces contains so these apis includes following steps so importing the api module so for each of the database we need to import the api module it contains acquiring a connection with the database so through this api we are able to connect to the database by using this api the next thing that we are able to do is we can issue sql statements and stored procedures so through this api let us consider mysql db api we are using so we are able to write the sql statements or we are able to execute the stored procedures and the important part is this db apis contains closing the connection so generally we have to use these apis if we want to perform the different operations on the database so please remember that for each of the database python has a different db api thank you again for watching hello everyone welcome back in this video we are going to talk about the mysql connector in the previous video we have seen that there are various sql connectors available in python as python supports variety of databases one of them is mysql so let us try to learn how mysql connector works how to install it so the mysql connector enables python programs to access mysql database so this mysql connector is enabling us to access the mysql database so if you are using a mysql database so you need to have this mysql connector similarly if you want to use the oracle database you need to install the oracle connector and so on so what are the steps to use the mysql connector first thing which is needed is we need to download the mysql api or the exe file and install it so i have just put in a url over here which i am going to show you so this is an official website to download the mysql api which is the this is the official website for the mysql to install as you are able to see this is the developer dot mysql dot com under which we are coming into downloads and the connectors for python so first thing you need to install is you need to see that which installer is required so depending on the operating system that you are using you need to select the connectors as you are able to see for all the operating systems they have provided the connectors you are having ubuntu debian susai redhat fedora oracle mac os we are going to use the microsoft windows under that it is you can just select the os version whether it is a 64 bit or 32 bit so depending on that also you are able to select so most of the time you are having the 64 bit version so once you come on to this page you need to select the operating system you need to need to select the os version and then it will show you the msi that is the microsoft installer and this you need to download once it is downloaded you have to just click on that and it will install the connector for python so once it is downloaded you need to install the mysql python connector by using opening the command prompt either you can do it by using the graphical user interface which is provided or you can go to the command prompt and execute the following command that is pip install mysql connector so this is also going to install the mysql connector for you and now connect mysql server using the python so once it is done you need to start the mysql server and connect it using the python so write the python statement in python shell so whatever id you are using for python you need to go to the shell and write down this command that is import mysql dot connector if there is no error message coming after this then it is clear that your mysql connector is properly installed so this is generally the way of getting the mysql connector but before that we need to install the mysql always remember that before installing this mysql connector you need to install the mysql so thank you for watching we will make in the next video hello everyone welcome back in this video we will talk about how to establish a connection but before that let us see what we need to do so before establishing the connection there must be a mysql installed on the system also database and a table already created so there are two requirements that we need to do first is we need to install mysql if you have not seen the previous video just see the previous video and you will know how to install a mysql and then we also need to create a database and a table in that mysql so let me show you how that can be created first is you need to start the mysql this is a command prompt where we are you are able to see that i have you need to go to the mysql directory which which is generally stored into c drive program files mysql in that you need to go to the bin folder once you go into the bin folder uh once you have given that path you need to type in this command that is mysql d dash dash console so this is going to start your server mysql server for you and it will show a window like this you need to keep this window open or start uh keep the server running once it is running you need to open another command prompt window by using the cmd command and in that again you need to go to the path where the mysql is installed in that you need to go to the bin directory yes after that you need to write down this particular command that is mysql dash u root dash p so this is generally what this is generally it's a mysql command followed by u which is for user and the generally the user which is created installing mysql is generally named as root you can change of course you can give some another name while installing it as well as dash p represents the password so it will ask you for the password the password is again the same which you have given at the time of installation so at the time of installation my user was root and I have also created with a password as one two three four so I have given a very simple password you can change these user names as well as password and once it is done you now you are able to see that there is a mysql prompt which is created yes so here we are actually creating the we need to create the database as well as the table but we can see that how many already the databases are present by using the command as show databases to run it we are using a semicolon and if you do that so as you are able to see that I have written a command called as a show databases and it is showing all the databases which are currently present in that mysql that is information schema mysql performance schema and sys so we need to create our own user defined database to create our own table so the command which is used to create a database is create database sorry and you can give as let us say I am giving the name as test and ended with semicolon and you just have to press the enter so as you are able to see the query is okay there are no errors one row affected so we have created successfully a database named as test let us see whether it is visible or not again I am using the same command show databases so as you are able to see over here so our new test database is created in mysql now we need to use this database remember that we need to create the database or tables under this test so the command for that is use test so it is going to use or use the test database for us so database is changed as you are able to see this is running successfully and then you are getting the message as database changed so now whatever tables we want to create will be created under this test database so under this now we will see how to create the tables so a very simple command is there create table and you can just create a table called as a student and if you are able to remember the SQL concepts so you can just use it and we will just create two or three columns under this so the command for it is create table I am sorry I have written it wrongly can I change this I don't think so so it is going to give us an error but let me let me just let us create a row number which is having the data type as int then let us create a name which is having wire care suppose 20 so I am creating a trying to create a database I think I am getting some errors I have just erased it and let me try it again so create table student where I am trying to create row number as int and name as wire care 20 and if you try to run this so yes query okay zero rows affected so we have successfully created a table named as student which contains two columns one is the row number and second one is the name so you can see this you can see the description of this table by using the DESC command so as you are able to see there are two fields which are there in this particular table that is row number and name row number is having the type as int name is having the type as wire care 20 this is something that we want to learn null these both columns are null so null value can be inserted over here by default they are also null there is no primary key defined and there is no extra information so this is just to show you that how to create the database in my SQL and how to create the table under that particular database so hopefully you have understood this let us meet in the next video hello everyone welcome back so in this video we are going to talk about the cursor object the object or the cursors that we need to create to do all the SQL operations so basically we have seen that there are four basic operations that we are performing on the databases that is to create a database to read from the database to update the database and to delete the database or the tables inside it yes so in python we need a cursor object so in the previous video we have seen how to establish a connection in this video let us talk about the cursor objects so the my SQL cursor class instantiates objects that can execute operations such as SQL statement so whatever SQL statements you would need to write you need to write through the cursor object of python so how to create this cursor object so very simple steps are there first we need to import the my SQL connector so in the previous video also we have talked that when you import this my SQL connector if it is properly installed then you are not getting any error messages so first thing is you need to import the my SQL dot connector which is the connector for connecting python to the my SQL database once it is done you need to create an object called as a my db or you can give any other name is equal to then you are writing the my SQL dot connector dot connect method you are calling this my SQL dot connector dot connect method to connect to the database so if you are having the database which is created on your local machine so generally there are three parameters it is taking first one is the host host is in our case if you are using the or if you are having the my SQL stored on the same machine so a local host is the name that you are providing so local isn't a host is nothing but the same pc that we are using so I have installed the my SQL on the same pc and and that is why I am writing as local host comma user user is the second parameter that we are passing to the connect method here you need to give the name username of the my SQL so as we have seen in the previous video that the name that we have given was the root and then you need to give the password that is pass wd is the third parameter and for that you need to provide that password which you have given while installing the my SQL so I have told you previously also that I have used a very simple password one two three four and we have seen that before once it is done so it will connect so this connect method will connect to the my SQL by using these three parameters that is the host username and password once that is done you need to create a my cursor object so here we have created a my cursor object by using my db so you are passing this connection object and you are calling the cursor on the same connection object and then you need to create a my cursor dot execute so either if you have created a database earlier so you can just use the same or you can use this particular command also that my cursor dot execute so this will execute this particular query that is create database if not exist test so this particular command is used to create a database called as a test we have already created a database called as a test in the my SQL but from python also you are able to create a database using this command so what this command does it will create the database test for you but when when if it is not existing so if it is existing so this particular query will not have any effect the test database will remain as it is it is not overwritten or something like that so please remember that this command is just to ensure that if there is no test database then it will create a database test for you then as previously we have seen here also through this also we are able to see all the databases which are present in the mysql so the command for that is for my cursor dot execute show the databases so as we have seen already there can be number of databases which are present in mysql so this command will show you all the databases to display all these databases you need to use the for loop for x in my cursor so here number of rows will be coming and this rows will be printed one by one by using the print x yes so here through this cursor object what you can do is you can just check for the uh connection you can check for the database creation and you can just see all the databases which are present in the mysql so thank you for watching hello everyone welcome back so in the previous video we have seen how to create a cursor object and how this cursor object in python can be used to write various sql queries so in this video we will talk about how to create a table through a python yes we have already seen how to create a table in mysql by going to the command prompt and writing the command so let us see how to create a table through python so the first step is we must open the database before table creation so so to perform any operation on database in python we should always open the database before doing or before writing any sql query so the steps now you should be able to remember always the first step is to import the mysql dot connector so we have talked many times about this followed by you are creating an object for the connection that is mydb mysql dot connector dot connect host here something it changed as we are seeing how to create a table see now we are passing the four parameters here one is the host second one is the user third one is the password and the fourth one is the database so here what we are changing is as we need to create a table we need to create a table under a particular database and to create a table under a particular database we need to provide the database name also so as we have seen we have created a test database previously so let us see again this host is local host as we are using the same machine or for storing the database then user is nothing but the username username of mysql that is root password while installing the mysql i have given as one two three four and then in the previous video we have seen that we have created a database called as test so now what will happen after this is whatever table we are going to create will be created under the database test next is to create a cursor object so we have created a cursor object called as a my cursor and we are just calling that so mydb.cursor then to execute any SQL statement we are using this my cursor object so my cursor.execute execute is going to execute this particular query and the query is really simple so create table followed by the name of the table that you want to give so here in this case we have given that as student so create table student followed by we are creating the two columns under it roll number which is having the data type as int three which is the size of that then as you are able to see something it changed over here we have written it as a primary key so while creating the table it will create the roll number which will have the integer values and which is also a primary key of that particular table and the second column that we are creating is the name which is having the data type as where care 20 so once this my cursor.execute will run this particular table named as student will be created in the mysql which is having two columns as roll number and name and roll number is nothing but a primary key so in the next video we will see how to display the records of the table thank you hello everyone welcome back in this video we will talk about how to display the records of a table so in the previous video we have seen that how to create a student table by using python so here we will see that if some records are inserted how to display the records of the table so mysql cursor is providing a fetch all method as the name itself is suggesting it is going to fetch all the rows from the table for you so this method is going to return all the rows which are present in the table so the method fetches all or all remaining so whatever is there so either it can return all or if you have previously fetched some of the rows so it will fetch all the remaining rows of a query result set and returns a list of tuples so this is very important part so it is returning a list of tuples so this as you have already known that there are various data types which are provided by python one is the number second one is the string third is the list then dictionaries tuples sets so here when we try to take all the records from the table so it is returning a list of tuples so that you have to remember so it's a list and if there are no more rows available in the table so it returns an empty list yes so in both cases it is going to return the list but if there are some records so it is going to return the list of tuples in the tuple format it will come and otherwise it will return an empty list so how to do that let us see the commands that we are writing on the shell so this is a this is a common command that we are writing everywhere import mysql.connector then all the other things are same localhost username is root password is 1234 and database is test yes and under this we have created a student table if you are able to remember so my cursor then you are creating the cursor object then my cursor.execute so this is one of the ways how you are writing the or executing the queries and here you are just simply writing as select star from students so if you are able to remember the SQL basics so select star from student is going to return you all the rows which are present in the student table now once you have executed this then how to take all these rows so now you are creating one more object called as a my records is equal to my cursor dot fetch all so fetch all method is going to fetch all the rows from the table and that will be stored into my records and to display them one by one if you want to display them one by one you are using a for loop for x in my records so it will take one row at a time from the my records and you can just use the print command print x so this is going to print one row at a time for you from the student table so this is a general way of displaying all the records of a table thank you hello everyone welcome back so we have just started with the crud operations so previously we have seen how to create a database and a table by python in my sql by using python in my sql we have also seen in the previous video that how to display the records of the table or we can simply call it as reading from the table and now we are focusing on how to update the record of a table so to update the record of a table one of the important condition is there should be some records in the table which is already present if the records are already present let us say that you are having a record of a student who is having the roll number as one and his name is akash and suppose now a new person is coming and he is in having the name as amit and you want to assign roll number one to the amit then what you can do is you can just update the record of a table so that is one example so how to do that by using python through python so again the some of the steps are common that you need to import the mysql.connector then you need to do the connection by using the host username password and database then you need to create a mycursor object so mycursor is equal to mydb.cursor and then you need to execute a command sql command by using mycursor.execute so here i have taken another example actually we are not having any marks column in the student table but what we can do is we can just add a new column by using the alter table command if you are able to remember the alter table from sql so by using the alter table command you are able to alter the table and you can add the new column as marks and here what we are trying to do is we are updating a student table so the command for updating is to update followed by table name that is student set is the keyword marks marks is the column name suppose we are having some kind of a marks column and you are assigning the marks as 99 where roll number is equal to 2 so here we are trying to update the record of a roll number to student and his marks are set to 99 so this is how you are able to update the record of a table and to see the change what you can do is you can again fetch all the records from the table by using the fetchall method and you can just print it and see whether updation has been done or not thank you hello everyone welcome back so one of the last operation that we need to perform on the database is the delete operation so out of the four important operations that I have told you out of the four credit operation that was create a read update and delete yes so most of the time it happens that you there are we are number of records which are present in the database and you need to read a particular record from the database or from the table so for that you are using a delete command in sql so if you want to delete a particular row by using a python let us see how it is so import mysql.connector this is all these are all our common statements then mydb mysql.connector.connect again you are using four of the important parameters localhost then user is username is root password is 1234 and databases test and then you are using the mycursor is equal to mydb.cursor and then you are using the mycursor.execute command and here what you are trying to do is you are trying to delete a particular record from the table so delete from student student is nothing but our table name where row number is equal to one so what will happen after this particular command so it is going to delete the entry from the student table where row number is equal to one so to check this again what you need to do is you need to use the fetch all method and in that cursor you need to write down the simple command select star from student and it will display you all the records which are remaining and it will definitely show you that this particular entry is deleted from the table where row number was equal to one so this is how generally you are able to use python with the databases as you are able to see in our course that it is really easy to use the mysql database with python and python also makes it very easier to write the programs or to do the operations on the database so hopefully you have understood how to write programs using python and how to interface python with mysql and how to perform different operations using python hopefully you have liked this course if you have liked this course please write a review for it and let me know that what changes we can make in this course so thank you for attending this particular course


And Steph here with Freedom and I'm with another friend, Meryl, whose birthday is today? How are you? It's my birthday. What questions did you ask Tiffany? I didn't think. Did you just stand and stare? Yeah. Cheesy hands, cheesy hands.


Namaste. We are going to start with an interesting course which is on cost and management accounting. Myself, Varadraja Bapad, I am a faculty in accounting and finance at IIT, Mumbai. I am a chartered accountant and cost accountant with PhD in finance and has and I have teaching and professional experience of about 25 years. This course will be extremely useful for everybody who is interested to know about cost and is also wanting to know how managerial decisions are taken. It will be useful to graduates of various streams whether it is students doing engineering, whether it is students doing MBA, whether it is industry professionals, whether self-employed people. This is useful for almost everyone because we keep on incurring cost in our day to day life and cost accounting makes us cost conscious and it also helps us in improving efficiency. Further in our day to day life also we have to take several decision. Cost accounting helps us in providing correct information, in providing fair information, in providing useful information so that we can take decisions which are suitable to us. We consider about cost benefit analysis to make the best use of resources. So this course would be really useful and it involves not only conceptual discussion, there are various case studies and problems to help you understand and grasp basic cost concepts and to make them useful for decision making. Namaste. Thank you.


Good afternoon foundation staff. This is dr. Theron Sherman today's briefing doesn't contain any objectionable material Although if you're just about to reach your daily quota for ridiculous bullshittery, which here at the foundation had you not You may want to return to this briefing at a later date Reminder that this briefing is brought to you by the site 42 broadcast network Which brings you the best possible news anomaly briefings and entertainment content in the foundation verse Head to the site 42 beacon in the description to support our mission on patreon and other social media platforms using your encrypted foundation issued accounts Steve let's begin List of things dr. Spanko is not allowed to do at the foundation notice from director naysmith Given scp 2337's poor grasp of cause and effect the futility of providing the subject with these guidelines is obvious However, should any of these rules be broken containment staff will be held liable We apologize if this article's title was misleading But list of things you are not allowed to allow dr. Spanko to do at the foundation was too long for skip nets character maximum One under no circumstances is scp 2337 allowed to have access to bagpipes rubber chickens the collected works of Marcel Proust weapons grade plutonium or table salt To scp 2337 is no longer allowed to claim that he's a quote psychic flying type or quote one of the legendary birds three scp 2337 may not defraud more than three civilian food service companies per hour for Insider trading tips from scp 2337 are to be ignored with extreme prejudice Five scp 2337 is no longer allowed to run for political office Six however given the inevitability of such an incident scp 2337 may only run as a demo Proble corn partly candidate Seven scp 2337 may not claim to have invented grass toasters MLA format or the spanko phone Eight the spanko phone does not exist Nine spanko phone is not another word for French horn Ten spanko phone is not another word for Sherman tank 11 spanko phone is not another word for calculus 12 spanko phone is not another word for Tom weights 13 any attempts made by scp 2337 to physically alter the vocalizations made by cows is to be intercepted and stopped immediately Cows are fine the way they are they do not need to say cack or a Treskin style 14 scp 2337 is not allowed to make hashtag boo the moo twendon Twitter 15 scp 2337 is not allowed within 400 meters of psych 59's on-site nuclear warhead 16 scp 2337 is not allowed to send Valentine's to psych 59's nuclear warhead 17 scp 2337 is not allowed to star in a PG 13 buddy cop movie alongside psych 59's nuclear warhead 18 scp 2337 is not to make any further attempts to coerce psych 59's office supplies into fighting each other to the death 19 under no circumstances is scp 2337 to be made aware of the works of Gilbert and Sullivan 20 scp 2337 is not allowed to be in a family guy cutaway gag 21 scp 2337 is not allowed within 20 meters of the psych 59 cafeteria 22 on a related note scp 2337's culinary suggestions are to be ignored with extreme prejudice 23 scp 2337's recipe for spanko sauce is to be especially disregarded and nestics will be issued for assistance 24 following incident 59 1 0 0 dash C and the resulting border restructuring efforts in Central America scp 2337 is forbidden to have any further contact with scp 7 9 7 6 25 continued suggestions from scp 2337 that the border between Costa Rica and Panama needs to be quote shaped like any zoo animal are to be ignored with extreme prejudice 26 scp 2337 is no longer allowed near an open telephone receiver Should he be caught humming and audible frequencies into a receiver again? He is to be immediately taken back to his cell and the phone is to be disconnected hermetically sealed in a lead line in sarcophagus filled with slaughterhouse byproducts and buried 500 meters under a mesh work grid of railroad ties Blessed by Serbian Orthodox monks containment staff are then to point at scp 2377 and exclaim knock it off you weasley goober in a portuguese accent 27 scp 2337 is no longer allowed to create original characters for the sonic the hedgehog universe while harmless in an isolated environment the unexpected internet popularity of such characters as Oif the Bramble Puss and ferrigerator the goose a dillo threatens the secrecy of foundation operations 28 scp 2337 is not allowed to be a whistleblower for any alleged misdeeds undertaken by scp 7333 Given rule 3 and 4 that would be hypocritical 29 under no circumstances is scp 2337 allowed to produce any more offspring with any instance of scp 3758-a scp 2337 has been neutered as per containment protocol, but this does not seem to have stopped him 30 scp 2337 is not to attempt any contact whatsoever with the entity. He designates his crazy cousin ubuntu 31 any attempt made by scp 2337 to reboot Frago Rock is to be intercepted and reported to o5 command 32 under no circumstances is scp 2337 to provide any constructive criticism to the Sun regarding color theory 33 scp 2337 is not allowed within 500 meters of scp 2317 34 the minimum distance from scp 2317 is to be increased to 20 kilometers if scp 2337 is wearing a Halloween costume and carrying a little pumpkin bucket 35 scp 2337 is no longer allowed to cling to be quote open source 36 scp 2337 is not allowed to create fanfiction 37 his Garfield fanfiction in particular is to be contained in the specialized hermetically sealed vault under the motherland call statue in vulgograd 38 scp 2337 is not and never will be an order muppet 39 scp 2337 is no longer allowed to add his OCs to the English alphabet The ongoing misinformation campaign to claim that the letter w has always existed has caused irreversible damage to the Foundation's budget 40 scp 2337 is no longer allowed to sue containment staff 41 scp 2337 is not allowed to be within 500 kilometers of a megaphone 42 claims that scp 2337 is a quote Skeksis are to be ignored 43 that being said scp 2337 is not allowed within the same building as a gelfling 44 there is no spanko cinematic universe and there never will be 45 attempts to contact the entity known interchangeably as the all-mather-of-lots Queen persnickety hoopla or that Sampa wielding magic mama on the moon who waters the spoons and prunes the spittoons are to be reported immediately to o5 command 46 scp 2337 is no longer allowed to turn himself into a rutabaga and claimed to be packle rack 47 please see sublass 1 through 38 for forbidden yodeling protocols 48 claims that scp 2337 is in possession of a never stone are to be ignored 49 that being said if scp 2337 attempts to contact any third party with the surname koshe Regarding sale of this never stone site 59 is replaced on lockdown until o5 command gives you all clear 50 finally scp 2337 is expressly forbidden from having any lists posted about you Oh god fucking damn it Steve did you do this all right? Well while we clean up this cacking mess that ends today's broadcast use your foundation in krypton youtube Like comment subscribe hit the bell become a patron to support our broadcast and we'll see you in the next briefing secure contain protect Damn it. I told you thank you for listening Site 42 studios and its staff are funded by viewers like you Please become a patron or visit our merch store at the link in our bio to support our work Secure contain protect


The base salary is the basics. It's like a cash. The moment you join the company, they're gonna give you the base salary. And the base salary is different compared with type of jobs in tech companies. For example, if you're fresh out of college, you have no work experience, but if you join big tech companies such as Google, Meta, Microsoft, and Amazon, you're getting paid a lot. If you are a software engineer, your base salary could be about $150,000 or up to $200,000, but they also give you lots of equity and stock options, and your total compensation can easily get up to $250,000 as a fresh graduate.


out well, so it's like landlines, not even like wireless phones. We're using like wired landlines right now.


Hello my creative friends and welcome to my home studio that I call Monet Cafe. This is my little place in my home that I love to create and share via YouTube with you guys or wherever else you may be seeing this and I am excited about our Facebook group. It's called Monet Cafe Art, Monet Cafe Art Group. It is a private group so you would have to ask to join but we welcome any art level. You can be someone who's never even tried pastels but we do ask that you are actively seeking to learn more about pastels. You can even come from another medium. It doesn't matter if you've never tried pastels before so we welcome you and again I love seeing your art and everybody is growing and learning. But anyway back to Monet Cafe YouTube. Today I'm going to be standing at my easel which is what I prefer. I've gotten away from standing a little bit because it's easier to make the videos sitting down with my camera the way it is. But I prefer to stand because I can step back and I can see values and it's so much easier to see what you've done from far away. So I will be standing and I don't think today I'm going to give us much commentary as I've been doing the last couple of videos. I know a lot of you have requested the commentary. I totally get that. I actually love talking to everybody while I'm painting. I feel like I'm right there with you. But in this particular case I want to enjoy the process. Sorry is that selfish. I miss sometimes just the experience because it's as much about the experience as the finished product and I often put on praise and worship music and paint and it's just a place like an escape that I go to in my mind and I love it and most of you probably know what I'm talking about. If you don't you should try it. It's awesome. So anyway I'm going to get started and today I'm going to be using a reference photo from a gentleman named Martin who is on our Facebook group and he has generously added some of his photography to our member reference album. We have an album on the Facebook group where members are uploading their photographs allowing other artists to use them to paint and the neat thing is artists or people interested in art are usually really good at photography and they already crop things out right and have good compositions. So there's some beautiful photography there for you to use as reference photos or upload your photographs for other people to use. So that's what I'm going to be using today. It's just a beautiful photo that inspired me of some beautiful flowers. So I'm going to get started and I hope and pray that you enjoy this and that you'll come back and subscribe to our channel. All right thanks guys. I can't wait to get started. All right this is the initial sketch with this is just a Geoconda pastel pencil. This is sepia light is the shade but you could use really anything that's like a harder pastel. You can even use a pencil pencil but I like keeping it you know in the pastel family for the sketch. All right so now I'm just going to sketch this in and enjoy the process. All right I don't always get this detailed with an undersketch but in this case the photo was already so beautiful and I love the placement of everything that I just really wanted to get it down as accurately as possible. Some of these things may change as I go but at least I have a base to work from to feel confident about where things are to begin with. Now what I'm going to do is because this is UART paper you can hear it's sanded and it will receive water. So this is a 10 by 8 inch. I work in standard sizes typically just so that they're easy to frame. If a client doesn't want to have to go get a custom frame there are a lot of pre-made frames that are really great right now but um but anyway so that's just my reasoning for that. Now I'm going to I thought about doing an underpainting with my wax pastels which you may have seen in another video but I think first what I'm going to do is do an underpainting with um watercolor. This is a just a little travel set that I have. This is actually kind of a neat little travel watercolor set. I've added too much paint down in here um but it's made so that you can hold it like a palette. I'm left-handed so I would hold it this way and you you use your little wells here to paint with and I think the watercolor behind it will sort of set the mood. That's usually what I'm doing um with my art um with an underpainting is just setting a mood to work from. So here I go with a watercolor underpainting um a little bit of my thinking behind the underpainting with the watercolor. First of all you may notice that if you see my other videos I like drips. I think it adds to the painterly feel so I purposely mix up my watercolor with a lot of water. I didn't used to do this. I remember when I was first trying to discover how to do watercolor and under paintings with watercolor or just applying watercolor painting. I wasn't confident enough to let the water explore and to get creative with color. Now there's a fine line with it. You don't want to get too dark too quickly with watercolor but one good thing about this is it's an underpainting and it is going to dry lighter than it typically goes on at first. But what I'm doing with this is I'm giving this is not a complimentary underpainting. This would be what's called more of a local color. I'm using pretty much the colors that are in the scene already. I'm punching them up quite a bit because I like color um and I like that bold statement of beautiful color um but if you notice I um I am working mostly with values in this. I noticed that in the photograph this area here behind these flowers is some of the lightest values like the sun is shining behind them. If you notice the flowers are really kind of in the shade and so that's why I went ahead and gave them um you know some shadowy color bluish bluish purplish um petals here because um there's no sense in just leaving them white and then having to go do the value in pastel. So that already gets an idea of the fact that they're in the shadows and so that helps me a lot. There's a tendency sometimes when with painting that you see the flowers and you want to leave them blank because you're going to go in and do pastels but I've found that it's good to go ahead and just let things flow over it as long as I can still recognize where things are which I can for the most part and if I can't it's okay I'll just improvise and that kind of adds to the uh um spontaneity of it all. So anyway I think I like this underpainting so far I like the color I like the drips and I'm going to take it slow and easy with the pastels because I want to keep this painterly loose style and not lose what I have going on here so now on to pastels. Here we go. Alright so I know this looks like a lot of pastels in my little box that I use but I got lazy like I do sometimes and I didn't put my pastels away from my other paintings so I just added a few to this and um I should have enough selection out of this numerous amount of pastels so we'll see what we come up with here but I might also use my handy dandy little pipe foam insulation blender that fortunately I learned from Karen Margolis um it's just a little piece of pipe foam that works really well for blending um some of these background I'm going to try to leave the luminosity of the paper um but I think I will have to add some pastels to get a darker value back in here again these watercolors dried pretty light um so I'll just keep squinting my eyes and blending and try to get it uh correct but I am going to try to keep this loose and carefree so here we go I'm going to turn on my music and take a sip of my coffee the creation um creations that you're making and um others are sharing about their um things that they have a little


My parents tried to like have me learn my heritage and at the time I didn't really want to oh really do we have dual citizenship We're rolling. All right. Here we go. Let me do an Instagram story behind the scenes Hi guys, welcome back to my channel I have such a special guest with me because this is Leni D. Hi. She was adopted with me We were in the orphanage together And if you haven't seen one of my other videos with one of my other shaman sisters Emily I will link it down below. Also, Leni D has a YouTube channel. So I'll link her channel down below as well I'd love it if you would go check it out. She talks about different topics and hopefully in the near future She will talk about going to boarding school. That is coming soon So go over to her channel and like spam her comments saying that you want that video because I want that video Do you want to say anything? I mean basically, I think you just covered that intro Anyway, if you enjoyed this video make sure to subscribe and also give this a thumbs up Leave a comment down below if you are adopted or know anyone who's adopted because I would love to know Today's video. We are answering some questions from you guys About being adopted if you guys are not following me on Instagram Make sure to do so and you can participate in any of my other Q&A type videos. We're gonna start off with Twitter Okay So Laura says would you like to learn the native language that your biological parents know? So a fun fact. I actually did learn it, but very badly Um, I mentioned that in my other video. Basically, I took Chinese I think for about 10 years before I quit taking it and I learned how to speak it so I can like Conversationally speak to someone in Chinese Mandarin only not Cantonese, but I can't read anything for me No, I don't really care. I know that sounds so bad But number one Chinese or Cantonese or whatever you just I speak Mandarin specifically And that's what they speak like on the mainland primarily not it and yeah But I've just heard that it's so hard to learn and I could barely understand Spanish and around here There's a lot of people that speak Spanish. She would think that I would know like more I know some words or whatever because I had to take that in school But like that was my hardest class. I found like it was harder than any other class I've ever taken and I've taken some pretty challenging classes So no just because I don't think it would come natural at this point Also, I'm just kind of done taking it because it's like I could probably go back and learn more But at this point in my life, I'm just not particularly interested I took five years of Spanish actually so I speak that much better and I just find there's more places I can use it the next question is actually a really good question So thanks Courtney Courtney has a channel. Thanks girl for supporting me Even though I called you out about not asking a question Do you have dual citizenship as far as I know? We don't I don't know I don't think so, but I'm gonna call my mom and ask because hopefully she'll answer Hey Do we're filming a video. Do we have dual citizenship or no? Okay, then we don't yeah, yeah cuz Shailen's right. Yeah, what am I gathered? It's like it kind of transferred over when we came over here. Yeah. Yeah. All right. Thanks, Sherry. Thank you Okay, you're welcome. What are you guys doing today? Filming out filming hanging out. Okay. All right. Bye Sherry So, no, we don't have dual citizenship Nope It all just transferred over when we came over here like I have the old passports that we used to have yeah We do have an old passport. So speaking about the passport. I have mine and this is what it looks like Here is my Chinese passport Obviously, I want to show you guys a picture of me as a baby before I was like adopted and stuff There it is There's me as a baby and my name in the orphanage was Joe Mangin Joe Ma Jean. Yep. What was yours? Song Zihong. Sherry says that you have the prettiest Chinese name Yeah, it's really funny because people always say how pretty it is when I think talk to Chinese people and they're like Oh, what's your Chinese name? I tell them because like in English it just sounds kind of ridiculous It's thinking rainbow. Song Zihong. No in English if you translate it it means thinking rainbow Well, then what does mine mean? I don't know. That's the problem with not being able to read Chinese Okay, well anyway, that's my passport We had the passports which is like what they issued us when we had to you know cross the sea to come back over here and then I think from that point like it was just done because then we were officially like American citizens and She's from Washington state. Mm-hmm. So if you guys didn't know all of us live in kind of different states I think you guys already knew that though. All right, so let's move on to Instagram Instagram Someone says have a good day. Thank you. K saw asks in what ways have you felt connected to your heritage? Oh, I gotta think about this one Both of us were completely from like white families, so It's a very different attempt to connect to it. I guess you could say then You know like Alyssa who was raised by Chinese parents So there's like a difference with just that to begin with I mean for me, I didn't really connect to it for a really long time If you look at my channel, I've got these like videos that are like these Asian studies projects from college And that's kind of what I started to do like actual connecting to my heritage because before that my town is like very small And very like non diverse so I didn't really have any way to connect to my heritage I just kind of would try to like ignore it because more often than not it'd be something that would make me other than like Part of something I only got to really enjoy that kind of part of being like Chinese and when I went to high school and hung out with Chinese Americans boarding school not my public school and then When I was doing my studies stuff to kind of like get in depth and just kind of think about it Um for me, I haven't really and I know that sounds so bad But because like she said we come from white families and a lot of people around here are not at least Chinese I was friends with a lot of Asian people like during my childhood and growing up So that is kind of where I got my Asian pride, but they weren't Chinese necessarily for strictly the heritage part I haven't really connected at all. I mean that your parents and try to like I want to use like this like with quotation marks Like make you though like no your heritage because my parents like tried to like have me learn my heritage And at the time I didn't really want to oh really yeah, you know with like I'm taking Chinese And then I took like some kung fu and I quit immediately because I really hated they put you in kung fu Yeah, I mean I wanted to learn a martial art cuz like You know those things how like every like kid like there's always kids that are taking like martial arts and whatnot Yeah, but no, it's just funny because that's kind of like your Chinese like not saying that's racist But like that's very stereo. No, it is it really is cuz here's the thing So everyone's taking like martial arts at the time. So I was like, yeah, I was taking karate Let's do that and instead they put me in kung fu the martial art itself is fine But the way that it was taught at that particular place. I did not like it was very let's say intense It was very intense. I also wanted to say she is right My parents never really forced upon me to learn or connect with the heritage And I'm kind of happy about that because that's not who I am as a person. That's not how I was raised It's not where I grew up or anything So I kind of am appreciative of that because I wouldn't want to feel something pushed on me because I think I would have your reaction of Like not really wanting to do that and I personally don't if I wanted to do that I would want to have it within me to want it. It's like when you choose you want it Yeah, it's like time to come back to it or whatever. Yeah, which I did do that a little with learning Chinese when I was taking community college I thought I was I was trying to go to a school that had a language Credit requirement So I actually took some a bit of Chinese at the community college because I was literally like I've done five years of Spanish I don't need more of this. Let's see if I can learn how to read. All right next question Have you thought about meeting your birth parents? Not specifically when I was younger I might have dwelled on it a certain amount just because of like again being one of like the only Asians and the only Chinese people in the area So sometimes, you know, people would ask that a lot which got really annoying as a kid But I would sometimes wonder about that just because of the fact that like oh would I belong there better than like here And that kind of thing keep in mind too. She lives in a very very small town. It's very white very white very small town I grew up in a obviously a larger city a lot more diversity, so we have a different experience. Yeah It was extremely different. I was it was like I'm from like really rural parts of Washington Like when you think Washington you think like the rain and like Seattle But our side is like a desert climate so you get like all of the seasons and also it's extremely rural So sometimes I would just sort of think like what I fit in better there and those kind of things But it's not necessarily about finding like my family and who I am It's more about like just when I was a kid It was more like what I fit in better and then I kind of you know, let that go as I got older Have I thought yes, and I still kind of do but not necessarily to connect with them on like any emotional level I would just want to see what they'd look like. Who do I look like more? Do I look like the birth mother or birth father and to just put this out there? They are birth parents They're not my parents not the people that raised me Please don't use the word real parents because people use that all the time in real life It's at least to me very annoying. It's just they don't understand though. Yeah I'm saying like as an informational way like I'm not like trying to like attack people who are doing that I'm saying like for future reference, you know, like personally for me And I think for you as well like using real parents is just kind of annoying. Yeah. Yeah, but then I correct them So I'm like, oh my birth parents. Yeah, that's what I do, too Yeah, just to like make sure that they understand so I feel like I mean I'm guessing about this But I feel like I have the birth father's body. I don't know but I have an hourglass figure So maybe I have the birth mom, you know I feel like I have like male shoulders though because they're just so broad and it's annoying You never know maybe like your grandma's shoulders or something now. Oh gosh. Yeah, that is something I am curious about sometimes. So the next question is kind of towards me But Baraboo 101 asks did you have any struggles growing up being adopted by two women? No, not really I had a couple people that thought it was weird, but that was when we were in middle school Other than that not really I was always and I'm still nervous about telling people because like I don't know what reaction I'm gonna get but we are in 2020 now and you know times have changed So I get less nervous saying like hey, I have two moms.  Do you ever want to try and find your birth parents? This kind of segues into something I'm working on because I took a 23 and me DNA test And I wasn't like specifically looking to find my parents or family when I took it It's actually funny people like when I'm in public will like walk up to me and like Korean people and they'll be like Are you Korean? You look just like my sister and so I was mostly I look Korean too. Really? I think it's because of our eyes. Yeah, it might be the eyes And I really high cheekbones and so me too. Yeah, I mean mine are high. We come closer Like we've got those like high cheekbones, which are in certain areas. Yeah But yeah, so people will ask me that and so after a while I was like, let's put this to bed I'm curious now. Like is there any Korean in there? Like is there anything else non-Chinese in there? So I figured let's take the test for that reason But then like I also like clicked off the on the like find my relatives thing because I thought oh, this could be Really interesting. What if I find like a random adopted sister or something? You know, that's gonna be really interesting Yeah, I know so I figure like I don't know if I'll I don't know if I find anyone if I'm gonna approach them or not But I just thought it'd be interesting to like Specifically see those results and then if anything shows up that could be interesting as well Um for me I would want to try and find them only because I want to see what they look like and Because I think it would make a great video It would be like titled finding my birth parents or something But I need a lot of money for that which I don't have so I don't know if my YouTube channel like skyrockets or something and Yeah video coming soon, but obviously I don't have the money to find China and especially with the corona virus The last question is where are you from? They probably mean like where you from in China? Yeah Oh, we're called shop and sisters as far as we know. We are from China and a Fuji on province Yeah, okay, so that is going to be it for this video I hope you guys enjoyed it make sure to give it a thumbs up go over to Lenny Dee's channel and She will have hopefully a collab with us that will be up relatively soon Hopefully and I will see you guys in my next video. Bye


Hey stampers! Welcome to another week of Watch It Weekly Wednesday. I'm Aubrey, part of the Stampin' Jill creative team, and today I'm excited to share with you the Halloween suite from the mini catalog, the holiday mini catalog. It's the Magic In This Night suite. It's on page 52 and 53 is the spread, and I have to tell you the accessories in this suite are some of my very favorites in this catalog. They are so cute. So in in this suite comes the Magic In The Night designer series paper, which is so cute. You have the Hollows Night Magic Bundle that comes with the stamp set and the dies. You can see it a little more clearly here on the next page. Super cute. It has these fun kind of like tag dies in there. So cute. It comes with the 3D embossing folder, the cobwebs, the black glitter paper, which is the prettiest paper ever. I love it. Iridescent pearls, my favorite, and the metallic mesh ribbon, which is beautiful and it's great for Halloween, but I also think it's beautiful for Christmas or other holidays too. So so much fun. I've had a lot of fun playing with this suite, and I just wanted to show you some of the projects that we've come up with. So I'll bring those in. I did this one Happy Halloween and I embossed here, and then I cut it out with those dies, the tag dies that come in that bundle, and then I put them on one of our little round tins for a cute little treat. So fun. Here's another one with the round tin. Open if you dare. So cute with this spider. Love that spider in the stamp set. On this one you can see I stamped the bats here on and this is one of our mini paper pumpkin boxes that's in the catalog. So cute. Love that one. And then this one with the mosaic cello bag. I just sponged the some of the DSP in there and then made a cute little tag on here. There's magic in this night. And then this is some of that metallic mesh ribbon. And if you notice it is colored blue instead of the silver. So I want to show you how I did that. Just a quick little tip on how to make this cute metallic mesh ribbon, which really is one of my favorites. You can make it any color you want. So here it is. You can see it's so pretty and it just has that beautiful sparkle to it. And I've I've showed this before, but it's such a great technique. I want to just show you quick again. So we have our Stampin' Blends. These are alcohol based markers. So because of that you can color ribbon and the color won't smudge onto your fingers after you color the ribbon. It's really great. They come in a lot of our different Stampin' Up colors. So you can color your ribbon whatever color you want. But I especially love it on this metallic mesh ribbon. I think it looks so beautiful. So let me just show you real quick. I just took my blends. And this is the Pretty Peacock. The Dark Pretty Peacock. And I just literally just color it with that tip. And I use the the thicker brush tip because it will cover a bigger area at a time just like that. And then the coolest part is let it dry like for a few seconds.  So such a great way to color your ribbon. And then I just tied a fun little knot in this. So you could see that color even better in the knot. So cute. I love love love this ribbon. One of my favorites. So I've loved playing with this bundle that's in the Holiday Mini catalog. If you're interested in any of the products you've seen here today make sure to click the link below. And thanks so much for watching. We'll see you next week for another Watch It Weekly Wednesday.


One of the things that I hate the most about Linux is that developers often put Configuration files where they don't belong. I just cannot stand Config files in my home directory. I don't know why developers insist on putting things there. They don't need to go there There's a configuration directory for a reason now part of this is just me being Pedantic about where things go and why things exist in certain places But one of the things I love most about Linux is the control that I have over the system and a lot of times I don't have the control to move those directories and files to other places They're forced to be there because they're hard-coded into the programs and that is just Terrible design and terrible developing in my opinion. So developers, please Please stop putting configuration files in the home directory. They don't go there. They go in dot config. Thanks for watching