🚀 Medial Secures Investment on Shark Tank India - Fueling the Future of Professional Social Networking. 🔥
Login

Back

Sanskar

Keen Learner and Exp... • 6h

Day 26 of learning python as a beginner. Topic: CRUD operations in python postgreSQL. I had tried to explore SQL database handling in python and someone suggested me that I should also try performing CRUD (Create, Read, Update and Delete) operations in it. Although I have performed CRUD using the code however it was my first time doing the same by using a SQL database. While programming I was getting ideas of using try except (error handling), using match case (for selection of operation) however I decided to stick to CRUD only for now. I created four functions to perform each operations and used with keyword which someone has suggested me. Some of the SQL keywords I used are as follows: 1. INT PRIMARY KEY: this means that the type of value will be an integer and the primary key means that it is necessary for it to be entered. 2. VARCHAR: you can call it like a string as it can take data with strings, integers, special characters etc. 3. CHAR: this is a one word character which I used to enter the value of gender. And here's my code and its result in both console and database.

Reply

More like this

Recommendations from Medial

Sanskar

Keen Learner and Exp... • 1d

Day 25 of learning python as a beginner. Topic: database handling. I used to write simple programs which just showed some text in the console when I started learning python. I didn't used to store that data somewhere because I didn't know how to.

See More
Reply

Hitendrasinh Chauhan

Software Engineer | ... • 24d

🚀 Open to Full Stack (.NET + Angular) Developer Role 🎯 I have 1 year of experience as a Full Stack Developer, working alongside my studies. I've built responsive web applications and robust backend systems. 🛠️ Tech Stack: ASP.NET (C#) | Angular

See More
Reply
1
3
Image Description
Image Description

Comet

#freelancer • 8m

What is SQL? "Guys, ever wondered how data analysts 'talk' to databases? It’s with SQL! Think of SQL as the language of data. Just like English or Hindi helps us communicate, SQL lets us interact with databases. Here’s the cool part: SQL is super

See More
3 Replies
5

Vikram Kumar Raju

Hey I am on Medial • 1y

I have lost my job in last month due to office politics, I am a seasoned python developer with skills in flask, html, css, SQL and bootstrap. Can anyone refer me. I had an experience of 7 months. Thanks in advance.

Reply
5

Sajal Kumar

CTO | Full stack dev... • 1y

Hey everyone, Can someone suggest me a good and cheapest cloud media database which can be used with mongodb and express where front-end is developed using react native

Reply
2

Sanskar

Keen Learner and Exp... • 14d

Day 12 of learning python as a beginner. Topic: object oriented programming (OOP). Yesterday I shared a journal taking app and many people suggested that it would be great if I used classes. Initially I was not aware of what classes actually are an

See More
Reply
2
Image Description
Image Description

Krish

CRITICAL THINKING|MA... • 6m

Any python cryptography expert, I have encrypted a data long back ago using python cryptography but cannot recover it now, even after checking all possible ways I have the key also but it's not working. Could anyone help

3 Replies
6
Image Description

Comet

#freelancer • 8m

Essential Python Topics for Data Analysts 😄👇 - Data Structures: Lists, Dictionaries, Sets, and Tuples. - NumPy: Array manipulation for numerical operations. - Pandas: Data manipulation and analysis with DataFrame. - Data Cleaning: Handling missin

See More
2 Replies
2
5

Download the medial app to read full posts, comements and news.