🔍
CSAPP
  • 🔍CSAPP
  • Overview
    • 💡Why??
    • ✨Features
      • ⛏️pypi_data_harvest.py
      • 🗃️pypi_package_validator.py
      • 🎯audit_pypi_info_db.py
  • Fundamentals
    • 🛠️Getting set up
  • Web App Walkthrough
    • 🏠Homepage
    • 🧐Explore Page
  • Threat Hunting
    • 📔PyPI's Terms of Use
    • ❔Useful SQL Queries
    • 🕵️‍♂️Analyzing A Python Package
    • 👾Malicious Package Techniques
    • 🎯Hunting Tips
Powered by GitBook
On this page

Last updated 1 year ago

The default SELECT statement contains the most important fields I consider useful for analysis. The FROM statement will always be the same, CSAPP only has one table, so don't change it. The WHERE statement is for you to add filters to only display the records of your choosing.

Example Query

The query results are returned in a table view that can be expanded to full screen. Select the columns to quickly sort the data. The total records are displayed below with an option to download the results into a separate CSV file.

The following query will return packages that were first uploaded between two dates. This is useful for reviewing recent package uploads to .

pypi.org
PreviousHomepageNextPyPI's Terms of Use
  1. Web App Walkthrough

🧐Explore Page

The Explore page lets you write a SQL query and display the matching records.