DEV Community: Gokil

GrilScript Summer of code

Gokil — Sun, 11 Aug 2024 07:30:37 +0000

GirlScript Summer of Code (GSSOC): Empowering Coders and Building Communities

The GirlScript Summer of Code (GSSoC) is a yearly, three-month open-source program. It brings together eager students and professionals from different backgrounds to work on real projects. As one of the biggest and most inclusive coding programs in India, GSSoC promotes technical skills, community building, and mentorship. This blog will explore what GSSoC is about, its structure, benefits, and how you can join.

What is GSSoC?
GSSoC, initiated by the GirlScript Foundation, is designed to promote open source contributions among students and beginners. It spans over three months, typically from March to June, and includes participants from across the globe. The program provides an opportunity to work on a variety of open-source projects, ranging from web development to machine learning, under the guidance of experienced mentors.

Why Participate in GSSoC?
Skill Enhancement: Participants gain hands-on experience in coding, debugging, and collaborating on large-scale projects. This practical exposure is invaluable for budding developers.

Mentorship: GSSoC offers a robust mentorship system where experienced developers guide participants through the intricacies of project development and open-source contributions.

Networking: The program connects participants with a global community of coders, developers, and industry experts. This network can open doors to future collaborations, internships, and job opportunities.

Real-world Impact: Contributions made during GSSoC are not hypothetical exercises but actual improvements to existing projects, benefiting real users and communities.

Structure of GSSoC
Application Process: Interested participants and mentors apply through the GirlScript Foundation's portal. Selection is based on prior experience, enthusiasm, and project fit.

Community Bonding: Before coding begins, there is a period dedicated to community bonding. Participants familiarize themselves with the project repositories, mentors, and fellow contributors.

Coding Period: The core of GSSoC, where participants work on their assigned projects. Regular check-ins, evaluations, and feedback sessions ensure progress and learning.

Evaluation and Rewards: Participants are evaluated based on their contributions, commitment, and collaboration. Top performers receive recognition, certificates, and sometimes prizes.

Success Stories
Many participants of GSSoC have gone on to achieve significant milestones in their careers. The program has alumni who have landed roles at top tech companies, secured prestigious internships, and even started their own ventures. Their stories are a testament to the transformative power of GSSoC.

How to Get Involved
As a Participant: Keep an eye on the GirlScript Foundation's official website and social media channels for announcements regarding application openings. Prepare by contributing to open-source projects on platforms like GitHub to build your profile.

As a Mentor: Experienced developers and professionals can apply to mentor. Sharing your expertise and guiding new coders can be a fulfilling way to give back to the community.

As an Organization: Companies and organizations can support GSSoC by sponsoring the event, providing projects for participants to work on, or offering resources and workshops.

Conclusion
The GirlScript Summer of Code is more than just a coding program; it's a movement towards inclusive and collaborative growth in the tech industry. Whether you're a beginner looking to break into the world of open-source development or an experienced coder wanting to mentor and shape the next generation of developers, GSSoC has something valuable to offer. Join the movement, contribute to meaningful projects, and be a part of a community that is shaping the future of technology.

For more information and updates, visit the official GSSoC website and follow them on social media.

Technology has become an integral part of our daily lives, shaping how we communicate, work, learn, and entertain ourselves. It continues to evolve at a rapid pace, offering endless possibilities and opportunities for innovation.

As we embrace the advancements in technology, it's essential to consider the ethical implications, ensure inclusivity, and strive for sustainability to create a better future for all.

If you found this blog post helpful, please consider sharing it with others who might benefit. You can also follow me for more content on web Development topics.

For Paid collaboration mail me at: gokilp25@mail.com

Connect with me on Twitter, LinkedIn, and GitHub.

SQL Beginner

Gokil — Tue, 23 Jul 2024 00:19:08 +0000

Database

A database is an organized collection of structured information or data, typically stored electronically in a computer system. Let me provide you with more details:

Definition:

A database consists of data that is logically organized and efficiently managed. It can store various types of information, such as text, numbers, images, and more. Databases are usually controlled by a Database Management System (DBMS).

Key Features:

Structured Data: Data within databases is typically modeled in rows and columns, organized into tables for efficient processing and querying. Access and Management: Databases allow easy access, modification, and organization of data. SQL: Most databases use Structured Query Language (SQL) for writing and querying data.

Evolution of Databases:

1960s - Hierarchical Databases: Organized data in tree-like structures (e.g., IBM's IMS).

Late 1960s to early 1970s - Network Databases: Introduced many-to-many relationships (network model).

1970s - Relational Databases: Edgar F. Codd's relational model with tables, keys, and relationships (e.g., Oracle, MySQL).

1970s - SQL (Structured Query Language): Standard language for relational databases.

1980s to 1990s - Object-Oriented Databases: Stored data in objects (OODBMS).

2000s onwards - NoSQL Databases: Scalable, flexible solutions for unstructured data (e.g., MongoDB, Cassandra).

2010s onwards - NewSQL Databases: Blend of SQL and NoSQL features for high-throughput workloads.

Present - Cloud and Serverless Databases: Scalable, managed solutions in the cloud with serverless options (e.g., AWS RDS, Azure SQL Database, Google Cloud Spanner).

Difference Between Databases and Spreadsheets:
Databases:

Designed for large collections of organized information.

Allow multiple users simultaneous access using complex logic and language. Spreadsheets (e.g., Microsoft Excel):

Originally designed for single users.

Suitable for simpler data manipulation.

DBMS

Database Management System (DBMS) acts as an interface between the database and end-users.

It is software used to store, retrieve, define, and manage data in a database.

Supports easy CRUD operations (Create, Read, Update, Delete).

Manages authentication, concurrency, logging, backup, optimization, etc.

Types of Databases:

Hierarchical databases

Network databases

Object-oriented databases

Relational databases

Cloud Database

Centralized Database

Operational Database

NoSQL databases

Relational Data Base
A Relational Database is a type of database that organizes data into tables with predefined relationships between them. This type of database follows the relational model, which was first proposed by Edgar F. Codd in 1970. Relational databases are based on the principles of relational algebra and use Structured Query Language (SQL) for querying and managing data.

Key features of relational databases include:
Tables: Data is stored in tables, where each table represents an entity (e.g., customers, products, orders) and consists of rows and columns. Each row in a table represents a record or instance of the entity, and each column represents an attribute or property of the entity.

Relationships: Relational databases establish relationships between tables using keys. The primary key uniquely identifies each record in a table, while foreign keys establish links between related tables. Common types of relationships include one-to-one, one-to-many, and many-to-many.

Normalization: Relational databases use normalization techniques to reduce redundancy and improve data integrity. Normalization involves organizing data into multiple related tables to avoid data duplication and inconsistencies.

ACID Properties: Relational databases adhere to the ACID properties, which ensure data consistency, reliability, and atomicity. ACID stands for Atomicity, Consistency, Isolation, and Durability.

Structured Query Language (SQL): Relational databases use SQL for querying and manipulating data. SQL allows users to perform operations such as selecting, inserting, updating, and deleting data, as well as defining database structures and constraints.

Examples of popular relational database management systems (RDBMS) include:

MySQL: An open-source RDBMS widely used for web applications and small to medium-sized databases.

PostgreSQL: An open-source RDBMS known for its advanced features, scalability, and extensibility.

Oracle Database: A commercial RDBMS known for its robustness, scalability, and enterprise-level capabilities.

Microsoft SQL Server: A commercial RDBMS developed by Microsoft, commonly used in Windows-based environments and enterprise applications.

SQLite: A lightweight, embedded RDBMS suitable for mobile apps, IoT devices, and small-scale applications.

SQL?
SQL stands for Structured Query Language is a computer language that we use to interact with a relational database. SQL is a tool for organizing, managing, and retrieving archived data from a computer database. The original name was given by IBM as Structured English Query Language, abbreviated by the acronym SEQUEL.

When data needs to be retrieved from a database, SQL is used to make the request. The DBMS processes the SQL query retrieves the requested data and returns it to us. Rather, SQL statements describe how a collection of data should be organized or what data should be extracted or added to the database.

SQL Data Base
Mysql ⇒ Open Source

SQL Server ⇒ Microsoft

Oracle ⇒ IBM

PostgreSQL ⇒ Opensource

SQL REQUIRES

/*
  multiline command line
 /*

 -- single command line

DataTypes

Character Data

char - eg:char(5) stores fixed length string of length 5. Max 255 bytes.

varchar - eg:varchar(5) stores variable length string of length 5. Max 65535 bytes.

SHOW CHARACTER SET; -- shows various character sets that are supported.

latin1 is the default character set. We can also choose a specific character set like below,

varchar(10) character set utf8    -- the particular column is set to utf8
create database foreign_sales character set utf8;   -- entire database is set to utf8

Text Data

All images in the section are from Learning SQL by Alan Beaulieu

BLOB - Binary Large Object File → TinyBlob, Blob, MediumBlob, LongBlob

Numerical Data

Whole Numbers:BLOB - Binary Large Object File → TinyBlob, Blob, MediumBlob, LongBlob

Numerical Data

Whole Numbers:

Tinyint is used to store Bool or Boolean

Decimal Numbers:

Mastering Keyboard Shortcuts for Enhanced Productivity

Gokil — Sun, 21 Jul 2024 14:28:37 +0000

In the digital age, being efficient and fast at typing isn't just about quick fingers; it's also about mastering keyboard shortcuts. Keyboard shortcuts can greatly boost your productivity by cutting down the time spent on repetitive tasks. Here’s a complete guide to understanding and using keyboard shortcuts effectively, along with resources to practice and improve your typing skills.

Essential Keyboard Shortcuts

Basic Text Editing

Ctrl + Backspace: Deletes the word to the left of the cursor.

Shift + Home + Backspace: Deletes the entire line where the cursor is located.

Home/End: Moves the cursor to the beginning or end of the current line.

Navigation

Ctrl + Arrow Key: Moves the cursor one word at a time, speeding up navigation in text.

Shift + Arrows: Highlights text character by character.

Ctrl + Shift + Arrows: Selects entire words or lines, making text manipulation faster.

Window Management

Ctrl + W: Closes the current window, useful for quick closing of tabs in browsers or documents.

Practice Websites

To get better at typing and using these shortcuts, regular practice is crucial. Here are two websites that can help:

10FastFingers: Offers typing tests in various languages to improve typing speed and accuracy.

*Keyboard *: Provides practice lessons that adapt to your skill level, focusing on areas that need improvement.

Understanding Keyboard Shortcut Applications

Notion Shortcuts

Cmd + F1: Sets the heading of the page in Notion, a popular productivity tool.

Search Shortcut

Ueli: This is an application launcher for Windows that functions similarly to Spotlight on macOS, allowing you to start applications and find files with just a few keystrokes.

key board shortcut

Ctrl + back space => delete words

Shift + home + back space => delete whole Line

Ctrl + arrow Key  => Navigate lines

shift + arrows => Hightlight the word 

Ctrl + shift + arrows => Select the text of word 

Home/end => Starting a line end of line 

Ctrl + w => close the Window

practice  website 

https://10fastfingers.com/

https://www.keybr.com/

Under Standing Key board Short cut application

Notion Shortcut 

cmd f1 => heading of page 

Search Shortcut 

Ueli app => spot light app like apple

Conclusion

Mastering keyboard shortcuts is like learning a musical instrument; the more you practice, the better you get. Integrating these shortcuts into your daily routine will not only boost your productivity but also make your computer usage more enjoyable. Start with the shortcuts listed above, practice regularly, and you’ll soon find yourself working more efficiently than ever.

Thank you for reading! If you found this helpful, follow me on Twitter and LinkedIn for more tips and updates.

Css

Gokil — Fri, 03 Nov 2023 04:37:52 +0000

Cascading Style Sheets

CSS stands for Cascading Style Sheets
CSS describes how HTML elements are to be displayed on screen, paper, or in other media
CSS saves a lot of work. It can control the layout of multiple web pages all at once
External stylesheets are stored in CSS files
CSS is used to define styles for your web pages, including the design, layout and variations in display for different devices and screen sizes
The selector points to the HTML element you want to style.
The declaration block contains one or more declarations separated by semicolons.
Each declaration includes a CSS property name and a value, separated by a colon.
Multiple CSS declarations are separated with semicolons, and declaration blocks are surrounded by curly braces.