Back

Sanskar

Keen Learner and Exp... • 1m

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... • 1m

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 | ... • 2m

🚀 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

Comet

#freelancer • 9m

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
Image Description
Image Description

Yash

YoYo • 9m

I know the basics of python language like functions, file handling, stack, etc what should I learn in python to get the fastest internship or job as freshers

4 Replies
2

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
Image Description
Image Description

Krish

CRITICAL THINKING|MA... • 7m

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

PRAKHAR MISHRA

Associate Data Scien... • 3m

Hi I am PRAKHAR Mishra, I’m writing to express interest in Data Scientist data analytics or DevOps role.I bring 3 years of experience from the National Payments Corporation of India (NPCI), where I worked on critical products like UPI and RuPay, ha

See More
Reply
4

Vikram Kumar Raju

Validation Engineer • 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

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