Σ Sigma Hosting is mainly a video tutorial website

Σ Sigma Hosting is mainly a video tutorial website that make it easier for you to search within the transcript of videos for solutions of problems you might face during your journey in dealing with different webhosting companies. So, we are very sorry if the text is not well organized and we may work on it in the future but for now we hope you get the benefit mainly from the video then you may need to have a look on the transcript. Thanks for your understanding 🙂

hello everyone welcome to part two of how to build a social network in Wix the non-coding founders guide so we're at a little bit of a different style of video here because I really make sure to stress the importance of planning a website before you build it so I'm gonna take you through the process of doing exactly what I would do when building a website so we're learning how to build a social network in in today's video we're gonna focus on the database side of things so what we're gonna do is we're gonna plan out our user group in the different databases we can think of right off the bat right now when we're starting this social network type website so before we get into things it's important for me to stress a couple important points here one we are gonna build a website similar in style and in functionality to Twitter now we're not going to get as extreme as crazy as Twitter has but we're gonna build the basic layout in the basic functionality of being able to create a profile post statuses like statuses direct message those type of things same as Twitter now the other important thing that I need to tell you is some of you may be watching this video and saying well I'm not building a social network if that's not you what I need to stress is that this series has more than just building a social network we're learning valuable Wix code lessons this series was originally built to teach a bunch of Wix code tutorials because I know how in high demand they are and how much you've requested them so what I would ask is join along in this series and take the points from each part of the series that we go through that will apply to you in your website I will tell you that we have a couple other series coming up but they will follow this building a social network in which series so let's hop right into it so first right off the bat we're building a social network similar to Twitter so what are our user groups well we have really one main user group and that is users themselves so on social now we're gonna have a couple different groups depending on the style of social network you look at Facebook now and they've got so many different types of groups so many different dynamics because they have business pages groups regular everyday users but you look at Twitter something like Twitter it's a little bit more simplified in the aspect of who's on the platform its users it's strictly users so we have to take into account what type of databases we're gonna set up for our users so let's draw this out a little bit when we know our target market here is users right we've got our users right here but then what we need to do is we need to identify okay what do these users need to be able to do on the website what access are they gonna have what type of functionality will they be able to use so when we're building this website there's a couple of different functionalities we need to think of design and functionality the first is well we want our users to create a profile page we want them to be able to create a page edit the profile information edit their profile picture and put information on to their page so the first one is profile pages okay so profile pages is step one that's the very basic form right so when you get onto a social network a hundred percent of the time what you do is you get a profile when you sign up the other thing we need to look at is a social network is full of social activity you're posting stuff to the network it's social media you're posting media to the website so the next aspect of this is statuses posting statuses so we're gonna go ahead and say statuses when you get a social media account you usually follow other people and what you do is you see that information in the feed so we have to have something to put into that feed and that's where the statuses come into play the next thing we have here I do have a handy-dandy little sheet over there to my left is something in addition to statuses is image uploads so we want to post more than just text to our social network so we're going to post a couple different styles of things in this case we're gonna have two different styles we're gonna have your regular text type statuses where you write out text and post it or image uploads so we're also going to have image uploads I'll just put images for short so now after we have our profile pages statuses and we know we're going to have image uploads we also need to have a system to be notified when something happens on a status that we post so we often refer to these as notifications so we know we're going to need notifications on our social network we'll go ahead and write notifications okay so now we have a user that signs up build a profile page when they build that profile page they can either stay there stay stagnant and just follow people and read other people's statuses or they want the ability to post the status of their own post their own update post their own status post their own picture perfect we've got to that step following that step we want those people to be notified when something happens on their status if someone comments and someone likes their status so we want notifications built in as well on Twitter you often see this referred to as liking and retweeting also quoting so commenting is quoting on Twitter so we're going to again build a light version of Twitter here so we have these different statuses we have our notifications profile pages and then that next thing we need is also what I just said a liking system so we need to build a liking system into this side okay so we have our lighting system after our lighting system we need to build in a commenting system to also back up that whole liking and commenting notification idea so we want a commenting system okay so we have our lighting system commenting system and those are technically part of notifications but at the same time we can't necessarily classify that it's classified under the entire scope of what we're trying to do after our commenting system we also need to build in a follow system but we're gonna that's a little bit more complex we're gonna really focus on the database side of things today but what I'm gonna do is I'm gonna write it in here and I'm gonna go through and at least put the ones we know right off the bat so follow system is next you want to be able to follow someone and then get their statuses their feet of information that they post so anyone you follow you get their statuses and their images that they upload so we want a follow system and then the last thing we're going to write on the board in this video as far as planning goes is peer-to-peer messaging so also known as PM or DM direct messaging private messaging either way we want to have that on our list as well because this is going to be a separate database as well so we're gonna have here we'll just call it p2p messaging okay so this is a basic outline of the different functionalities and pages we're going to need on our website so most if not all of these pages will be something called dynamic pages well in order to display information and pull information onto a dynamic page we need databases so what I really want to stress and show you in this video is the setup of databases that we're going to need so we're going to start with everything we've mentioned here we know off the bat that profile pages are going to need their own databases because profile pages are a separate entity of some of the other things we have here profile pages are where people are going to create their profile upload their image profile image maybe a header image as well their name their email there may be app name or follow name if we're gonna do that I haven't decided quite yet and then also there are about information and all that great information but we also want them to be able to edit that information or delete that information at any time so we need a separate database to host all the profile page information so we'll just call this database one so after we've got database one here that houses profile information we need a separate database for our statuses because when someone posts a status we need them to be able to post it and that information will be stored in a separate database because it'll be stored on a separate dynamic page known as our feed paint so our feed page here will house information from database to and database to will house all status updates that anyone on our website comes in and post so statuses and images will go together on database to since statuses may contain images in there they're gonna coincide and go together so we're gonna go in here and we'll connect them and we'll call this database too so now we've got database 1 and database 2 for profile pictures statuses and images notifications so notifications are gonna be a little bit different I'm gonna have to show you guys as we go through the series how we're gonna do some of these things as I said this is the non-coding founders guy however there are going to be very minimal amounts of coding and a few little lines here and there notifications are gonna be part of this so right now in the planning phase we're gonna say okay we're not ready to move on to notifications so we're gonna say TBD next to it as far as databases go to be determined because I will carry through notifications when we get to that point in the series that'll be a little farther down the road after we go through the series and build out profile pages build out statuses build out feed pages build out an image upload all that fun stuff we'll be done before we get into notifications the lighting system and commenting system are gonna be similar however for the commenting system we are likely going to need a separate database to house comments and we're going to use reference fields to reference them back to the original status post now I know this is confusing but we're not going to focus on that in this video what I will tell you is we're gonna call commenting system here database 3 so database 3 to database 3 right there and for our liking system we're also gonna put TBD to be determined because again we're gonna use a little bit minimal amounts of code and use that to build our liking system if we continue down our list there we have our follow system once again not going to focus in emphasis on this one we're going to put Beadie on the following system and then finally we have our peer-to-peer messaging what I can tell you off the bat is this is going to be a complex part of this series it's going to be cool because really there hasn't been many websites done in which where you can actually create a direct messaging system homemade from scratch custom built but I'm going to show you how to do it the only thing is we're gonna have a high emphasis later on in the series this will be one of the last things we do in this entire series again there will be one video uploaded per week and this is going to be towards the tail end of things what I can tell you is we definitely will need a separate database to store private messaging so for right now we're just gonna put database for but we may get into more complex databases we may need a couple databases but I'm not going to stress that too much yet so we're gonna put database for here ok so now we have all of our tools to properly say okay here's our users here's what our users need to be able to do on the platform they need to create profile pages they need to be able to post addison's they need to receive notifications based off of whatever happens on their statuses from other people we need a liking system so that way people can like certain statuses we need a commenting system so people can comment on those statuses we need a follow system so people can follow other people and receive different status updates in their feed and then finally we need a peer to peer direct messaging or private messaging feature that allows you to message someone else that you follow or don't follow we'll have to set the parameters there and put send messages back and forth to each other this is our basic layout of what our lite version of a simple Twitter is going to look like so this is the information we need to know now what I'm gonna do is I'm gonna cut this video here and I'm gonna head into Wix and show you guys the actual setup and database creation of which so what I'm gonna do is I'm actually gonna build this site from scratch with you in Wix so I'm gonna show you my step by step what I am NOT gonna show is I'm not not show every single piece of design that I do so I'm gonna show you all the functionality but when it comes to the overall scope and fuel the design I may not show you every aspect of that but I will show you how to connect the design that you create and that I create to all the functionality that we're building here so let's hop right into Wix and show you how to actually go about setting up these databases and setting the correct permissions right off the bat so that way we know okay this user has access to do this this and this in this database with this information so let's hop into Wix and go ahead and start that hope you guys are enjoying welcome to part two of part 2 so I just explained to you guys on the whiteboard our whole planning sequence and planning out the databases from the user groups obviously we discussed profile pages status updates image uploads liking system commenting system follow system and a peer-to-peer messaging system so we discussed a lot of different things in our planning phase now we're not gonna go through all of those things in one video because man that would be one long video but what I am gonna do is I'm gonna take you guys from the start of the process which is picking our template which right off the bat guys we're building from scratch on this one we're gonna go with which is blank templates here and we're gonna go start from scratch and press edit so now that we've got our template up here's what I'm gonna do for the remainder of part two I'm not gonna go through and build out the fields in each database that we need because that would take one a large amount of time for the time we've already spent in this video I'm gonna save that for another reason because when we build out the fields I really want to correlate that with our dynamic pages so we're gonna save the building out the fields and dynamic pages for part three of our building a social network in Wix the non-coding founders guide series we're gonna say that for part three so in this video remember the remainder here of part two I'm gonna actually just go ahead and set up the databases we already know we need and set the permissions up on them with you so we can see here the which code developer tools were activated as soon as we came onto the website if you are just getting on a website and you were ready to go design and you're not ready to add the tools and the functionality and yet to deactivate them come up here to code and if you hover over it you could just turn off developer tools just like that but in this case I'm gonna turn them on so like I said in the previous whiteboard part of this video the design portion of this entire process of this entire series I'm gonna kind of do in the backend along as we go you guys are gonna see me incorporate some design into it there is gonna be a design like it's gonna be fully designed fully functional but I may not show every single element of design that I do what I really want to stress in this series is the importance of the functionality the Wix code that is the meat of this whole entire series however with that in mind obviously to make elements work a certain way you have to connect them with functionality so you're gonna see an incorporation between the two but like for its in instance right now I'm not gonna show you like myself designing the home page I will save that for a next portion maybe even a filler video somewhere in mid week I'll throw out okay here's the home page design but I'm only going to show you setting up the databases right now so this leads me to my next point to set up databases in Wix code we one have to activate the developer tools and then we have our properties panel over here we're not going to worry about this guy right now in fact we're even gonna Exim out and then we have our pay our excuse me our page code or our code manager code handler down here at the bottom of the page I'm gonna minimize that little guy and then over here to the left we have our site structure if you do want to minimize the site structure at any point you just press this little arrow and it'll minimize and to bring it back out you press the arrow again so we see over here on the site structure pages public back-end database public and back in these are for two code two different types of code to call API stuff like that of course we've got a little update coming in here no not today so that's that's for that we're not gonna focus on that aspect right now but what we are gonna focus on is we're gonna focus on this database section so we identified in the previous video that we need a couple of databases one we need at least a database for profile pages to tend to collect user information store user information and allow that information to be edited or deleted so we need one for profile pages we need a second database for people to post statuses in images again usually images with their status that's gonna have its own database we're gonna have a database for our commenting system we may use some reference fields in this portion but we are going to need a database for this and then we're also for sure going to need a database for the peer-to-peer messaging now the peer-to-peer messaging I am NOT going to show you the setup of the database in this video because like I told you in the previous portion that is gonna be a whole you know part of this series by itself the peer-to-peer messaging is probably going to be in addition to the series it's gonna be the last thing we do tying everything back together so we're gonna build everything out again that's like light version of Twitter and then that peer-to-peer messaging direct messaging will be the last portion we work on so in this video what we're really gonna set up is we're gonna set up the database for profile pages and statuses because that will connect to what series we're doing neck or excuse me what part of the series we're doing next which is the dynamic pages along with database fields so let's do that let's set up the database first for profile pages this will be user information so to set up a database we're gonna go click add a new collection when we do that we'll see this nice little introducing database collections then we press start creating this is where we name our database so I'm gonna name him here's a big portion of this guy's when you're naming databases for whatever project you're working on because I understand some of you may not be building a social network but you're building a similar type of concept make sure you keep everything organized and clearly named and marked it's gonna help you in designing especially for these more advanced complex websites so for these I'm gonna name it profile I'm gonna name it user profile data user profile data is pretty self-explanatory I know that it's the users data and it's gonna be for their profile keep it clean keep it concise what's this database collection for I'm gonna scroll down and we're gonna use custom use there's gonna be pretty much all custom use databases in this tutorial in this whole series so now we're gonna go to set up custom permissions what this means is we're gonna set the permissions of this database so when we do that we have a couple different options set permission rules so the first one reads who can read the content from this collection well remember this is the user's profile page and when you're on a social network or social media you're always able to click on someone's profile page and read it right so that means anyone the answer to this question is anyone ok so we want this to be anyone any site visitor could come on and read someone's profile that's step one step two who can create content for this collection well we only want the site member auth well in this case the site member to create the content for their collection for their page we want that site member to be able to upload their own information for their profile page which leads us down to our next two who can update content from this collection well we see a new option here we see site member author so this means and this is who we're going to select the registered user who can modify their own content so if the site member created and updated the information in their profile page the site member author that same person that added that information is the only one who can update it and we're going to select the same thing for the same person who can delete it so the site member author is the one who can delete that content from their collection once we do that what we're gonna do is we're simply gonna press set and create collection and then just like that our user profile data database is created once again I'm not going to show you the building out of the fields in this portion of the series that is going to be in next week's portion which is gonna be database fields in dynamic pages so we've got the user profile data database complete somewhat we've got it started I should say now we want to create a database for statuses so this is the database that's going to hold all the information of where people post statuses so we're gonna go back to database and now we can click this little plus button over to the right to add a new one new collection and we have to name this one for this one I'm gonna name this user statuses pretty simple we know that this database is user statuses the user is going to post their status updates their third posts they're gonna post to this database this is where the information is gonna be stored this is where it's gonna be held and we're gonna also choose custom use on this and then we're gonna go back set up custom permissions at again so who can read content from this collection well once again if we're on a website a social media website it's not just the site member that can read they're author I can read their content or other people's content it's anyone so we're gonna select anyone on here who can create content for this collection well once again the site member because the person has to be registered in order to create content so the person has to have an account with our website in order to post statuses in order to build their profile page just like the profile pages we want the site member author to be the one that's able to edit or change the information in their status post the next is who can delete it once again we want the site member author to be the one to be able to delete their post if they so choose and then we're simply gonna click set and create collection and just like that we now have our user profile data and our user status data like I said the other for-sure databases that we know are the commenting system and the peer-to-peer messaging system so I'm not going to show you the commenting system database setup in this either because what we're gonna do is we're gonna get to the commenting system in part 4 of this series which will follow the next series which is dynamic pages in database field creation so part 4 will contain commenting and liking and that's when we'll get into those databases and that code so that way we can arrange that properly I'm trying to take you through a very strict and polished sequence in this series because it's gonna help you stay on top of creating this type of website so guys that is it for part two of building a social network in which the non coding founders or co-founders guide if this video helped you out and you enjoyed it drop a like down below comment if you've got any questions or if you're enjoying the series guys I really want to hear your feedback for this it's very important to me because I'm trying to continue on this very good series that I feel is gonna be very helpful for you and then also it's gonna give me a good read and if I should create a series like this again for a different style website you know how to build an online marketplace how to build a real estate style website a real is like an Airbnb type website those type of things so I really need to get your feedback don't forget to subscribe here on computer I'm da Gilbert in the final thing I'm gonna ask you to do is head over I just rebranded everything for this entire new fresh start I guess you can call it two wicks training academy.com guys this is the previous which my website comm and it is now an online training resource I have lots of blog content podcasts getting started I've got a if we come here to getting started here I've got a Facebook group a free Facebook group that you guys can join I will throw the link in the description a free Wix website roadmap it's a 12 step roadmap to get you started in building your website I've got my podcast and most importantly the final aspect of this that I want this is a personal passion project that I've been working on is the Academy guys this is really exciting so in this Academy it's called the Wix training academy if we scroll down here I'll show you what you get access to so you get an extensive training library full of courses workshops webinars you've got a result driven community of other like-minded entrepreneurs business owners CEOs in there in the Academy at the moment we've got checklist apps reviews member-only discounts and plus we've got a monthly mastermind / Q&A call with me every single month to answer any questions you may have this Wix training Academy is the real deal so if you're looking to exponentially grow your knowledge on Wix and upskill yourself on Wix come check this out guys I really appreciate all of your support this is amazing I'm so excited to be putting on this series it's been a process for sure it's been in the works for a while but I finally got to the point where Wix is ready for everything that I'm teaching right now and I've got this Academy built out so the timing couldn't be better thank you guys again for watching and I will catch you on part three next week .

Video Discription

Wix Training Academy-
————————
Are you asking: How do I build a social networking website on Wix?

I wanted to create a series to help fill a major need in the Wix market. People want to know how to use Wix Code and what the capabilities of the platform truly are. With that in mind, I listened to my community, read comments and engaged with Wix Design Pros.

Today, I am bringing you Part 2 of a multiple part series. The series is called: "Building A Social Network In Wix | The Non-Coding Founder's Guide"

Part 2 is dedicated to educating you on how to properly plan your website and plan out the databases we will need to build our social media website. We whiteboard the planning phase and then take a deep dive into the editor to get our first two databases set up.

This series is specifically made for entrepreneurs, CEO's, Founder's, President's and Co-Founder's looking to build a website for their startup or re-design their existing website. The goal is to bring you quality Wix Code training videos while also displaying the capabilities you have in Wix.

I want this series to pioneer an issue Wix is currently tackling. I want people to understand how powerful the Wix platform is and how you can maximize your online marketing efforts within Wix.
————————————————
Series Schedule: (x1 Video Per Week)

Sunday July 15 – Part 1 | The Introduction
Tuesday July 24 – Part 2 | Planning Databases + Homepage Design
Tuesday July 31 – Part 3 | Creating Profile Pages and Database Fields
————————————————
Topics To Be Covered:

-Creating Profile Pages
-Creating Custom Login Pages
-Giving A User Ability To Post An Update And Edit Or Delete It
-Working With Repeaters And Dynamic Pages
-Building Feeds
-Peer-To-Peer Messaging (Direct Messaging)
——————————————————–
Stay Connected:

Email: info@wixmywebsite.com
Twitter:
Subscribe: Wix Training Academy
Wix Training Academy:

 

Leave a Reply