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.
MySQL. Hello, i have rich experience in this area and ready to work. Please contact me to further discuss. Regards, Alex
25 freelance font une offre moyenne de €158 pour ce travail
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 Plus
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.
"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 Plus
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 Plus
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 Plus
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 Plus
⭐Full Stack Guru here. ⭐ I am good at Frontend and Backend. [login to view URL] [login to view URL] afrikbid.com. -> 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 Plus
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€.
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
⭐ 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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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.
"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 Plus