René's URL Explorer Experiment


Title: GitHub - developer-led/community-sql: Query your Discourse community with PostgreSQL

Open Graph Title: GitHub - developer-led/community-sql: Query your Discourse community with PostgreSQL

X Title: GitHub - developer-led/community-sql: Query your Discourse community with PostgreSQL

Description: Query your Discourse community with PostgreSQL. Contribute to developer-led/community-sql development by creating an account on GitHub.

Open Graph Description: Query your Discourse community with PostgreSQL. Contribute to developer-led/community-sql development by creating an account on GitHub.

X Description: Query your Discourse community with PostgreSQL. Contribute to developer-led/community-sql development by creating an account on GitHub.

Opengraph URL: https://github.com/developer-led/community-sql

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:31242088-9e94-e254-88f7-6d119970d768
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-idC066:DC652:9A882F:CFF718:698E3C07
html-safe-noncea16a0d6acc57226b04ff99fe69d8ea6832ecb6d690361248c50e48487f5244dc
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMDY2OkRDNjUyOjlBODgyRjpDRkY3MTg6Njk4RTNDMDciLCJ2aXNpdG9yX2lkIjoiNzMxNDI1MDg1Mzc0NDc5MzY3IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac0fdc7cc1fb255659b2b6a72e2973052f76fb8fa0b2f9ebb68f3bd240641efda1
hovercard-subject-tagrepository:1064005107
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/developer-led/community-sql
twitter:imagehttps://opengraph.githubassets.com/4f24884aee1d03d6233ffb49697363f56ea7488ce4fbc7fc8b91dced0b2c194c/developer-led/community-sql
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/4f24884aee1d03d6233ffb49697363f56ea7488ce4fbc7fc8b91dced0b2c194c/developer-led/community-sql
og:image:altQuery your Discourse community with PostgreSQL. Contribute to developer-led/community-sql development by creating an account on GitHub.
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Nonea5632af64f7fed7bff1d6a428d1aca1b94fa7a48f760de2d39d9b1effdbf0082
turbo-cache-controlno-preview
go-importgithub.com/developer-led/community-sql git https://github.com/developer-led/community-sql.git
octolytics-dimension-user_id232774121
octolytics-dimension-user_logindeveloper-led
octolytics-dimension-repository_id1064005107
octolytics-dimension-repository_nwodeveloper-led/community-sql
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id1064005107
octolytics-dimension-repository_network_root_nwodeveloper-led/community-sql
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releaseaa1fa9100f85cd8b602c63c7e337f9151e70024f
ui-targetcanary-1
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/developer-led/community-sql#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fdeveloper-led%2Fcommunity-sql
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fdeveloper-led%2Fcommunity-sql
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=developer-led%2Fcommunity-sql
Reloadhttps://patch-diff.githubusercontent.com/developer-led/community-sql
Reloadhttps://patch-diff.githubusercontent.com/developer-led/community-sql
Reloadhttps://patch-diff.githubusercontent.com/developer-led/community-sql
developer-led https://patch-diff.githubusercontent.com/developer-led
community-sqlhttps://patch-diff.githubusercontent.com/developer-led/community-sql
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fdeveloper-led%2Fcommunity-sql
Fork 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fdeveloper-led%2Fcommunity-sql
Star 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fdeveloper-led%2Fcommunity-sql
0 stars https://patch-diff.githubusercontent.com/developer-led/community-sql/stargazers
0 forks https://patch-diff.githubusercontent.com/developer-led/community-sql/forks
Branches https://patch-diff.githubusercontent.com/developer-led/community-sql/branches
Tags https://patch-diff.githubusercontent.com/developer-led/community-sql/tags
Activity https://patch-diff.githubusercontent.com/developer-led/community-sql/activity
Star https://patch-diff.githubusercontent.com/login?return_to=%2Fdeveloper-led%2Fcommunity-sql
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fdeveloper-led%2Fcommunity-sql
Code https://patch-diff.githubusercontent.com/developer-led/community-sql
Issues 0 https://patch-diff.githubusercontent.com/developer-led/community-sql/issues
Pull requests 0 https://patch-diff.githubusercontent.com/developer-led/community-sql/pulls
Actions https://patch-diff.githubusercontent.com/developer-led/community-sql/actions
Projects 0 https://patch-diff.githubusercontent.com/developer-led/community-sql/projects
Security 0 https://patch-diff.githubusercontent.com/developer-led/community-sql/security
Insights https://patch-diff.githubusercontent.com/developer-led/community-sql/pulse
Code https://patch-diff.githubusercontent.com/developer-led/community-sql
Issues https://patch-diff.githubusercontent.com/developer-led/community-sql/issues
Pull requests https://patch-diff.githubusercontent.com/developer-led/community-sql/pulls
Actions https://patch-diff.githubusercontent.com/developer-led/community-sql/actions
Projects https://patch-diff.githubusercontent.com/developer-led/community-sql/projects
Security https://patch-diff.githubusercontent.com/developer-led/community-sql/security
Insights https://patch-diff.githubusercontent.com/developer-led/community-sql/pulse
Brancheshttps://patch-diff.githubusercontent.com/developer-led/community-sql/branches
Tagshttps://patch-diff.githubusercontent.com/developer-led/community-sql/tags
https://patch-diff.githubusercontent.com/developer-led/community-sql/branches
https://patch-diff.githubusercontent.com/developer-led/community-sql/tags
29 Commitshttps://patch-diff.githubusercontent.com/developer-led/community-sql/commits/main/
https://patch-diff.githubusercontent.com/developer-led/community-sql/commits/main/
.githubhttps://patch-diff.githubusercontent.com/developer-led/community-sql/tree/main/.github
.githubhttps://patch-diff.githubusercontent.com/developer-led/community-sql/tree/main/.github
Querieshttps://patch-diff.githubusercontent.com/developer-led/community-sql/tree/main/Queries
Querieshttps://patch-diff.githubusercontent.com/developer-led/community-sql/tree/main/Queries
assetshttps://patch-diff.githubusercontent.com/developer-led/community-sql/tree/main/assets
assetshttps://patch-diff.githubusercontent.com/developer-led/community-sql/tree/main/assets
.gitignorehttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/.gitignore
.gitignorehttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/.gitignore
README.mdhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/README.md
README.mdhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/README.md
READMEhttps://patch-diff.githubusercontent.com/developer-led/community-sql
Code of conducthttps://patch-diff.githubusercontent.com/developer-led/community-sql
Contributinghttps://patch-diff.githubusercontent.com/developer-led/community-sql
https://developerled.substack.com/
https://patch-diff.githubusercontent.com/developer-led/community-sql#community-sql
Discoursehttps://www.discourse.org/
OpenAIhttps://community.openai.com/
MongoDBhttps://www.mongodb.com/community/forums/
Cursorhttps://forum.cursor.com/
Cloudflarehttps://community.cloudflare.com/
tierhttps://www.discourse.org/pricing
Data Explorerhttps://www.discourse.org/plugins/data-explorer
https://patch-diff.githubusercontent.com/developer-led/community-sql#one-step-backwards-discourse-dashboard
https://www.discourse.org/features
https://patch-diff.githubusercontent.com/developer-led/community-sql#what-is-discourse-data-explorer
Data Explorerhttps://www.discourse.org/plugins/data-explorer
https://www.discourse.org/plugins/data-explorer
https://patch-diff.githubusercontent.com/developer-led/community-sql#queries-queries-everywhere
Herehttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries
https://patch-diff.githubusercontent.com/developer-led/community-sql#️-high-level-queries
Those querieshttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level
Consolidated Pageviews By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/ConsolidatedPageviewsByMonth.sql
Get Pageviews By Group by Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetPageviewsByGroupByMonth.sql
FAQ Views By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/FAQViewsByMonth.sql
Forum High Level Activity Summaryhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/ForumHighLevelActivitySummary.sql
Get Number of Inactive and Active Usershttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetNumberOfInactiveAndActiveUsers.sql
Get Number of New Posts by Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetNumberOfNewPostsByMonth.sql
Get Number of New Topics By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetNumberOfNewTopicsByMonth.sql
Get Number of Topics Solved By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetNumberOfTopicsSolvedByMonthsql
Get Number of Topics With No Replyhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetNumberOfTopicsWithNoReply.sql
Get Reply Ratehttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetReplyRate.sql
Get Top Active Categories Based on Topics Counthttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetTopActiveCategoriesBasedOnTopicsCount.sql
Get Total Number of Users By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetTotalNumberOfUsersByMonth.sql
Get User Visits By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetUsersVisitsByMonth.sql
Get Number Of New Users By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetNumberOfNewUsersByMonth.sql
Get Active Users By Time Periodhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetActiveUsersByTimePeriod.sql
Get Users With No Activity Since Joininghttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/High-Level/GetUsersWithNoActivitySinceJoining.sql
https://patch-diff.githubusercontent.com/developer-led/community-sql#-member-specific-queries
the querieshttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific
Get Active Readershttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetActiveReaders.sql
Users Leaderboardhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/UsersLeaderboard.sql
Get Users With number of Badges Grantedhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetUsersWithNumberOfBadgesGranted.sql
Get Users Sending Most DMshttps://github.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetUsersSendingMostDMs.sql
Get Users Replies Within Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetUsersRepliesWithinMonth.sql
Get Top 100 Likershttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetTop100Likers.sql
Get Number Of Topics Solved By Employees By Monthhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetNumberOfTopicsSolvedByEmployeesByMonth.sql
Get Number Of Solutions By Users Since Account Creationhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetNumberOfSolutionsByUsersSinceAccountCreation.sql
Get Lurkershttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Member-Specific/GetLurkers.sql
https://patch-diff.githubusercontent.com/developer-led/community-sql#-admin-queries
Those querieshttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Admin
Find Category IDhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Admin/FindCategoryID.sql
Get Specific User Infohttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Admin/GetSpecificUserInfo.sql
Get Topics Solved But Not Closedhttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Admin/GetTopicsSolvedButNotClosed.sql
Get User Accounts Emailshttps://patch-diff.githubusercontent.com/developer-led/community-sql/blob/main/Queries/Admin/GetUsersAccountsEmails.sql
https://patch-diff.githubusercontent.com/developer-led/community-sql#how-to-contribute-or-report-bugs
https://patch-diff.githubusercontent.com/developer-led/community-sql#where-to-find-more-info
Discourse Data Explorer Official Sitehttps://www.discourse.org/plugins/data-explorer
Data Explorer Docshttps://meta.discourse.org/t/discourse-data-explorer/32566
Writing Queries & Schema Explorerhttps://meta.discourse.org/t/discourse-data-explorer/32566
Setting Group Based Access Control for Specific Querieshttps://meta.discourse.org/t/discourse-data-explorer/32566
Formatting Data Explorer Table Resultshttps://meta.discourse.org/t/formatting-data-explorer-table-results/277939
Utilizing Parameters in Data Explorer Querieshttps://meta.discourse.org/t/utilizing-parameters-in-data-explorer-queries/277934
Data Explorer Tutorial - Part 1https://meta.discourse.org/t/data-explorer-tutorial-part-1-writing-your-first-query/277925
Data Explorer Tutorial - Part 2https://meta.discourse.org/t/data-explorer-tutorial-part-2-discourse-sql-basics/277927
https://patch-diff.githubusercontent.com/developer-led/community-sql#developer-led-community
https://developerled.substack.com/
https://www.linkedin.com/company/developerled/
https://x.com/developerled
https://developerled.substack.com/
Readme https://patch-diff.githubusercontent.com/developer-led/community-sql#readme-ov-file
Code of conduct https://patch-diff.githubusercontent.com/developer-led/community-sql#coc-ov-file
Contributing https://patch-diff.githubusercontent.com/developer-led/community-sql#contributing-ov-file
Please reload this pagehttps://patch-diff.githubusercontent.com/developer-led/community-sql
Activityhttps://patch-diff.githubusercontent.com/developer-led/community-sql/activity
Custom propertieshttps://patch-diff.githubusercontent.com/developer-led/community-sql/custom-properties
0 starshttps://patch-diff.githubusercontent.com/developer-led/community-sql/stargazers
0 watchinghttps://patch-diff.githubusercontent.com/developer-led/community-sql/watchers
0 forkshttps://patch-diff.githubusercontent.com/developer-led/community-sql/forks
Report repository https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fdeveloper-led%2Fcommunity-sql&report=developer-led+%28user%29
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.