Fermé

Hire a MySQL Developer

We are using the YouTube API to gather data from python code requests to the API. We have the UI concept down, the UI design concept down, info graphs explaining the concept etc. Once you see those things everything will make much more sense for what the end goal is (a website). If you think you can handle the following, let me know. We will speak and if we're a good fit we will proceed. We have a team chat for this project which you will be invited to afterwards.

User Interface

Application (or data model)

Database

The database schema, for example, for the channels table, should be defined after the json response from the YouTube API call. Along with additive data fields that are not included in the json response. This is the reason the database is needed in the first place. Data about change over time doesnt exist in the YouTube data api, and must be recorded and stored in a proprietary database. Some superfluous fields from the json possibly may not be required in the schema. The requirements are defined by the user interface, and application. The application is responsible for populating an existing database schema with values. It might say "everyday, starting at 12am, start updating the database (for the reason of being able to know something such as the current daily view count.)" The application will call YouTube, and update each database record accordingly. With an intermediate step; an algorithm to produce or update additive data, such as things related to change over time (like current view counts.)

I imagine that there should be a table for region codes, where each region has a "channels" relation (the reason for this structure is that it is defined by the YouTube api; a regional code is the predicate for a search on channels ordered by view counts.) The "channels" related to a region: should be a database relation to the specific (defined by region code) table of channels, from which, values will be populated by the correspondent json returned by a YouTube API call (made through the application.) For each region, then, there is a set of channels. That way, if the user selects a country, we have the channels for that "region" on hand, along with the required data (each channel record should have its (defined by the json) included in the schema.) On this, the "channels, by region, ordered by top view counts (as defined by the YouTube API,) is variable dependent on time. The top 500 today, may not be the same top 500 tomorrow. Therefore, for each region, if the view (UI) is intended to display the top 500, the database should keep the top 600 (the number here is arbitrary, and only intended to show that an overflow of channels should be stored in the database so that the expected data exists if it specifically becomes required in the future (the relative position of two channels changes, altering the contents of the list such that a new member (channel) is introduced to the set (channels to be displayed), and one is removed)).

It seems that simply querying the database on demand, would be the most straightforward, and optimized procedure.

We don't know much about databases, this is why we are looking for you to help. If anything seems vague that is because it probably is. If you think you can help, reply or DM me.

Compétences : HTML, MySQL, PHP, Python, Développement de logiciel

Voir plus : android developer for hire, android app developer for hire, wow developer mysql, free mysql hire system, ios developer mysql, iphone developer mysql server, php mysql hire test, ipad developer mysql, asp developer bid hire, iphone developer mysql, based developer mysql lowest unique bid auction, iphone developer cost hire, iphone developer work hire, buddypress developer website hire, sql developer mysql integration

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #12628356

45 freelance font une offre moyenne de $538 pour ce travail

SRajpurohit

Hello Sir, This proposal finds you best in health! We are a team of PHP-WordPress developers who is assisting globally to our clients. We have worked almost 70+ website till the date and have experience in worki Plus

773 $ USD en 14 jours
(239 Commentaires)
8.2
A2Design

Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here [url removed, login to view] Here’s a little video about our team too! ht Plus

750 $ USD en 7 jours
(87 Commentaires)
8.4
TenStar718

Hello, and thanks for the opportunity to bid on your project. [url removed, login to view] I am an expert in many different area’s of web and mobile applications based on the following languages: W Plus

526 $ USD en 10 jours
(164 Commentaires)
7.9
gkws

Dear Hiring Manager, Greetings! Let me keep this really short as I'm sure you would become overwhelmed with many offers :) On demand we can provide you: 1. Detailed Proposal 2. WBS 3. Wireframe 4. Mockup * Plus

600 $ USD en 15 jours
(172 Commentaires)
7.5
ambalaonline1

Ambalaonline1 is one of the top notch multi-faceted WebDesigning and Development company that gives you unique and absolutely innovative custom web designing solutions . We are in TOP 20 freelancers here on freelance Plus

444 $ USD en 10 jours
(288 Commentaires)
7.6
itcslive

Dear sir, At first we like to say that we are expert and had more than 10 years experienced in programming languages ( php & mysql, ajax, JS, curl ) We can do your project work as per your requirements sir you will get Plus

250 $ USD en 5 jours
(149 Commentaires)
7.6
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Plus

773 $ USD en 20 jours
(59 Commentaires)
7.1
Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further Plus

773 $ USD en 15 jours
(19 Commentaires)
6.9
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & Plus

555 $ USD en 10 jours
(48 Commentaires)
7.0
eagleblackdesign

Hello! We are a professional team of web developers with huge experience in using python for custom webapps based on django and odoo. Please provide more details about your project. We are available and will be hap Plus

750 $ USD en 21 jours
(39 Commentaires)
6.8
BitLabs

Hello, I have gone through your outsourced requirements "Hire a MySQL Developer" and have analyzed that I have right skills (HTML, MySQL, PHP, Python, Software Development) to execute your esteemed project. I wil Plus

534 $ USD en 365 jours
(115 Commentaires)
6.4
JamesTechnology

Hello There, Hope you are doing well !! we have gone through your requirements. Lets discuss more over Chat box, So i can define the best suitable time frame to get it finished at the earliest. Waiting for your prec Plus

250 $ USD en 10 jours
(126 Commentaires)
6.5
SevenStarInfo

Hello ! We want to discuss about your project as we have experience in it. What Differentiates us from the other freelancers : # Experience of more than 5 years in Unity 3D, Xcode, CoCoa 2d, Phonegap and major Plus

1000 $ USD en 10 jours
(62 Commentaires)
6.9
tudiptechnology

Hi, Let me keep this really short as i am sure you would be swamped with proposals :)! We have been developing/maintaining various web applications in Python Django. Mostly these applications are hosted on clouds Plus

1111 $ USD en 20 jours
(8 Commentaires)
6.1
500 $ USD en 6 jours
(78 Commentaires)
6.2
asait1192

Hello Sir/Madam, I am Asait from Skynet Global System ,Gujarat. We have team of inhouse team of 15 developers and we have delivered 200 projects within 1.5 year of time span. My Skills: - - >Design : PSD to HTM Plus

500 $ USD en 18 jours
(26 Commentaires)
5.9
526 $ USD en 10 jours
(74 Commentaires)
6.0
juniadsarfraz

Designed and Developed lot of databases. Contact me ASAP with more details. I am interested. Thanks, Junaid

300 $ USD en 10 jours
(20 Commentaires)
5.4
miracitech37

Hi I have read your job description extremely carefully , so now don’t need to worry we will give PROFESSIONAL work in MINIMUM PRICE and I am absolutely sure that our team can do the job very well but I have couple of Plus

555 $ USD en 10 jours
(14 Commentaires)
5.6
AleenaIlyas

Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discuss Plus

555 $ USD en 10 jours
(5 Commentaires)
5.1