Ditutup

Postgres Expert | Full Stack

Project Canary is committed to helping the oil and gas industry reduce methane/VOC emissions. We are an IoT company and deploy real-time sensors that continuously analyze air quality at remote sites.

We are looking for a talented, committed resource to help integrate a Postgres backend data and help implement a web UI for user admin and IoT metadata.

*****Question******

I have telemetry data flowing into a table called "events". New payloads arrive every few seconds.

Let's say there are 5000 devices reporting.

Now I want a table that shows ONLY the latest event from each device.

How would you populate the data in this table?

Kemahiran: Elasticsearch, MySQL, node.js, NoSQL Couch & Mongo, Python

Lihat lagi: python postgresql example, python postgresql web application, using postgresql with react, postgresql python 3, postgresql, postgresql documentation, postgresql 10.3 download, python postgresql insert, stack project, full commerce project, bluetooth stack project, converting full flash project file, primavera project bad public user name password, loan modification project bid website user, project database design user interface design, full program project, university payroll full documentation project java, free full code project connected computer using gprs, expert advisor freelance project, martingale expert full

Tentang Majikan:
( 2 ulasan ) Cuernavaca, Mexico

ID Projek: #19222410

29 pekerja bebas membida secara purata $23/jam untuk pekerjaan ini

meet2amitvw

can we discuss more on this to get detail understanding about project ? As i am having some technical question on this so let me know when you get time to discuss on this and clear the doubts. As Postgres developer Lagi

$20 USD / jam
(85 Ulasan)
8.6
suju8811

Dear Client. How are you? Nice to meet you. I have read your project requirement. and I am interested in your project. I am full stack DB manager with over 7 years experience. I have enough experience in postgresql Lagi

$22 USD / jam
(49 Ulasan)
7.4
tudiptechnology

Hi there, We have been developing/maintaining various web applications in Python Django. Mostly these applications are hosted on clouds (AWS/Linode) and have SASS, CoffeeScript, AngularJS/JQuery, Bootstrap as front Lagi

$15 USD / jam
(16 Ulasan)
6.6
ValueCoders

Hi There, I can do it very quickly & effectively. I'm having more than 9 years of web development experience. Looking forward to work with you! Thanks!

$22 USD / jam
(73 Ulasan)
6.6
flance9

Hi there, Thank you for sharing your requirement. Hope you are doing good and having a nice day. We are a team of technocrats having 8+ years of experience in Web and Mobile design plus development and primarily Lagi

$22 USD / jam
(22 Ulasan)
6.5
peng72083

Hello, How are you? I am a senior full stack developer. I have full experiences in developing websites managing big data using AWS Elastic search, GAE bigquery. I am very familiar with Postgresql as well. As for yo Lagi

$25 USD / jam
(35 Ulasan)
6.8
hy1990com

Dear Client. Nice to meet you. I have read your request and I am interested in your project. I am full stack DB manager with over 5 years experience. I have enough experience in postgresql, elastic search. I think Lagi

$22 USD / jam
(16 Ulasan)
5.8
marcnealer

Hi In answer to your question. to show the lastest data, you state there are 5000 devices and I am assuming you only want to see the latest results for each device. Assuming each device has a name or id, the Lagi

$27 USD / jam
(8 Ulasan)
5.8
elym81

I would add a unique constraint to the device id field and use PostgreSQL’s upsert feature, so that when a new event is inserted, it will only update the existing row for the device. Please send me a message so we ca Lagi

$17 USD / jam
(4 Ulasan)
5.5
fleedsteed

Hello How are you? I'm very interested in your job I have full experience in postgresql and mysql Please tell me more details about your device info I'm ready to work Lets discuss via chat Kind Regards

$20 USD / jam
(12 Ulasan)
5.9
ChernenkoEgor

I have read your job description pretty carefully. Higher-quality and faster-delivery is promised. Your job seems to be posted only for me not for the others, because you are looking for only an expert just like me. Lagi

$25 USD / jam
(11 Ulasan)
5.0
TomorrowlandAB

Hello I have hands-on experience of 8 years, in designing and development of the websites, I have gone through the requirements and realized, I am the right fit with experience, skills, and technology needed to comp Lagi

$25 USD / jam
(4 Ulasan)
4.1
rajanthakor08

Hello Sir, I have Read your requirements and understood that you are looking for an experienced Postgres Expert | Full Stack I have send your question And Answer via personal chat. I am pleased to inform you w Lagi

$15 USD / jam
(1 Ulasan)
3.7
ChewGekKhim

Hi, Client. Nice to meet you. I'm very interesting in your project. Because I've already developed such system. please see my past works. [login to view URL] I think I can help you a lot. Thanks

$22 USD / jam
(1 Ulasan)
3.2
finaldragon123

Hello,sir I 'd really like to work with you on this one if possible! I have read your description with great interest. I've gone through the post description carefully and ready to start work on this project. My Lagi

$25 USD / jam
(6 Ulasan)
3.2
kstephens6054

I would use a one-to-many relation between two tables, one containing information for each sensor and the related table containing the timestamped data for each reading joined on the sensor id. When each new reading Lagi

$22 USD / jam
(4 Ulasan)
3.0
krishaweb

Hello, Hope you are doing well! We at KrishaWeb are most preferred agency for our client due to 100% recommendation and “5 STAR” rating from our clients which we achieve through an excellent client support as wel Lagi

$22 USD / jam
(2 Ulasan)
3.0
annakuzmenko917

Hello! I think your project is best for me and send you a bid. I am a Python and Nodejs expert who knows the value of time, working hard and always working on time. My motivation is to make my employer feel the g Lagi

$20 USD / jam
(4 Ulasan)
2.7
SolaceInfotech

Hello, Hope you are doing well. It looks like you are looking for an experienced Full Stack Mobile Developer expertise who can dedicatedly work on your ongoing projects for a long-term relationship. As qualities, yo Lagi

$22 USD / jam
(1 Ulasan)
1.1
abdulmoizeng

Hi, I have about 5 years of experience on developing apps as per your required skills, My profile : [login to view URL] **SOLUTION** i ll insert w.r.t device_id and can make Lagi

$22 USD / jam
(1 Ulasan)
0.6