Sql query builder open source jobs
We are seeking an experienced full-stack Developer to join our dynamic team. The ideal candidate should have a minimum of 8 years of hands-on experience in JavaScript and a strong proficiency in the following technologies: NWJS, NodeJS (backend) JS, TypeScript, HTML, CSS, JQuery, MYSQL, WordPress, and AWS. The candidate should possess excellent communication skills, both written and verbal, and be capable of working with minimal supervision. Responsibilities: -- Develop and maintain robust and scalable SaaS and desktop applications using NWJS, NodeJS, JavaScript, TypeScript, HTML, CSS, and JQuery. -- Ensure the technical feasibility of UI/UX designs and implement them accordingly. -- Work with MYSQL databases to handle data storage, retrieval, and manipulation. -- Utilize AWS services fo...
Looking for help with sheets set up, one must know import range, query features, can write custom scripts codes etc. Someone creative in how to get the things done. Will pay well.
Avem un site realizat custom in opencart 2.3. de cineva. dorim o colaborare cu un programator care sa ne implementeze journal 3.
Hello, I want to create my own website for coupons linked to my application with good features
...history, preferences, and behavior history. Experience in efficient data handling and privacy management is required. App in flutter with google maps main objective is to update the customer's data or register a new one and schedule the daily route for the seller. What you generate daily will serve to make this information ready for your attention for delivery the next day and you must connect to db sql server /csv /excel of clients to edit or record data and purchase history this at the time of working with the Google API but to automatically obtain latitude and longitude the supervisor at the end will be able to see the map with all the clients served On the day in them you will know how many are recurring and new. It has a web side where you can import and export the inf...
I am seeking a skilled WordPress programmer to incorporate a custom search feature on my website. The functionality should include: - The ability to filter results: Users should be able to narrow down their search based on specific criteria. - Auto-complete suggestions: As users start typing, relevant suggestions should automatically populate to enhance usability. The search func...results: Users should be able to narrow down their search based on specific criteria. - Auto-complete suggestions: As users start typing, relevant suggestions should automatically populate to enhance usability. The search functionality should be restricted to post titles and contents only. Only developers with prior experience in custom WordPress search features should bid. Proven expertise in PHP, SQL...
I'm currently in need of assistance with a MySQL query task; specifically how to make use of a subquery in order to yield accurate results in a Select statement. The main purpose here is to fetch data. **** All SQL files are attached to the files for this project. What I am Seeking: Help with the attached query. The query joins two tables. A header and details table. The intent of the subquery in this statement is to find/match a SINGLE "Invoice Date" value in the inv_details table that matches a "PO Date" from the po_details table in the subquery using the main queries currently matching "item" , "ship to city" and "customer name". Using "distinct" in the subquery generates an error (subquery...
I need an expert in PowerBI who is capable of connecting to Excel spreadsheets and SQL databases to create a visually engaging and vibrant dashboard. This dashboard will need to provide: - Detailed analysis of sales performance, enabling a clear understanding of the areas that are working well and those that need improvement. - Thorough customer segmentation that provides deep insights into our customer base to improve marketing effectiveness. - Comprehensive trend analysis that identifies patterns over time to assist in strategic decision making. Ideal candidates should have a strong background in PowerBI dashboard creation and data analysis, as well as a good eye for vibrant and colorful design that can help to bring the data to life.
...wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Improve angular.js performance then work on transforming angular.js to 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term
Come do interesting GIS programing in a database. *** Please no AI responses. *** Experience with snowflake and other big data a plus. Able to advise and write. Able to work TODAY. Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map developm...
...delete, and route DIDs within the system. Call Feature Configuration: Enable/disable call recording for specific numbers, and set/modify caller IDs. CDR Synchronization: Develop a mechanism to synchronize Call Detail Records (CDR) from FreeSWITCH to a SQL-based application. API Security: Implement robust authentication and authorization for the API to ensure secure access. Requirements: Expertise in ASP.NET for API development, with a strong background in RESTful API principles. Experience with MariaDB, including schema design, and proficient in SQL for database manipulation and management. Familiarity with FusionPBX and FreeSWITCH internals, including database schema and ESL (Event Socket Library). Knowledge of telephony systems and VoIP technologies, specifically related...
...wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Improve angular.js performance then work on transforming angular.js to 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term
I am seeking a freelancer to create a simple webhook for WhatsApp in C# , all wrapped in a neat project source code. This will be hosted on a Windows Server. The main functionality that I'm seeking is for the webhook to receive messages through WhatsApp. This must be developed to the standards of secure and efficient data handling. Ideal candidate would be someone with: - Proficiency in C# - Experience in webhooks development - Familiarity with Windows Server environment - Understanding of WhatsApp API integration. Please detail your experience with these languages and systems when applying.
I'm looking for a skilled developer to create a straightforward system that allows me to input data into a custom database and generate detailed reports at the end of each day. Key Elements to Include: • Space for twelve specific data fields: Name, Locality (dropdown), Call (checkbox), Time (timefield), No Determination (checkbox), Number of People (numeric field), Type of People (dropdown), OWI (Yes/No dropdown), and Remarks (free text) • The 'Locality' dropdown should contain various location options, to be provided. • The 'Type of People' dropdown should include three options: Adult, Child, and Mixed. • At the end of each day, the system should auto-generate a PDF report from the daily entries. Ideal Project Completion Time: • As soon...
...like Digital Ocean, ensuring high availability and scalability. - Manage databases using SQL, Postgres, and MongoDB, ensuring data integrity and efficiency. - Work with JSON for data interchange and leverage Pandas for data analysis and manipulation. - Conduct web scraping using Scrapy, Requests, Httpx, and implement automation with Selenium for browser tasks. - Utilize Redis and Celery for background task processing and message queueing to enhance application performance. Qualifications: - Proven experience as a Python Developer, with a strong portfolio of projects. - Proficient in Django, Flask, JavaScript, React JS, Axios, Docker, and cloud deployment (Digital Ocean preferred). - Experience with SQL, Postgres, MongoDB, JSON, Pandas, and web scraping tools (Scrapy, Requ...
I am looking for a proficient coder able to acquire the source code for the games depicted in the pictures I provided. No specific programming language has been selected for this project; hence, the freelancer is free to work with what they find most comfortable while ensuring optimal results. If you have: • A background in game coding and development • Familiarity with a variety of programming languages • Proven experience in acquiring game source codes Then, this job is for you. Please note that the method of game implementation is open for discussion since I haven't made a firm decision on that. A freelancer confident in approaches like HTML5/JavaScript, Unity, or Unreal Engine will have an advantage in this project. Your input on this aspe...
I want the source code for the games in the pictures or similar games for a Live Stream program
I'm seeking a highly skilled PHP and Laravel developer for back-end development for my project. The primary responsibilities of the right candidate will majorly involve: - Setting up the server-side lo...efficient, fast and robust code. Although not specified, it would be an advantage if the developer has experience or is comfortable with: - Implementing a user authentication system. - Payment integration. - Developing a data analytics feature. The timeline for project completion hasn't been determined yet, but we will discuss this during the hiring phase. Strong command over PHP, Laravel, SQL and knowledge of AngularJS will be preferred. Prior experience in server-side templating languages and authentication and authorization between systems, servers and environm...
'DB query failed: SQLSTATE[HY000] [2002] No such file or directory'. Mariadb stopped - I need someone who knows about mariadb and plesk
we are looking for a senior PHP developer with a minimum of 16-20 years of experience Skills and Experience MUST HAVE: - 16-20+ years of PHP development experience. - Proficient in Laravel framework. - Experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - implementing new features , for enhancement of the platform, - must be an INDEPENDENT developer, not an agency! ********** - must be able to work on GITHUB - MUST be able to change FIGMA design to HTML and implement php pages from it. - lastly making sure platform is mobile responsive Must be knowleadble in updating designs as well when needed. DO NOT BID if you are an agency, if you are a marketing person or project manager. We will only give the project to the independent freelance...
I am looking for a freelancer to create a basic five-page secured WordPress website for a business. You can use elementor or any other theme builder. I have the majority of pages, text and photos ready to go. Create it on your own server and then upload it to mine when finished or any other way you like. This is pretty much a five page job with nothing else such as SEO required.
...video producer to create a 1-2 minute promotional video for our new website, a dedicated funeral/memorial website builder. This video should serve as a compelling introduction to our services, highlighting the ease of use, customization options, and the emotional value we offer to our users during their times of need. Key Project Requirements: Length of Video: The final video should be between 1 to 2 minutes long. Script: A script has already been prepared and will be provided. The video must adhere closely to the provided script with imagery that matches the narration. Voice-over: The video must include a high-quality voice-over by a female American English voice. We are open to the use of AI voices, particularly Nova or Shimmer AI voices from OpenAI’s text-to-spee...
...equipped for long hours of work. • Customer Station: An easily-accessible area for customer service, ensuring interaction with customers is smooth and professional. • Packing Station: This station should feature a durable packing table and a dedicated spot for a printing station. Must be functional and well-organized to support all packaging operations. Open Concept Structure: Pertaining to the overall layout, I'm looking for an open concept design. This should foster a collaborative and interactive environment while still offering a level of privacy for individual work. Skill Set of Ideal Candidate: The ideal freelancer for this project should have a proven track record in interior design with specific focus on office layout design. They should have a ...
...how to create/edit/customize drip campaigns, email sequences, and triggered emails. Klaviyo has some templates included for various Flows and Sequences. They have generic info in these. I would need you to be able to go in and customize them and add our own images to the templates. Also I need you to understand how to create these types of things from scratch. Klaviyo has a drag and drop builder to create new email flows. Analyze Email Analytics: Segment the audience based on actions, create new emails for specific audiences, analyze click thru rates, and conversions. I have attached a few that I found on the internet that I like. Can you produce a similar quality? Please submit images of emails you have designed. I am looking for someone that will be able to create a ...
I'm looking for an experienced API developer to construct a website builder API with specific functionalities. Here are the tasks you'll need to perform: - User Notifications via WhatsAPP The API developed should be capable of integrating with WhatsApp to send Text Notifications. Ideal skills: - API development - WhatsApp API Integration Experience in the above mentioned areas is extremely desirable.
I'm seeking a skilled data analyst to help with tasks including data cleaning and preprocessing, data visualization and reporting, and statistical analysis. The data they will be working with is of medium size, ranging between 1GB to 10GB. Prior experience with Python, SQL, and Excel is crucial for this project. Specifically, proficiency with the Python libraries Pandas and Matplotlib is required for the analytics components of the work. This project requires both strong technical skills and a thorough understanding of data analysis methodologies.
...are seeking a skilled .NET Full Stack Developer to build our website on a contract basis. Responsibilities: • Design and develop our website using ASP.NET, WEB API, Develop user-friendly interfaces using HTML, CSS, and Bootstrap • Implement front-end functionality using a JavaScript framework like Angular or React (familiarity with either is preferred) • Experience with relational databases like SQL Server or Oracle is a plus Qualifications: • Proven experience as a .NET Full Stack Developer • Strong understanding of ASP.NET, NET Core, ASP.NET Web API, HTML, CSS, Bootstrap, and a JavaScript framework (Angular or React) • Experience working with relational databases is a plus This is a contract position, not a full-time or part-time role. To Apply:...
I'm in need of a proficient app developer who can create an application for both iOS and Android platfor...additional feature of exporting the data to an Excel format. Key aspects of the project: - App development for both Android and iOS - Data entry allows manual input by users - Front-end display to present the data inputted - Functionality to export the entered data to Excel The ideal candidate should have robust experience in cross-platform app development, with expertise in .NET, C#, and SQL Server Database. Strong skills in UI/UX design are also preferred to create an intuitive and user-friendly interface. Understanding the requirement of manual input and Excel exportation is crucial for this development job. If you feel this brief fits your capability, please ...
...the new logo to portray an air of elegance complimented by a sense of luxury. Our work is high-end and our logo should reflect our dedication to top-tier quality. There's no specific color palette or shapes dominating my vision for this logo, so I'm completely open to your creative interpretation. When you're crafting your masterpiece, bear in mind that this is for an established business in the luxury design-build construction sector, so our logo must convey our professionalism, credibility, and class. If you look at PERRONE builder in Sarasota Florida - I want to appear more like his classy logo but his is too light - you can’t see it well from the road. Here's what I'm looking for in a freelancer: 1. Proven experience in logo design, pr...
I am seeking an experienced Shopify developer for the creation of a robust online store to both sell and exhibit a collection of products. The targeted demographic for this store is, specifically those aged 18 to 65. Key Job Requirements: - Expertise in Shopify store setting up and design - Mastery of minimalist and clean aesthetic as per project needs. - Full understanding and able to target young adults, tailoring the site to their specific preferences and buying behaviors. -Setting up payment integration so I can take mobile payments -Getting shopify to approve instant payouts to my bank Smooth flawless setup integration and success Ideal Candidate: - Previous experience designing and building Shopify stores - Strong grasp of current design principles, can provide a portfolio showc...
...updates: This is the heart of this project. The application needs to furnish real-time price updates every 5 seconds (user configurable) - API Integration: Price data will be expected to be sourced from a reliable API. - User will provide mandatory fields you need to call APIs ( contract-address, chain-id). - Most APIs have a rate limit of something like 120 calls/minute so you need to bundle and query multiple crypto into a single call. Most APIs allow upto 30 to be bundled in one call. - There can be any number of cryptocurrencies to track, anywhere from 10 to 10,000 - so it'd be important to bundle calls to respect the rate limit. Ideal Skills: - Experience with cryptocurrency API integrations (such as GeckoTerminal API, DexScreenerAPI, DexView API - any of those three)...
I am in urgent need of an experienced full stack developer to take on the development of a web application. This individual needs to be adept at handling all aspects of development, from frontend to backend, and even database management. The task requires profici...stack developer to take on the development of a web application. This individual needs to be adept at handling all aspects of development, from frontend to backend, and even database management. The task requires proficiency in the following: - Backend development, - Frontend development, - Database management Skills and Experience: - Excellent command over HTML/CSS - Adequate knowledge of SQL - Strong background in TypeScript The main objective of the project is the development of a unique and efficient web ap...
I'm looking for a skilled freelancer who can help me with a unique requirement. The main objective is to create a code that will: - Load multiple CSV files into one SQL database. - Furthermore, the code needs to delete all duplicate data in the database. I left a few crucial questions unanswered. - First, the ideal programming language for this code is not specified, therefore I'm open to Python, Java, PHP, or whichever language you believe would be most appropriate for the task. - Second, the location of the CSV files was also left unspecified, meaning they could be located in a specific folder or scattered in different locations. Your solution should be prepared to handle either situation. - Lastly, the code's handling of duplicate data was left undeterm...
...feedback, and ensure adherence to best practices. Troubleshoot and debug issues as they arise, ensuring timely resolution. Stay up-to-date with emerging technologies and trends in software development. Qualifications: 2- 5 years of experience in full stack development, with a strong portfolio showcasing past projects. Proficiency in programming languages such as JavaScript, Python, HTML/CSS, and SQL. Extensive experience with frameworks and libraries such as React, Angular, Node.js, Flask, Django, etc. Strong understanding of databases and data modeling concepts. Demonstrated expertise in AI and ML, including experience with frameworks like TensorFlow, PyTorch, or scikit-learn. Excellent collaboration and communication skills, with the ability to work effectively in a team envi...
I'm on the hunt for a professional who can develop an automated system designed to fill up and send queries to a particular website every time new offers are posted. Care to rise to the challenge? What I'm looking for: - Development of a straightforward automation that can fill up and forward queries automatically to a website when new offers are posted daily. - I'm open to innovative ideas and methods to achieve the expected results. What you need to be successful: - Experience in automation development Note: Specifics regarding the website to be targeted will be shared with the chosen freelancer. So, if you can build this kind of system quickly and efficiently, I want to hear from you! Let's chat about how you can help me automate and streamline this proc...
I'm in need of a SQL engineer with specialization in query optimization and extensive knowledge of MySQL. The project will involve fine tuning basic single-table queries for better performance in MySQL database. Ideal skills and experience include: - Expertise in MySQL database management - Proficiency in SQL query optimization - Ability to troubleshoot and debug errors Your responsibility would be to collaboratively review the existing database structure, and optimize the SQL queries in order to improve the performance, reduce the run time and the load on the server. This task requires clear understanding of SQL code, MySQL database design principles and industry best-practices. With your technical expertise, I'm looking forward to ma...
I am seeking a proficient PHP programmer for the addition of functions to an existing script. The ideal candidate will have expertise in: - PHP programming - Front-end development (HTML, Javascript) - Back-end development - Database integration (SQL) The main purpose of this project is to build upon and enhance our pre-existing system. Your role will be essential in introducing new functionalities to improve our script. Please only apply if you have extensive experience in these areas. I look forward to potentially working together.
...relationships to pair with the business requirements documentation (BRD). • Familiarity with data quality issues and Exact, Transform, Load (ETL) processes • Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). • Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. • Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques • Proven skills in data analysis – including queries to calculate data quality. • Solid written, verbal, and analytical skills • St...
Priority given to what has been done
I'm on the lookout for an adept .NET developer with a strong background in jQuery and SQL server. The end goal is to construct an efficient hospitality software. This is an urgent position, ideally located in Nagpur. Primary Requirements: - System development using .NET and jQuery. - Thorough understanding of SQL server operation. Key Features: - Capable of handling billing and invoicing. - Inventory management capability. Ideal candidates would have considerable experience managing comparable projects and deriving software solutions in the hospitality industry. Proven proficiency in .NET, jQuery, and SQL server is crucial to this role. Your proficiency will be key in delivering a quality solution that aligns with our objectives.
I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table I have column named ...
I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table I have column named ...
... - Giving Information on how to give tithes and offerings. Online giving options, if available. - Contact Page Comprehensive contact details, including address, phone number, and email. An embedded map showing the church’s location. A contact form for inquiries. Page Requirements: - The website should consist of between 5 to 10 pages - The website will be built using the GoHighLevel Website Builder Design Vision: - I envision a modern and clean-design elegant template. The website should be user friendly and have ease of navigation. Great emphasis is to be paid to the aesthetic value of the site while keeping simplicity in sight. Ideal Skills: - Experience in Website Design and Development - Understanding of modern design principles - Experience in creating large scale ...
I'm looking for a solution whereby PDFs open in Google Drive when clicked on. I am currently getting an error message "Couldn't Preview File. This file is empty." Other PDFs I already have on there open just fine but not the new ones I dropped into a folder.
...minute promotional video for my new website. I already have the script created, I just need you to create the video along with the voice over and background music. I’ll give you access to my website along with the script and I need you to create the video. You are free to use an AI voice for this, as long as it’s a good female American English voice. My website is funeral/memorial website builder and I’ll grant you access to the site to make the video. The video must include images and video of my actual website similar to the sample videos below. If you need stock music or footage for the video that you are creating, I have a account, so all you have to do is send me the links and I’ll download them and send them to you. If you decide to use ...
My query below doesnt work i need AS order_total BUT ONLY WHEN = 'ot_total' and i also need AS shipping_method BUT ONLY WHEN = 'ot_shipping' my strategy below failed as it seems i can only use the condition in the normal WHERE clause near the bottom i.e WHERE o.orders_status = s.orders_status_id AND s.language_id = '1' AND = 'ot_total' however this means will return data for the ot_total class but i want it for the ot_shipping class im simply trying to add 2 conditions 1. return AS order_total for the = 'ot_total' 2. return AS shipping_method for the = 'ot_shipping' i dont want for = 'ot_total' so help me ? is this not possible or do i have to execute a completely sepearate
Quote for We are done job on this chat: https://www.freelancer.com/projects/php/Menu-query-fix We are fix li tags and fix colors .
