Get creative! Mix and match filters to achieve your desired results.
Wildcard matching
SELECT latest_upload_date,first_upload_date,name,rank,description,latest_release_published_at,package_manager_url,repository_url,maintainers,homepage,stars,latest_release_number,forks,total_versions
FROM pypi
WHERE name LIKE '%atlass%'
This search attempts to find packages typo squatting on the name atlassian.
Filtering by first_upload_date
SELECT first_upload_date,name,rank,description,latest_release_published_at,package_manager_url,repository_url,maintainers,homepage,stars,latest_release_number,forks,total_versions
FROM pypi
WHERE first_upload_date < '2023-06-12' AND first_upload_date > '2023-06-04'
This is useful for reviewing recent packages uploaded.
Filtering by repository_url
SELECT first_upload_date,name,rank,description,latest_release_published_at,package_manager_url,repository_url,maintainers,homepage,stars,latest_release_number,forks,total_versions
FROM pypi
WHERE repository_url='https://github.com/pypa/sampleproject'
This is useful for finding packages linking to the same Github project.
Filtering by stars
SELECT first_upload_date,name,rank,description,latest_release_published_at,package_manager_url,repository_url,maintainers,homepage,stars,latest_release_number,forks,total_versions
FROM pypi
WHERE stars>1000
This is useful for reviewing packages with a large amount of Github stars.