Alumni database mysqlemplois

I’m seeking an experienced database developer to build two MariaDB/MySQL nodes using Galera, aiming to ensure high availability of our transactional data. Your responsibility will be centered on constructing these clusters to maintain constant uptime and assuring that they serve as a dependable solution for our growing needs. Primary Tasks: - Creation and configuration of two MariaDB/MySQL nodes using Galera. - Migration of transactional data from an existing MariaDB/MySQL database to these new nodes. Ideal Skills: - Significant experience with MariaDB/MySQL and Galera cluster. - Proficient in database migration processes. - Strong knowledge in high availability solutions. Your expertise will play a vital role in guaranteeing ou...

I need a tech-savvy individual to set up my Control Web Panel (CWP) on my Virtual Private Server (VPS). Since my VPS is running on Linux, having a strong background in this operating system is essential. Ple...(VPS). Since my VPS is running on Linux, having a strong background in this operating system is essential. Please be prepared to provide: - Basic Security setup on CWP. Prior experience with Linux security protocols is a bonus. - Installation and configuration of specific services including: - Web Server (Apache, Nginx, LiteSpeed) - Mail Server (Postfix, Dovecot, RoundCube) - Database Server (MySQL, MariaDB) Deep knowledge and proven experience with these servers and databases are required for this project. Appreciate your interest and look forward fo...

For my upcoming Laravel-based project, I am looking for an expert Laravel developer. This project will be developed from scratch and its main functionality will be a robust data management system. - Required skills and experience: - In-depth knowledge of Laravel PHP Framework - Previous experience in creating data management systems - Expertise in MySQL or similar databases I do have specific requirements and will provide the detailed documentation to the selected candidate. The developer would need to follow these requirements closely to ensure the project's success. Strong problem-solving skills with an analytical mind would be a major plus.

As an alumni association, we need a web developer to create a highly interactive and user-friendly site featuring a detailed map. This map should show where each alumnus of our association is currently employed. The map should accomplish the following: 1. Display clear and concise markers for each alumni's workplace. 2. Offer popup windows with details about each alumnus when these markers are clicked. Each popup window should contain: - A photograph of the alumnus. - Contact information. We will need a back office to deal with the data, and a form to allow each one to be added on the map after verification. We would like to be able as well to store the list of everybody's emails to send message easily. The whole site will of course need to be protected, to...

I'm looking for a skilled professional to design and implement a MySQL database system. The database cluster, mysql router, should feature: - data warehousing, Data analysis tools to interpret and present data in a meaningful way. - User management systems to organize and regulate users effectively. - Cluster management, sql router management. - Open source tool to monitor the slow query, query...effectively monitor the data base. Ideally, the system should be equipped to store an estimated 10,000 to 500,000 records. Strong experience with MySQL is imperative, alongside a working knowledge in data analysis, user management, and real-time data updating functionalities. Your portfolio demonstrating similar projects will be highly appreciated.

Students Database of 11th STD and 12th STD Science , currently interested in NEET/JEE Free courses and free test series .

I am looking for someone proficient in Excel and familiar with MySQL databases to assist me with data collection, manipulation, and analysis. The ideal freelancer would - Have proven experience in Excel, specifically in data manipulation and analysis. - Be familiar with MySQL databases or apache spark - Understand how to generate comprehensible reports. - Possess an analytical mind to identify trends and patterns from the data collected. The purpose of collecting, manipulating, and analyzing the data is to have a single type of database for all the data-driven decisions I need to make. As such, knowledge in building and working with databases is an added advantage. To make a convincing proposal, show me how you've done something similar in the pa...

For our project, we require a reputable Grafana developer. Our cloud servers are housed on DigitalOcean and Hostinger, operating on an Ubuntu or similar ope...environment on these servers. Key tasks will include: - Establishing Grafana on our existing cloud server - Customizing the environment to suit our specific requirements - Preparing the environment for further development - Implementing necessary changes throughout this process In addition, expertise will be needed to integrate a MySQL database data source with Grafana. In summary, we are seeking someone with solid Grafana experience, Ubuntu competency, and knowledge of MySQL databases. Ability to optimally perform this project is highly important to us, and we look forward to connecting with prospective freel...

Fix issues related to MySQL on the Linux Server / Drupal

I require a competent freelancer to locate and collect 3000 product images on the internet and transfer them into a database for inventory management. The images should correspond to the given skus and upc codes. The project specifics include: - Images should be in JPEG format - Minimum acceptable image resolution is 72 dpi This project would ideally suit someone with the following skills and experiences: - Image sourcing and editing - Strong research abilities - Experience with data entry and database management - Familiarity with skus and upc codes - Attention to detail. Please ensure all images are obtained legally and are suitable to use for commercial purpose.

I'm looking for an expert to guide me in running an existing windows command script. My ultimate aim is to extract specific data from my databases. Here are a few details about what I need: Key Tasks: - Guide me through the process of executing an existing Windows command script with steps by steps written documentation - script is password protected - password is known - Assist in extracting valuable data from various databases Essential experience and skills: - Proven expertise in Windows command scripts - Proficiency in data extraction from databases - Excellent communication and teaching skills, as I need step-by-step guidance. Please bid only if you match the skill set and experience.

I'm searching for an experienced full-stack web developer with a proficient command in PHP (php mysql). The candidate will be tasked with the implementation of a frontend for an already designed api. view the reference code: Key Responsibilities: - Development of the web platform using PHP for add or delete load balancers - Development of the web platform using PHP for add or delete servers in the load balancers - Ensuring high performance of applications and providing support to do it - Integrating UI elements with server-side logic Ideal Experience and Skills: - Profound knowledge of PHP - Strong experience in web development - Understanding and implementation of security and data protection - Good problem solving skills - Validating user

...React websites and MySQL databases. The purpose of the project is to add features and update the design of our already operational travel-based website where users get information and can book travel. The website covers: - Destinations: Detailing various interesting locations, their information, and booking options. - Retreats: Indepth information on various spiritual and wellness retreats; offering booking service. As such, the freelancer would be responsible for: - Creating/troubleshooting some bugs - Implementing and verifying secure booking features. - Upgrading website design for user-friendliness and aesthetic appeal. - Updating database as necessary for new features. - Updating obsolete libraries Ideal skills for this project include: - Proficiency in React an...

I'm seeking a skilled developer to build both front and back ends for an existing online database design. This project will involve constructing the admin and user portals with specific functionalities. Admin Portal Needs to enable: - User management; to ensure I can control access and permissions within the platform - Data entry and editing; to ensure the database content is dynamic and updated as required User Portal Needs to facilitate: - User registration and login; to ensure only authorized users have access - Search and filter options; to allow users to quickly find specific information they need - View and edit user profile; letting users manage their own information on the platform The type of data to be stored primarily includes: - User information - Order ...

I'm seeking an expert to help create a Dockerfile that runs Perl and DBD::mysql so that I can run a legacy website. This should be a simple task if you have the knowledge. Specific requirements include: - A Dockerfile is the only output required, roughly corresponding to mine - It should build and run in wsl, i.e. docker run -p 8080:80 image_name - It must use Apache, Perl and the CPAN module DBD::MySQL - It should have been tested on a MySql database, the file is provided to run on localhost:8080/ - A screenshot of the above is required to prove that it is working (you just need a MySql Table with fields Id and Name) Candidates should ideally have: - Extensive experience in Docker and a basic knowledge of Perl - Understanding of Perl CPAN modul...

Sprache : Delphi Anforderungen: Über die Ebay-API sollen alle verkauften Artikel mit Kunden und Portodaten ausgelesen werden (einfach alle Informationen, die Ebay bereitstellt - also auch, ob die Artikel bereits bezahlt sind) und diese Daten in eine MySQL-Datenbank geschrieben werden. Dabei würde sich eine Kopftabelle mit den Kundendaten etc. und eine Detailtabelle mit den ersteigerten Artikeln anbieten. Gewünscht ist auch eine separate Tabelle mit den extrahierten Kundendaten, um Redundanzen zu verhindern. In der Kopftabelle kann dann auf die Kundendaten referenziert werden. Wichtig ist, dass die Lieferadresse über die API angefordert wird. Diese kann sich von der Kundenadresse unterscheiden. Die gewonnenen Daten sollen im Programm angezeigt werden - eine sin...

I am looking for a seasoned Python developer with experience in Telegram bots. The bot should automate responses and facilitate user registration/authentication. It will need to link with external APIs. The mai...functionalities: - Auto-reply messages - User registration and authentication - Integration with external APIs - Capability to handle multi broadcast systems The bot should be able to handle all databases in one system for efficient broadcasting. Specifically, it should work within a MySQL database. It needs to be able to send messages to specific groups and individual users. Ideal freelancer skills and experience: - Extensive Python development experience - Familiarity with Telegram bots & APIs - Understanding of MySQL databases and how to implement t...

...with inherent data processing and error handling mechanisms of Go script. Project Scope: • Script is available at this GitHub Library: • We would like a middleware in form of MySQL/PostGres DB to which we can push data (messages to be sent) from our existing web application. We would like the data to be consumed by the go-script (from table 1) and send messages to appropriate SMSC (Telco) using the script. • We would like the Delivery Reports (DLRs) from Telco's that are sent to the go-script mentioned above via SMPP to be logged into the database(table 2). • We would like to add one functionality (available in another script) for throttling/ rate-limiter per second to the telco. Telcos specifies the rate limit per second (transactions per s...

I am seeking a skilled Flutter Flow developer to develop a web app. Key Functionalities: - Appointment scheduling: Facilitate easy booking and management of patient appointments directly within the app. - Electronic medical records management: Patients' medical records should be safely stored and easily accessible within the app. - Telemedicine/video consultations: Incorporate a function for virtual consultations, allowing doctors and patients to connect remotely. Who Am I Looking For? A highly skilled professional with substantial experience in Flutter Flow is a must. Familiarity with the healthcare domain would be advantageous. Additionally, I'm seeking someone who is willing to communicate and develop ideas together.

I am in need of an expert who can proficiently filter and extract financial time series data from compressed files in AWS S3. Upon extraction, thi...can proficiently filter and extract financial time series data from compressed files in AWS S3. Upon extraction, this data should be neatly compiled into a streamlined, accessible database with clear, intuitive organization. Ideal skills and experience for the job: - Familiar with Amazon AWS, specifically S3 - Understanding of financial time series data - Proficiency in database design and management - Experience handling large data sets Job Responsibilities: - Filter and extract time series data from AWS S3 - Design a coherent, user-friendly database structure - Transfer extracted data into the new database fo...

I am shifting my operations and client management to and require help importing my client data into its database. You'll be gathering this from various sources including, but not limited to social media platforms, my current CRM tool, and email contacts. Key Data to Extract: - Client names - Contact details - Transaction history - Family names - Pet names - Birthdays - Anniversaries - Addresses Ideal Candidate: The ideal candidate will have excellent data management skills, experience with CRM platforms, preferably monday.com. They will require strong attention to detail to ensure the accuracy of the imported data. An understanding of personal data protection principles is crucial. Knowledge in real estate sector will be a definite plus. For items that are not known, the ...

I'm searching for an expert web developer who specializes in creating e-commerce websites integrated with MySQL databases. The website is already developed needs to change some content on pages. Key tasks include: - Designing and developing a seamless user registration and login system - Ensuring efficient performance and security features The ideal candidate should possess a strong background in web development, particularly in building e-commerce platforms. Furthermore, significant experience and proficiency in MySQL are paramount.

Hello, I have a simple php page and a complex database. My database size is very high and when I query a data I don't get a response for a very long time. I created a basic API and I have complex data in my database. I need a system that will delete repeated data in the database, destroy all unnecessary data and work with a proper, reliable api.

I need a website built in PHP, allows users to setup a list of pre-defined medication orders , based on a procedure) and then send to a SQL Server database / aim is to insert rows of data into the my SQL SERVER Please note that the site does not need user registration or login functionality. We also do not need to track customer info or delivery location. Ideal freelancers for this job should be proficient in PHP development/ mySQL and SQL Server. They should also have experience in designing simple yet functional websites, with a focus on order-processing functions. A keen attention to detail is necessary to ensure accurate data capture of product-related details.

I'm in urgent need of a developer well-versed in PHP, MYSQL, and FFMPEG for the creation of a GPU Transcoding Panel operating on Linux. Key project details and specifications include: - The system will be Linux-based due to its flexibility, stability, and open-source nature. - The project completion timeline is urgent. Ideal skills and experience include: - Proficiency in PHP, MYSQL, and FFMPEG - Experience in developing GPU Transcoding Panels - Extensive knowledge of Linux systems - Knowledge of video encoding and decoding tools is not obligatory, but would be advantageous. Please note that the output format requirements are currently undefined and will be determined with the successful freelancer as the project progresses.

Hi Kolte Technologies, I noticed that you have experience with QuickBooks API integration. I am interested in a two-way QuickBooks Sync tool to MySQL DB, which can support multiple QuickBooks company files and has an auto-sync scheduling function. Additionally, I have a MySQL DB schema that needs to be followed; the sync output should match my schema so that I don't need to modify it. If you can develop this, please provide a quote. Thank you.

I am looking for a seasoned Python developer with experience in Telegram bots. The bot should automate responses and facilitate user registration/authentication. It will need to link with external APIs. The mai...functionalities: - Auto-reply messages - User registration and authentication - Integration with external APIs - Capability to handle multi broadcast systems The bot should be able to handle all databases in one system for efficient broadcasting. Specifically, it should work within a MySQL database. It needs to be able to send messages to specific groups and individual users. Ideal freelancer skills and experience: - Extensive Python development experience - Familiarity with Telegram bots & APIs - Understanding of MySQL databases and how to implement t...

I'm urgently in need of a competent PHP developer to build a login form for an existing backend. This form requires a unique combination of name and mobile number for user identification. After filling in these detai...to complete the project promptly. I want login form with name and mobile no. and OTP verification through MSG91 API just for authenticating and save the user record at backend, after login button the page will redirected to defined link, and want the simple admin backend to see the record for all registered user Login form should be responsive and mobile friendly Preferred backend in php and MySQL This is 10-30mints of work for experience one And the budget is for is $2-10 Next task will give in next project this task is immediately MSG91 api is very simple ...

We are seeking an experienced Magento 2 developer to assist with the migration of our e-commerce website from Cloudways hosting to a new dedicated server Requirements: Proven experience with Magento 2 migrations and management. Strong knowledge of server technology, especially related to hosting Magento 2 site...Ability to troubleshoot and resolve issues related to Magento 2, server configuration, and data migration. Excellent communication skills, with the ability to provide clear updates and instructions. Commitment to following best practices for security and performance. Current server specs in cloud ways: 8 GB 160 GB Disk Appache Elastic Search Mysql Redis Php 7.1 New dedicated server; Linux; Almalinux 9 Php 8.1 Appache Elastic Search Mysql 64 GB 500 G...

I need someone skilled in data entry and Excel to help me create a comprehensive database. I'll provide an Excel file with a list of names that I'd like you to translate into an organised, efficient Excel sheet. For each name, I require the following additional information apart from their email, title, and job specialty: - Company name - Location - Phone number - Job description I don't have a specific excel template in mind, hence, your creativity and technical know-how in creating a user-friendly format will be an asset.

I'm seeking an experienced developer to build an automatic music fingerprint database. Dynamically collecting audio files, this database needs to accommodate newly released songs efficiently. Key Project Actions: - Music fingerprints need to be created using existing music fingerprinting algorithms. Prior experience with these algorithms is a must. - The system needs to scan all major music labels and future songs that are coming out. - Specifically, the focus should be on popular songs that are played on radio stations. Purpose of the Database: - The primary purpose is to create music fingerprints of songs and save this into the database with artist and song name if is possible also the isrc. Preferable Skills: - Experience working wi...

I'm aiming to enhance my Laravel PHP and Vue.js web application with an upgraded TXT file generation and management page. The new functionalities will include: 1. **File Capabilities**: The applic...download and securely store these TXT files. 4. **Security Measures**: To maintain the integrity and secrecy of the TXT files, top-level security measures like user authentication and access control should be put in place. This would prevent unauthorized access and misuse of file-related data to a great extent. Ideal freelancers for this project should possess mastery over Laravel PHP, Vue.js, MySQL, and solid experience in data encryption, compression, web security, and file systems. A rigorous focus on accuracy, security, and responsiveness of the application is critical for p...

Looking for a PHP developer with experience in the development of APIs and Admin Panel development who can communicate with front end developer simultaneously and complete document related admin panel works . Code contains mainly php, some angular and mySQL as database APIs: - Custom API development required - Strong understanding of REST and SOAP protocols - Experience in integrating APIs with third-party applications Admin Panel: - Basic CRUD operations required - Familiarity with advanced features and analytics is a plus - Ability to develop custom functionality based on our specific needs Timeline: - Project needs to be completed in less than a week - Ability to work quickly and efficiently is a must Ideal skills and experience: - Codeigniter framework PHP v3 - Angula...

I am looking for a skilled PHP developer with specific expertise in the CodeIgniter framework. My project requires both design and functionality changes to the existing dashboard. 1) Need error to pop up when tables are left blank without valu...until all tables have a value. May say Table “X” has no points, please enter all points before submitting 2) Need to add position value to teams list. 3) Need to Rename Pay Now = Pagar Cuenta 4) New team Swiss (Need modify existing Swiss, to be fully Swiss instead of rotated) Skills and Experience: - You should be a pro at CodeIgniter with a keen eye for design details. - Expertise in PHP, MySQL, CSS will be highly appreciated. - Please provide past work samples related to CodeIgniter dashboard design or functionality enh...

...London to Manchester, Paris Airport to Paris, Barcelona to Madrid, and countless more. Here's what we specifically need: * Mastery in HTML, CSS, JavaScript, Laravel, MySQL and SEO (on-page and keyword) is required, as these are the languages used for development* Familiarity with AI-generated copy and prompt techniques and their implementation to enhance SEO would be an advantage. This is because we aim to improve SEO ranking, deliver the project cost-effectively, and efficiently save time. You will be delivered an existing static landing page that you will modify for the programmatic one. * The pages are to leverage our database of currently 249136+ global station connections for the SEO landing pages, so experience and skill in creating the perfect programmatic ...

...authorization. Collaborative editing with multiple users simultaneously. Version history and the ability to revert to previous versions. Sharing options to allow users to share their code with others. Choose the Tech Stack: Decide on the technologies you'll use for front-end, back-end, and database. Front-end: HTML, CSS, JavaScript (possibly frameworks like React or Vue.js). Back-end: Node.js with , Python with Django or Flask, or any other suitable framework. Database: MongoDB, PostgreSQL, or MySQL, depending on your preference and project requirements. WebSocket technology for real-time communication. Set Up the Development Environment: Set up your development environment with necessary tools and libraries. Version control with Git/GitHub would be essential ...

Fatal error: Uncaught Error: Call to undefined function mysql_pconnect() in /home/ocean1/public_html/eng/system/database/drivers/mysql/ Stack trace: #0 /home/ocean1/public_html/eng/system/database/(115): CI_DB_mysql_driver->db_pconnect() #1 /home/ocean1/public_html/eng/system/database/(148): CI_DB_driver->initialize() #2 /home/ocean1/public_html/eng/system/core/(346): DB(Array, NULL) #3 /home/ocean1/public_html/eng/system/core/(1171): CI_Loader->database() #4 /home/ocean1/public_html/eng/system/core/(152): CI_Loader->_ci_autoloader() #5 /home/ocean1/public_html/eng/system/core/(51): CI_Loader->initialize() #6 /home/ocean1/public_html/eng/system/core/(308): CI_Controller->__construct() #7 /home/

I need a music fingerprint database, so we need to collect the audio files and create a database that can also accommodate new songs.

I'm currently using a Windows operating system and urgently require assistance with a task related to Putty and MySQL Server. Key Responsibilities: - Troubleshoot and maintain my setup as and when required. - Handle remote server management effectively. - Participate in database development and updating. Ideal Candidate: - Should be proficient in the use of Putty and MySQL Server. - Possesses good experience with Windows operating system. - Must be able to deliver results promptly. Please bid if you can fulfill these requirements urgently.

I'm looking for a MySQL expert who can create a complex query to retrieve data from multiple tables (Table A, Table B, and Table C) of my database. These tables are interconnected, and the goal is to join data from all these tables, perform necessary calculations, then save the result into another table. Excel file with explanation is attached. Required Skills: - Experience in MySQL query writing - Ability to handle multi-table complex join operations

...secretaria: registro de pagos, reportes diarios de ventas, reportes diarios de pagos, reportes diarios de mora) i) El sistema deberá de generar un reporte general de ventas por proyecto inmobiliario, tanto de rentabilidad, ventas, disponibles y reservas, un reporte de venta por vendedor que calcule sus comisiones de forma mensual. 7. El sistema debera de desarrollarse en lenguaje PHP con BD Mysql con tecnolgía responsive, para ser accedido desde cualquier dispositivo....

Veuillez vous inscrire ou vous connecter pour voir les détails.

...a landing page grid that integrates two actions: button with link and form submission. - Designing and creating a backend for user logins. - Creating and hosting a MySQL database in Amazon AWS with approximately 5-10 tables. Site Details: - The site's grid should enable users to select a quantity from 0 to N of an unspecified product. - The form submission action on the landing page grid must collect this selection data, along with the quantity chosen. Ideal Skills and Experiences: - A strong background in web development, with an emphasis on creating dynamic, user-oriented sites. - Extensive working experience with AWS MySQL databases. - A track record of success in similar e-commerce projects. - Excellent understanding of user interface and user experience...

I am looking for a seasoned Python developer with experience in Telegram bots. The bot should automate responses and facilitate user registration/authentication. It will need to link with external APIs. The mai...functionalities: - Auto-reply messages - User registration and authentication - Integration with external APIs - Capability to handle multi broadcast systems The bot should be able to handle all databases in one system for efficient broadcasting. Specifically, it should work within a MySQL database. It needs to be able to send messages to specific groups and individual users. Ideal freelancer skills and experience: - Extensive Python development experience - Familiarity with Telegram bots & APIs - Understanding of MySQL databases and how to implement t...

I'm in need of a proficient Flutter Mobile App developer with experience in Go API and MySQL. The project involves building a social networking app with a unique twist - a matching interface for filtering companies and related attributes. Key Features: - User Profiles: Ability to create, edit, and maintain personal profiles. - Messaging System: Secure and seamless communication among users. - Matching Interface: A smart algorithm that matches users to companies based on shared industry interests and investment potential. Ideal Skill Set and Experience: - Proficient in Flutter, Go API, and MySQL - Experience in developing social networking apps - Understanding of matching algorithms - Familiarity with e-commerce platforms would be a plus. The final application needs...

I need the exact same description added to all products short and main description fields, there are around 20,000 products and I can provide Mysql access if thats the quickest way

I am looking for a seasoned Python developer with experience in Telegram bots. The bot should automate responses and facilitate user registration/authentication. It will need to link with external APIs. The mai...functionalities: - Auto-reply messages - User registration and authentication - Integration with external APIs - Capability to handle multi broadcast systems The bot should be able to handle all databases in one system for efficient broadcasting. Specifically, it should work within a MySQL database. It needs to be able to send messages to specific groups and individual users. Ideal freelancer skills and experience: - Extensive Python development experience - Familiarity with Telegram bots & APIs - Understanding of MySQL databases and how to implement t...

I'm dealing with a persistent issue on my WordPress page; an error message stating "Error establishing a database connection". This issue arose not long after installing some new plugins, suggesting a possible correlation. I need a knowledgeable freelancer to investigate this issue and correct the error. Skills and Experience Required: - Proven experience in WordPress troubleshooting. - Deep understanding of WordPress plugins and potential conflicts. - Mastery in diagnosing and resolving database connection errors. Role and Responsibilities: - Analyze and identify the root cause of the "Error establishing a database connection". - Fix the error, ensuring the page loads smoothly. - Ensure new adjustments do not interfere with the site's ...

I need an experienced developer adept in php, laravel, html, css, mysql and web app development to construct a user-friendly platform for both customers and admins. Key functionalities should include: - User Registration & Authentication: A secure system that allows both customers and admins to register and login with user-specific permissions. - Data Management & CRUD Operations: Provision for administrators to create, read, update, and delete data efficiently. - Reporting & Analytics: The system should be able to generate data reports, track, and analyze user activities for insightful decisions. Ideal qualifications include: - Proficient in PHP, Laravel, HTML, CSS, MySQL - Solid experience in web apps development - Strong knowledge in user authentication -...

I'm in need of a proficient developer to create a custom program designed for data visualization, database querying, and alert generation. The specifics of this project are detailed in an attached document, but to enable interested developers to make an informed bid, here's an overview: - The program should be capable of making specific database queries to extract, to a MySql DB. - The queried data will need to be presented in a visually clean and engaging format, with different types of visualizations such as charts, graphs, and tables. - The program should include an alerting system through email for important updates or changes. - Data exports in a PDF format should be possible. - The program will need a customizable configuration file for adjusting db qu...