Tarun Sharmatapstechie.hashnode.dev·Dec 19, 2024What is ORM and How it is Helpful to Us?Introduction to ORM Imagine you’re a developer managing a complex web application for an e-commerce platform. You’re dealing with tons of data: customer records, order details, inventory management, and more. Each day, you write SQL queries to insert...ORM (Object-Relational Mapping)
Anix Lynchgozeroshot.dev·Dec 6, 2024Python Automation #3: Data ingestion w/pandas, SQLAlchemy, dataprep.connector, petl1. Read Data from CSV, Excel, or JSON (pandas.read_csv, pandas.read_excel, pandas.read_json) Read CSV: import pandas as pd # Read data from CSV df = pd.read_csv("data.csv") print(df.head()) Output (Sample): ID Name Age 0 1 Alice 25 1 2 ...dataprep.connector
Rhoda Oduro-Nyarkorhodalee.hashnode.dev·Nov 30, 2024Securely Managing Database Credentials in Python with dotenvIntroduction Before pushing your code to GitHub, you may want to hide some sensitive information from the public eye 👀.We can make use of the ‘dotenv’ module in Python. The dotenv Python module helps us to load environment variables from a ‘.env’ fi...38 readsPython
Breanna Humphresbrehumphres.hashnode.dev·Oct 23, 2024Phase 4 Wrap-Up: A Team Project to RememberPhase 4 was all about new challenges and exciting wins. This time, I got to work with a team, and I absolutely loved the experience. We built a Gaming Tournament App called GameVerse that lets users create, browse, and sign up for tournaments. It was...womenwhocode
Grivine Balabala-grivine.hashnode.dev·Oct 21, 2024Optimize Data Retrieval in Python with Time-based API PaginationIn the modern application development, APIs(Application Programming Interfaces) serve as the core mechanism for connecting various systems and enabling seamless data exchange. An API is a way for different software systems to communicate with one ano...APIs
Grivine Balabala-grivine.hashnode.dev·Oct 19, 2024FastAPI Tutorial: Creating a CRUD Application EasilyFastAPI is a modern, fast(high-performance), web framework for building APIs with Python 3.7+ based on standard Python type hints. FastAPI uses ASGI(Asynchronous Server Gateway Interface) instead of WSGI. ASGI supports asynchronous programming, which...FastAPI
Anix Lynchgozeroshot.dev·Oct 4, 202420 SQLalchemy concepts with Before-and-After Examples1. Connecting to a Database 🔌 Boilerplate Code: from sqlalchemy import create_engine engine = create_engine('sqlite:///mydatabase.db') Use Case: Connect to a database (e.g., SQLite, PostgreSQL, MySQL) to perform queries and operations. Goal: Estab...sqlalchemy
kennedy musyokikenedy4.hashnode.dev·Sep 24, 2024Introduction to Backend Programming; BasicsGetting Started In my previous post I boosted myself of being conversant Frontend basic skills and tools; Html, CSS, JavaScript, and React. In this post, I am happy to announce that over the last one month, I have managed to get a grasp of Backend d...1 likeJavaScript
Callme-Miladitz-amethyst.hashnode.dev·Aug 17, 2024Optimizing Database Tables with Generics: Python and SQLAlchemy ApproachIt's not always shortened to types, but indeed we can use this method to optimize our tables. In this article, we'll follow the structure of benefiting from generics in models. Tech used in this article: Python FastAPI PostgreSQL SQLAlchemy Wit...FastAPI
Cosmin Marian Padurarunimsoc.com·Aug 15, 2024How to Recover the Model from a Subquery with SQLAlchemyDisclaimer: This guide offers an alternative explanation to the official SQLAlchemy documentation on subqueries, providing more visual examples and simpler explanations. The information is based on SQLAlchemy==2.0.30, and newer versions or features m...84 readsPython
