Sql Server Edinburgh Projects
Looking for freelance Sql Server Edinburgh jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Sql-server-edinburgh" Projects
I need help for setting OBS for streaming on social media
I need to arrange livestreams on several social networks. Important for me are: Telegram, VK.com (russian SN), Instagram, Facebook, YouTube. The SN are in order of importance (I work on russian market). I have OBS and I would like to have your help to set it for the multistreaming. I don't want to use platforms like Restream so please don't offer. Currently I have OBS set on my PC Windows 64b for streaming on VK (Server rtmp and key) but I want to use OBS on multistreaming. Can you help me by Teamviewer? For your convenience: OBS multistreaming plugin you can download here → https://obsproject.com/forum/threads/multiple-rtmp-outputs-plugin.122535/
Discord chess community
We are looking for a talented and experienced freelancer to help us build a Discord community for chess players. Our goal is to create a thriving community of chess enthusiasts who can connect, learn, and play together on Discord. The ideal candidate will have experience working with Discord and managing online communities. You should be passionate about chess and have a good understanding of the game's rules, strategies, and tactics. You should also be able to create engaging and informative content to share with the community, including chess puzzles, game analysis, and tutorials. The responsibilities of this role will include: - Setting up and managing the Discord server for the chess community - Creating and implementing a content strategy for the community - Moderating the community and ensuring that all members adhere to the rules and guidelines - Organizing and promoting events and tournaments for the community - Providing chess coaching and training to members who need it Requirements: - Experience working with Discord and managing online communities - Excellent communication skills and fluency in English - Strong understanding of chess rules, strategies, and tactics - Ability to create engaging and informative content (puzzles, game analysis, tutorials) - Availability to work flexible hours to accommodate different time zones - Passion for chess and desire to build a thriving online community If you are interested in this project, please respond with your portfolio and any relevant experience you have working with Discord communities and/or chess. We will review your information and contact you for further discussion. We look forward to working with you to build a vibrant and welcoming Discord community for chess players! Budget: open budget (depending on experience and qualifications.
opportunity
Need help setting up FB/Insta business pages - local only
Hi I really need help in edinburgh to sit down with someone and help go through my fb and Insta and simply delete some legacy accounts and make sure everything is set up correctly.
Set up a Mastodon Server for me
Hi all, Thanks for viewing! I'm sure this is easy enough for anyone in the know. I would like to set up my own UK focused Mastodon server, probably through a managed server solution but open to your suggestions. I will fund the costs associated with it, I simply want someone to set one up for me, explain what options I have and to set one up in a cost efficient way. If you're a user of Mastodon then that will also be a bonus. Any questions just ask away in your proposal! Many thanks, Connor
Help with Discord Tasks
Hello, I am looking for someone who is great at Discord to spend 4-6hrs a week helping me with that and some related tasks such as: * Completing Discord tasks * Organising Discord channels, managing notifications etc * Linking wallets to Discord servers, gaining roles etc * Completing tasks on Crew3 such as linking my Twitter, joining a Discord server etc * Some fairly simple research tasks Much of this will be done on TeamViewer. I have extremely low vision which is why I need help. If you are excellent at Discord stuff and would like to spend 4-6hrs in 2hr shifts 2 or 3 mornings each week working with me I would love to hear from you. Please tell me about your relevant skills and availability. Look forward to speaking with you, Nick
Setting up the facebook API - Double checking it works
I need someone to setup the facebook API and double check it works on the server
Discord Moderator Bot Creator
I need you guys to help me build my Discord Community Server
I need to setup facebook pixel
i am looking for someone who can setup my facebook pixel and conversion api with server-side tracking.
opportunity
Grow a Learning Discord Community
We are looking for a community manager with experience of growing a new discord community from 0 to 5000+ members. The community is for a learning app/game similar to Kahoot/Duolingo with trivia quizzes. We have the server setup with some automated bot elements. The main target audience is learners/students aged 16-25 UK and US studying for college and university exams. The server focuses on helping people to learn. We want real users identified and brought across from similar communities on YT, Discord, Facebook etc. We have a list of similar communities. The community manager should: 1. Focus on converting user personas matching the above from other communities to the Discord server 2. Focus on onboarding users and stimulating early engagement and interaction We would expect this to be a 4-8 week engagement initially with regular work on offer if successful.
Moderators for Discord and Telegram
We are looking for people to moderate our Discord servers and keep the community engaged. We offer a flexible work time with a 4 hour workday.
opportunity
Discord monitoring and members recruiting
We at Evolves.tech are looking to recruit a team of skilled people, preferably with fluent English skills for a discord server monitoring and community engagement. The payment is $70 per week for a 4-hour workday. The task will be simple - get to know a bit about the project - engage in conversations when the chat dies down for more than 15-20 minutes - answer simpler questions (or if you can't ping one of the core members)
opportunity
Looking for a marketing manger/CMO for an NFT project
Hello, I am launching a fashion focused NFT project. This is a women led project. I am looking for a marketing lead/manager to handle social media such as twitter, Instagram and discord server for a month or 2.. The aim of the marketing manager is to grow our twitter following, instagram following and also draw more members into the discord community. We have 10k -20k twitter follower goal per month. You will be responsible for creating the marketing strategy for the NFT project, organising twitter spaces, identifying marketing and partnership opportunities to promote the NFT project. You will also be responsible for creating engaging content for the community and building hype for the NFT project and brand. I need someone with a lot of social media marketing experience and potentially knowledge on NFTs/NFT community on twitter. Kindly reach out if you fit this description.
opportunity
I require a Discord/MEE6 experienced developer
I need a developer that fully understands every aspect of the Discord Server. Also must have full experience in adding relevant bots after completing the full settings as required such as MEE6, Smoogle Translate, Rhythm etc. The server is already active with 200+ members and it needs some updated work on there to complete some of the following: - Once a new member joins, we want them to understand and acknowledge the server rules and also complete a form or maybe acknowledge reaction roles to identify who they are before allowing them to enter the server. Also entry to the server can only be approved by the admins? - Create roles - Polish up the welcome area - Create custom commands - Create reaction roles - Update the roles and commands in MEE6 and other bots - Add some life to the server in general
opportunity
Urgent: Create 3 tailored UK influencer lists this weekend
Looking for the following lists by Sunday evening: Tier 1 (x250 - high profile UK influencers who have an engaged audience of women aged 20-45 and would consider supporting a campaign without a fee but being gifted something (probably use pr gifting hashtags which could be a good starting point) Tier 2 (x250) - makers and teachers - high profile trendy people who make or teach cool things - primarily crafting and cooking, people with interesting content showing you how to do things, mainly painting, crafting, home interiors crafts, etc. Tier 3 (x250) - local influencers to Edinburgh and Manchester in the right demographic who might be interested in taking part in online classes Would like to use someone with access to good influencer identification tools, who will pull together the lists and also sift through and make sure they are relevant (so not just pull of a spreadsheet and submit, we'd like a well thought through list to add to our own research) To apply, please answer the questions below. If we find someone who can do a good job there could be further work next week in helping us with the influencer outreach itself too)
Urgent: Create 3 tailored UK influencer lists this weekend
Looking for the following lists by Sunday evening from a UK based freelancer: Tier 1 (x250 - high profile UK influencers who have an engaged audience of women aged 20-45 and would consider supporting a campaign without a fee but being gifted something (probably use pr gifting hashtags which could be a good starting point) Tier 2 (x250) - makers and teachers - high profile trendy people who make or teach cool things - primarily crafting and cooking, people with interesting content showing you how to do things, mainly painting, crafting, home interiors crafts, etc. Tier 3 (x250) - local influencers to Edinburgh and Manchester in the right demographic who might be interested in taking part in online classes Would like to use someone with a strong understanding of influencer relations that has their own existing lists and knowledge to build on and also has access to good influencer identification tools, who will pull together the lists and also sift through and make sure they are really relevant and perfect for the brand (so not just pull off a spreadsheet and submit, we'd like a well thought through list to add to our own research) To apply, please answer the questions below. If we find someone who can do a good job there could be further work next week in helping us with the influencer outreach itself too)
opportunity
Social Media Strategy
We have a holiday let business (1 property in the center of Edinburgh) and for the past few years, we have used Airbnb, Booking.com, Holiday Lettings and Home Away. On each of the sites, we have a considerable number of bookings a great reviews. We have our own website, however we rarely get any traffic on the website. The objective of this project is as follows: 1) Review all our channel content - Facebook | Instagram | Google | Our website - and provide feedback 2) Develop a high level strategy to - Attract more traffic to our site. - Attract more bookings 3) Educate us on the best way to advertise The challenge that we have is that this is a static property where little content to constantly put up. Also, the guests that we host are largely making a big trip and tend not to come again - so not repeat customers. Link to the property: www.heriotrowapartment.com
I need someone with an iphone to stream live events at the edinburgh festival
I need someone with an iphone to stream live events at the edinburgh festival. We have developed an app and website that both connect to VerHub database
Cryptocurrency Twitter Sentiment Analysis
I would like to create a twitter sentiment analysis tool based upon the attached white paper. This information would be accessible as a simple data feed for number of mentions, which I can use as part of a google spreadsheet. You will propose the best way to construct this tool, whether it is on a server, or just a google spreadsheet.
pre-fundedurgent
I need python code fixed
I am currently using python and tweepy to access a MySQL db and pull down screen_names in the store, I then request the tweets associated with the specific screen name and save them to MySQL for processing. I have a central table where I store if an account has been pulled from Twitter, when I get the repose I update the central table to indicate that the screen_name has been processed. The problem is that the central table is not being updated to indicate that the screen_name has been processed. Not being effective with Python I am not sure the syntax to use (I have tried strings and %s but that does not work). I need someone to urgently help and assist in fixing the below code so that I am able to execute the program. The line of code below I am having problems with is: cursor.execute("UPDATE `xxxxxxxx.xxxxxxxxx` SET submitted = 'yes' WHERE screen_name=%s;", (screen_name,)) I need to finish this within the next two hours. ============================================================================================= #!/usr/bin/env python import tweepy import MySQLdb import sys # Keys consumer_key = 'xxxxxxxxxxxxxxx' consumer_secret = 'xxxxxxxxxx' access_token = 'xxxxxxxxxx' access_token_secret = 'xxxxxxxxxxx' host = "xxxxxxxxxx" user = "xxxxxxxx" passwd = "xxxxxxxxxxxx" database = "xxxxxxxxx" # Twitter initialization auth = tweepy.OAuthHandler(consumer_key, consumer_secret) auth.set_access_token(access_token, access_token_secret) api = tweepy.API(auth) # MySQL initialization connection = MySQLdb.connect(host=host, user=user, passwd=passwd, db=database, charset="latin1") cursor = connection.cursor() # The table schema: CREATE TABLE tweets # tweet_id BIGINT NOT NULL, # tweet_text VARCHAR(160) NOT NULL, # screen_name VARCHAR(160) NOT NULL, cursor.execute("SELECT screen_name FROM xxxxxx.xxxxxxxx WHERE platform = 'tw' and submitted = 'no' LIMIT 1") screen_name = cursor.fetchone()[0] print(screen_name) cursor.execute("UPDATE `xxxxxxxx.xxxxxxxxx` SET submitted = 'yes' WHERE screen_name=%s;", (screen_name,)) print(screen_name) print("submitting to twitter") try: statuses = api.user_timeline(screen_name=screen_name, count=200) for user in statuses: print(user.id, user.text.encode('UTF-8'), user.author.screen_name.encode('UTF-8'), user.author.id, user.created_at) # load to MySQL server cursor.execute("INSERT INTO tweets (tweet_id, tweet_text, screen_name, author_id, created_at, inserted_at) VALUES (%s, %s, %s, %s, %s, NOW());", (user.id, user.text.encode('UTF-8'), user.author.screen_name.encode('UTF-8'), user.author.id, user.created_at)) connection.commit() if not cursor.rowcount: print("no values found") except tweepy.error.TweepError: print("Tweepy error, could not fetch data!") except UnicodeEncodeError: print('Unicode error') else: print("Unexpected error: ", sys.exc_info()[0]) finally: cursor.close() connection.close()