Postgres timestampproiecte
Hi, I am looking for 5 Python projects, that can be used to test some one, about their hands on coding skills during interviews. For example. Eg 1. A Flask based REST api server that has a bug and doesn't work. Candidate has to fix the bug and make it work. Eg 2. Develop a REST API given a specification Eg.3 Add an API to a working Django/Postgres based app. All tests should have skeleton code along with code, commands to build it etc Need to total of 5 tests Skills to test: Python 3, Django, Flask, PostgreSQL etc. Code can be either own or modified version of MIT license only. Can not be GPL and any other restricted licenses. Please feel free to message me if u have any questions.
I have a dataframe of type timestamp. This dataframe has only two columns. The first timestamp. The second is numerical. In this example the lines are inserted every 5 minutes but there are failures. The programmer needs to scan the entire dataframe and where it hasn't, will insert the date and time and the last number it found. Example: 31438 2021-10-18 21:40:00 0.70864 31439 2021-10-18 21:45:00 0.70869 31440 2021-10-18 21:55:00 0.70840 31441 2021-10-18 22:00:00 0.70813 ....... 31438 2021-10-18 21:40:00 0.70864 31439 2021-10-18 21:45:00 0.70869 31440 2021-10-18 21:50:00 0.70869 <---- 31441 2021-10-18 21:55:00 0.70840 31442 2021-10-18 22:00:00 0.70813
...token recovered from a postgres database (table and schema to be defined) for each user (unique code) we defined which wearable service is active and therefore authorization token (potentially 1-n) - performs the recovery according to a timer (time scheduler, example: recovery all data of all users at 1:00 am every day for the fitbit service) (time interval to be agreed)) - Expose the same services using api created on camel k (for consumption by web portal on demand) -manage the refresh token based on expired time, we need to refresh the auth token in the postgres database based on scheduled time. - the response json must be written on Db couchbase for this development is required consider for each integration flow a link with unique user code to be recovered in a p...
...but more like hundreds of hours as there are a lot of modules, libraries and web pages to implement. (One thing you need to know for sure is that this project is NOT about web scrapping. IT IS NOT!) The PHP programmers we are looking for would need to learn our environment and willing to commit to us for the long run. The main skills required are: 1. PHP 2. SQL (mySQL or MariaDB or even PostGres) 3. Good to expertise level knowledge of MVC architecture 4. Javascript 5. Jquery 6. some CSS (expertise level would be a plus) Any additional skill would be a plus if related to PHP or programming. This role is mostly for a backend-programmer, however someone with also good front-end would be a big plus. That said, even if you do not have much front-end knowledge we w...
I have a multitenancy application and I need to link each tenant schema to a postgres database generated in heroku. It is based on the apartment gem.
Backend development request on Camel K / Couchbase DB / Postgres DB for this development is required to consider for each integration flow a link with unique user code to be recovered in a Postgres database table (details to be defined) this application will run on OKD cluster on azure. we can provide a dev&test environment in our private account. We need a software development based on apache camel k framework that satisfies the following characteristics: 1 - Flows from Iot HUB Azure - ensure the integration and transport of messages to events from azure iot hub / event hub: - reading of events from event hubs - writing on Couchbase db (details to be defined) 2 - Wearable integration and recovery flows (Apple, Fitbit, Xioami….) - ensure the consumption of Fit...
Here are the work details- I will assign you videos. The timestamp will be given from our end. You don't have to worry about that. You will be having 24 hours to complete the task. We are willing to have a team of 3male and 2 female dubbing artists. You can do more than 1 work per day according to your capability.
I am looking for a python web developer who can build a retirement calculator web app to run on the pythonanywhere platform. Some snippets about the intended project: - nice front end website, with CMS, (similar to ) -should allow tiered user access and authentication, -users will take the retirement planning questionnaire and save results to MySQL or Postgres DB -should allow admin or user with elevated access to edit responses and render new analysis (some API needed to de-complex to users) -formulas for the calculations will be provided (& suggested output formats) -should be able to produce pdf reports of analysis (results) -more visual specs available to assist decisions Possibility of more work as system expands
...around our customer's production halls on the various machines and processes. The data logged via the app can see e.g. be: Date (timestamp) Batch number Location Notes. 01-01-2021 18:25 B424432 SupplyExit “Please check lid” 03-01-2021 14:22 B424432 Port1 “Packaging ok” 03-01-2021 14:33 B424432 Lager 1, reol 2 “” 15-01-2021 11:30 B423332 Stirring “” 15-01-2021 13:30 B423332 Dipping 1 “” The data is stored in a "transaction table" hosted on AZURE. (SQL) The second ap (laboratory ap) is used to record data from samples taken from the raw material. The user scans the batch number as with ap 1 - the location code is locked as "Laboratory" The data is Date (timestamp); Batch number; Location (l...
...stack engineer to join our team on a contract-basis. We are an early stage startup, building software to help clinical care teams. You will be working with our team to help develop and scale our platform. Qualifications: 1+ years of Software Engineering experience Experience with JavaScript / NodeJS Preferred experience working with React, TypeScript (or Flow) Understanding of database design - Postgres / MongoDB Basic understanding of system design High level understand of DevOps / infrastructure (we use Terraform / AWS) UI, UX, design experience a huge plus To be a best fit for this project you need: Ability to communicate clearly Dedication to meet project deadlines in a timely manner Worked with a fast-moving software team (experience with git, code reviews, CI, CD, etc.) ...
Looking for an experienced full stack engineer to join "Healthcare" on a contract-basis. 1+ years of Software Engineering experience Experience with JavaScript / NodeJS Preferred experience working with React, TypeScript (or Flow) Understanding of database design - Postgres / MongoDB Basic understanding of system design High level understand of DevOps / infrastructure (we use Terraform / AWS) UI, UX, design experience a huge plus To be a best fit for this project you need: Ability to communicate clearly Dedication to meet project deadlines in a timely manner Worked with a fast-moving software team (experience with git, CI, CD, etc.) Experience building projects end to end Attention to details Minimize rate: 20/h
...stack engineer to join our team on a contract-basis. We are an early stage startup, building software to help clinical care teams. You will be working with our team to help develop and scale our platform. Qualifications: 1+ years of Software Engineering experience Experience with JavaScript / NodeJS Preferred experience working with React, TypeScript (or Flow) Understanding of database design - Postgres / MongoDB Basic understanding of system design High level understand of DevOps / infrastructure (we use Terraform / AWS) UI, UX, design experience a huge plus To be a best fit for this project you need: Ability to communicate clearly Dedication to meet project deadlines in a timely manner Worked with a fast-moving software team (experience with git, code reviews, CI, CD, etc.) ...
Hello All I need a bash script file to process a recursive call to delete files. I have a directory structure that looks like this: /backup/d...create a 'root' directory file - it will create a root directory list, for example /backup/ /yearly-backup/ 3. I want to run a which will recursively get each filename from file and delete it from all the locations that are designated in the file. 4. I want to see a report at the end (on screen and output to report.<timestamp>.log) showing: A. all the files with their full path that were deleted B. In the end of the report: Summary - the filename appeared 15 times in 3 of directories and all were deleted On screen report should be shown only after completed all runs.
We have a website hosted on AWS EC2, and based on python, postgres database, lambda. We need help in maintaining the site and developing new changes. We have a working website and it needs tweaks to fix some bugs and changes requests. Please note: Shirish Sharma from my company is working with me to staff this project.
We are looking for an individual backend (ruby + php) developer who has good experience with DevOps. Responsibilities - Build and manage applications to support the needs of our customer - Take full ownership of a product or feature from onboarding to launch - Write tests for the software you write to ensure we deliver a scalable and reliab...Skills 5 years of professional experience in Ruby, PHP, Docker Experience designing and developing applications that expose or integrate with RESTful APIs Ability to analyze and breakdown complex problems and come up with inventive, elegant solutions Bonus Skills Experience building and deploying applications in AWS or another cloud environment Experience working on relational databases (such as Postgres or MySQL) and/or graph databases (such...
I am looking for ongoing help on existing projects. Here is the tech I use: React NextJS Docker TypeScript Traefik Jest Cypress Relay Chakra UI Zustand Postgraphile Postgres Work managed with Github. English required please. If you bid, I'm going to ask you about them. If you don't know them, please try working with them first.
I have built 3 containers locally and also tested them with docker compose. I pushed the individual containers to AWS ECR but I have problem running the task definition in ECS (AWS). I need all the help I can get ASAP
...in a team environment. This work would involve full Golang development including but not limited to: - Building and Maintaining Restful Endpoints for consumption service-oriented architecture - Golang development - Object-Oriented design - Test-Driven Development - Database work, specifically but not limited to Postgres Additionally, you should be comfortable working with: Languages: - Golang - Python - Django - Vue - Kafka Storage Engines: - Elastic Search - Vespa - Postgres - Bigquery Hosted Services: - GCP (Google Cloud Platform) The Following concepts: - RESTful API's - GRPC - Kubernetes - Git - GitOps - AI (Artificial Intelligence) - ML (Machine Learning) In this role, you will be working daily with a technical team and business stakeholders to contin...
-extract the timestamp, e-mail and geolocation (city and country) of each recipient - convert timestamp into the right date and time based on the city/country timezone - the output for each text file (opens and clicks) is a data table (excel/csv) where each recipient has its own row and the timestamp, e-mail address, city, country and date and time are further columns -as a final column I need a binary variable "monday"
1) Load the Postgres database that is hosted in Amazon RDS 2) Do some manipulations in the data such as masking phone number fields, making some fields blank, etc 3) Store the modified database in another Postgres RDS Database. 4) This process should run every 15 mins and we want to adjust and schedule the trigger time. 5) Configure this whole setup using AWS.
1) Load the Postgres database that is hosted in Amazon RDS 2) Do some manipulations in the data such as masking phone number fields, making some fields blank, etc 3) Store the modified database in another Postgres RDS Database. 4) This process should run every 15 mins and we want to adjust and schedule the trigger time. 5) Configure this whole setup using AWS.
kotlin, iOS swift, NodeJS - TypeScript, Wordpress - PHP, NestJs, React Js, AWS - EB, EC2, RDS, SES, Lambda, Cloudwatch, S3, Postgres, MySql, BitBucket, CI/CD, APIs, AR, Geolocation, apple dev.prog., google dev.prog. dissents, monitoreo kpis
I need a testing website which has been 20% done by an user. The front page, login, adding user, contact us page. Backend and remaining front end needs to be done. Backend: python, db: mongodb or postgres(suggestions welcome) . my expected budget is around 20k inr.
I don't want freelancers who are already doing other projects. I need 2 script, to be created using VBS: * the first has to --- read on ENV variables the di...with more options. ROBOCOPY can: - tolerate network interruptions and resume copy - skip NTFS junction points which can cause copying failures - copy file data and attributes correctly, and to preserve original timestamps - set persistence by default, with a programmable number of automatic retries if a file cannot be copied - skip files already in the destination folder with identical size and timestamp - show continuously updated command-line progress indicator. - copy paths exceeding 259 characters — up to a theoretical limit of about 32,000 characters — without errors - return code on program terminati...
...Resources: Completing the Golang tour should give one a good grip over the language. Do this well and you will complete the task with ease. This book covers both the workings of web and Go based servers. Users should have the following attributes Id Name Email Password Posts should have the following Attributes. All fields are mandatory unless marked optional: Id Caption Image URL Posted Timestamp...
BUILD A MEDICAL VIEWER AND ADD A LOG LOG FILE Material : https://docs... Outcome of the project : Get a simple dicom viewer usable on any computer (provide simple doc for installation) Get a logfile with the images displayed on the screen and their timestamp with a millesecond time resolution and document the code. Project : 1) Deploy the open source medical viewer with standalone or local pacs source of data. A simple guide of installation on local environnement would be appreciated. 2) Modify the frontend code javascript to obtain the timestamp of the event (image_rendered) from the library Cornerstone and store all the events in a file. For more information please contact me
...efficiency, and other key business performance metrics. • Create data tools for analysts and data scientists that will assist them in building and optimizing our product into an innovative industry leader. Our ideal candidate would feel comfortable with the following statements: • Experience with big data tools: Spark, Kafka, etc. • Experience with relational SQL and NoSQL databases, including Postgres. • Experience with data pipeline and workflow management tools: Luigi, Airflow, etc. • Experience with cloud services: AWS, GCP, Snowflake • Experience with stream-processing systems: Kafka, Storm, Spark-Streaming, etc. • Experience with object-oriented/object function scripting languages: Python or Java Skills and expertise Apache Airflow, Apac...
Your task is to convert timestamps to relative time using the library momentJS It should look like this moment("20111031", "YYYYMMDD").fromNow(); // 10 years ago
Required skills - Java - Spring and Hibernate - Microservices - Postgres
It is an ongoing project and already a lot of code has been done. We are a team of 10 people and looking to add 2 more backend developers with at least 5 years of experience. A candidate, - Must be able to provide at least 30-40 hours per week. - Fixed Monthy Salary. - Should take ownership of the work that you do. - Available in India worki...project and already a lot of code has been done. We are a team of 10 people and looking to add 2 more backend developers with at least 5 years of experience. A candidate, - Must be able to provide at least 30-40 hours per week. - Fixed Monthy Salary. - Should take ownership of the work that you do. - Available in India working hours, not necessarily 9-5 but preferably day time. We are using Postgres but it is not mandatory to have knowledge...
...all platforms and external communication messages. Handle the internal communication response to crisis situations which affect organizational perception and reputation Candidate Requirements Experience of minimum 1 years with PHP framework Laravel, Lumen Knowledge in RESTful API frameworks Knowledge in database programming or design skills, including relational database skills (MySQL, SQL, Postgres, etc.) having non-relational database skills (MongoDB, etc.); Knowledge in CI / CD (Jenkins, CircleCI) Great team working skills Experience deployment with Docker containers Previous experience from working and designing microservice systems with high performance and scalability. Bonus points for: Experience with react js, javascript. Experience working with high-performing, Agile ...
...is based of a specific chat message with a contact. I need a function to format the date/time based off milliseconds from epoch. The returned date or time should follow these rules. - if the timestamp is today then it should return the "time" (e.g. 11:08 AM) - if the timestamp is within one week of the given timestamp, excluding today, then it should return the "day of week" (e.g. Mon) - if the timestamp is within one year of the given timestamp it should return the "month" and "day" (e.g. Sep 16) - if the timestamp is older than one year of the given timestamp it should return "month", "day" and "year" (e.g. 9/8/20) String fo...
write a python script to take folder as input containing json files usin tkinter based on timestamp value located as a key value pair in json
NodeJs, Expressjs, Angular6, Kafka, Camunda workflows, mongodb, Postgres db and Devops part( Docker, Kubernates) Also the tools of Cisco NSO and BPA
I have pdf saved in postgres database and I need it to be downloaded through angular js .
I have open and click data from an email marketing campaign in text files (one for opens and other for clicks). As a first step, I need someone to extract the timestamp, e-mail and geolocation (city and country) of each recipient. As a next step, the timestamp needs to be converted into the right date and time based on the city/country timezone. The output for each text file (opens and clicks) is a data table (excel/csv) where each recipient has its own row and the timestamp, e-mail address, city, country and date and time are further columns. As a final column I need a binary variable "monday" which indicates whether the recipient opened/clicked on Monday, based on the timezone-adjusted date and time.
I have a PDF file been saved in postgres database and I need to be showed in front end
...understand Focus on delivering quality centred around a great experience for the API user Experience with agile & distributed software development Strong self-organizer with a hands-on mentality Strong drive towards ownership Programming Languages: 4+ years of experience in backend development 3+ years in using Golang to build cloud platforms used in production Stack & Systems: Strong experience with Postgres, Redis and message queues like RabbitMQ Strong experience in defining REST APIs and designing microservices Experience in building distributed low-latency systems exposing an API Experience with Docker, Kubernetes Production experience with popular cloud services (Azure, AWS, GCP) Experience with CI/CD pipelines Methodologies and tools: Agile (Scrum, Kanban), Jira...
Possuo um App Android para visualização de dados de telemetria, atualmente apenas para sinais digitais e preciso agora adicionar a visualização de sinais analógicos. O sistema foi desenvolvido em Delphi e comunica com um banco de dados Postgres em um servidor Ubuntu dedicado para recepção e armazenamento de tais dados.
I have JSON packets coming into AWS IoT core from an ESP32. I want to store these packets in a MySQL database hosted in AWS and need someone to provide a step by step written tutorial with screenshots that describe...store these packets in a MySQL database hosted in AWS and need someone to provide a step by step written tutorial with screenshots that describes the following: 1. How to install MySQL in AWS 2. Create a database with a time column and temperature column 3. What steps to follow to ensure data coming into AWS IoT goes into the database. Each data packet coming in is in JSON format and has a timestamp and temperature. 4. The freelancer must provide a solution for any error we may encounter while following their steps. The freelancer must have access to his/her own AW...
> Create 1 excel file with 30 rows with video from youtube. > The file must have only 2 columns( Youtube Url, (from timestapm - to timeStamp)) as in the following example (in the folowing example there is a "| , but in excel files this are columns. | from=00:03:51;to=00:04:41; | from=00:06:21;to=00:06:47; | from=00:07:17;to=00:08:48; | from=00:02:56;to=00:03:42; | from=00:00:01;to=00:01:04; | from=00:02:01;to=00:02:54; | from=00:01:06;to=00:01:41; |
...to build distributed services, modern web applications, and at-scale data analytics. We build using Kotlin, Typescript, Java, Go, Rust, Python. Our frontend systems are built with functional React, Material UI, Redux, d3, RxDB, and others. We use Kafka, Spark, Cassandra, and ClickHouse to track and analyze over 35 billion events per day. Our backend systems use Redis, reactive-streams, MongoDB, Postgres, RabbitMQ, and a bunch of other cool stuff. What you would do Design, build and maintain systems/tools in our Constellix, PerfOps, and DNS Made Easy product suite. Deliver products that will see the light of day. Work independently and as part of a team (depending on the project). What we're looking for Passionate about: ● Designing, building, and delivering products and ...
Hi, We provide public blockchain infrastructure API nodes today. We want to expand our services to larger audience by providing API as a Service and Standalone nodes as w...infrastructure API nodes today. We want to expand our services to larger audience by providing API as a Service and Standalone nodes as well. We are looking for a Linux system administrator with the following skill set: 1) Expertise working with Postgres Databases HA setup and management 2) Expertise in infra setup automation and scripting 3) Expertise with web servers, proxies. websockets, REST APIs 4) Experience in setting up API gateways with rate-limiting, monitoring snd billing policies. We work with ZFS, Proxmox, HAproxy, Nginx, Elastic search, Postgres etc. If you have the above expertise, sha...
I am making a Contact Form page with WPForms plugin. I need the Submit button to trigger the following actions: 1. Assemble Unique ID for the submission, using timestamp+API key into a string 2. save Message Body as PDF 3. save other form data in CSV and add all submissions in here over the day.. 4. Convert Unique ID to hash 2. convert hash to base64 3. convert base 64 to mD5 4. make mD5 a variable to put in the http POST I can use postman one time per day to POST the ZIP file manually. We can automate it next job.
...useContext, etc), Navigation with @react-navigation, Network: react-native-ssl-pinning, UI: Ant design react native () Unit test(Jest and @testing-library/react-native) with test coverage > 90%, Backend(Backend with nodejs will use free service at Heroku for development stage: ) Node JS with express, Typescript, Functional Programming Database: Postgres(all the primary ids use uuid version 4), Sequelize for DB ORM, Table Models with relation between tables Database migration scripts, Unit Test(Jest) with test coverage > 90%, Web:(two portals: one for the website version of the app, one for the admin portal for audio-ers; Both will use free service at Heroku for development stage) React JS, Typescript, Functional Programming with Hooks, react-router-dom
I am looking for someone to develop a price comparison website in Django. You will be using a scraper such as Scrapy and Selenium. It will crawl a dozen websites and pull product details such as the vendor/store, title, image, price description, details, stock, ratings, reviews, percentage discount. This information should be in a Postgres database. There should be an option to change the URL products to affiliate links. Expected features. 1. A front end framework such as Bootstrap, Foundation etc that is responsive, scalable and can turn into a progressive web app in the future. 2. The products table should be automatically populated by the scraper. 3. A scrollable page with discounts in the last 24 hours, week and month from highest to lowest. Discounts no longer available should ...
I have a set of data and I would like an expert in postgis and postgres to do some queries and verify the existing ones
Need help writing a geospatial query using postgres and postgis
