Sql Projects

SQL database

Using SQLite to store employee sign-in and sign-out logs for the last six months. . It doesn’t require a separate server, and it will efficiently handle hundreds (even thousands) of records per employee without performance issues. Here’s what I’ll implement: 1. Store every sign-in and sign-out action for each employee. 2. Maintain up to 6 months of logs automatically (older entries will be deleted). 3. Allow you to export individual logs to Excel (CSV format) for each employee. 4. Ensure the system remains fast, scalable, and user-friendly for non-technical users.

Vulnerability/API checks/Basic Cyber Audit on website

I’m looking for someone with web security experience to do a basic vulnerability and API exposure check on my website: https://www.mymaternalhub.co.uk This isn’t a high-risk or enterprise-level system, but it will collect personal information, so I want to make sure there are no exposed API endpoints, admin panels, or misconfigurations that could put user data at risk. I’d like you to: Identify any exposed API endpoints Check for open directories or admin pages See if any sensitive files like .env, .git, server-status, etc. are publicly accessible Look for common vulnerabilities (like XSS, CSRF, SQL injection) Scan for subdomains or staging environments I may have forgotten about Check if any secrets, tokens, or API keys are visible in frontend code Review basic security headers and misconfigurations Provide a simple report with what you found and what I should fix Optional but appreciated: if you can recommend or help apply basic fixes like security headers or hardening steps. This should be a non-invasive audit — I don’t want anything aggressive like brute-force attempts or DDoS tests. Just surface-level scanning and light probing using tools like OWASP ZAP, WPScan, Nikto, Nmap, or anything else you're comfortable with.

SQL - Excel Macro

Hi Hope you are well. I have an excel with a Macro that links to SQL and does some calculations using 3 tables of data in SQL and then keeps the data in SQL in a new table. 1. this macro has stopped working due to "ADODB.Recordset" issue. 2. the macro produces monthly account balances from inception to now and I would like to adjust this to be based on a start date and not all of the history. If you believe you can help with these two issues can you please let me know. Many thanks Robert

opportunity

Opencart data migration to Latest Version of NopCommerce

Opencart Version 3.0.3.6 data migration to Latest Version of NopCommerce Please see our Opencart website and a staging website I have created for this migration.. 1 - How long will the migration take and what access would you require.. 2 - How will you make the transfer, what are the steps involved to include the full history of.. Number Of Products - 4580 Number Of Orders - 25233 Number Of Customers - 7353 Number Of Blog Posts - 17 3 - It must contain the SEO data such as the SEO URL, Meta Title, Meta Keywords, and Meta Description & abcProducts . ID , Name , SKU , Short Description , Full Description , Images in Description , Status . Price . Meta Title , Meta Keywords , Meta Description. . Product Image , Additional Images . Quantity , Stock Availability , Manage Stock , Stock Status . Weight , Width , Height , Depth . Related Products , Product Tags . Product Attributes (Name, Values) abcProduct Categories . Name , ID , Description , Status . . URL , Meta Title , Meta Description , Meta Keywords . . Category Images . abcCustomers . ID , First Name , Last Name , Email , Telephone , Customer Group , Newsletter , Passwords , Created Date , Status . . Customer Billing Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone, Fax). . Customer Shipping Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone, Fax). abcOrders . ID , Order Date , Order Status , Custom Order Status , Order Products (Name, SKU, Option, Image) , Product Price , Quantity , SubTotal Price , Discount Price , Tax Price , Shipping Price , Total Price , Order Comments , Order Status History . . Customer Name , Email , Telephone , Billing Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone). . Shipping Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone). --------------------------------------------------------------------------- A - I’ve created a fresh NopCommerce installation specifically for this job. We’ll be transferring all the data to the following staging URL: https://eloquent-merkle.217-154-22-152.plesk.page B - Current Opencart website - TBC once project agreed ------------- Here’s how you may handle it: Export all data (products, orders, customers, blogs) from Opencart, clean and structure it properly. Import it into NopCommerce using its built-in tools or custom SQL scripts where needed. Test everything thoroughly to make sure the data is accurate and displaying correctly. The process is very similar too: exporting data via phpMyAdmin, cleaning/mapping in CSV or Excel, and importing using your own platform tools or your own SQL scripts. You will of course review NopCommerce’s import structure. ------------------------

React native app ongoing project

I need coding assistance with development of a React Native application. Requirements — Knowledge of React Native — Knowledge of technical English for reading tasks and documentation — Experience with REST API integration — Knowledge of SQL and relational databases Nice to have — Knowledge of Tanstack query (React Query) — Knowledge of WatermelonDB ORM I plan to work through a fixed price contract to start with, adding small milestones as needed. Later, if everything is satisfactory, we will switch to an hourly contract. Project starts in about 1 week

Fix bugs to website

Website needs an overhaul - Quality Assurance (QA) - website Tester, and bugs/glitches addressed. Website is built using; How the website is built: Frontend • Frontend (its in "create-react-app" framework) Backend • Nodejs Database • Postgres or MS SQL Option 1 is to fix the existing issues, Option 2: rebuild website - the current frontend and backend structures are poorly designed—for example, the code is unoptimized, the website runs slowly, and the setup is incorrect. A better option may be to rebuild the website entirely, while preserving the existing database and its data. Option 3: duplicate an existing website, which is very similar and adjust page that are appropriate to this website.

REACT NATIVE MOBILE APP

looking for an experienced React Native mobile app developer to build a cross-platform mobile application for both iOS and Android. The app will interface with an SQL Server database to manage user interactions, support requests, health-related updates, and notifications. While AI tools will be leveraged to accelerate development, the app itself will not feature AI-driven functionalities. Key Features 1. User Registration & Login – Secure authentication with multi-factor authentication (if required). 2. Support Requests & Resolution – Users can raise service requests, and administrators will manage responses. 3. Health-Related Requests & Updates – Manual data entry for health-related queries and updates. 4. Interaction Updates – Users can track communications within the app. 5. Push Notifications – Alerts and notifications based on predefined events. 6. Activity Calendar – Publishing, scheduling and reminders for key events. Technology Stack • Frontend: React Native (for cross-platform development) • Backend: Node.js, AWS, SQL Server (for database management) • API Management: REST APIs for smooth data exchange • Security: Secure authentication, encrypted storage, and compliance with industry standards AI-Assisted Development To accelerate development, AI tools will be used for: • Code generation & optimization – AI-assisted React Native component creation. • Automated testing – AI-driven test case generation for quicker bug detection. • UI/UX enhancements – AI-assisted recommendations for better user interface design. • Performance improvements – AI-driven analysis to optimize responsiveness. Ideal Developer Profile • Strong proficiency in React Native for mobile UI/UX design and development. • Experience integrating REST APIs and third-party libraries. • Backend development experience with Node.js, AWS, or similar technologies. • Skilled in SQL Server and optimizing database performance. • Familiarity with AI-assisted development tools to improve efficiency. • Strong debugging, performance optimization, and testing skills. • Availability for regular updates and testing during development. • A full-stack developer who can own both UI and backend logic.

opportunity

REFLEX -Zero-Knowledge Architecture Implementation

DO NOT APPLY IF YOU DONT HAVE RELEX AND SECUITY EXPERIENCE We are seeking a skilled developer to implement a zero-knowledge architecture in our existing Python-based web application built with Reflex. The application currently handles user data, company information, and contact entries, and requires enhanced privacy and security through zero-knowledge principles. ____________________________________________________________________________________ Current System Architecture The application currently uses: Reflex framework for web development SQLModel/SQLAlchemy for database operations Local authentication system Models for UserInfo, AdminUser, CompanyData, and ContactEntry ___________________________________________________________________________________ Technical Requirements Required Skills Strong experience with zero-knowledge protocols and cryptography Proficiency in Python and modern web frameworks Experience with SQL databases and ORMs Understanding of secure key management Knowledge of end-to-end encryption implementation Specific Technologies Zero-knowledge proof systems (e.g., zk-SNARKs or zk-STARKs) Modern encryption libraries Secure key management solutions Database encryption tools Deliverables Detailed technical design document Implementation of zero-knowledge architecture Updated database schema with encryption support Secure API endpoints Documentation for: System architecture Security protocols Key management User guide for encrypted operations

Windows .NET Console App Developer – On-Premise Data Sync Agent

We need a C# developer to build a Windows console-based “On-Premise Agent” that will: • Authenticate to our central API (POST /api/login) via username/password and obtain a Bearer token • Fetch SQL query, field mappings & endpoint URL (GET /api/fetch-query) • Query an on-premises SQL Server and retrieve data • Map SQL fields to the API payload schema • Send data in batches of 1,000 records to POST /api/receive-data • Retry up to 5x on login, fetch-query, SQL execution, and data-send failures • Log every step (timestamped, daily rolling files) and report errors to POST /api/receive-error-data • Be schedulable via Windows Task Scheduler and runnable manually Deliverables: 1. C# console app targeting your chosen .NET runtime (.NET 6 or .NET 4.8) 2. Config file template (appsettings.json) with placeholders 3. Packaged installer (self-contained EXE or MSI with silent-install support) 4. Git repo with clear commits & branching 5. Unit/integration tests (≥70% coverage) 6. README (build, deploy, troubleshoot) To apply, please include: • Links to similar projects or GitHub samples • Your preferred .NET runtime & logging framework • Estimated hours (or fixed price) and hourly rate We’ll share the full API spec and sample SQL schema once you’re shortlisted.

Memebrstack memebership ssytem

We are seeking a skilled developer to build and customize a MemberStack-based membership system. You will design, develop, and implement secure user authentication, role-based access control, subscription management, and payment integrations (Stripe, PayPal, etc.). Responsibilities: Develop a scalable membership platform using MemberStack (or similar tools like Clerk, Supabase Auth, or custom solutions). Implement user roles, permissions, and gated content. Integrate payment gateways (Stripe, PayPal) for subscriptions & one-time payments. Ensure secure authentication (OAuth, SSO, email/password). Optimize performance and database structure (Firestore, MongoDB, or SQL)

UI UX design and implementation

We are looking for a skilled UI UX designer and developer to enhance the design and implementation of a table in our website that uses a SQL database as a source. While the site has a modern and sleek design, we believe that the table needs a refresh to make it more intuitive and visually appealing. We are seeking a developer who can create a modern and sleek design for the table, using icons or other layout techniques to make it easy to understand the results being displayed. Additionally, we require the developer to implement the design effectively. I have attached a screenshot of the table.

SQL Database administrator

Role: Database Administrator Experience: 5 to 7 Years Location: Saket (Delhi) About The Company: At WeCredit, we partner with heading NBFCs to help Customers find the best online financial solutions, including quick and hassle-free loans. Our skilled team provides assistance every step of the way, from Completing your loan documents to ensuring fast disbursal of funds. About the Role: We are seeking a skilled and detail-oriented Database Administrator (DBA) to manage and maintain our company’s databases. The ideal candidate will have extensive experience in database management, performance tuning, and ensuring data integrity and security. As a DBA, you will be responsible for overseeing database systems, ensuring their reliability and performance, and supporting business applications Responsibilities: • Install, configure, and maintain database management systems (DBMS) such as MySQL, SQL Server • Design and implement backup and recovery strategies to safeguard data against loss or corruption. • Manage database security, including user access controls and data encryption, to protect sensitive information. • Diagnose and resolve database issues, including performance problems, corruption, and connectivity issues. • Work closely with developers, system administrators, and other IT staff to support application development and ensure seamless integration. • Apply software updates, patches, and upgrades to database systems as needed. Qualifications: • 5 to 7 Years of experience as a Database Administrator or similar role, with expertise in managing databases and performance tuning. • Proficiency in SQL and experience with DBMS such as MySQL or SQL Server. • Strong analytical and troubleshooting skills with the ability to resolve complex database issues. • Query Optimization. • Internal DB Level.

Power BI Developer

I'm looking for a Power BI developer who can assist me any company on a number of analytics projects over the coming months. This will be predominantly work within Power BI Desktop with a focus on visualisation and measure creation. Data sources are already set-up and fed into the respective reports Requirements will be provided on a project by project basis. The developer will be required to use our remote desktop to carry out the work and also sign an NDA. The developer should be proficient in DAX. Although not necessary, having good SQL skills will also be a huge bonus. Please include examples of previous work or provide some descriptions of the projects you've worked on

opportunity

Full-Stack Developer to enhance our payment processing system

Full-Stack Developer to enhance our payment processing system , Job Responsibilities: 1. Balance and Payment Calculating System Development - Redesign and implement a cloud-based balance calculator that allows for real-time updates and integrates with the Financial Disclosure Statement (FNC). 2. User Input System Creation - Design a user-friendly interface for clients to fill out the FNC and view balance calculator options. 3. Payment Processing Integration - Develop a backend system to generate payment detail forms based on user selections and incorporate electronic signature functionality. 4. API Integration - Integrate payment gateway APIs to automate payment processing and ensure secure handling of payment information in compliance with PCI standards. 5. Recurring Payments Automation - Implement a system for setting up and managing recurring payments with minimal administrative oversight. 6. Client Communication Automation - Create automated email notifications for payment receipts, upcoming payment reminders, and declined payment alerts. 7. Daily Reporting System - Develop a reporting feature to summarize daily transactions, including forms sent, signed, and payments made, ensuring reports are accessible and exportable. 8. Backend Management and Overrides - Design a flexible backend system for easy updates and changes, including a manual override feature for payment approvals. 9. Quality Assurance - Conduct thorough testing to ensure system functionality, usability, and security; address any bugs or issues. Qualifications: - Education: computer science, Software Engineering, or a related field. - Experience: - Proven experience in full-stack development. - Familiarity with payment processing systems and APIs (e.g., Centz, Stripe, PayPal). - Experience with cloud-based applications and database management. - Technical Skills: - Proficiency in programming languages such as JavaScript, Python, Ruby, or PHP. - Familiarity with front-end frameworks (React, Angular, Vue.js). - Experience with database management systems (SQL, NoSQL). - Soft Skills: - Strong problem-solving abilities and attention to detail. - Excellent communication and collaboration skills. - Ability to manage multiple tasks effectively. Desired Attributes: - Proactive approach to identifying and addressing issues. - Flexibility to adapt to changing requirements. - Commitment to delivering high-quality work.

Full stack developer for regular work

Proficiency in JavaScript/TypeScript. Hands-on experience with front-end frameworks such as React. Experience with backend technologies like Node.js, Express, NestJS, or similar frameworks. Familiarity with SQL databases such as PostgreSQL or MySQL. Strong problem-solving skills and the ability to understand client issues. Experience with RESTful APIs and third-party integrations. Knowledge of version control systems like Git. Strong debugging and troubleshooting skills. Ability to work both independently and in a team environment.