Sedang Disiapkan

SQL (MariaDB/MySQL flavour) specialist needed

Hi there,

I have a MariaDB 10.3.16 database in which data is received, from many electrical meters, each minute, in the format shown in the attached image.

I need an SQL expert to create the needed views/triggers/stored procedures, so that, to have some other tables/views populated on-the-fly (in realtime) from this shown table, as such:

- energyDelta field should be filled in as the difference between energyOrig at each minute, for each meter.

- I need to offer these energy consumption data per 5/15/30 minutes too, i.e. the data should be processed including the energy deltas too.

- I need to present the data taking into account a certain timezone (not UTC as it is now in tsOrig), according to other tables that contain this info (joined by meter id);

- other data manipulations and complication that will be introduced to the chosen freelancer.

The final purpose is to have the resulting tables/views used as a back-end for PowerBI (in Azure) but PowerBI is not part of this project.

Please note that:

- I prefer programmers from Europe (including Eastern Europe), due to time zone differences.

- I need someone comfortable in linux command line (mysql client).

- English mastering is required, as we need to communicate!

- the first bullet above is actually solved already; however I'll use it as a test, so that I can evaluate your understanding of the task and asses the skills level. I have solved this via SQL/MySQL only, myself, so I need someone who is more skilled than I am.

I need a price per hour and estimated number of hours for the first 3 bullet points above. Any further developments will be discussed/negotiated individually.

Please start message with "MySQL" to help me avoid automatic repliers that did not read this thoroughly.



Kemahiran: MySQL, SQL, Linux, MariaDB

Lihat lagi: best transfer sql server mysql, replicacion sql server mysql, sql server mysql transfer, sql developer mysql integration, conver xml sql table mysql, marketing specialist needed, import sql server mysql, seo specialist needed russia, sql export mysql database, oracle sql server mysql provider, export sql mssql mysql, convert sql 2008 mysql, synchronisation sql lite mysql, sql injection specialist needed urgent

Tentang Majikan:
( 0 ulasan ) Bucharest, Romania

ID Projek: #22129211

Dianugerahkan kepada:


MySQL. Hello, i have rich experience in this area and ready to work. Please contact me to further discuss. Regards, Alex

€100 EUR dalam 3 hari
(8 Ulasan)

25 pekerja bebas membida secara purata €158 untuk pekerjaan ini


Hi there. I got really excited with your project and I can say that really matches to my skills. Along as my worth experience of Mysql programs, I can help and support you 100% bringing fully satisfactory result. I ass Lagi

€200 EUR dalam sehari
(22 Ulasan)

Hello, This project is quite easy for me, but I got couple of questions to clear before we proceed [login to view URL] message me to have a quick chat.

€250 EUR dalam 3 hari
(19 Ulasan)

"MySQL" Dear Client, I read through the job details extremely carefully. As an Oracle certified DBA, I would like to apply for this task. I have hand-on experience in Linux Administrator, Build/Release Management, Sof Lagi

€200 EUR dalam 3 hari
(39 Ulasan)

I am European Dear Sir, Our team is interested in developing your project and we can easily do it for you. The main part of our technical team is located in Ukraine, so we can work together in one time zone. Our team Lagi

€250 EUR dalam 7 hari
(57 Ulasan)

I am European. You are specifically asking for a solution using database triggers and stored procedures. My preference to implement your requirements would be a PHP script or any other application that can access yo Lagi

€60 EUR dalam 3 hari
(8 Ulasan)

Dear sir! ⭐I am very interested in your project and I am exciting. ⭐I read your project details carefully and I though that I am the best fit developer for your project. ⭐I have rich experience about your proj Lagi

€100 EUR dalam sehari
(11 Ulasan)

⭐Full Stack Guru here. ⭐ I am good at Frontend and Backend. [login to view URL] [login to view URL] -> mobile [login to view URL] [login to view URL] [login to view URL] [login to view URL] are all my successful portfolios. I have more than 7 yea Lagi

€250 EUR dalam 7 hari
(6 Ulasan)

MySQL Hi, there is no image I can see in the project description. So my bid is based on the text provided. Each point will take 1 hour to complete and cost 40€.

€120 EUR dalam 3 hari
(11 Ulasan)

Hi, Dear (✿◠‿◠) :) I am happy to put my bid on your project. I am DB expert I have 6+ years highly experience to deliver quality work with Website design and MySQL/MsSQL/NoSQL project successfully. It's very worthwhile Lagi

€50 EUR dalam sehari
(5 Ulasan)

MYSQL, To start with, I am a Full Stack SQL developer having expertise in creating triggers and all. I am based out of India, but EST time suits me as I get free and works as freelancer in this timezone only. Let's ha Lagi

€222 EUR dalam 20 hari
(2 Ulasan)

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is Lagi

€140 EUR dalam 7 hari
(4 Ulasan)

MySQL Hi there, This sounds really interesting. I'm a cloud architect with 10 years experience on Azure, based in the UK. I think there's a better way to solve this problem that would save you money in the long run Lagi

€166 EUR dalam 10 hari
(1 Ulasan)

I am European Welcome to your job! I read your description carefully and i am very interested in your project. I'd like to get more details in chat. I have rich experiences and flexible skills in sql query. I can start Lagi

€140 EUR dalam 7 hari
(2 Ulasan)

⭐ Hello, Sir! ⭐ Nice to meet you. I am a fullstack web developer with over 5 years on web development. ****In SPECIAL Very familiar with Linux, SQL, MySQL***** I am ready for your project now. I can do it and start rig Lagi

€140 EUR dalam 7 hari
(1 Ulasan)

Hello , i've already did something similiare for another combany about smart energy monitor , device recognition and so on your 3 bullet can be done in 5 or 6 hours my price is 50$/hours but i cannot work on it eve Lagi

€250 EUR dalam sehari
(1 Ulasan)

I am European Hi Dear, I am very interested in your project. I can develop your project by using the cron tab with laravel. I am ready to start your project with my best. Could you please share your details? Please s Lagi

€140 EUR dalam 7 hari
(1 Ulasan)

I am European Hello. I am very interested in your job. Even though new freelancer, I am web development expert who have enough experience. Especially SQL is my favorite thing. I can start right now and will finish on t Lagi

€60 EUR dalam sehari
(1 Ulasan)

You are asian. Welcome to your job! I read your description carefully and i am very interested in your project. I'd like to get more details in chat. I have rich experiences and flexible skills in sql query. I can star Lagi

€140 EUR dalam 7 hari
(1 Ulasan)

I am European -The price per hour is 10.50 EUR. -The estimated time is from 16 to 22 hours. I look forward to you comments.

€180 EUR dalam 5 hari
(0 Ulasan)

"MySQL" Dear Client, I've checked the requirement and understand that :) I've created S..I..M..I..L.A..R.... Project in past. Do you want to see the D.E.M.O.. ????? I'm not here most of the time so kindly pl Lagi

€200 EUR dalam 2 hari
(0 Ulasan)