Postgresql jobs
Bug fix + performance task in a 14 / TypeScript / Prisma / PostgreSQL real-time dashboard app. Context: the app polls a leaderboard endpoint every 2 seconds to show ranked results from an Event table (user activity events with type, userId, timestamp, and a numeric value field). Two issues: 1. Missing database indexes. The polled query filters on (accountKey, lastActiveAt) and a separate query filters on (accountKey, status, updatedAt) — neither has a covering index, so both scans get slower as event history grows. Need hand-written Prisma migration SQL adding the two composite indexes (not `prisma migrate dev` autogenerate). 2. Leaderboard fallback silently fails as empty state. The ranking endpoint has a primary data source and a fallback data source. W...
...Selenium * Puppeteer * Scrapy * Apify * Other scraping frameworks/services You are free to recommend the best technical approach based on scalability, reliability, cost, and data completeness. ### Database The final data will be stored in **PostgreSQL**. I will provide: * PostgreSQL database * Server/VPS * SSH access * Database credentials * Server environment You will be responsible for developing the scraper and integrating it with the provided PostgreSQL database. ### Expected Deliverables 1. Complete scraping system/source code 2. PostgreSQL database schema 3. Data extraction and storage pipeline 4. Duplicate detection / data normalization 5. Logging and error handling 6. Resume/retry functionality 7. Configuration for categories and geographic ar...
...information that can be used by a consumer application * Build data-quality checks, anomaly detection and confidence systems * Document data sources, transformations, assumptions and limitations * Work closely with the founder and development team to translate product requirements into reliable data infrastructure Technical skills we are looking for Strong experience with: * Python * SQL * PostgreSQL * APIs / REST APIs * Web scraping * ETL / ELT pipelines * Data cleaning and normalization * Pandas / NumPy * Large structured datasets * Automation * Scheduled data pipelines * Geospatial data and coordinate matching * Git / GitHub Experience with some of the following is a major advantage: * Machine learning * Recommendation engines * Ranking and scoring algorithms * Time-serie...
...* Docker and containerization * CI/CD pipelines * Production environment configuration * Domain, SSL, monitoring, logging, backups, and security * Performance and scalability optimization Preferred Technology Stack Experience with the following technologies is highly preferred: Frontend: React.js, , TypeScript Mobile: Flutter, React Native Backend: Node.js, Python, FastAPI Database: PostgreSQL, MySQL, MongoDB, Supabase, Firebase AI: OpenAI, LLMs, AI Agents, RAG, LangChain, Vector Databases, Embeddings Cloud & DevOps: AWS, Azure, Google Cloud, Docker, Kubernetes, CI/CD Other: REST APIs, GraphQL, Git, GitHub, Payment APIs, Third-Party API Integrations Equivalent technologies are also welcome if you can demonstrate strong experience. Ideal Candidate We are looking for a Fu...
...verification/KYC integration readiness * Secure API communication * Backend integration * Admin functionality * Basic reporting and transaction management * Error handling and security controls The exact financial workflow and proprietary features will be provided privately. Technology We are open to recommendations, but the preferred architecture is: * React Native or Flutter * Secure backend API * PostgreSQL/Supabase or equivalent * REST/GraphQL APIs where appropriate * Cloud-based infrastructure * Strong authentication and authorization * Modular architecture so the product can scale Experience with financial APIs, payment providers, wallets, KYC/AML systems, or FinTech applications is a major advantage. MVP Expectations The first version should be: * Fast * Secure * S...
...Synchronization Automatically sync stock levels from our warehouse to the merchant’s Shopify store via inventory_levels/set to prevent overselling. 3. Technical Requirements & Stack Preferences Backend Framework: Node.js (Remix / Shopify App Template preferred) or Ruby on Rails. API Standards: Shopify GraphQL Admin API & REST APIs (where applicable). Database: Lightweight, high-performance database (PostgreSQL / Redis for caching) to handle high order volume seamlessly. Security & Compliance: GDPR/CCPA webhooks implementation, secure token storage, and compliance with all Shopify App Store Partner guidelines. 4. Acceptance Criteria Flawless Installation: The app installs and authenticates without errors on development and production stores. Speed & Sca...
...Management MVP Budget-12.5k INR Fixed We need to build a small but properly structured multi-tenant School Management MVP using Django. The goal of this phase is to create the core foundation with tenant isolation, school/user management, student/staff management, RBAC, audit logs, PWA setup, and background task setup. Technology Stack • Latest stable Python Django • HTMX for CRUD operations • PostgreSQL • Celery, beat, Redis • PWA setup MVP Modules 1. Multi-Tenant Architecture • Each school will be treated as a separate tenant • data isolation between schools • School-specific users, students, staff, and academic structure • Tenant-aware permissions and queries • Architecture must also support single-tenant deployment using the ...
Looking for an Automation & AI Expert to build a Facebook Scraper, AI Parser, and Moderation Dashboard Project. I have build a free hyper-local mobile app that aggregates food and drink promotions (Happy Hours, dinner deals, etc.) from Facebook pages onto an interactive map and calendar layout. I am currently sourcing these offers manually, but I need to automate the b...review it, make minor edits if needed, and click a single "Approve & Publish" button to push it live to the app database in under 2 seconds. Ideal Freelancer Skills: Python (BeautifulSoup, Scrapy, or API integration) Open AI API / LLM text processing Backend dashboard development (e.g., Node.js, Django, or a low-code framework like Retool for speed)Experience with database mapping/geocoding (Postgre...
...confirmation and delivery history. 4. SUPER ADMIN/CRM – complete control over customers, orders, inventory, stores, delivery partners, payments, revenue, offers, reports and full order timelines. Backend must securely connect everything with role-based access, server-side validation, real-time order/inventory sync and stock-conflict protection. Prefer React/, React Native/Flutter, Node.js and PostgreSQL/Supabase. Need complete source code, deployment, documentation and testing. Freelancer should provide relevant portfolio, proposed stack, timeline, fixed/milestone cost and support....
...job opportunities. Fields may include: - Name - Mobile - Email - Location - Experience - Qualification - Skills - Preferred work type - Availability - Documents - Resume/Profile information Admin should be able to review and manage applications. 7. TECHNOLOGY Preferred technology stack: Frontend: - React.js / - Tailwind CSS Backend: - Node.js - Database: - MySQL or PostgreSQL Other: - REST APIs - Secure authentication - Cloud storage for documents/images - WhatsApp integration - Email notifications - Google Maps/location integration where required 8. SEO & PERFORMANCE The website should be optimized for Google search. Requirements: - SEO-friendly URLs - Meta titles/descriptions - Open Graph tags - Sitemap - - Schema markup where appropriate - Optimized
...MUST FOLLOW Please quote only if you are comfortable with this exact stack: - — App Router - TypeScript - Tailwind CSS - shadcn/ui - PostgreSQL — Neon, Singapore region - Drizzle ORM - Better Auth - Zod validation - Razorpay payments - Resend email - Cloudinary images - Vitest testing - Vercel deployment The GitHub repository and Vercel project already exist. Do not replace the stack or add npm dependencies without discussing and getting approval first. Critical Technical Requirements 1. Double-booking must be impossible This is a non-negotiable requirement. Availability must NOT rely only on application-level checks. Use PostgreSQL: EXCLUDE USING gist constraint + btree_gist extension There must be an automated test demonstrating that an overlappin...
...Customer-facing workflows We are looking for a developer who can review the platform, identify weaknesses, fix critical issues, improve code quality, and help make the system more stable and production-ready. This is not a greenfield project. ## Current Technology Stack ### Frontend * * React * TypeScript * Tailwind CSS ### Backend * FastAPI * Python * REST APIs ### Database * PostgreSQL * Redis ### Infrastructure * Docker * Kubernetes * Microsoft Azure ### Mobile * iOS Application * Android Application ### Cloud & DevOps * Azure Services * CI/CD Pipelines * Containerized Deployments ## Scope of Work The successful candidate will: * Review the existing codebase * Review architecture and application structure * Identify technical debt * Fix critical bugs * I...
...an architecture & interior design studio—Sales CRM, AI-assisted site visits, design-gate workflows, project management, and operations. You’ll work on NestJS (TypeScript) APIs, domain modules, and workflow/state machines PostgreSQL data models, RBAC, audit trails, and document metadata Async jobs (SQS): notifications, reminders, AI site-visit report generation AWS: ECS/Fargate, RDS, S3, Cognito, SES, Redis Integrations (LLM/Bedrock, email) and solid API contracts for the frontend What we expect Strong Node.js / TypeScript and REST API design Hands-on PostgreSQL, auth/RBAC, and production debugging Comfort with AWS (or equivalent cloud) and CI/CD Clear communication, ownership of features end-to-end, and quality under phased delivery Nice to have: NestJS...
...relies on a unified PostgreSQL/PostGIS database serving specialized map tile, geocoding, and routing engines. The objective is to transition the current local build into a highly available, scalable production environment. Core Technology Stack: - Deployment: Docker, Kubernetes. - Database: PostgreSQL 16 + PostGIS 3.4 (High Availability setup required). - Backend Services: Martin (Vector Tiles), Pelias (Geocoding), Valhalla (Routing). - API Gateway: Kong, APISIX, or Traefik. - Observability: Prometheus, Grafana, Loki/ELK. - Automation: n8n, CronJobs, bash/SQL scripts. Required Deliverables: 1. Infrastructure Provisioning: Set up the hosting environment and configure Kubernetes clusters for horizontal scaling. 2. Database Configuration: Deploy a Highly Available (HA) P...
...fertilizer e-token ### Communication * Official WhatsApp integration * SMS/OTP * Push notifications ### AI * AI Farmer Assistant * AI product recommendation * WhatsApp AI chatbot Government integrations must use official APIs and authorized access only. No scraping or unofficial APIs. ## PREFERRED TECHNOLOGY Preferred: **Mobile:** Flutter **Backend:** Laravel / Node.js **Database:** PostgreSQL / MySQL **Admin:** React/ or equivalent Developers may propose an alternative technology stack with technical justification. ## SOURCE CODE AND OWNERSHIP This is a mandatory requirement. The client must receive: * Complete Android source code * Complete iOS source code * Complete Web source code * Backend/API source code * Database schema * Complete database backup * Git rep...
...languages). • High-volume Email, WhatsApp Business API and SMS gateway integrations, with delivery reports that can be filtered, searched at account level and downloaded as CSV/Excel. • Elastic search across all campaigns, customers and delivery logs. Tech expectations Use a modern, widely supported stack (think Node.js/Express or Django/FastAPI on the back end, React or Vue on the front, PostgreSQL or MongoDB for data, and Docker/Kubernetes for scalable deployment). Secure code practices, RESTful or GraphQL APIs, and a micro-service-friendly architecture will be appreciated because we anticipate future feature expansion. Deliverables 1. Source code in a private repo with clear commit history 2. Deployed MVP on our cloud account (AWS/Azure/GCP) 3. Data...
...Generation • Structured content → AI → PNS metafields Step 10 — Variant Cleanup • Supplier variants → AI → Standardized variants tep 11 — Image Optimization • Supplier images → Image pipeline → WebP optimized Step 12 — Shopify Publishing • All optimized content → Shopify Admin API --- 4 TECH STACK developer should use: Backend • - Node.js or Python • - Express or FastAPI • - MongoDB or PostgreSQL AI • - OpenAI API • - Local LLM (optional) • - Custom prompt templates • - Keyword ranking algorithms Scraping • - Puppeteer • - Playwright • - SerpAPI • - Amazon/Walmart autocomplete scrapers Image Processing • - Sh...
...operations * Initial project organization We primarily need you for **technical leadership + architecture + hands-on full-stack development**. ## Technologies Our projects may involve: **Backend:** Node.js, , TypeScript, , Django, Flask, Laravel, Ruby on Rails, Java/Spring Boot, C#/.NET **Frontend:** React, , JavaScript, TypeScript, jQuery, HTML/CSS **Database/ORM:** PostgreSQL, MySQL, MongoDB, Prisma You **DO NOT need to know every technology listed above**. Strong engineering fundamentals, architecture knowledge, problem-solving ability, and the ability to learn or understand unfamiliar technologies are more important. ## Leadership & Collaboration This is particularly important to us. You may work with junior developers, intermediate developers, designers,
...combinations The admin should also be able to add or modify customization options without requiring changes to the source code. ### Technical Requirements The website should be: * Fully responsive * Mobile, tablet and desktop friendly * Fast and optimized * SEO-friendly * Secure * Scalable * Easy to maintain Preferred technologies can include **Laravel/PHP, React/, Node.js, MySQL or PostgreSQL**, although I am open to recommendations from the developer. ### Important Requirement The most important part of this project is the **interactive customization experience**. The interface should feel smooth and premium rather than simply displaying a standard product form. The architecture should also make it possible to add more clothing categories and customization options in th...
...production code and need a full-stack engineer who can own the build-out of an AI-powered recruitment platform. Temporal will orchestrate every workflow, Postgresql will back our data, and Nous’s Hermes 3 agents will handle reasoning throughout the pipeline. The product vision is clear: • a Publication agent pushes openings to multiple channels; • a Marketing agent drives targeted outreach; • a Shortlisting agent filters applicants in real time; • built-in Analytics & Reporting present actionable insights; • an Application Tracking System ties everything together. Your first milestones involve wiring Temporal to a solid Postgresql schema, standing up Hermes 3 reasoning agents, and exposing an API layer that other micro-services...
...Reporting and analytics for sales and marketing performance • Integration with email/SMS so agents can communicate directly from the CRM • User role management to separate agent, manager, and admin views Tech direction A modern web stack is expected; React or Angular on the front end with a REST or GraphQL API. Feel free to recommend supporting tooling (Redux, Zustand, Node.js, NestJS, PostgreSQL, etc.) that will speed delivery without locking us into niche dependencies. Collaboration style Version control will live on GitHub with a standard PR workflow. The senior developer will spearhead initial project setup, code review, and deployment pipelines; the junior member will pair on features, write tests, and assist with documentation. What to include in your...
...login * Dashboard with order and sales statistics * Add, edit, and delete products * Manage categories * Manage product prices and availability * Manage product images * Manage customers * Manage orders * Update order status * Manage inventory/stock * Manage discounts and offers * Generate basic sales/order reports Backend Requirements * Python * Django * Django REST Framework where required * PostgreSQL/MySQL * Django ORM * REST API development * Secure authentication and authorization * Proper database relationships * Clean and reusable code Frontend The developer can use: * HTML5 * CSS3 * JavaScript * Bootstrap * Django Templates ## Developer Requirements We are looking for someone who: * Has strong experience with **Python and Django** * Has developed e-commerce, rest...
...Docker-based integration test stack: â—¦ meltano container (with Singer taps/targets) â—¦ postgresql container (target destination for loaded data) • Integration task — validate that tap-edu-v works end-to-end by: â—¦ Running the tap within our Meltano environment â—¦ Loading data into PostgreSQL via a Singer target (e.g., target-postgres) â—¦ Validating data integrity and completeness You will need to ensure compatibility with this setup and troubleshoot any issues that arise during integration. What We Provide • Test environment — access to a running EDU-V instance with API credentials • Integration test stack — Docker Compose with Meltano + PostgreSQL • API documentation ...
...Vendor Management * Product Approval System * Category & Brand Management * Customer Management * Commission Management * Order Management * Reports & Analytics * Admin Dashboard * Website Settings Preferred Technology Stack * Frontend: React.js + Tailwind CSS, Must be Skeleton Loading UI and Proper Pagination Features * Backend: Spring Boot, Redis, Kafka, API Gateway, OAuth, RBAC * Database: PostgreSQL / MySQL * Payment Gateway Integration * Shiprocket Integration * Fully Responsive Design * Figma Design Wireframe Developers may suggest improvements to the architecture or technology stack, but any proposed changes should be clearly explained in the quotation. Expected Timeline Target timeline: 8–10 weeks Please mention your realistic delivery timeline in your...
...full inventory and sales flow: barcode or QR code generation for every product, label printing straight from the browser, real-time stock maintenance, purchase entry, sales billing, plus a ledger section that rolls everything up into clear Excel-exportable reports. Please wire in a straightforward email-and-password authentication flow and keep data in a SQL database—I am fine with MySQL or PostgreSQL as long as schema migrations are simple to manage. Reports should download in Excel with the columns properly typed so they open cleanly in Microsoft 365 or Google Sheets. Because the project will eventually tie into other services, clean RESTful endpoints, sensible TypeScript interfaces, and modular Angular components are important. I would also like brief setup documentati...
...performance data Reuse competitor and past-performance insights when generating future content Create automated monthly performance reports and strategy recommendations Custom model training is not required. However, automated retrieval, storage, and reuse of prior performance data is required. Preferred Stack n8n Claude, OpenAI, and/or Gemini for image/video generation Supabase or PostgreSQL Meta APIs Buffer, Metricool, or a comparable publishing/analytics tool You may recommend alternatives if they are more reliable, compliant, or cost-effective. Deliverables Fully working end-to-end workflows Architecture overview and workflow documentation List of all APIs/services used Setup and maintenance instructions Walkthrough video Transfer of all workflows, prompts, d...
Project Overview I am seeking an experienced full-stack developer or small team to audit, improve, secure, and modernize an existing production website and infrastructure. This is **not a greenfield project**. An existing frontend, backend/API, PostgreSQL database, content, media, forms, administrative functionality, Docker deployment, and VPS environment are already in place. The current website has experienced intermittent outages and loading failures. Based on prior troubleshooting, the likely problem area is a combination of deployment/runtime stability and security rather than a simple frontend bug. Known symptoms/issues include: Website sometimes hangs or times out while Docker containers still appear to be running. Nginx and Docker are functional, but the deployment is n...
...with IRS and state rules. • Integrate e-file workflows that generate ready-to-submit federal and state forms. • Add real-time advisory features: scenario modeling, credit optimization, and audit-trail reporting. • Provide role-based dashboards, multi-entity management, and SOC-2-ready security. Preferred tech (open to suggestions) React/ front end, Python or Node micro-services, PostgreSQL, AWS, plus integration with the IRS Modernized e-File (MeF) API or similar tax SDKs. Key deliverables 1. Technical architecture and data model 2. Clickable UI prototype 3. MVP with automated tests 4. Deployment scripts and CI/CD pipeline 5. Documentation and final hand-off Acceptance criteria • Accurate 2023-24 calculations for federal and at least two...
Cloudport dMRV – Phase Overview Phase 0: Production build. Calculation-ready for Cookstoves, Biochar, Blue Carbon (others stubbed). Stack: Node.js/TypeScript + BullMQ, separate Python carbon engine, PostgreSQL/PostGIS, AWS ECS. Needs repo access, GEE sandbox, registry agreements before start. Phase 1 (Days 1–4): Scaffold, CI/CD, staging setup. Full DB schema with audit logs and encrypted IoT triggers. JWT auth with RBAC/DPA enforcement. Public branding API. Acceptance: passing security tests, clean CI/CD. Phase 2 (Days 5–10): Org-scoped Sites API; patrols/alerts/uploads; satellite ingestion via GEE; webhook verification with idempotency; BullMQ processing with DLQ retries; stale-data alerts; equipment API with offline sync. Acceptance: duplicate rejection, DLQ r...
...Agent * Executive Intelligence Agent Agents should securely call application APIs/tools to retrieve real-time data. ## Recommended Architecture The AI layer should be implemented as an **independent AI service/microservice** connected to the existing application through secure APIs. Preferred technologies: * Python * FastAPI * OpenAI API * LangGraph / LangChain * Qdrant / Pinecone * Redis * PostgreSQL or existing database integration * Docker The architecture must allow future replacement of AI models/providers without rebuilding the entire system. ## Security Required: * Strict multi-tenant isolation * Role-based access control * Secure API authentication * Audit logging * Data protection * No cross-organization data exposure * Human approval before critical actions * A...
...details automatically. • Product data should flow in from my existing database; once I update a record, the new information must be reflected in replies without manual intervention. • Fast setup and low friction for both the customer and me; no separate app or login required on their side. • Simple behind-the-scenes structure so I can extend the catalogue or promo rules later (MySQL or PostgreSQL preferred but open to your suggestion). Deliverables 1. Fully working WhatsApp bot deployed to my chosen number. 2. Source code and database schema. 3. Brief hand-off guide covering how to add new products, adjust prices, and launch or expire promotions. Acceptance criteria • A test conversation that shows correct responses for at least three different...
...engineering direction. This is not a greenfield project and I am not looking for someone to rewrite the application from scratch. I am looking for someone who is particularly good at inheriting existing systems, understanding them quickly and deciding what should be kept, simplified, improved, removed or deferred. Current technology The application is primarily built around: - Python / Django - PostgreSQL - Redis - Celery and background workers - Docker - Cloudflare R2 / S3-compatible object storage - Document generation and PDF processing - Microsoft Word / Outlook integrations - REST APIs - Cloud-based deployment infrastructure The application deals with sensitive legal information, so security, data isolation, reliability and maintainability are particularly important. ...
...Instagram Professional account integration Instagram post/comment detection Media-wise link mapping Instagram DM automation Core Requirements User Platform Registration & Login User dashboard Facebook & Instagram connection Post management Campaign management Post-wise link management Keyword configuration Automation ON/OFF Activity logs Basic analytics Backend Node.js / Python / equivalent REST APIs PostgreSQL/MySQL Secure OAuth implementation Scalable webhook/event-processing architecture Meta Integration Meta OAuth Facebook Graph API Instagram Graph API Meta Webhooks Messenger API Instagram Messaging API Comment event handling Post/Media ID-based automation Secure token management Proper handling of Meta permissions, messaging windows and platform policies Admin Dashbo...
...Deep links to official government PDFs and application portals. Although an eligibility calculator and user accounts may come later, right now I want you to concentrate on delivering the most accurate, lightning-fast scheme discovery engine and the interactive front end that showcases it. Tech stack suggestion (flexible) React or Vue for the UI, Node/Express or FastAPI for the backend, PostgreSQL for structured scheme data, and OpenAI or Cohere for natural-language search. If you know better tools that achieve the same snappy response, propose them. Acceptance criteria 1. Users can pick a language from the dropdown and see every static label translated. 2. A single search returns relevant schemes in under two seconds for a 10k-record dataset. 3. Each scheme card show...
...primarily focusing on PHP and Laravel-based web application development. I was responsible for developing new features, building REST APIs, managing databases, fixing bugs, and improving existing applications. Key Responsibilities: - Developed and maintained web applications using PHP and Laravel. - Built and integrated REST APIs for web and mobile applications. - Designed and managed MySQL/PostgreSQL databases. - Developed CRUD modules, admin panels, authentication, and role-based access systems. - Implemented dynamic forms, filters, search, reports, and data management features. - Integrated third-party APIs and external services. - Debugged and fixed application errors and production issues. - Improved application performance, security, and code quality. - Worked with JavaSc...
...app returns matched schemes — PM Kisan, Ladki Bahin Yojana, Ayushman Bharat, PMAY, scholarships, pensions, etc. — with an AI-generated, plain-language explanation of why each one applies to them. Architecture React 19 + TS Frontend (Hugging Face Spaces / Render, Nginx+Docker) ↓ HTTPS Cloudflare Worker (edge gateway) ↓ ASP.NET Core 8 Web API (Railway/Render, Docker) ↓ PostgreSQL (Neon) — 4,600+ schemes aggregated from 5 govt data sources Key features - Conversational AI matching — Claude (Anthropic) extracts a structured user profile from free-text chat, asks follow-up questions if data is missing, then explains matched schemes conversationally. - Multi-source scheme aggregation — scheduled background jobs sc...
...production-grade AI SaaS platforms from scratch • Multi-tenant SaaS architecture • Granular role-based permissions (RBAC) • Secure handling of sensitive data • Audit logging • RAG/LLM implementation ensuring traceable AI outputs • Scalable cloud infrastructure (Azure/AWS) • React / or similar modern frontend technologies • Python, Laravel, Node.js or comparable backend technologies • PostgreSQL • Dashboard/data visualisation • UK GDPR compliance Experience developing healthcare, social care, children’s services, CQC/Ofsted or other regulated-sector software would be particularly advantageous. What we want from applicants: Please provide: 1. Examples of relevant production-grade AI/SaaS platforms you have per...
...been secured—save it before it expires!" Anchoring: Show the original price crossed out next to the discounted price when applicable. SECTION 4: TECHNICAL REQUIREMENTS Frontend React.js or (must be fully responsive for mobile, tablet, and desktop). Must have a clean, modern UI focused on conversion. Backend Node.js (Express) or Python (Django/Flask). Database PostgreSQL or MongoDB. File Storage Must integrate with AWS S3 or Cloudinary to securely store uploaded floor plans. The system should generate a unique filename for each upload (e.g., ). Store the secure file URL in the database linked to the user's lead record. Hosting Must be deployable on Vercel/Netlify (frontend) and AWS/Heroku (backend). Provide
...role (with the ability to extend later to Admin and Viewer) • Real-time Income Statement and Cash-Flow Statement generation • Comprehensive audit logs for every transaction • Secure, scalable multi-tenant setup (single codebase, isolated data) Tech expectations I am open to the stack you are most productive with—whether that is a Kotlin/Jetpack Android front end talking to a Node.js + PostgreSQL backend, Flutter paired with Firebase, or something else that you can justify for long-term maintainability and compliance. What matters is that the core accounting logic is reliable, test-driven, and documented. What I need from you to move forward 1. A short note on two or three accounting/ERP products you have delivered (links, screenshots, or app sto...
...Full-Stack Developer Needed to Complete Existing Web Platform We are looking for an experienced Senior Full-Stack Developer to take over and complete an existing web-based management platform. The project is approximately 75% completed and is already deployed on a development server. Current Technology Stack * Frontend: 14, React, TypeScript * Backend/API: NestJS * Database: PostgreSQL + Prisma * Languages: Arabic & English (RTL/LTR) * Deployment: VPS, PM2, nginx * CI/CD: Automated deployment pipeline * Existing Integrations: * V5L fingerprint/attendance device * WhatsApp * Email * Google Gemini AI for document extraction and letter drafting Current Project Status Approximately 75% of the system has already been developed. We ar...
...received - Follow button - Message button - My room - Wallet - Ranking 11. NOTIFICATIONS - Gift notifications - Follow notifications - Room invitations - System notifications 12. SETTINGS - Account - Privacy - Notifications - Blocked users - Language - Logout - Delete account TECHNICAL REQUIREMENTS: - Android-first MVP - Flutter or native Android/Kotlin - Node.js/TypeScript backend preferred - PostgreSQL preferred for wallet/financial ledger - WebSocket for realtime chat/room state - Agora or LiveKit (or another reliable RTC provider) for live audio - Cloud storage for profile/room images - Secure API - Server-side wallet/coin calculations - Payment gateway integration with secure server-side webhook verification - Admin panel using React/ or similar IMPORTANT SECURITY REQUI...
...for: Purchase orders Supplier bills Expenses Payments Journal entries Support approval limits, multiple approvers, rejection, comments and history. Technology Developer may recommend the final stack, but must explain the architecture. Possible technologies: Web: React/, Vue/Nuxt or Angular Mobile: Flutter or React Native Backend: Node.js/TypeScript, Python, .NET, Java or Go Database: PostgreSQL or MySQL Cloud: AWS, Azure or Google Cloud Priority is accounting accuracy, security, scalability, performance and maintainability, not a particular programming language. Testing Mandatory: Unit testing Integration testing End-to-end testing Security testing Performance testing Critical automated tests must cover: Debit/credit calculations Tax Invoices Payment allocation Inventory costi...
...client operates a gaming and esports marketplace serving Saudi Arabia and the wider GCC. The platform connects gamers, talent scouts, studios, teams, and brands. The founder is hiring a senior developer to take technical ownership of the codebase while the founder leads the business. --- ## THE ROLE We need a Senior Full-Stack Developer to take technical ownership of an established React and PostgreSQL platform currently in closed beta and moving toward public launch. This is a six-month engagement structured in three stages: a paid scoped trial, a defined first milestone, then ongoing work. A longer-term or full-time arrangement may follow for the right person. This is not a greenfield build. The product exists, has real users, and has a mature schema. We are looking for so...
I need a seasoned full stack developer to help integrate OpenAI APIs into my existing application. The tech stack includes React, , Node, PostgreSQL, and REST APIs. Key Responsibilities: - Frontend Development: Building responsive UIs with React and Next.js. - Backend Development: Setting up and managing Node servers, PostgreSQL databases, and REST APIs. - AI Integration: Seamlessly integrating OpenAI APIs into our system. - QA & UI Testing: Ensuring a bug-free, high-quality user experience. Ideal Skills & Experience: - Proficient in React, , Node, PostgreSQL - Experience with OpenAI API integration - Strong background in QA and UI testing - Excellent problem-solving skills for bug fixing Please include your relevant experience in your application.
I need a clean, well-struc...or category, and automatic restocking alerts that flag items below their reorder point. • A small manufacturing component is required: please include fields or a lightweight table design that lets me track which finished SKU is produced from which component SKUs (bill of materials style). Acceptance criteria – Normalised SQL schema delivered as .sql file ready for deployment on MySQL or PostgreSQL (let me know which you prefer). – Sample data set for testing. – At least three example queries demonstrating the two reports and a basic bill-of-materials lookup. – Brief README explaining table relationships and how to run each query. If you have suggestions that streamline the manufacturing piece or improve report spe...
I need a solid PostgreSQL-backed RESTful API to drive the Solar TwinPro web application. Your task is to design the database schema and expose clean, versioned endpoints that cover full CRUD functionality for each core resource in the system. The web front-end will consume JSON, so consistent status codes and clear error handling are important. Please structure the project so it can be deployed easily (Docker preferred, but I am open to other simple approaches) and include concise documentation; an OpenAPI/Swagger spec is ideal so the front-end team can plug in without guesswork. Deliverables • PostgreSQL schema (DDL) and seed data • REST endpoints covering create, read, update, delete for all defined entities • Environment and run instructions (e.g.,...
...feel light and intuitive on phones as well as large screens, with page transitions that stay below perceptible latency. React (or a comparable JS framework) on the client and Python (Flask or FastAPI) on the server are my leading candidates, but I’m happy to hear alternative stacks if they help us reach better performance or maintainability. Key requirements • Data will live in a SQL store—PostgreSQL or MySQL is fine—so design a tidy schema, handle migrations, and include an ORM layer. • Sign-in must rely on OAuth (Google, Facebook, or both) for smoother onboarding. • The first release needs a user-facing dashboard; admin or analytics modules can remain future enhancements. • Security, rate limiting, and input validation have to be i...
I’m developing a cross-platform Flutter application that centers on location services. The core feature set is an interactive map that offers real-time tracking and turn-by-turn navigation, plus geofencing that fires events whenever a user enters or leaves predefined zones. The back end will live on Supabase with its PostgreSQL database, so you’ll connect the Flutter front end to Supabase for authentication, live position storage, and event logging. Google Maps or Mapbox—whichever you work fastest with—can power the mapping layer, provided it supports smooth location updates and low-latency WebSocket or stream channels. Flow I need: • User signs in, grants location permission, and sees their live position on the map. • Movement is tracked cont...
...web dashboard. * Integrate with multiple third-party APIs and cloud services. * Implement authentication and role-based access. * Build automation workflows. * Write clean, maintainable, and well-documented code. * Participate in architecture discussions and technical planning. * Ensure high performance, security, and reliability. ⸻ Required Skills * Node.js * TypeScript * React / * PostgreSQL * REST APIs * Docker * Git * Cloud infrastructure * Experience building SaaS products * Strong software architecture knowledge Nice to Have * Mobile development experience (React Native, Flutter, Unity, or native iOS/Android) * CI/CD experience * DevOps experience * Experience integrating third-party APIs * AI integration experience ⸻ What We Are Looking For We value quality over s...
Top postgresql Community Articles
Using PHP PDO to manage data in MySQL
Details about how to use the PHP PDO library for data manipulation