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.
Application (or data model)
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.
45 freelance font une offre moyenne de $538 pour ce travail
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
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 [login to view URL] Here’s a little video about our team too! ht Plus
Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Plus
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
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
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
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
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
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
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
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
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
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
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
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
Designed and Developed lot of databases. Contact me ASAP with more details. I am interested. Thanks, Junaid
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
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