Find Jobs
Hire Freelancers

Database clean up, discard unchanged values

€8-120 EUR

I përfunduar
Postuar about 1 year ago

€8-120 EUR

Paguhet në dorëzim
Need a DB command (or procedure) to save only the latest value when it has been changed. Whole purpose is to free up database space while still keeping all evidence about value flapping. For example, if input: clock | value ============= 1 | a 2 | a 3 | a 4 | b 5 | b 6 | c 7 | a 8 | a 9 | a then after running script it will erase older values of kind, but still keep evidence if the same value comes back again. Result must be: clock | value ============= 3 | a 5 | b 6 | c 9 | a Output should NOT blindly erase duplicates and keep latest one. This is wrong: clock | value ============= 5 | b 6 | c 9 | a Ideally there should be same SQL command/script/one-liner for MySQL and PostgreSQL. If an unified solution is not possible, then I need two snippets to solve task on each DB flavor. Solution should work for MySQL 8, MariaDB 10.3+, PostgreSQL 12+
ID e Projektit: 35851728

Rreth projektit

21 propozime
Projekt në distancë
Aktive 1 yr ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
€0 EUR në 1 ditë
5,0 (14 përshtypje)
2,9
2,9
21 freelancers are bidding on average €721 EUR for this job
Avatari i Përdoruesit
Hello there, i think one stored procedure will solve your problem, it will do 2 things: 1. Save all the current data including history to audit table and next remove all the old data just keep only the latest version. This can be done by a cronjob for each 10 mins or hourly depend on your requirement. Pls share me your real table so we can discuss. Waiting for your response if interested. Thank you!!!
€150 EUR në 2 ditë
5,0 (52 përshtypje)
6,2
6,2
Avatari i Përdoruesit
Hi there, I am a PHP developer and very keen in your posted job, please check my experience according what you need: Back-End Web Development. Extensive use of other frameworks such as Laravel and Codeigniter. Having understanding of building maintainable, test driven, scalable web applications. Strong knowledge of object-oriented programming, TDD and BDD and the MVC pattern. I have extensive commercial use of PHP, MySQL, PostgreSQL and Elasticsearch. Use of many other languages such as Python and Ruby. My Front-End Web Development: 5 years’ experience with jQuery. Thorough understanding of HTML5, JavaScript and CSS. Proven experience developing quality, user-focused, accessible, standards-compliant and responsive websites. Experience with tools like React, Backbone, Grunt, Sass, Less, Bootstrap and Foundation. DevOps and Systems Administration. 8 years’ experience provisioning and maintaining Linux servers to run high traffic, high availability websites. Extensive command-line knowledge across Linux and Mac operating systems. Please check my portfolio: https://www.freelancer.com/u/pinesucceed01 I am also experienced with Git, Mercurial and SVN. Ability to administer Nginx, Apache, PHP, MySQL, PostgreSQL, HAProxy, Exim, OpenSSH and other services. Experience migrating to and working with cloud platforms like Amazon EC2 and Rackspace Cloud, various CDNs, and development tools like Vagrant, Docker and Jenkins. A keen eye for tight security and robust systems. Thanks
€64 EUR në 7 ditë
4,8 (26 përshtypje)
5,5
5,5
Avatari i Përdoruesit
Database clean up, discard unchanged values Hello Aigars K., I would like to grab this opportunity and will be dedicated to your work till you get 100% satisfied with the tasks. I have 10+ years of experience on MySQL, Database Administration, PostgreSQL, MariaDB. You can check out my freelancer portfolio section. I will also share my portfolio on further demand over a chat. Please come over chat and discuss your requirements in a detailed way. Thanks & Regards, Ali K.
€65 EUR në 7 ditë
5,0 (4 përshtypje)
4,5
4,5
Avatari i Përdoruesit
Hi I have 15 years of experience in Sql server database development, mysql database development, postgresql database development. Expert in data analysis. Reporting using power Bi. Programming using C#and sql server. Expert in data engineering. I will be able to help you with the project. Please ping me offline to discuss further.
€250 EUR në 3 ditë
4,9 (11 përshtypje)
4,1
4,1
Avatari i Përdoruesit
Hi Greetings!! Hope you are doing well. I am having 5+ years experience in database administration . I have vast experience in MySQL, Postage SQL and Maria DB. I need more information about database structure so that I can make script for that. Please give me a chance to use my expertise at your work. you will be 100% satisfied with my work. Looking forward to hear from you. Thanks & Regards
€30 EUR në 1 ditë
5,0 (3 përshtypje)
3,4
3,4
Avatari i Përdoruesit
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
€104 EUR në 2 ditë
4,3 (15 përshtypje)
3,6
3,6
Avatari i Përdoruesit
~ 1 DAY NO PROBLEM ~ Hello I read your description and understood what you want. As a full stack developer I'm sure I can do your project for only 1 day. Thanks.
€120 EUR në 1 ditë
5,0 (3 përshtypje)
3,1
3,1
Avatari i Përdoruesit
I can help you with sql queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated again, send the details for the project. Please contact me asap. I have 12+ years of experience in database programming, website designing, powershell scripting and android development. Feel free to message me anytime if you need to discuss this further.
€100 EUR në 2 ditë
5,0 (4 përshtypje)
2,6
2,6
Avatari i Përdoruesit
Hi there. ⭐⭐ I am a full stack Developer ⭐⭐ with experience in Power BI, C & C++ Programming, MY SQL, Machine Learning (ML), PYTHON, Deep Learning and Communications. I have worked with many similar projects as i have a team of enthusiastic developers. We strive to give our best. Please contact to discuss in detail.
€70 EUR në 1 ditë
5,0 (2 përshtypje)
2,7
2,7
Avatari i Përdoruesit
❤️❤️❤️Senior Fullstack Developer❤️❤️❤️ Hello Mate!Greetings Aigars K., Good evening. I hope you are doing well! I read your requirements several times and I understood what you want. I am a full-stack with skills including Database Administration, PostgreSQL, MariaDB and MySQL. I have 7+ experience in developing the projects using Database Administration, PostgreSQL, MariaDB and MySQL and so on. I'm confident in this project because it is extremely similar to the work I’ve provided for many of my other clients. I am checking your attachment, I'll update you shortly... ❤️I always aim to build well-documented and reusable and understandable code and websites, so after the completion of the project, you will be able to upgrade this project easily. Please send a message to discuss more about this project. I have no projects now so can devote fulltime on this project immediately. Fast work and high quality is ready for you. ❤️ For more details Chat with us
€75 EUR në 7 ditë
5,0 (1 review)
1,4
1,4
Avatari i Përdoruesit
Hello Aigars K., I examined your project description, and I confirm I can handle those tasks perfectly, as I am an expert in MySQL, Database Administration, PostgreSQL, MariaDB. I am prepared to handle projects requiring Database Administration, MariaDB skills. Please come over chat and discuss your requirement in a detailed way. Regards
€41 EUR në 7 ditë
5,0 (1 review)
1,4
1,4
Avatari i Përdoruesit
@@@Hello@@@, I am very interested in your project. I am an expert who have 8 years of experience AI/ML, Django, Flask and Node.js. I love to use numpy, scikit,pytorch, tensorflow etc and so on. And also, I have deep knowledges in artificial intelligence, and Machine Learning so I developed many Object Tracking, Face Recognition, Spy Detection, Fingerprint recognition, voice recognition. Furthermore, I have solid skills and experiences in Python including Django, Flask, Pandas, etc. I believe I would be in a good position to analyse your requirements and advice on the best manner of proceeding. Hope to have a positive response soon. Best Regards
€13 596 EUR në 999 ditë
5,0 (1 review)
1,3
1,3
Avatari i Përdoruesit
I will definitely clean up the database with the mentioned details, i would be needed more things to check and start the work immediately let's begin @@ 100% SUCCESSFUL DELIVERY WITH QUICK TIMELINE, LOOKING FOR LONG TERM BASIS @@ ## Ready To Start Right Away ## What I am going to do if you hire me:- ============================== * You will get time to time Updates regarding project status and completion before the deadline. * Dedicate 9+hours/day and 45+hours/week for your job. * Have excellent communication skills in English. * 100% ongoing satisfaction with your project. * 24*7 Support With 100% money back guarantee. * Reasonable/ Competitive rates MY CORE SKILLS AND STRENGTHS: ✓ Back-End: Core PHP, Cake PHP, Laravel, Codeignitor, Node.js, Python (Django, AIML, Data Pipeline), WordPress/Woocommerce, .Net, C# Programming, MySQL Server. ✓ Front-End JS: AngularJS, React.js, Vue.js, jQuery, AJAX, HTML5, CSS3, jQuery And Joomla ✓ Native: iOS, Android (Objective-C, Swift, Java, C#), JNI, NDK (C/C++) ✓ Hybrid: PhoneGap, Ionic Capacitor, Titanium (HTML5, jQuery Mobile, C#) ✓ Databases: MS SQL Server, PostgreSQL, MySQL, MongoDB, Redis ✓ Payment: Stripe, PayPal, Shopeepay ✓ Servers: AWS, MS Azure, Hostinger, DigitalOcean ✓ Version Control Tools: Github, Bitbucket, Gitlab ✓ PM Tools: Jira, Monday, Trello, Asana ✓ Web service: XML/JSON, REST/SOAP Thank you very much
€30 EUR në 1 ditë
5,0 (1 review)
1,0
1,0
Avatari i Përdoruesit
Hello, there! I CAN START YOUR PROJECT RIGHT NOW. I have just read your requirement and I understood what you would like to do. I have the experience and skills to create results that fully satisfy your requirements. Please drop me a message and let us discuss project in detail. If you are still interested, please visit my profile to check out my experiences and skills. https://www.freelancer.com/u/hayatodev0329 Talk to you soon!
€50 EUR në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi, I have 7 years of experience working with PostgreSQL, MySQL and MS SQL. I can solve your problem quickly.
€60 EUR në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hello, I am a full-stack developer with more than 5 years of experience. I have done relevant work like this before as well. Just send me a message, then we can discuss the details and build a long-term & healthy business relationship with each other. Regard, Saad A.
€64 EUR në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Extensive experience in sql scripting and stored procedure development. Oracle Database Certified Professional. Looking forward to working with you on your project.
€60 EUR në 5 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i LATVIA
Riga, Latvia
5,0
13
Mënyra e pagesës u verifikua
Anëtar që nga gush 27, 2017

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.