Databases & SQL

We have synchronization of two data sources with the CRM. The system as a whole is stable. However, there remains a part that becomes desynchronized. The main hypothesis is that in one of the sources, the data changes after the initial synchronization, and these changes are not always pulled into the CRM. + the data in the two sources have different names/identifiers even though they represent the same entities.

Task: deploy an LLM service that knows all the company's documentation and answers questions from the sales department managers. Current situation: the client has independently assembled a prototype (a separate project with uploaded company information, hosted on a server), but the information from the database is not transmitted to the model — likely, there is an issue with the API. We will provide the code and access. The first step is an audit: fix the existing setup or justifiably rebuild from scratch. Required functionality: Upload all company documentation: description of each service, regulations, FAQ, pricing (all materials will be provided). Answers strictly based on the uploaded documents (RAG). The model does not invent facts; if the answer is not in the database — it honestly informs about it. Access for managers via a link (web interface), with authorization. Scenarios: the manager asks any question about the company's work; inserts the client's question "as is" and receives a ready answer for sending; finds the necessary regulation/report by request. Knowledge base updates without a developer (uploading files through the interface or a connected folder). English language. History of requests for quality control. Technical expectations: LLM via API (Claude/OpenAI — propose with a cost calculation for tokens), RAG pipeline (vector database, embeddings), hosting on our server or in the cloud, HTTPS. The architecture should allow for future connection of the assistant to the analytical data warehouse (parallel project). In the response, indicate: examples of similar RAG projects, stack, timeline, cost of work, and estimated monthly ownership cost (tokens + hosting).

Hello There is a small department where patients are admitted. It is necessary to develop a simple "database" where consumables, medications, and others can be entered, along with incoming and outgoing records, as well as assigning usage to a specific patient. Required functionality Directories Medications Consumables (manual entry option) Patients (ability to continuously add new ones and delete those who have been discharged) Employees (ability to modify)Movement Accounting A single table (movement log) where everything is registered Incoming and write-off Manual correction option When writing off, the nurse must select: date; patient; medication or material; quantity; her full name. The system automatically reduces the balance. When receiving, the head nurse must be able to enter: Delivery date; Medication/material; Remaining quantity; Source; Expiration dateAutomatic Functionality automatic balance calculation; minimum stock control; expiration date control; low stock warnings; protection against writing off more than is available; drop-down lists; data entry validation; conditional formatting.Reports It is necessary to implement automatic reports: current balances; usage over a period; usage by patient; usage by employee; history of movement of a specific medication.Preferred implementation on Google Sheets; We will fill in the databases ourselves. A template for work is needed. I don't know how much this costs, so let's start with $50, and you can suggest your options, preferably with experience.

C# / .NET WPF Developer – Completion of Migration of a Large Invoicing Program RAFSOFT.NET Sp. z o.o. is looking for a C# / .NET developer to complete the rewriting of a large, long-standing invoicing program to a new technology. The project involves the migration of an extensive desktop application for companies, used for invoicing, handling sales documents, contractors, records, and accounting-tax functions. The new version of the program is being created in C# / .NET, using DevExpress components. The project is already about 70% rewritten. We are looking for someone who can help bring it to completion, organize the missing elements, perform tests, and ensure the new version operates in accordance with the existing program. Scope of Work: completion of the migration of a large desktop application to C# / .NET, recreation of the functionality of the old program in the new version, maintaining as identical logic of operation, appearance, and handling as possible, working with DevExpress components, analyzing existing code and comparing the operation of the old and new versions of the program, fixing bugs, completing missing functions, and testing the application, collaborating on the final preparation of the program for deployment. Requirements: very good knowledge of C# and .NET, experience in creating desktop applications for Windows, knowledge of WPF or WinForms, experience with DevExpress or similar UI component libraries, ability to analyze a large existing project, accuracy and patience in reproducing existing functionality, ability to test one's own changes, very good ability to use AI tools supporting programming, code analysis, refactoring, and testing. Preferred: experience with legacy projects, knowledge of or previous work with Visual Basic 6.0, experience in migrating applications from older technologies to C# / .NET, knowledge of issues related to invoicing, accounting, JPK, or KSeF, experience working with large business applications. Who We Are Looking For: We are looking for a self-sufficient, precise, and technically experienced person who can enter an existing project, understand its logic, and consistently bring it to completion. In this project, it is very important not only to write new code but also to faithfully reproduce the operation of the old program — both in terms of functionality and appearance as well as handling. We also require proficiency in using AI tools in daily programming work. We are looking for someone who can use AI practically: for code analysis, bug finding, speeding up migration, creating tests, and organizing the project. About the Company: RAFSOFT.NET Sp. z o.o. is a Polish company creating software for entrepreneurs, accounting offices, and small and medium-sized enterprises. Our main product is the VAT Invoice program, supporting the daily handling of invoices, sales documents, contractors, records, and settlements in accordance with Polish regulations. We develop our own desktop applications and tools related to invoicing, accounting, KSeF, JPK, and automation of business processes. Our solutions are designed with stability, ease of use, and practical application in users' daily work in mind. Company website: www.rafsoft.net

It is necessary to calculate statistics in a medical project (including correlations). Additionally, there is a request to create a mathematical model for predicting the development of pathologies based on available data.

Hello, I need your help in implementing a task. Fix the bugs on the website page, the page displays a 404 error.

Project Meta Implement Viber integration without using third-party CRM systems. All work with messages should be done directly in our internal CRM based on BAS / 1C 8.3.Current System BAS / 1C 8.3 Custom configuration "Customer Service" Database of over 40,000 subscribersRequired Implementation Integration through an official Viber Business provider (TurboSMS, GMS Worldwide, or another agreed service). The button "Write to Viber" in the subscriber card. Sending messages directly from BAS. Receiving incoming messages via Webhook. Automatic linking of messages to the subscriber by phone number. Complete preservation of correspondence history in the subscriber card. Displaying the time, message status, and the manager who responded. Simultaneous work of multiple managers. Message templates for quick responses. Assistance with setting up the Viber provider, API keys, and Webhook. Transfer of all source code and settings after the work is completed.Acceptance Conditions The work is considered completed after successful testing of all functions on the working database and transfer of the source code.Guarantee 1 month warranty for fixing bugs related to the implemented functionality. Further modifications are carried out by separate agreement.Result After the project is completed, managers should be able to fully work with Viber directly in BAS: write to clients, receive responses, view correspondence history, and communicate without using third-party CRMs. All source code, modifications, API keys, and settings will be transferred to the client after the project is completed.

It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for verification and correction: 1. Products subject to repair – assignment of a mark Result: Number of records discrepancies Correction script 2. List of Categories, Groups, Subgroups – comparison with the tmp table Result: Number of records discrepancies Correction script 3. Number of products in category. Groups, subgroups. (statistics) – Comparison by table, identification of discrepancies Result: Number of records discrepancies Correction script 4. List of spare parts in the system with category, group, subgroup - Comparison by table, identification of discrepancies, elimination of discrepancies Number of records discrepancies Correction script 5. Repair items related to spare parts - Comparison by table, identification of discrepancies, elimination of discrepancies Discrepancy table Correction script 6. Reconciliation of balances and SN Discrepancy table

Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are hardly used, and documents currently rather "pull" information into Airtable, although ideally Airtable should become the source of truth and generate the necessary operational artifacts. What is needed is not just help with forms or automations, but structural work: analyzing the current logic, designing a relational schema, creating a clean new database/instance, documentation, and recommendations for migrating to the new schema. And potentially even implementation. System context: There are two main directions: Feedback system A system for collecting and processing signals from external advisors, focus groups, internal teams, and stakeholders. It should support: signal log; advisor tracking; feedback intake; synthesis dashboard; status/gates/recommendations; close-the-loop logic. Product catalog The product catalog currently has about 400 entries, approximately 100 of which are active/live. It is necessary to better structure products, statuses, relationships, data sources, lifecycle/gate logic, and reporting. Current state: Airtable already exists and is used by the team. The current data accuracy is about 80%. The schema is mostly flat, not relational. Only the first few tables/tabs are actively used: Some validation gates, tasks/decisions, and dashboard views are currently hardly used. There is no PII. Any work with the live base must be done with maximum caution: no changes in production without agreement. The ideal approach is to analyze the structure and build a new clean base separately in Sandbox. What needs to be done: Phase 1 — Audit & architecture recommendation Look at the current structure of Airtable. Determine which tables/fields/views are actually needed, which are duplicated, which can be merged or removed. Propose a relational data model. Describe the main entities, relationships, primary keys, linked records, lookup/rollup logic. Propose a clean schema for the Project + Product catalog. Determine which dashboards/interfaces are needed for different users. Prepare a short architecture memo or schema map. Phase 2 — Build clean Airtable base Create a new clean Airtable base/instance. Set up tables, fields, linked records, views, basic interfaces. Set up basic dashboard/reporting logic. Prepare a migration map: how to transfer data from the old structure to the new one. Document the structure so that the team can maintain it after handover. If necessary, propose an automation strategy, but without excessive complexity. Expected deliverables: Airtable schema map. A new clean Airtable base. Tables + relationships + key fields. Views/interfaces for main users. Migration recommendation. Short documentation for the team. Governance recommendations: who enters data, who approves changes, which fields are mandatory, how to avoid duplication. Optionally: 1 short handoff call / Loom walkthrough. Important security/access rules: No PII. No dangerous tokens or personal integrations. AI/MCP/ChatGPT/Claude cannot be connected to live Airtable. If access to the existing base is needed, it must be read-only or through export/screenshots/structural description. Any records/changes are made only in the new test/clean base, not in live production. Who I am looking for: The ideal candidate has experience in: Airtable base architecture; relational schema design; Airtable interfaces, views, forms, automations; migration/cleanup of messy Airtable bases; product operations / CRM / workflow systems; documentation and handoff. In your response, please indicate: Examples of Airtable bases or systems you have built. Whether you have experience transforming a flat Airtable structure into a relational schema. How you would approach audit → schema design → build. An estimated number of hours for Phase 1. Your hourly rate or fixed-price proposal for the first phase. Whether you are willing to work under an NDA. Work format: It is preferable to start as soon as possible. Initially, a small paid discovery/audit can be done, after which we can move to the full build.

Basketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational content including: Basketball Actions Basketball Breakdowns Basketball Drills Basketball Articles The platform will also include a custom Content Management System (CMS) that allows administrators to manage all website content without requiring developer assistance. The website is intended to be scalable and support future growth, including additional content types, memberships, practice plans, coach accounts, and premium educational products.Main Features1. Public Website The public website will include: Home Page Actions Library Breakdowns Library Drills Library Articles About Page Contact Page Key functionality: Search content Filter content View educational content Watch embedded YouTube videos Browse by categories Mobile responsive design SEO-friendly URLs2. Admin Content Management System The CMS must allow administrators to:Drills Management Add, edit, publish, and delete drills Upload drill diagrams/images Add YouTube videos Manage drill categories Manage drill positions Manage featured drillsActions Management Add, edit, publish, and delete actions Upload diagrams/images Add coaching tips Add related content Manage display orderBreakdowns Management Add, edit, publish, and delete breakdowns Upload thumbnails Add Thinkific course links Manage CTA buttons Manage lesson counts Redirect users to Thinkific coursesArticles Management Add, edit, publish, and delete articles Upload featured images Add YouTube videos Manage featured articlesSEO Management SEO titles SEO descriptions Open Graph images URL slugsThinkific Integration Breakdowns are premium coaching products hosted on Thinkific. The website will act as a marketing and discovery platform. Users should be able to: Browse breakdowns View breakdown details Click "View Breakdown" or "Enroll Now" Be redirected to the appropriate Thinkific course pageDesign Requirements The design style has already been defined with page mockups and detailed requirements. Pages include: Home Actions Breakdowns Drills About Contact The design should be: Modern Clean Professional Mobile responsive Fast loading Coach-focusedDeliverables Please provide:1. Technical Proposal Explain: Frontend technology Backend technology Database technology Authentication approach Hosting recommendation Media storage solution CMS architecture2. Technology Stack Please specify exactly what technologies you plan to use. For example: Frontend: Angular / React / Vue / Next.js Backend: Spring Boot / Node.js / .NET / Laravel / Django Database: PostgreSQL / MySQL / SQL Server / MongoDB Authentication: JWT / OAuth / Session-based Cloud & Hosting: AWS / Azure / Google Cloud / VPS Storage: AWS S3 / Cloudinary / Local StorageImportant Questions for Bidders When submitting a proposal, please answer: What frontend framework will you use? What backend technology will you use? What database will you use? Why do you recommend this technology stack? How will you structure the CMS? How will you implement Thinkific integration? What hosting environment do you recommend? What security measures will you implement? How will you ensure SEO best practices? Can the system scale to support memberships and paid content in the future?Required Experience Developers should have experience with: CMS development Content-heavy websites SEO-friendly development Responsive web design Third-party integrations Database design and architecture Please include examples of similar projects completed.Budget & Timeline Please provide: Estimated project timeline Development phases Testing approach Post-launch support options We are looking for a long-term development partner who can help expand the platform over time.

Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist or team to implement Viber integration without using third-party CRMs (SalesDrive, KeyCRM, etc.).What Needs to Be Implemented1. Viber Integration Connecting Viber via API or a ready-made Viber gateway.2. "Write to Viber" Button Placement of the button: in the subscriber card; in the application card; in the subscriber list (if possible). The manager should be able to start a conversation with the client with one click.3. Conversation History All correspondence should be automatically saved in the subscriber card. It is necessary to see: the date and time of the message; the author of the message; the status of the message.4. Incoming Messages Messages from clients should automatically enter the system and be linked to the corresponding subscriber by phone number.5. Managers' Work It is necessary to support the work of several managers simultaneously. It should display: the responsible manager; the history of correspondence; who exactly responded to the client.6. Message Templates Examples: Application accepted. Engineer has departed. Work completed. Payment reminder. Information about debt.Important Preference will be given to candidates who already have experience: Viber integration; Telegram integration; working with APIs; working with 1C 8.3 / BAS; telephony integration (Asterisk, Binotel, Ringostat, UniTalk, etc.).In your response, please indicate Your experience with similar projects. Examples of implemented integrations. Estimated budget. Estimated timelines. Whether you are ready to further support and refine the system. We are considering a long-term cooperation for the development of the company's internal CRM.

Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always notice messages on the screen. It is necessary to implement different sound signals for different scanning results. Required functionality: Successful scanning and processing in 1C short sound signal. Barcode read by the scanner, but the product is not found in 1C another sound signal (different from successful). Error during warehouse operation incorrect cell; incorrect product; other address warehouse control errors. separate sound signal. Sounds should be played on the TSD via RDP. Preferences: use of WAV files or another reliable playback method; ability to add new types of sound messages in the future; minimal impact on the speed of TSD operation. Please specify in your response: Experience with UT 11 and address warehouses. Have you implemented similar tasks for Zebra TSD or other TSDs. Estimated cost and execution time. How the implementation of sound signals is planned.

Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year.