no-home.sql

select r.name from rubygems as r where id in (select distinct(r.id) from versions as v join rubygems as r on v.rubygem_id = r.id join linksets as l on r.id = l.rubygem_id join gem_downloads as d on d.rubygem_id = r.id   where v.metadata::jsonb ?| array['changelog_uri', 'source_code_uri', 'documentation_uri', 'wiki_uri', 'mailing_list_uri', 'bug_tracker_uri', 'mailing_list_uri'] and not v.metadata::jsonb ? 'homepage_uri' and l.home is not null) order by name;

                  name                   
-----------------------------------------
 absee
 actioncable
 actionmailer
 actionpack
 actionview
 activejob
 activemodel
 activerecord
 activestorage
 activesupport
 airship-client
 asciidoctor
 ascode
 attempt
 auther
 aws-eventstream
 aws-partitions
 aws-sdk
 aws-sdk-acm
 aws-sdk-acmpca
 aws-sdk-alexaforbusiness
 aws-sdk-amplify
 aws-sdk-apigateway
 aws-sdk-apigatewaymanagementapi
 aws-sdk-apigatewayv2
 aws-sdk-applicationautoscaling
 aws-sdk-applicationdiscoveryservice
 aws-sdk-appmesh
 aws-sdk-appstream
 aws-sdk-appsync
 aws-sdk-athena
 aws-sdk-autoscaling
 aws-sdk-autoscalingplans
 aws-sdk-batch
 aws-sdk-budgets
 aws-sdk-chime
 aws-sdk-cloud9
 aws-sdk-clouddirectory
 aws-sdk-cloudformation
 aws-sdk-cloudfront
 aws-sdk-cloudhsm
 aws-sdk-cloudhsmv2
 aws-sdk-cloudsearch
 aws-sdk-cloudsearchdomain
 aws-sdk-cloudtrail
 aws-sdk-cloudwatch
 aws-sdk-cloudwatchevents
 aws-sdk-cloudwatchlogs
 aws-sdk-codebuild
 aws-sdk-codecommit
 aws-sdk-codedeploy
 aws-sdk-codepipeline
 aws-sdk-codestar
 aws-sdk-cognitoidentity
 aws-sdk-cognitoidentityprovider
 aws-sdk-cognitosync
 aws-sdk-comprehend
 aws-sdk-comprehendmedical
 aws-sdk-configservice
 aws-sdk-connect
 aws-sdk-core
 aws-sdk-costandusagereportservice
 aws-sdk-costexplorer
 aws-sdk-databasemigrationservice
 aws-sdk-datapipeline
 aws-sdk-datasync
 aws-sdk-dax
 aws-sdk-devicefarm
 aws-sdk-directconnect
 aws-sdk-directoryservice
 aws-sdk-dlm
 aws-sdk-docdb
 aws-sdk-dynamodb
 aws-sdk-dynamodbstreams
 aws-sdk-ec2
 aws-sdk-ecr
 aws-sdk-ecs
 aws-sdk-efs
 aws-sdk-eks
 aws-sdk-elasticache
 aws-sdk-elasticbeanstalk
 aws-sdk-elasticloadbalancing
 aws-sdk-elasticloadbalancingv2
 aws-sdk-elasticsearchservice
 aws-sdk-elastictranscoder
 aws-sdk-emr
 aws-sdk-firehose
 aws-sdk-fms
 aws-sdk-fsx
 aws-sdk-gamelift
 aws-sdk-glacier
 aws-sdk-globalaccelerator
 aws-sdk-glue
 aws-sdk-greengrass
 aws-sdk-guardduty
 aws-sdk-health
 aws-sdk-iam
 aws-sdk-importexport
 aws-sdk-inspector
 aws-sdk-iot
 aws-sdk-iot1clickdevicesservice
 aws-sdk-iot1clickprojects
 aws-sdk-iotanalytics
 aws-sdk-iotdataplane
 aws-sdk-iotjobsdataplane
 aws-sdk-kafka
 aws-sdk-kinesis
 aws-sdk-kinesisanalytics
 aws-sdk-kinesisanalyticsv2
 aws-sdk-kinesisvideo
 aws-sdk-kinesisvideoarchivedmedia
 aws-sdk-kinesisvideomedia
 aws-sdk-kms
 aws-sdk-lambda
 aws-sdk-lambdapreview
 aws-sdk-lex
 aws-sdk-lexmodelbuildingservice
 aws-sdk-licensemanager
 aws-sdk-lightsail
 aws-sdk-machinelearning
 aws-sdk-macie
 aws-sdk-marketplacecommerceanalytics
 aws-sdk-marketplaceentitlementservice
 aws-sdk-marketplacemetering
aws-sdk-mediaconnect
 aws-sdk-mediaconvert
 aws-sdk-medialive
 aws-sdk-mediapackage
 aws-sdk-mediastore
 aws-sdk-mediastoredata
 aws-sdk-mediatailor
 aws-sdk-migrationhub
 aws-sdk-mobile
 aws-sdk-mq
 aws-sdk-mturk
 aws-sdk-neptune
 aws-sdk-opsworks
 aws-sdk-opsworkscm
 aws-sdk-organizations
 aws-sdk-pi
 aws-sdk-pinpoint
 aws-sdk-pinpointemail
 aws-sdk-pinpointsmsvoice
 aws-sdk-polly
 aws-sdk-pricing
 aws-sdk-quicksight
 aws-sdk-ram
 aws-sdk-rds
 aws-sdk-rdsdataservice
 aws-sdk-redshift
 aws-sdk-rekognition
 aws-sdk-resourcegroups
 aws-sdk-resourcegroupstaggingapi
 aws-sdk-resources
 aws-sdk-robomaker
 aws-sdk-route53
 aws-sdk-route53domains
 aws-sdk-route53resolver
 aws-sdk-s3
 aws-sdk-s3control
 aws-sdk-sagemaker
 aws-sdk-sagemakerruntime
 aws-sdk-secretsmanager
 aws-sdk-securityhub
 aws-sdk-serverlessapplicationrepository
 aws-sdk-servicecatalog
 aws-sdk-servicediscovery
 aws-sdk-ses
 aws-sdk-shield
 aws-sdk-signer
 aws-sdk-simpledb
 aws-sdk-sms
 aws-sdk-snowball
 aws-sdk-sns
 aws-sdk-sqs
 aws-sdk-ssm
 aws-sdk-states
 aws-sdk-storagegateway
 aws-sdk-support
 aws-sdk-swf
 aws-sdk-transcribeservice
 aws-sdk-transfer
 aws-sdk-translate
 aws-sdk-waf
 aws-sdk-wafregional
 aws-sdk-workdocs
 aws-sdk-workmail
 aws-sdk-workspaces
 aws-sdk-xray
 aws-sigv2
 aws-sigv4
 aws-ssm-env
 awsutils
 axe-matchers
 braintree
 bullet
 c21e
 capistrano_confirm_branch
 capybara
 chunky_png
 consul
 cucumber-messages
 daemons
 discordrb
 dogapi
 double_entry
 dropybara
 dry-struct
 ducalis
 dump
 elastic-apm
 et-orbi
 fileutils
 flacsmith
 flexirest
 flipper
 flipper-active_record
 flipper-active_support_cache_store
 flipper-api
 flipper-dalli
 flipper-mongo
 flipper-redis
 flipper-ui
 geminabox
 gemsmith
 geocoder
 gherkin
 git-cop
 gitlab-markup
 goldencobra
 hanami-cli
 helix_runtime
 i18n
 ibm_watson
 idlc-sdk-deploy
 idlc-sdk-pfm
 image_optim
 image_optim_pack
 in_threads
 jekyll-asciidoc
 jira-ruby
 job-iteration
 jwt_signed_request
 lineage
 linguist
 loaf
 mailgunner
 metrician
 milestoner
 money
 navigator
 nexmo
 optimist
 panko_serializer
 pdftoimage
 pennyworth
 pHash
 postmark-rails
 pragmater
 prawn_plus
 rack-attack
 rack-mini-profiler
 railties
 rb-fsevent
 refinements
 resourcer
 restforce
 retryable
 roda
 rouge
 rspec_junit_formatter
 rspec-rails
 rubocop-rspec
 runcom
 ru_propisju
 sass
 selenium-webdriver
 senti
 sequel
 sessioner
 signet
 site_prism
 sorter
 sublime_text_kit
 test-unit
 thin
 tocer
 tokener
 trollop
 versionaire
 waxseal
 webpacker
 xeroizer
 yoginth
(294 rows)