Postgresql Projects

Proposals for a tailored 1:1 competence development program

We are looking for a tailormade competence development program including the following elements: Introduction to database design, training in building PostgreSQL databases, introduction to the possibilities and limitations of data design and handling edge cases, as well as the integration of data from Energinet. The competence enhancement must ensure that we have a common language and direction for our IT project manager and our CEO, who is an expert in energy efficiency and consumption. We want 4 full-day workshops alternating between instruction and hands-on work with the material. We expect feedback on homework between the four workshops. Workshops can be conducted online • The first workshop on database design • The second on PostgreSQL databases • The third on possibilities and limitations in data design and edge cases • The fourth on data integration from an API The propposal needs to include the following to be taken into account: • Information on the supplier and recipient (company name, company registration number, address, and contact information). Our company registration number is DK42994901 • Date of the proposal submission • Detailed description of the tailored competence development program offered (must be based on the attached specification of requirements) • Timeline for the program • Price for the service • Whether the price includes VAT and other taxes • Description of what the hourly rate or total amount covers • Whether there are services not covered by the price

opportunityurgent

Dating app development

Project Scope for Backend Developer - New Dating App Position Overview We are seeking a skilled Backend Developer to collaborate on the development of a new dating app. The chosen candidate will work closely with our frontend team and other team members to ensure smooth integration of backend functionalities with the app’s user interface. This project offers an initial payment of $3,000-$4,000, with the possibility of transitioning to a full-time employee position (contract-based) in the United States, depending on performance and alignment with the team. Key Responsibilities • Develop, test, and maintain scalable and efficient backend systems for the dating app. • Collaborate with the frontend team to integrate APIs and backend logic. • Implement database architecture, user authentication, and secure data storage. • Optimize backend processes for high-performance and low-latency user experience. • Work with the team to troubleshoot and resolve backend issues as they arise. • Ensure adherence to security and data privacy regulations. Required Skills and Experience • Proficiency in programming languages such as Python, Node.js, Ruby, Java, or similar. • Expertise in backend frameworks like Django, Flask, Express.js, or similar. • Experience designing and managing relational and non-relational databases (e.g., PostgreSQL, MongoDB, MySQL). • Understanding of cloud services such as AWS, Google Cloud, or Azure. • Familiarity with RESTful APIs and microservices architecture. • Knowledge of secure coding practices and experience with data encryption. • Strong debugging and problem-solving skills. • Ability to work collaboratively with cross-functional teams. Preferred Qualifications • Previous experience in developing backend systems for mobile or web applications, especially within social networking or dating platforms. • Experience with real-time messaging systems or push notifications. • Knowledge of GraphQL or other API query languages. Payment and Contract • Initial Payment: $3,000 - $4,000 for the project phase. • Future Opportunity: Candidates demonstrating exceptional performance may be offered a permanent employment contract in the United States. Additional Details • Collaboration: You will have access to clear guidance and regular support from our team throughout the project. • Work Integration: Our dedicated frontend development team will work alongside you to ensure seamless development. • Tools: Preferred development and communication tools will be provided (e.g., GitHub, Slack). • Timeline: The project’s expected duration and milestones will be discussed during the hiring process. How to Apply Interested candidates are requested to provide: 1. A portfolio of relevant backend projects. 2. A brief explanation of your experience in backend development. 3. Availability and preferred working hours. We look forward to collaborating with passionate developers eager to create an innovative and impactful dating app!

Automated open ai / + social media apis social media system

Using our original database, and social media APIs Twitter/X API, Facebook Graph API etc , harness our curated posts in a database (like PostgreSQL, MongoDB) for future scheduling and tracking. libraries like APScheduler or cron jobs to automate the time of posting. Implement error handling for API responses (e.g., handling rate limits, authorization errors, media upload errors, etc.). Log successful and unsuccessful posts to a database or file for monitoring.

Website needed for store inventory management (Backend+Frontend)

We are a growing grocery store chain with four stores, and we currently manage all inventory manually on paper. As we plan to expand, we need a robust backend inventory management system to streamline our operations and help us manage key tasks such as: > Goods stock management > Sales tracking > Order processing > Inventory level alerts > Multi-store synchronization > Reporting and analytics Key Requirements: > Experience in building backend systems, preferably in retail or inventory management > Proficiency in database management (e.g., MySQL, PostgreSQL) > Experience in building APIs for frontend integrations > Ability to manage multi-store data synchronization > Strong knowledge of stock tracking and sales management systems > Experience with cloud services for data storage (optional but preferred) Please don't submit AI proposals as we tend to recognize them. If you think you can do the job with perfection we would love to hear from you!

opportunity

Single page angular page with embedded syyncfusion gantt plugin

Job Description: We are seeking a skilled developer to create a single-page web application that allows users to copy and paste project plans directly into a Syncfusion Gantt chart. The application will enable users to view, edit, and manage project schedules efficiently. Key Responsibilities: Develop a user-friendly interface for pasting project data into the Gantt chart. Integrate Syncfusion Gantt chart functionalities, ensuring a hierarchical view of tasks. Implement features for in-place editing, task dependencies, and rescheduling via drag-and-drop. Ensure the application is responsive and performs well with large project plans. Collaborate with stakeholders to gather requirements and provide updates throughout the development process. Technical Requirements: Proficiency in Angular for frontend development. Experience with Syncfusion Gantt chart integration preferred. Familiarity with RESTful APIs and backend technologies (Python/Flask preferred). Knowledge of database management (MySQL/PostgreSQL).

Python Job Data Collection System (scraping)

Project Overview We are seeking an experienced Python developer to optimize and enhance our job data collection system. The current Selenium-based approach needs to be replaced with a more efficient API-driven solution, incorporating sophisticated data management and robust error handling. Key Requirements - Strong Python programming skills with API integration experience - Database design and implementation (PostgreSQL preferred) - Experience with data versioning and delta tracking - Familiarity with VPN handling for IP rotation - Linux server deployment experience (Ubuntu) Technical Specifications Core Functionalities 1. API Integration - Implement API-based job ID collection to replace current Selenium approach - Design intelligent filtering system to manage data retrieval within API limitations - Develop dynamic filter adjustment for optimal data collection 2. Database Design & Implementation - Design and implement a PostgreSQL database structure - Key data points to track: - Job IDs and metadata - First addition and update dates - Full job details (JSON format) - Update tracking and versioning - Job availability status 3. Data Management - Implement delta versioning for historical tracking - Design system to handle regular job listing updates - Ensure no data loss during updates 4. System Features - Flexible time period selection for data retrieval - Automatic filter optimization to work within API limitations - IP rotation mechanism using NordVPN Additional Requirements - Comprehensive logging system - Email notification system for errors and results - Daily statistics tracking and reporting - Server deployment on Ubuntu VPS Technical Considerations - System must handle large volumes of data efficiently - Solution should be scalable and maintainable - Must work within API rate limits and restrictions Deliverables 1. Complete Python codebase 2. Database schema and implementation 3. Import of existing data 4. Deployment documentation 5. System documentation including error handling procedures Skills Required - Advanced Python programming - API integration expertise - Database design and optimization - Linux server administration - Network handling (VPN integration) This is a complex project requiring a developer with strong system design skills and attention to detail. The ideal candidate will have experience with large-scale data collection and management systems.

Backend Node.js application improvement for e-commerce

Hello, and thank you for reading. We have an e-commerce affiliate platform. Now this platform is switching from the WP to Next.js + Strapi. To fill in the product information (create/update/delete) products in DB that is used for the e-commerce platform we have a Node.js (Express) application with a simple (2 pages) React app. Application functionality for today: 1. Get the uploaded csv file from front-end with the list of affiliate products 2. Check each product for the next categories: * exist and no changes in price/description/availability from partner * exist and there are changes in price/description/availability, so it has to be updated * not exist in DB - need to be created * product from DB not in the provider list anymore - needs to be hidden on the platform and then deleted 3. Make the logical matching of the fields from the provider according to the settings json that we create for each provider into the fields in DB 4. Send the API call to update the products in the e-commerce 5. For new products, an app is adding them to DB to the temporary table 6. There is a cron job that gathers the new products, sends them to the AI engine API and gets the response with additional data, then marks the products as ready to be sent to the API 7. Send new products already after AI polishing to e-commerce API The app is running locally. What should be done: 1. Clear code and make some refactoring 2. Change the connection from MongoDB to PostgreSQL and organize the repository to be a single DB related module 3. Change the logic from working with csv files to working with API calls and getting data in XML format (data input on step 1) 4. Add 2 providers based on the settings that I will give you (probably already in json files ready to use), but some logical operations need to be coded according to the previous providers logic-matching templates 5. Small changes in AI request logic: change one call to the set of two consistent calls (all prompts are ready) We treat this task as a fixed price. But we want to find a reliable developer who will handle the requests with this application in the future. Please, let me know what do you think.

opportunity

PostgreSQL upgrade and AWS managment.

PostgreSQL upgrade. AWS Maintenance. platform development. I'm looking for a company or an individual with the following skills and experience. -Full stack developer with solid experience using JAVA strut 1 (This is an old technology now, but that skill is necessary) -Experience in Postgres SQL upgrade and implementation change on AWS servers. - Aws certified expert with solid knowledge of data security. Your professional profile You also have a track record for delivering on time and within the agreed budget. You have the capacity to respond to urgent calls and are able to respond to emergency or catastrophic events. (either you or your team) The task: We have two 12-year-old platforms built on old technology (java strut1 one and postgreSQL11) that must be maintained and updated. Both platforms are the same; one uses live data, and the other uses dummy data to allow us to conduct testing and customer training/support. The first job (to be quoted here) is to upgrade PostgreSQL from 11 to 16 on both instances, including implementation on AWS. You'll need to be able to advise and take action to optimize AWS's cost efficiency and security. Including advising on security protocol, best practices and Following the successful and on-time delivery of this first task, you will be required to deliver some upgrades and minor bug-fixing using JAVA struts 1. These tasks will be quoted separately on PPH. Then, before implementing new functionality and service upgrades, you will be required to upgrade the technology used from Java Strut 1 to JAVA Spring or other more recent/appropriate technology. We hope to establish a long-lasting relationship, with the successful individual or company. Please do not apply for this Job if you are not 100% certain that you have the required skills, particularly regarding expertise in JAVA strut 1. This is a large code, and there is very limited documentation available. If you are not or never have been an excellent JAVA strut 1 developer, you will be lost, wasting our time and yours. While we do not exclude individuals' applications for this job, customising accounts is part of our service to our demanding customers. Which requires availability on demand. We can't reasonably expect an individual to drop everything when we suddenly need it. You also need experience handling sensitive data, are older in Public and Professional Liability Insurance cover for 10.000000, and are preferably ISO 27000 certified. About us: We have created a company to deliver a digital solution with a single purpose: digitalising the retail market sector through PaaS. This involves providing digital services to British local governments and meeting their high standards. While we are not interested in providing these institutions with other digital services, the successful implementation of our services will provide the developer partnering with us with a unique track record and direct access to many additional opportunities.

opportunity

Database Setup and GUI for Managing Google Ads Data

I am looking for a skilled freelancer who can handle both the setup of a database and the development of a user-friendly interface for managing and searching Google Ads data. The project will be completed in two stages: Stage 1: Database Setup (MySQL/PostgreSQL) I currently have CSV files containing Google Ads copy, headlines, and related information that need to be stored in a well-structured database. This stage involves: - Setting up a MySQL or PostgreSQL database on my Contabo server. - Designing and implementing a schema to organize the following fields: headline, description, URL, last_seen, and any other necessary attributes. - Importing existing CSV data into the database. - Implementing deduplication logic to update records (e.g., update "last seen" dates for recurring ads). - Providing instructions or documentation on how to upload future CSV files and manage the data. Stage 2: GUI Development for Data Search by Domain - Once the database is in place, I have a mockup for a user-friendly web-based interface to search the data. This stage includes: - Deploying my simple, intuitive interface that connects to the database. The interface should allow users to: - Search by domain name. - Retrieve and display relevant Google Ads data, including headline, description, URL, and last_seen fields. - Implementing basic filtering and sorting options for the search results. - Ensuring the system is scalable and easy to maintain. Deliverables: - Fully functional database on the Contabo server, including a structured schema and deduplication mechanism. - A web-based interface that allows searching by domain and retrieves relevant Google Ads data. - Clear documentation for both database management and the GUI. If you're capable of handling both the backend database setup and the frontend GUI development, I would love to hear from you!

opportunitypre-funded

Java Struts 1 developer wanted

Experienced Developer for Legacy Project Maintenance and Upgrades We are seeking a highly skilled developer to take over the maintenance, upgrades, and ongoing development of a large-scale project initially developed 12 years ago using JAVA Struts 1. This role requires deep expertise in specific areas, as you must execute specific tasks across the platform. Key Responsibilities: 1-Database Upgrade: Your first task will involve upgrading our PostgreSQL database from version 11 to version 16, ensuring a seamless transition without introducing bugs. The allocated budget for this task is $900, with a strict two-week deadline. your ability to execute this first task on time and within budget will lead to further opportunities including: 2-Project Maintenance & Development: Upgrade and develop functionalities using JAVA Struts 1 to ensure smooth operation and consistent performance. (initially 3-AWS Management: Oversee and manage AWS instances supporting the platform. 4-Future Upgrades: While initially focused on maintaining the current system, you'll be instrumental in planning the eventual migration from JAVA Struts 1 to a more modern framework, such as Spring. Essential Skills: 1-JAVA Struts 1 Expertise: This is non-negotiable. Please do not apply if you lack experience with JAVA Struts 1. 2-PostgreSQL Experience: Proven experience in upgrading PostgreSQL databases. 3-AWS Management: Proficiency in managing AWS environments is crucial. Additional Beneficial Skills: 1-Data Security: Experience in conducting penetration tests and implementing security protocols to meet ISO 27000 standards. 2-Payment Integration: Experience implementing Stripe merchant accounts, including online payments, PDQs, and direct debits. 3-Legacy System Upgrades: Familiarity with upgrading legacy projects, especially migrating from older frameworks like JAVA Struts 1 to modern alternatives. 4-UX & Front-End Focus: While this role is primarily backend-focused, a user-centric approach to development will be advantageous. About the Project: This multi-user platform is heavily database-driven, necessitating a solid understanding of JAVA Stuts 1. The project consists of two identical platforms: a live commercial platform and a UAT (User Acceptance Testing) version used for testing and development. All changes are deployed to the UAT environment before being rolled out to the live platform. Successful task completion will be determined by passing UAT testing. Long-Term Opportunity: We are looking for more than just a developer—we seek a long-term partner committed to our vision. After a six-month trial, the successful candidate will be offered profit-sharing opportunities with growth potential as the project scales. We'd love to hear from you if you're an experienced JAVA struts 1 developer ready to take on a challenging yet rewarding role. This is a unique opportunity to contribute to a significant project and share its future success.

opportunity

Vehicle/Driver Tracking and Control

The project uses a PostgreSQL Backend database. All the tables and data fields are already designed but we can add fields if necessary. I need an application that will run from an Android Tablet that will be mounted inside a vehicle. The Job Tasks etc will be preloaded by the Job Planners. This is what happens when the Driver starts their shift and these aspects need to be controlled by the Tablet App. The driver will sign in to get the process started then, 1. The driver starts by completing a Pre-trip Inspection. There is a questionnaire the driver completes to confirm that he is happy with the condition of the vehicle etc. 2. Then the driver will select his assistants for the day from a list of available employees – drop down list 3. The driver then opens his Job list and select the first Job on the list – in other words he clocks IN on the first Job. And then drives off to the first destination provided. 4. Upon arrival at the destination, there may be a number of items that need to be done at the destination. The driver will tick-off each item as may be required. 5. There will be times on each Leg of a Job that the vehicle needs to go through a Weighbridge. The driver must then record the applicable data from the weighbridge. 6. Once all items are completed, the driver will be prompted to close-off the first Job of the day and proceed to select the next Job in the List. So the drive Clocks-Off on that job and simultaneously clocks on for the next Job. 7. The driver follows the prompts and in so doing completes all the assigned Jobs for the day 8. At the end of the shift, the driver returnes to the home base and does a post-trip inspection to certify the condition of the vehicle. The driver must also have the option to provide feedback regarding the vehicle etc. Then, during the course of the day a number of background things need to happen as follows: 1. At regular intervals, determined by a configuration setting, the GPS location of the vehicle must be captured as well as the weather conditions. 2. If the vehicle is involved in an accident the driver will push/click a button in the app to alert the management. 3. If the vehicle breaks down the driver can also click a button to alert the Workshop 4. The driver must have the option to add a note to each job when necessary A nice to have option will be to suggest a best route to the driver when he clocks onto Job. In other words, Google maps opens and shows the driver the best route to follow to travel from their current location to the address of where they must go.

Full Stack Developer to Create a Wellness Platform

Project Overview: We are an NPO, https://roraimalearningtrust.com, are looking for a skilled Full Stack Developer or development team to build an online Wellness platform to leverage a Pilot study. The Pilot tested the hypothesis that social media can be used to induce sustainable changes in lifestyles to reduce the incidence of non-communicable diseases. The Study report will be shared with the qualifying entities. The platform will provide users with a mix of EAT/MOVE/FEEL videos etc. This project will require expertise in both frontend and backend development, as well as experience in integrating third-party services like video streaming and live chat support. Technology Stack: Framework: Python (Django/Flask) or Ruby on Rails Database: MySQL, PostgreSQL, or MongoDB Payment Integration: Stripe or PayPal Hosting: AWS, Google Cloud, or DigitalOcean Mobile Responsiveness & PWA Capabilities Additional Features: Live chat for real-time support Push notifications for classes and special offers Integration with fitness trackers (Apple Watch, Fitbit) Optional multi-language support Deliverables: Fully functioning web platform with mobile-friendly design User-friendly admin panel for content and user management Comprehensive documentation for the codebase and future updates Thorough testing and bug fixes before launch Timeline: The project is expected to be completed before the end of November. Budget: Please provide a breakdown of the cost, including the time required for each feature. How to Apply: In no more than 2 pages, please submit your portfolio, relevant experience, and an outline of how you would approach this project. Be sure to include examples of any similar platforms you’ve developed in the past. Initial proposals due by noon NYT on Friday 20th September, top 3 interviews over the weekend

opportunityurgent

Ruby On Rails Developer Needed

We need an expert ruby on rails developer to help us complete a CRM project. We are looking for someone extremely proficient who can start almost immediately. Your first task is for a calendar module for our system which we have estimated at around 5 days. If this extends we will also look at extending the budget and a full spec will be provided before you start so we can agree timeframe's. Ideally we would like someone with full calendar experience. Please quote accordingly based on your hourly rate, we need someone reliable and professional. Ideally you would have the following skillset: Proficient in Ruby on Rails framework (minimum 5-6 years of experience) Strong understanding of object-oriented programming (OOP) and MVC architecture Experience working with PostgreSQL database management system Familiarity with front-end technologies such as HTML, CSS, and JavaScript Knowledge of RESTful API design and implementation Experience with version control systems, preferably Git (we use bitbucket) Ability to write clean, maintainable, and well-documented code Strong problem-solving skills and attention to detail Excellent communication and teamwork skills Ability to work independently and meet deadlines Knowledge of agile development methodologies, such as Scrum or Kanban Familiarity with cloud platforms like AWS or Heroku is a plus Knowledge of ReactJS is an advantage but not a requirement Understanding of basic web development concepts, such as HTTP, SSL, and web servers Experience with debugging and performance optimization techniques Ongoing work available. Please start your proposal with the word Upodcrm. We are not necessarily looking for the cheapest, happy to discuss budget base on experience.

opportunity

Custom e-commerce affiliate web-site (JS full-stack)

Hi, I need a simple e-commerce website. Back-end on Node.js (preferably Next.js), front-end - React.js. It should work with MongoDB or PostgreSQL. Additionally for some tasks ElasticSearch and Redis. As the shop is only working with affiliate products - only showing products and filtering (listing) should be made. No registration, cart, check-out, etc. Please, review the technical requirements and description of the design and pages in the attached document. Thank you, I am looking forward to getting your offers.

Need Django Devloper

I seek a skilled Django developer to build a custom solution for my growing business. Requirements include proficiency in Python and the Django framework along with developing backend REST APIs, database integration, and website development. The project involves creating an inventory management system with features such as item listings, order processing, and reporting. Developers should have 2+ years of commercial experience successfully completing similar projects. Experience with PostgreSQL is preferred but not required. Please submit your pitch and portfolio highlighting relevant worksamples demonstrating your ability to deliver a high-quality solution on schedule and within budget. I look forward to reviewing submissions from qualified candidates.

opportunity

Development of Online Service Marketplace App & Website.

We are seeking skilled and experienced developers or a development team to build an online service marketplace similar to platforms like MyBuilder, JustFix, and Airtasker. The project involves creating both a mobile app (iOS and Android) and a responsive website that connects users with service providers for various tasks and projects. Key Features: User Registration & Profiles - User types: Customers (people looking for services) and Service Providers (professionals offering services). - Each user type will have a profile with relevant details (e.g., reviews, ratings, portfolio for service providers). Search & Filtering Options - Users can search for services or professionals based on categories, fixed offers, location, price range, ratings, etc. Managing Rating and Reviews: - Both Customers (people looking for services) and Service Providers (professionals offering services) will have ratings to establish a trusting environment. Job Posting & Bidding - Customers can post jobs/tasks, and service providers can submit bids or quotes for the work. - Alternatively, customers can request direct quotes from providers. Messaging System Secure in-app/website messaging between customers and service providers to discuss project details. Booking & Scheduling - Customers can book services directly via the platform and schedule work. Payment Gateway Integration - Secure payments via credit/debit cards or other methods, with the platform taking a commission or service fee. - Payment release upon job completion and customer approval. Review & Rating System - After job completion, both parties can leave reviews and ratings. Notifications & Alerts - Push notifications for job offers, bids, approvals, and payments. Admin Dashboard - Admin control for managing users, services, payments, disputes, and platform analytics. Technical Requirements: Frontend Development: - Mobile app: React Native / Flutter (iOS & Android). - Website: React.js / Vue.js / Angular. Backend Development: - Node.js / Django / Laravel or similar technologies. - RESTful APIs for seamless communication between the app and website. Database: - MySQL / PostgreSQL / MongoDB (or other scalable database solutions). Payment Integration: - Stripe, PayPal, or similar payment gateways. - Possibility to buy credits from the app to use a way to pay for a service. Cloud Hosting: - AWS, Google Cloud, or similar for scalable hosting and storage solutions. Deliverables: - Fully functional mobile app (iOS & Android) and website. - Documentation for both the code and user/admin guides. - A detailed roadmap of the development process, including timelines and milestones. - Support for testing, bug fixing, and post-launch support for an agreed-upon period. Required Skills: - Proven experience developing marketplace or gig platform apps/websites. - Strong knowledge of frontend and backend technologies. - Expertise in UI/UX design, payment gateway integration, and security best practices. - Excellent communication skills and the ability to work within deadlines. Timeline & Budget: We expect the development to take approximately 3-6 months, with specific milestones set for each phase of the project (app and website). Please submit your proposals with a breakdown of estimated timelines, cost, and any relevant portfolio examples. Please submit the following with your application: A brief description of your experience in building similar platforms. Links to your portfolio or past work. Proposed technology stack and project approach. Estimated development timeline and cost breakdown. Please start your email with "CODEXPERT2024" just to be sure you read all the job description. Best wishes SB

Ruby on Rails Developer needed urgently to take workload

We are looking for a skilled Ruby on Rails Developer to join our team on a freelance basis. The ideal candidate should have extensive experience in developing web applications using Ruby on Rails and be comfortable working with the latest versions of the framework. The project involves developing a web application for a healthcare startup. The application will include features such as user authentication, appointment scheduling, and patient management. The developer will work closely with the team to understand the requirements and deliver a high-quality product. Please use the word Strawberry inside your proposal otherwise it'll be instantly declined Requirements: - Strong experience in Ruby on Rails development - Excellent knowledge of HTML, CSS, and JavaScript - Familiarity with RESTful APIs - Experience with databases (e.g., MySQL, PostgreSQL) - Ability to write clean and efficient code - Strong problem-solving skills - Ability to work independently and as part of a team - Excellent communication skills Responsibilities: - Develop web applications using Ruby on Rails - Write clean and efficient code - Implement RESTful APIs - Work with databases - Implement user authentication and authorization - Implement appointment scheduling and patient management - Test and debug applications - Collaborate with the team to ensure timely delivery If you are a skilled Ruby on Rails Developer and are interested in this project, please submit your resume and portfolio. We will review your application and get back to you if you are selected for an interview. Note: This is a freelance project, and we will not be providing any contact information or placeholders in the description.