Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Python is a highly multipurpose programming language with a vast network of libraries and frameworks that has capabilities beyond the standard language features. Arcade is one of the libraries used for creating graphics and handling user input. It uses basic shapes like circles and lines, a gradient approach, and many other techniques for creating attractive graphics. In this article, we will learn different methods for drawing a sun using the Arcade library in Python. Arcade Library and Its Features Arcade library is a Python library built on top of Pyglet, a multimedia library for python. It is a python library ... Read More
Excel is a strong programme that is frequently used for reporting, data analysis, and data manipulation. You could frequently get into circumstances while working with date and time data where you need to split the date portion from the time portion. With the integer portion representing the date and the decimal portion indicating the time, Excel stores date and time values as serial numbers. This step-by-step tutorial will show you how to use a variety of techniques to eliminate the time element from date values in Excel. We will investigate straightforward yet efficient methods to extract only the date while ... Read More
Powerful spreadsheet programmes like Excel provide a wide range of features to alter and clean up data. Getting rid of text that comes before or after a specific character in a cell is a common data cleaning activity. In this article, we'll walk you through each step of how to complete this work using the built-in functions in Excel. Excel offers the tools you need to organise your data and save time, whether you need to get rid of prefixes, suffixes, or any other undesirable text. Whether you're a novice or a seasoned Excel user, becoming proficient in text manipulation ... Read More
Django is a popular web framework written in python, helps the web developers to create web applications efficiently. One of the most important features of Django is the built-in functions known as shortcuts. These shortcuts help in providing useful features for completing the task. In this article, we will be learning about one of the commonly used shortcuts in Django which is ‘get_list_or_404()’. What is Django Shortcut Module? This is a collection of useful functions which can be used for completing the operations such as rendering templates, handling errors, etc. Some of the commonly used shortcut module are render(), ... Read More
SQLAlchemy is one of the popular Python libraries used for working with the databases. It offers a high-interface for connecting to variety of databases, including MySQL, PostgreSQL, and MongoDB. So, with the help of SQLAlchemy, Python codes can be written which interacts with the database in a more meaningful and intuitive way, that is without writing the SQL queries directly. In this article, we will discuss how to connect to a SQL database using SQLAlchemy in Python. First of all, let us understand what is and SQL database and what is SQLAlchemy. SQL Database A SQL database is ... Read More
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