Customization (sql Queries and app) for tictic

Algorithm for trending videos,

(sql select queries)

My current query is sql select * from videos order by rand () limit 50.

When a user open the app, the initial 50 videos shown on the feed shoul be based on the above stated query.

I want to change the trending videos based on ranking and not on rand ()

I suggest few queries:

1. Lifetime top liked videos - 10 videos limit order by top liked on top

2. Monthly top liked videos - 10 videos limit order by top liked on top

3. Weekly top liked videos - 10 videos limit order by top liked on top

4. Top liked videos in last 24 hours - 10 videos limit order by top liked on top

5. Most full watched videos - 10 videos limit order by most watched video on top.

6. Verified profile videos - 5 videos limit

7. Manually reviewed video - 5 video limit

All the stated queries are to mixed and randomly order them.

The videos from 1 query should not repeat in another query.

Once a user watches a video, the same video should not repeat on the feed Next time( you need to create usser watch history table In mysql).

All the queries should be optimized as to reduce the load on server.

also i want to setup ffmpeg on app for video optimization.

Taidot: MySQL, Mobile App Development, Videon lataus, Android, PHP

Näytä lisää: database app builder, powerapps, database application builder, web-based database application, how to create a web based database, open source web database application builder, microsoft access, custom query in sql, streamlining sql queries, table sql queries join, write sql queries customer order tables, sql backup app, sybase sql anywhere password encryption algorithm, wordpress custom sql queries, money optimizing sql queries, sql queries check total bulk sms day, fetch sql queries thru loadrunner script, sql queries airline reservation system, wordpress sql queries category, sql queries linux

Tietoa työnantajasta:
( 0 arvostelua ) India

Projektin tunnus: #26906355

7 freelanceria on tarjonnut keskimäärin 7233₹ tähän työhön

(91 arvostelua)

Hello I can do it now without any repeat of data. I have already done this type of work in my history with large numbe rof datas so it is easy for me. I am web developer having 4 year experience in PHP , Laravel , c Lisää

₹7778 INR 2 päivässä
(2 arvostelua)

"Hi !! Nice to E-meet you ! As per your requirement we will done your project with our best responsibility and great regard for our client satisfaction. We are experts in creating native iOS/Android apps and games. we Lisää

₹5000 INR 7 päivässä
(0 arvostelua)

#Free Hello employer, This is Siddharth. I completed my graduation from Bits Pilani in 2019. I have around 2 years of experience in Software Industry. I have the required skills. Hence I think I will be a good fit for Lisää

₹1500 INR 15 päivässä
(0 arvostelua)

I am an expert in SQL queries with joins, unions, triggers, cursors, stored procedures and all the complexed features. I am sure that your requirement can be addressed and targeted easily making use of a few features w Lisää

₹12500 INR 5 päivässä
(0 arvostelua)
₹7778 INR 3 päivässä
(0 arvostelua)

I have 6 years experience in Ms-sql and sql server. Although, I have the capability to make the queries in one day but I donot know your database structure so I am taking two. My part will be limited to the query only. Lisää

₹7222 INR 2 päivässä
(0 arvostelua)