Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
What is PyMySQL? It is a python library which is used for connecting MySQL database. It is completely written in Python and uses python for communicating with MySQL server. Compatible with Python 2.7 and python 3.x, and provides a simple and instinctive interface for connecting to the MySQL database, executing SQL queries and for retrieving results. Why PyMySQL? It does not require any additional software, it is easy to use, provides security that is it supports SSL connections for secure communication, hence it is a popular choice for building Python applications that require database connectivity. What is MySQL MySQL ... Read More
Python provides variety of libraries one of them is SQLAlchemy, it provides an Object Relational Mapping (ORM) system for working with databases, including PostgreSQL. It is used for the purpose of storing and managing huge amount of structured data by the developers. By connecting both of them we can create a more productive and efficient database. In this article, we will learn how to connect PostgreSQL with SQLAlchemy in Python. What is SQLAlchemy? It is a powerful library that helps in simplifying the process of working with the databases, and is widely used in web development and data analysis. ... Read More
EasyTAG comes in handy when editing associated text tags of an image, audio, or video. It is an open-source, cross-platform, feature-rich, and free tool released under the GNU General Public License. EasyTAG tool acts as a backbone for animation, video, audio, application, etc., in which the details of the files, like tags, data, and image information, can be edited. EasyTAG also supports ID3 tags using the tag manipulation library of the MAD project. Originally, EasyTAG was designed to organize the music collection and is available for different platforms, including Windows and macOS. EasyTAG currently has various features, including: ... Read More
To detect the user timezone with the name of the timzone itself, use the Internationalization API. This gives the name of the Timezone in which the user and the browser is being worked on. Detect Exact Timezone with Name Example To get the exact timezone name, we will use the Internationalization API − DOCTYPE html> Timezone document.getElementById("test").innerHTML = Intl.DateTimeFormat().resolvedOptions().timeZone; Output Get the Timezone (Difference between UTC ... Read More
What is Functional DependencyFunctional dependency in DBMS, as the name suggests is a relationship between attributes of a table dependent on each other. Introduced by E. F. Codd, it helps in preventing data redundancy and gets to know about bad designs.To understand the concept thoroughly, let us consider P is a relation with attributes A and B. Functional Dependency is represented by -> (arrow sign)Then the following will represent the functional dependency between attributes with an arrow sign −A -> BAbove suggests the following:ExampleThe following is an example that would make it easier to understand functional dependency −We have a ... Read More
The ready() method is used to make a function available after the document is loaded. Whatever code you write inside the $(document ).ready() method will run once the page DOM is ready to execute JavaScript code.ExampleYou can try to run the following code to learn how to use $(document).ready() method in jQuery:Live Demo jQuery Function $(document).ready(function() { $("div").click(function() { alert("Hello, world!"); }); }); Click on this to see a dialogue box.
The D flip-flop is a clocked flip-flop with a single digital input 'D'. Each time a D flip-flop is clocked, its output follows the state of 'D'. The D Flip Flop has only two inputs D and CP. The D inputs go precisely to the S input and its complement is used to the R input.Considering the pulse input is at 0, the outputs of gates 3 and 4 are at the 1 level and the circuit cannot convert state regardless of the value of D. The D input is sampled when CP = 1. If D is 1, the ... Read More
JavaScript is a famous programming language that is one of the core languages of the World Wide Web (WWW) alongside HTML and CSS. It allows the programmer to capture events and modify the Document Object Model (DOM). In this article we are going to see how we can make use of JavaScript to change the background color according to the location of the mouse cursor. Mousemove Event The mousemove is an event which gets fired at an element when the cursor of the mouse is moved, and it is still inside the element of concern. It gives us information about ... Read More
jQuery is a JavaScript library created to make event handling, CSS animation, Ajax, and DOM tree navigation and manipulation easier. In this article we are going to see how we can change the name of an element using jQuery. Algorithm We are going to follow a three−way procedure to change the name of any element using jQuery: Identify and select the element we want to change. Copy all the attributes of the selected element to a temporary object. Create a new element with the new name and copy all the attributes to it. Replace the old element with this ... Read More
JavaScript is a famous programming language that is one of the core languages of the World Wide Web (WWW) alongside HTML and CSS. It allows the programmer to capture events and modify the Document Object Model (DOM). In this article we are going to see how we can make use of JavaScript to change the text of the button whenever it is clicked with the help of localStorage. localStorage The localStorage is a read−only property of the window interface that allows the user to store data. The saved information is kept between browser sessions. The localStorage property is like sessionStorage, ... Read More