In Progress

Simple websocket api project - receives data & inserts into database

EDIT : This is about 2 hours simple coding. Some people have bid £250 for the project. Bid sensibly or I will just do it myself. Please do not bid without reading. I had about 5 bids in 3 seconds, which is stupid. You can't bid sensibly unless you have read the project description.

EDIT 2 : I don't want to waste your time, and I realise that you have to bid for a lot of projects, so I will consider bids of more than £100 but I want you to include the authenticated channels as well as the public channels. You can find the authenticated channels here - [login to view URL]

i want a small web application to connect to websocket and insert data received via websocket into a mysql database.

this is only to collect data, not analyse it, or make any other interaction.

websocket data comes from bitfinex api.

there are 5 public channels (ticker, trades, books, raw books, candles, status). it is these that i want.

you will need to quickly read through the docs. they provide all the details that you need, including sample javascript.

the public channels documentation is at [login to view URL]

i am only interested in bitcoin/us dollar.

this is just about collect the information & inserting it into the database.

i am familiar with html, css, javascript, jquery, json, & php so you can use any/all of them that you want.

i will run this on a spare computer for a few months for testing.

i would like the webpage to be reasonably pleasing to view as i will be looking at it regularly but it does not need to be a work of art. please use a responsive layout. you may find it easiest to use a dashboard template like [login to view URL] which can be downloaded from [login to view URL]

you need to build & test on your own server and then send me all files, including db sql.

1) websocket connection is to be made when page is loaded into browser.

2) automatic connection to all channels is to be made.

3) connection status is to be displayed.

4) connection status history is to be displayed in a show/hide div.

5) automatic reconnection to websocket & all channels if connection is lost (eg if broadband drops, system must fully reconnect when broadband reconnects)

6) properly manage error codes

7) send response to pings from server. ok to create a javascript timer to send regular ping

8) latest data from every channel is to be displayed, together with human-recognisable datetime (eg "22|03|2020 - 15:37:21") - so i can see it is working

9) store ALL data

10) received data is to to be saved into 3 separate mysql databases (you can use 1 for design/testing but make provision for me using 3 databases)

11) connections, data, hearbeats, pings, & error messages are ALL to be stored in server

12) include "createddatetime" column at end of every row in database (mySQL "datetime" type column)

this isn't a big project and i could do it myself but am working on too many other projects at the moment. winning bidder will be in the front line for more projects in the future.

Skills: PHP, Javascript, MySQL, AJAX, jQuery / Prototype

See more: screen data grabber database, simple medical shop project, excel data access database, javascript websocket library, websocket client, websocket server nodejs, websocket send, websocket tutorial, javascript websocket example, websockets, websocket addeventlistener, solidworks api project, project term data, export data excel database java, simple layout development project, vb6 project searching data database, create api send data mysql database php admin, retrieve data magento database api, simple data save database oscommerce, simple project work data mining

About the Employer:
( 0 reviews ) Brighton, United Kingdom

Project ID: #24584662

Awarded to:


Hi, I’m a UK developer of 20 years’ experience. I’ve checked the documentation against your requirements, and it looks straightforward. I’d use PHP/MySQL with Bootstrap 4 and so jQuery but use the browser native WebS More

£75 GBP in 7 days
(0 Reviews)

8 freelancers are bidding on average £162 for this job


Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the More

£250 GBP in 3 days
(12 Reviews)

Hi, dear. How are you today? Reading your job description, I'm sure your project is very suitable for my skill. I've deep knowledge and abundant experience in web socket. Looking forward to work for this project, ple More

£150 GBP in 7 days
(15 Reviews)

Hi there, have checked the details of the project and we can surely work on your project of collecting and inserying data into database as we have done similar work in the past. We have years of professional expertise More

£200 GBP in 6 days
(5 Reviews)

Hello !!! I am specializing in website design/development in Wordpress/ Shopify/ HTML/CSS /WIX/ Bootstrap/ Photoshop/ Coral/ Email templates/ Business card/ Woo-commerce/ landing pages/ User-experience/ Responsive/ as More

£150 GBP in 3 days
(3 Reviews)

Hello. I've just read your job description carefully and I am interested in your project. I am very proficient in javascript, Jquery, Bootstrap, PHP etc so that I can complete this project as you need. Hope to work wi More

£135 GBP in 7 days
(2 Reviews)

Dear Client!!! I went over your job description thoroughly and I found out that you want to receives and inserts data in mysql database using websocket. As a senior ruby developer, I have a lot of experiences websocket More

£200 GBP in 4 days
(4 Reviews)

Hello. I'm Dmytro from Ukraine. I've fully understood what you wrote. I am very familiar with web sockets and DBMS. And I have 6+ years of experience in Web Development. I believe that my strong points are punctuality, More

£135 GBP in 7 days
(1 Review)