Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
Sr. Java Developer – specialising in Programming or Implementation MUST have exp in Sapiens – IDIT Remote • 5+ years of experience in Java technologies. • Worked on Core JAVA, EJB (Enterprise Java Beans), Web services (REST and SOAP), JSP, HTML and Servlets. • Worked on databases like MSSQL, SQL. • Sound knowledge of Object-Oriented Programming (OOP) Patterns and Concepts. • Familiarity with different designs and architectural patterns. • Skill for writing reusable Java libraries. • Understanding of the concepts of MVC (Model-View-Controller) Pattern, JDBC (Java Database Connectivity), and RESTful web services. • Abil...
OpenNMS Horizon 31 running in Ubuntu 22.04 Microsoft SQL 2022 running in Windows Server 2016 We want to monitor SQL server's performance e.g. Processor Time, Waiting Tasks, Database I/O,Batch Requests We can provide anydesk for you to remote config the systems.
I am having a old client server project that was developed in Visual Basic 6. It connects to windows server via winsock to receive live OHCL quotes . It uses asp.net to receive historical data from server stored in Ms sql server. The tables of the sql server were deleted . We need help to run the project and make it working. No new code to be done. Only the old running condition to be established. Sample code of the form having winsock and historical data calling is attached along with the aspx file that used to fetch the historical data from server
Looking for Remote - Power BI Developer - Full time Contract Experience - 10-12 years Job Description: Power BI Dashboards(MOQ, Retail, Camp Master, P&L), • Yardi Orion BI Dashboards(on SQL DB) • MOQ – POS Connectivity for New Tenants on .NET based Program. • Other Automation Programmes Support to the RPA Specialists Must Haves • Advance SQL query writer, tsql, ddl,dml • Power bi , DAX ability, • API read and write information, (postman, etc) • Basic C#, Python read and understandable
Please Sign Up or Login to see details.
We need a Python script to extract data from YouTube by performing searches ...would be needed 7. Save the extracted information into an output file. 8. Repeat the process for the next country in the list, until all countries are complete. Requirements for this task include: • Proficiency in Python programming • Experience with web scraping and working with APIs • Familiarity with YouTube API and Google Translate API • Knowledge of data storage solutions such as CSV, JSON, or SQL databases • Strong problem-solving skills and attention to detail The script should be thoroughly tested to ensure its accuracy and reliability. Additionally, the code should be well-documented, and instructions on how to use the script should be provided we have included the samp...
...it on a virtual machine on LAN accessed through VPN. I am reasonably skilled with MS SQL and Python as an engineer, but dont have much clue on other web technologies. Features required: - Home page with user login page. Allow users to create login id/passwords. However i must be able to approve this. Alternatively I can modify a user database directly myself. - Once user logs in allow user to create/modify/delete a new project. -Inside a project they can add equipment with test equipment template. -Once added, they can record the test results. - Allow to send the results over email by creating a .pdf similar to the word document samples attached. Additional Notes: - Database must be in Microsoft SQL (Express Edition is fine). - Python to be used in back-end preferred...
I am looking for a React Native/Typescript/Watermelon DB/MySQL expert to help with bug fixing on a large codebase. On setting up remote DB something is wrong with Watermelon DB. The successful applicant will possess great problem-solving skills and the ability to work efficiently to meet deadlines. If you are experienced in the required fields please submit a bid and I look forward to your response.
Hi, We are a sofware company that have a desktop applicaton similar to a CRM tool, which mainly does invoices and stock reports. This software it's been in the marked for 20 years, and we have reviewed the report layout few times, but we are not getting the fine touch in the design that we would like. I'm not looking to a sql / query expert, we are looking specifically somebody that can change the look and feel of the reports to something more according to modern days. Ideally we will need a template that we can use for the color pallet and the lines. Attached some samples of reports that we have currently to get an idea. Thank you.
I need to move data around from an existing database into other databases and api sources
I am looking for someone to help me with a project involving sql (Structured Query Language). I don't need help writing a query, but I don't have an existing database nor do I have the structure set up. I also do not need help creating stored procedures. The project does not involve any of these tasks. I simply need somebody to help me with sql for a particular project.
We have a stored procedure which is parsing a XML file and inserting and updating a table with more than 25 column which is already having more than 4 lakh record, Procedure is doing its job but it is taking approx. 900ms to just insert or update few records which is too much as large no of records need to be updated, we need an expert who can optimize this procedure to complete the task.
I'm looking for someone to help me fix some coding issues with my brand new Wordpress site, which is a side-project from my main business. Specifically, I need help with PHP, SQL, and/or Python (I think). I'm not a coder, but run a tech company, so I'm not a novice either. I've already imported the sql db, but haven't managed to get it working on my site which is in very early development. I think I'm nearly there, but I'm stuck on getting the search and browse functions to return the actual data. I think it's a matter of getting the right table heading names on the right pages and/or in scripts, but I'm just not clued up enough to work out what might be obvious to you. I am looking for an experienced professional who can provide...
I'm looking to hire a freelancer who can help me with Oracle SQL Query Tuning and improve Oracle Performance. I will be using Oracle Exadata Database and therefore the successful freelancer should have prior experience working with these versions. The specific work required is Ad-hoc Query Tuning so the applicant should include relevant past work and experiences as part of their application. Detailed project proposals are also appreciated. Scenario: 4 Oracle SQL Queries that we have taking time anywhere from 3-7 minutes and wanted these to be running in less than 30 seconds. So require some one with Oracle SQL Performance Tuning Expertise to rewrite the query or Add any DB Configuration or Indexes or other Performance enhancement tips to cut that runtime down to ...
Skills Required: - VBA - SQL - Any automation skills preferred! (python, google apps scripts) Deliverables: - develop an excel reporting solution that connects to our data warehouse and updates a set of charts and tables that we will work together to design. - we need to be able to automatically generate copies of this report for delivery to multiple clients, where the only difference is the data table connection (within the same database). Scope: - initially, we will develop 1-2 reports for a trial period. following that period we have up to ~30 excel templates that will need development, and may have additional opportunities for adjacent automation development work. When applying: If possible, please include an example excel report that you have developed in VBA that would allo...
We are looking for development experts, with the following requirements to join out team, - Proficient with .NET Core,Web API, Angular Material, MS Sql Server - Should be ready to complete the task in stipulated time - Should have minimum of 5 years hardcore development experience in these technologies required.
Deliverables: Query resolution - finding cause of failed reports and fixing them. Prerequisites: Understanding of the Database and Reports. Temporary access to the platform and it's elements.
I'm looking for someone to provide a solution for a database conversion from SQL to Oracle. I do not currently have an Oracle database in place, so this project requires creating a new database and transferring the existing data from SQL to Oracle. More specifically, I need the structured data to be migrated. The ideal freelancer will have experience with database management and be familiar with both SQL and Oracle databases. If you think you are the right fit for this project, please submit a bid outlining your qualifications and experience.
I would like a clean installation through the release files. I've considered some of the installer packages but would like a clean installation. The installer packages use mySQL as a back-end which I don't want. I've attempted the install and ran into incompatibility issues with certain gems through Ruby on Rails. I would ideally like a walkthrough on it. Where i can replicate the steps. Instructions here but I think I'm using the latest gems, ruby and ruby on rails:
Hi, I've already got a unfinished project that includes web CRM and iOS + Android apps developed using flutter. Need someone who can quickly finish the project for me. Code for web and both apps and sql file is here: Please need someone reliable and experience enough to finish the project quickly (within days).
Person should have experience in Java 11 AWS - lambda, S3, Postgres SQL, IAM Lambda should be written in Java 11 corretto.
Hi, please read my requirement carefully and bid on my project only 5+ year experienced candidate in ASP.Net core, MS SQL Server. Requirement: 1) Tax Regime Form, Tax definition form for GST Setup and a Item Tax class form 2) Develop a procedure at backend which can be called to apply accounting (accounting double entry fession): 3) Develop a price list form: description - Price list form should have two major sections ( A: Master- in which we will declare price list header level details like Price List short Name, Description, Start Date, End Date, Enabled Flag, Global Discount etc. B: Detail- Here will assign all types of items (Goods and Service Type item), Rate, Start date, End Date, discount etc. 4) Integrate this new price list form with existing sales and purcha...
modifying store procedure on sql server
by exident I reinstalled my forum. I have the SQL database with all categories ect. Can someonme help me fix it ?? to inplent again!!
Scanner Iphone Barcode project by using Mobile IPhone with visual studio 2019 Xamarin Form C# only Goal : Scan Barcode result to Sql server Database table step 1. simulate on desk computer under windows 10 pro,Iphone step 2. produce Barcode list table(i will support) step 3. Submit data go to Database step 4. Put application to Iphone to install Tools : Sql server Database , 2019 visual studio with Xamarin Form with c# ,SQL and so on
Sql server database backup job position We need a responsible hard worker that delivers results in a timely manner and that respects time estimates and pre agreed goals. A remote job cannot work properly without time / results discipline. Able to work remotely and independently making changes visible worldwide for peers from all over the world. Need to be free from other projects / family issues at least 10 hours a week. A few hours every week day to not miss with responsabilities. End of the week chat or live call required to keep up the project and avoid time lapses of no improves. New backend loader responsabilities: Backup DBs. And upload them if needed Install software in new servers. Able to install LAMP or equivalent smoothly. General mantainance of site's versions Upd...
import table from sql server to lists, attach file from local folder import just files folders from local folder. it will include sub folders testing using developer account
Job Description:...applications for maximum speed and scalability Stay up-to-date with emerging trends and technologies in web development Requirements: At least 3 years of professional experience as a full-stack developer Strong experience with modern front-end frameworks such as React or Angular Experience with server-side languages such as Node.js or Python Solid understanding of databases and experience working with SQL and NoSQL databases Experience with version control systems such as Git Strong problem-solving and communication skills Ability to work independently and as part of a team Nice to have: Experience with cloud platforms such as AWS or Google Cloud Knowledge of DevOps practices and tools such as Docker and Kubernetes Experience with testing frameworks such as Jest...
There are 2 very simple math questions for university study. We are looking for an expert who will solve these questions in a flexible way and with rational mathematical thinking using object oriented concepts. For the 2 questions he solved, he should create a readme file describing all classes and functions.
I am looking for an experienced .Net MVC with SQL server developer to make modifications to an existing project of mine. The project requires modifying the functionality of the codebase, which is written using ASP.NET MVC with MS Sql server. I have an existing codebase that needs to be edited. The developer must be proficient in the development of MVC applications, be able to code quickly, and deliver the project within a week. Please note- Developer need to work full time with us for one week and complete the development work as per our requirement. Let me know if you have any questions or if you are available for the assignment. Thanks for your interest!
Hi, We are looking for expert who could help us get data on existing report in SQL server reporting services & microsoft report builder, 2 reports are currently not returning data suddenly everything is intact, we are using SQL server 2016. SQL query in dataset is not returning data as of now. connection string / some connection dataset or queries needs to be checked. There is a table created by our team in SQL 2016. We need help in getting the data from database.
i need someone who is good at ERD, 3NF, Data dictionary, SQL scripts use of ER modelling
We are looking for a passionate Software Engineer to design, develop and install software solutions. Your creativity, skills, and leadership will shape the development of energy asset optimization solutions. Please complete th...developing technologies to support the adoption of new products and technologies. Our Requirements Bachelors in computer science, or related software engineering discipline or equivalent. 2+ years of professional software development experience. Experience working with C#, C++ on optimization algorithms, parallelism. Experience with web and app development a plus. Experience in database (primarily SQL) architecture design, optimization, and querying. Strong problem-solving ability and analytics skills. Strong work ethic with a desire to grow knowledge inde...
I need a good sql server programmer to be my right hand man , I have multiple projects small and big .I just need someone that knows SQL not bid if you haven't read the description ,you will be denied
I am looking for an experienced Oracle SQL and Python expert who is comfortable working at an intermediate level. The ideal candidate should have experience in a similar position, and should be able to demonstrate their ability to fulfill this role. The deliverables of the project will be SQL scripts that are built to accomplish a specific goal. This can involve automation of existing databases, as well as writing and improving existing ones. The successful freelancer will also be expected to perform data analysis and create reports from the results. For consideration, please include relevant experience, detailed project proposals and also past work in your application.
I need 19 existing SQLite .db files converted and imported into microsoft SQL server. Each file contains rows of one table. There are a total of 8 million rows of data split into 19 files. A sql server database already exists and the files are all being imported into a new table in that database. I need this today today please. I will send you the files (around 20gb) and you would then connect with my pc (anydesk) after converting and import into my existing sql server db which is on my local pc.
...currently, I'm doing validation using simple HTML, but I want the validation to be done using Jquery, like minimum length requirements and all should be there, I do have the written code for the same but it is not working I do not know why. As it is a CRUD app, I want validation on Create New Item Page and on the Edit Page. 3. For Information: I am using Visual Studio Professional 2019 and Microsoft SQL Server Management Studio 17 for this project since this is the sample project I'm using a local Database. 4. I'm using stored Procedures not the Entity Framework, but have different files for a different stored procedure, therefore I want you to combine all the stored Procedures in One Single File and update the Code Accordingly. 5. In the same way, as you must b...
I'm looking for an Oracle SQL and Python expert to help with a personal project I am working on. I have existing materials that need to be modified and utilized for the given project. The amount of time needed for this project should not exceed 2 hours. This project is for personal use and does not involve starting a new enterprise or working for an existing business. I am a knowledgeable user of SQL and Python, but am looking for someone who may have more experience to give me some extra guidance in completing my project with these languages. If you are an experienced Oracle SQL and Python programmer, I would greatly appreciate your assistance. If you are able to help complete the project in under two hours, please reach out to me and let's discuss fur...
Analysis of changes and massive update of data between two tables of agricultural parcels with a common field. Work environments: GIS, ms access, SQL and python.
I am looking for an automation anywhere and SQL expert to help with a one-time project. The scope of the project is designed to be completed within a week. My team is not sure whether we have an automation anywhere or sql expert already present. If you have the expertise, I would love to hear from you.
Configure CWP panel for Magento 2 Varnish + Nginx + Apache + FPM - OPcache - SQL MariaDB -PHP 8.2 - Bread - Elasticsearch - email For Magento 2: Redis AQM
Nature of Business - B2B IT infrastructure Solution provider , we have a sales team of close to 30 people , we would like to have an inhouse CRM Tool developed with custom flows and integration with our SQL database. Looking for individual who handle the developemnt part, i have a in-house product manager who can design the flows .
...functionalities: 1. Download data from a the destination type and store as a JSON in a pgSQL DB. 2. take data and upload to the destination I need you to create the following connectors that will include any authenticication parameters needed to access the data source: SQL Server, xls/xlsx, csv, txt (deliminated), Oracle, MySQL/MariaDB, Postgres, IBM DB2, MangoDB, TeraData, DBF, Slowflake, PowerBI, Tableau, Sales Force I require your recommendations on addtional: Azure, Google and AWS DB connectors, SAP, Shopify For DBs like SQL, PG, MySQL I need the ability to read the tables, in one function which will allow me to determine which table to import or query, In addition to building, I need documentation on how to use each the connectors. I will be constantly availabl...
WE ARE LOOKING FOR DEVELOPERS SRI-LANKA BASED ONLY ILLUSTRATOR/PHOTOSHOP DESIGNER 32H/WEEK - 45/65$ PHP/SQL DEVELOPER 32H/WEEK - 60/85$ C#/UNITY DEVELOPER 32H/WEEK - 60/85$ C++/UNREAL DEVELOPER 32H/WEEK - 60/100$ RECORD YOUR PROGRESS WITH TIMETRACKER AND SCREEN RECORDING
We are having issues with our Snipe IT Asset Management System. When removing assets or updating assets some fields are not getting updated. Example : When I check out an item it should lower the number of stock but currently it stays at the same quantity. Its like the SQL database values are not getting updated. Also when removing an item completely, the database value still stays the same. Need someone who knows Snipe IT asset System, Php and MYSQL to help fix whats going on with our Asset DB. Should be a quick job for someone who understands whats going on
OpenCBS System requirements are relatively low. As such the system could be installed on any computer with windows as operating system. OpenCBS is a system working as an interface between the user and a database containing the information of microfinance activity. As such using OpenCBS requires the installation of a database management system, in our case SQL Express as minimum requirement. The reporting section of the software requires as well the installation of Crystal Report Viewer, the software managing the visualization of report in the software. 2. Milestones 1. Analyse & Deploy the existing source code provide within the 2 folders (client & Server) 2. Minor customisation the existing application as phase 1 covering 50%+ of our requirements as per below table under...
...JDBC to connect to multiple data sources Nice to have skills: Good experience on Spring Security based Authentication and Authorization protocols Good knowledge and hands on experience working on AWS based technologies and services and integrating them with your Java application. Good knowledge of front end charting libraries like in both Angular and React is desired Good knowledge of SQL queries, specially using Oracle database Duration of the Project: 6 to 12 months ...
Step by step guide for using MySQL database engine from Node.js
Want to expand the freelance services you're offering? Learn a new skill and take an exam that will certify your expertise.
Here is a run down on what programming languages are dominating the mobile app space in 2017.