Hi Sunny， 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
Jie, 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
我们在寻找半导体行业的客户，SEMICON展览的参展商是我们的目标客户，我们希望你能够从网站将17年参展商的信息搜索并导入到EXCEL表格中。项目包含了公司名称中文，公司名称英文，公司的产品，公司的官方网站，公司在中国的据点城市，公司所属的行业这些。你可以从你的专业角度提供建议，我希望选手能够熟悉中文。 上述网站都有中英文版本供参考
...layouts - Collaborate with design and development teams to ensure seamless user experiences - Optimize websites for maximum speed and scalability Skills: 1. Proven experience as a Backend Developer with 2-5 years of hands-on experience in Node.js, JavaScript, and TypeScript. 2. Strong understanding of backend development concepts, including RESTful APIs, microservices architecture, and postgres. 3. Create database schemas that represent and support business processes. 4. Proficiency in writing clean, maintainable code and following software design principles and design patterns. 5. Experience with version control systems such as Git 6. Familiarity with cloud platforms (Google Cloud) 7. 2-5 years of working experience with Node.js in backend 8. Expertise in Node.js an...
...key social media channels, the website, in-person events, and occupier information. - The report should encompass data from major social media channels such as Facebook, Instagram, Twitter, LinkedIn and Tik-Tok, as well as any other relevant channels identified. - In terms of the website, the report should cover website traffic statistics, user demographic data, CTA page information, and page index. The report should be informative, visually appealing, and easy to understand. Ideal skills and experience for this project include: - Proficiency in data analysis and interpretation, particularly in the context of social media and website metrics. - Experience in creating engaging, visually appealing PDF documents. - Previous experience in creating reports for shopping centers...
...site in WordPress: Your primary task is to mirror the current website on the WordPress platform. This includes all pages, features, and functionalities. - Mobile responsiveness: The new WordPress site must be fully responsive and optimized for mobile devices. - SEO-friendly structure: Ensure that the site is structured in a way that is SEO-friendly, making it easy for search engines to crawl and index. You won't be responsible for content creation, as I will provide all the text, images, and other necessary content. Ideal Skills and Experience: - Proven experience in WordPress development, with a portfolio of successful projects. - Strong understanding of web design principles and best practices. - Experience in creating mobile-responsive websites. - Knowledge of SEO and ...
...crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website Go to Horse Index A-Z Starting with letter A all the way through to the letter Z Most of the fields will be self-explanatory. Some have been separated. Eg 1st 2nd 3rd Starts For the horses that have overseas formrecords, the information is in the PDF Files, such as the link below: chrome-extension://efaidnbmnnnib
...planning to create a professional A4 landscape brochure, which will comprise 40 to 45 pages. This includes a cover and back page, a table of contents, an "About Us" page, and an introduction. MAIN SECTION OF THE BROCHURE: 01. 31 SERVICE PAGES: Each of these pages presents a specific IT service of our company. 02. 8 CATEGORY PAGES: These pages group various services under thematic focuses. 03. INDEX PAGE: A comprehensive table of contents listing all services, categories, and the additional service page, 04 facilitating easy navigation and quick access within the brochure. 04. INTRODUCTION: A brief introduction to the brochure, outlining its purpose and providing context for the content. 05. "ABOUT US" PAGE: This page provides an overview of our company, miss...
I'm looking for a skilled developer to assist with implementing Postgres and Pgvector in a project that involves document retrieval and LLAMA 2 LangChain. Key Functionalities: - Highlighting relevant terms in the retrieved documents - Implementing Pgvector to enable vector-based searches Ideal Skills: - Deep understanding of Postgres and Pgvector - Proficiency in developing document retrieval systems - Prior experience with implementing semantic search enhancement Please include samples of previous relevant work in your bid. Your understanding of these technologies and how they can be leveraged in the project is crucial.
Help add search filter to iOS Swift App that exposes the selected items in the array (selected indexes) and the selected index if only 1 is returned.
...requirements: - The ebook should include fewer than 50 unique alcohol-based cocktail recipes and food dishes. - Recipes should cover a range of spirits and styles, from classic to innovative. - Each recipe should come with easy to understand cooking instructions and accurate measurements. - Include high-quality images and illustrations for each recipe, if possible. - Easy-to-navigate layout with an index or table of contents at the beginning. Ideal Candidate: - Previous experience in recipe writing or food/cocktail blogging. - Strong knowledge of cocktail concoctions and mixology. - Creative writing style that can make the content engaging and entertaining. - Proficient in English with excellent grammar skills. - Bonus if you have experience in food photography or graphic des...
Looking for a skilled developer to help with an issue related to Livewire gadgets. The key points of the project are: - The problem: Currently, the save functionality of one of the gadgets, namely Index Filter, is not working as intended. It's not saving data correctly. I need this to be fixed. -Also need to fix livewire library issues please Ideal candidates for this project should have: - Proven experience with Livewire gadgets - A strong understanding of database systems, particularly in the context of web applications - The ability to troubleshoot and solve issues efficiently - Strong communication skills to understand and implement the necessary changes to the saving mechanism.
I am looking for an expert in Python programming to assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file Please feel free to inquire if you need more clarification or informati...
I'm looking for a professional who can convert my Amibroker AFL script into a TradingView Pine Script. The converted script should be able to generate buy/sell signals and provid...provide backtesting capability. The ideal candidate should have experience in: - Amibroker AFL and TradingView Pine Script languages - Developing buy/sell signals - Implementing backtesting functionality Moreover, my trading strategy is based on breakout patterns. The converted script should reflect this strategy and incorporate the following indicators: - Moving Averages - Relative Strength Index (RSI) - Supertrend I'm looking for a freelancer who can deliver a polished and fully functional script that mirrors the performance of the original AFL script in TradingView. Feel free to ask any a...
I need an experienced NextJs (ShadCn) + Prisma (Postgres) developer to build an E-commerce application within a week. Key Requirements: - I already have a DB schema for the App and all the flows mapped out - Need someone to build a test taking app - Users can create online test, generate links and take test using the application - The whole app will be less than 10 pages - The App will have a lot of funtionality like generating common test link, session specific test link, generating test scores/result, question bank support, dynamic questions... The ideal candidate should have: - Solid experience in NextJs, ShadCn, and Prisma. - Proven track record in E-commerce application development. - Ability to deliver high-quality work under tight deadlines. Please only apply if you...
I'm seeking a skilled developer to create a trading bot for me. The bot should be compatible with TradingView and be able to implement multiple trading strategies, including trend following, mean reversion, and breakout. The bot should primarily use moving averages, RSI (Relative Strength Index), and Bollinger Bands as technical indicators. Key responsibilities include: - Developing a bot compatible with TradingView - Implementing the specified trading strategies (trend following, mean reversion, breakout) - Incorporating the key technical indicators (moving average, RSI, Bollinger Bands) into the bot's strategy Ideal Skills and Experience: - Proficiency in TradingView platform - Strong understanding of various trading strategies (trend following, mean reversion, breako...
...given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g., golden cross). RSI Oversold: Identify stocks with RSI readings below a certain threshold (e.g., 30), indicating potential over...
I'm in need of a skilled developer who can work with Apache Superset, particularly in relation to MSSQL data. The project involves creating a range of data visualizations including charts, graphs, interactive dashboards and geospatial maps. Though the data is of moderate size and complexity, it's essential that the visualizations are effective and easy to understand. The ideal candidate will be responsible for designing, developing interactive dashboards and reports using Apache Superset. You will work closely with data analysts, data engineers, and business stakeholders to understand data requirements and translate them into visually compelling and actionable insights. Key Requirements: - Proficient in working with MSSQL databases - Solid experience with Apache Superset...
We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.
...am seeking an experienced developer to integrate an open-source search function, like Elastic Search or Solr, into my application. The app's search utility must be optimized to suggest relevant products to the user based on input, even for spelling errors. For example, when searching for "Poma", it should suggest "Puma", "Puma shoes", or "Puma Tshirts". Details about the project: - The search index size would be small, accommodating less than 10,000 items. - It will focus on product search within the application. - The search results need to be sorted by relevance for better user preferences. Ideal Skills and Experience: - Proven track record of implementing and optimizing search functions. - Strong knowledge of open-source search ...
I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.
...535,000-word document into a book format (aprox 500 pages). It is a collection of the 222 essays written by Paul Graham () A very basic layout with an index and page number, plus every essay staring in its own new page will do. Key Tasks: - Ensure readability and coherence in the formatting - Ensure this can be printed into a book format so it can be read comfortably. The lower number of pages the better. - I would like each essay title to be highlighted in bold. - I would like all the notes and "thank you" sections to be in a smaller cap size. - I would like the index o show the page number for each essay. - I did the first 8 manually, and you can take them as an example model. Doing this manually will take me forever and I am sure someone pro like you
I have to transfer data and tables from oracle to postgres.
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for...
I am seeking a versatile ...project entails the creation of a cBOT programmed to execute an automated trading strategy while integrating risk management and technical analysis. Key features should include: - Blending of various trading strategies - trend following, mean reversion, and breakout trading. - Using a combination of various indicators and signals, including but not limited to, Moving averages, RSI (Relative Strength Index), and Bollinger Bands. Ideal freelancers for this role should have a strong background in finance, with particular experience in creating automated trading strategies. They should be knowledgeable in the use of various technical analysis indicators and demonstrate excellent programming skills. Experience with cTrader's proprietary programming lang...
hello i need a freelancer to change design of wordpress website to make it same freelancer should change the design live website not only mockup website details: built on WP Dev is ok no change we share screenshots of what should be done total 6 pages: 1- home page 2- map&table page(index page) 3-contact us 4-about us 5-terms and conditions 6-privacy and policy freelancer should not touch my other domains on my hosting and dont change anything without asking me freelancer should follow my admin panel: what original developer give me you should give same he gave me editing control on all pages (text editor) 10 days maximum good luck
...approving changes and code for deployment/deploying code, managing pipeline and doing whatever it takes to ensure uptime of greater than 99.999%. The developer will play an technical role in the enhancement of a video social networking website, focusing on: - Optimizing back-end performance and scalability for the upcoming website launch. - Ensuring effective database structuring and management for Postgres database. - Administering server tasks for maximum uptime and security for Digital Ocean hosting - must have the ability to understand and recommend hardware scaling strategy as the site scales. - Acting as the senior "gatekeeper" and final authority for deploying changes and bug fixes by reviewing code and deploying changes to both Development and Production websi...
I am in need of a professional with strong knowledge of pine script who can assist in developing intricate algorithms for my TradingView platform. Key Requirements: - Implementation of the Moving Average Convergence Divergence (MACD) and Relative Strength Index (RSI) indicators in Pine Script. - Development and integration of a customized 'Cup with Handle' indicator. - The moving averages for the MACD and RSI indicators should focus on a medium-term timeframe, specifically 14 periods. Ideal Candidate: - Has excellent experience in coding Pine Script. - Proven experience in designing trading algorithms especially MACD and RSI. - Familiarity with 'Cup with Handle' demonstrations would be a plus. The end result should be a robust and efficient script that effect...
I am in need of a professional with strong knowledge of pine script who can assist in developing intricate algorithms for my TradingView platform. Key Requirements: - Implementation of the Moving Average Convergence Divergence (MACD) and Relative Strength Index (RSI) indicators in Pine Script. - Development and integration of a customized 'Cup with Handle' indicator. - The moving averages for the MACD and RSI indicators should focus on a medium-term timeframe, specifically 14 periods. Ideal Candidate: - Has excellent experience in coding Pine Script. - Proven experience in designing trading algorithms especially MACD and RSI. - Familiarity with 'Cup with Handle' demonstrations would be a plus. The end result should be a robust and efficient script that effect...
...academic book using Microsoft Word. The book has various complex elements that need to be integrated seamlessly into the overall design. Key Responsibilities: - Designing the layout of the book to ensure it is visually appealing and easy to read - Incorporating images and graphs at appropriate locations - Formatting footnotes and citations according to the required academic standards - Creating an index and glossary for easy reference Ideal Skills and Experience: - Proficiency in Microsoft Word - Previous experience in designing academic publications - Strong attention to detail and understanding of academic formatting - Ability to incorporate various elements like images, graphs, footnotes, and citations into the layout - Experience in creating indexes and glossaries Please s...
I'm looking for a professional who can connect the contact page on my HTML website, , to Google Sheets, and set up Recaptcha functionality as well. The ideal candidate should have the following skills and experience: - Proficient in HTML and backend integration - Experience with Google Sheets and its APIs - Ability to set up Recaptcha for form security Key responsibilities for this project will include: - Connecting the contact form on my website to Google Sheets - Ensuring the Recaptcha integration works effectively - Ensuring the data flow to Google Sheets is secure and consistent - Testing the entire system to ensure it is bug-free - Providing documentation for the integration for future reference Please note my server-side language preference is Google
In urgent need of an experienced freelancer who can proficiently deal with sitemap and search console issues. The problems I'm facing are manifold: - Sitemap errors - No index errors - Redirect errors Further, my sitemap seems to have several issues like missing pages, incorrect URLs, and XML format problems. I am hopeful to have these issues resolved as soon as possible. Ideal candidates should have extensive experience in error fixing, handling sitemaps, and search consoles. Knowledge in XML format will be an added advantage. It's a critical and urgent task, so please consider before bidding.
...project). Please create a mockup on how that website will look like. Requirements: - professional looking - quality design and appearance - Attention to detail (you have to do your own QA review for spelling sign, functionality etc) - hosted on Hostgator WP - rendering to mobile devices properly - websites need to be created in 4 days from project award. Book Website 1: the following menu/pages: - index page - About the author - The books with purchase links - Speaking - Contact form (with Captcha) - Connected to newsletter (WP plugin) Ideal candidates should have experience in web design, preferably with related projects. A discerning taste for layouts conducive to the publishing industry would be commendable. Proven experience in creating user-friendly, engaging websites ...
...and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Include search bar, search results, and settings Cloud Component: Calendar Service * Calendar Integration * Integrate with Microsoft Graph API for calendar data * ...
... <div> <DragDropContext onDragEnd={handleDragEnd}> <div style={{ display: 'flex' }}> <Droppable droppableId="column1"> {(provided) => ( <div className = "drag" {...} ref={}> <h5>column 1 header</h5> {((item, index) => ( <Draggable key={item} draggableId={item} index={index}> {(provided) => ( <div {...} {...} ref={} > <p>{item}</p> </div> )} ...
The aim of this project is to create a unique calculator that will be integrated into my Shopify page. This calculator is intended to have two main functions: 1. Estimate weight and hand wrist circumference based on user's height and Body Mass Index (BMI) health status e.g underweight, ideal weight, overweight, obese. 2. Utilise the wrist circumference to determine the appropriate watch size. The ideal candidate able to undertake this task should have proficient skills in Shopify application development and a clear understanding of BMI calculations. Any previous experience with crafting calculators for eCommerce would be considered a plus. Key Requirements: - Develop a height and BMI health status input system - Formulate algorithm for estimating weight and hand wrist c...
...including: ✓ The first time working: 1 week and review result together ✓ Renew weekly if suitable with two sides • Other activities still count working hour and receive payment ✓ The first time is training in 1 hour ✓ Join the meeting online internal in 1 hour/ week • KPI deals: 5% commission on gross profits Assessment KPIs Index • Weekly: ✓ Get average 20 callings for 1 hour working. Total is 60 callings for 3 hours working ✓ Approach average 20 customers • Meet KPIs Index in week (3 hours working approach customers) if meet one of two levels below ✓ Level 1: Setup 3 meetings ✓ Level 2: Setup 1 meeting and have a total 60 callings. In 60 callings will have high the replied rate is 50% (around 10 customers) replied. Notice: ✓ Definition “replied&...
...book. Key Requirements: - **Document Conversion**: The existing genealogy document is in a Word format that needs to be converted and formatted properly for printing. - **Printing Preparation**: The ultimate goal is to have the genealogy printed as a book. Your job involves setting up the Word document to meet the specifications for book printing. - **Indexing**: You are required to complete the index of the genealogy to make it easily navigable for readers. Ideal Skills and Experience: - **Document Formatting**: You should have experience in formatting long documents for printing, specifically books. - **Indexing**: Familiarity with indexing principles is a huge plus. - **Graphics Design**: Although the design elements are already done, having a basic understanding of geneal...
I'm in need of skilled Python developers immediately to help me run a python code to load the data to postgres DB The current script is throwing error need to modify it to check where the error is. Need quick response to check the code and respond
...project). Please create a mockup on how that website will look like. Requirements: - professional looking - quality design and appearance - Attention to detail (you have to do your own QA review for spelling sign, functionality etc) - hosted on Hostgator WP - rendering to mobile devices properly - websites need to be created in 4 days from project award. Book Website 1: the following menu/pages: - index page - About the author - The books with purchase links - Speaking - Contact form (with Captcha) - Connected to newsletter (WP plugin) Ideal candidates should have experience in web design, preferably with related projects. A discerning taste for layouts conducive to the publishing industry would be commendable. Proven experience in creating user-friendly, engaging websites ...
...sources will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business analytics workflows. - Strong understanding of data cleaning, integration, and visualization. - Proven track record in successful migrations between data visualization platforms. I'm looking for someone who can take ownership of this project and deliver it with high precision and efficiency. A proactive approach t...
...with hands-on knowledge of stock market trading algorithms. The task primarily involves implementing proven trading strategies within a fully automated trading application. Below are my specific requirements: • Compatibility: The Python trading code must be compatible with the National Stock Exchange (NSE). • Algorithms: The code must incorporate 'moving averages' and the 'relative strength index (RSI)' into its algorithm to generate trading signals. • Data Sources: The software should leverage both real-time data feeds and historical data obtained from APIs to inform its trades. Programming in Python for algorithmic trading and understanding financial markets, especially the NSE, are essential qualifications. Familiarity with trading ...
...object etc. Please see the screenshot that explain the technical setup wanted: []() The final goal is to have a full blown searchable database, with list feature, and respond time always staying below a clean 100ms. The main DB will be Mongo, that needs to be optimized (shard, cluster config, index...) properly. On top of that DB will live Elastisearch, which will require a near real-time and bulletproof syncing between the two. The server budget expenses is 5-10k$ which should be enough to sustain such a setup. You will have to: Comment and detail what you think about our current thought-out infra strategy (see attached) Make large scale testing by generating hundreds of millions of fake
...directory contains and requirements.txt. Run the following command to first install all dependencies from there: pip install -r 4. Run python main.py. If everything goes well, you will see the following output: This means your indexes were successfully created. 5. Navigate to s2/intermediate/ folder where the indexes are stored. s2/intermediate/ is the inverted index file. This postings can be read in memory and used to construct vector representations. 3 What functions should I implement? You will find an incomplete function named rank and evaluate() already defined in main.py. It is called from the main function. Complete this function to implement ranking of documents using vector based models and their evaluation for each query. Feel free to add functions
