| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 20:30:37 GMT
content-type: text/html; charset=utf-8
vary: X-PJAX, X-PJAX-Container, Turbo-Visit, Turbo-Frame, X-Requested-With,Accept-Encoding, Accept, X-Requested-With
x-robots-tag: none
etag: W/"34dd7b3cc0be1118c5925f5b6d108d36"
cache-control: max-age=0, private, must-revalidate
strict-transport-security: max-age=31536000; includeSubdomains; preload
x-frame-options: deny
x-content-type-options: nosniff
x-xss-protection: 0
referrer-policy: no-referrer-when-downgrade
content-security-policy: default-src 'none'; base-uri 'self'; child-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/; connect-src 'self' uploads.github.com www.githubstatus.com collector.github.com raw.githubusercontent.com api.github.com github-cloud.s3.amazonaws.com github-production-repository-file-5c1aeb.s3.amazonaws.com github-production-upload-manifest-file-7fdce7.s3.amazonaws.com github-production-user-asset-6210df.s3.amazonaws.com *.rel.tunnels.api.visualstudio.com wss://*.rel.tunnels.api.visualstudio.com objects-origin.githubusercontent.com copilot-proxy.githubusercontent.com proxy.individual.githubcopilot.com proxy.business.githubcopilot.com proxy.enterprise.githubcopilot.com *.actions.githubusercontent.com wss://*.actions.githubusercontent.com productionresultssa0.blob.core.windows.net/ productionresultssa1.blob.core.windows.net/ productionresultssa2.blob.core.windows.net/ productionresultssa3.blob.core.windows.net/ productionresultssa4.blob.core.windows.net/ productionresultssa5.blob.core.windows.net/ productionresultssa6.blob.core.windows.net/ productionresultssa7.blob.core.windows.net/ productionresultssa8.blob.core.windows.net/ productionresultssa9.blob.core.windows.net/ productionresultssa10.blob.core.windows.net/ productionresultssa11.blob.core.windows.net/ productionresultssa12.blob.core.windows.net/ productionresultssa13.blob.core.windows.net/ productionresultssa14.blob.core.windows.net/ productionresultssa15.blob.core.windows.net/ productionresultssa16.blob.core.windows.net/ productionresultssa17.blob.core.windows.net/ productionresultssa18.blob.core.windows.net/ productionresultssa19.blob.core.windows.net/ github-production-repository-image-32fea6.s3.amazonaws.com github-production-release-asset-2e65be.s3.amazonaws.com insights.github.com wss://alive.github.com api.githubcopilot.com api.individual.githubcopilot.com api.business.githubcopilot.com api.enterprise.githubcopilot.com; font-src github.githubassets.com; form-action 'self' github.com gist.github.com copilot-workspace.githubnext.com objects-origin.githubusercontent.com; frame-ancestors 'none'; frame-src viewscreen.githubusercontent.com notebooks.githubusercontent.com; img-src 'self' data: blob: github.githubassets.com media.githubusercontent.com camo.githubusercontent.com identicons.github.com avatars.githubusercontent.com private-avatars.githubusercontent.com github-cloud.s3.amazonaws.com objects.githubusercontent.com release-assets.githubusercontent.com secured-user-images.githubusercontent.com/ user-images.githubusercontent.com/ private-user-images.githubusercontent.com opengraph.githubassets.com copilotprodattachments.blob.core.windows.net/github-production-copilot-attachments/ github-production-user-asset-6210df.s3.amazonaws.com customer-stories-feed.github.com spotlights-feed.github.com objects-origin.githubusercontent.com *.githubusercontent.com; manifest-src 'self'; media-src github.com user-images.githubusercontent.com/ secured-user-images.githubusercontent.com/ private-user-images.githubusercontent.com github-production-user-asset-6210df.s3.amazonaws.com gist.github.com; script-src github.githubassets.com; style-src 'unsafe-inline' github.githubassets.com; upgrade-insecure-requests; worker-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/
server: github.com
content-encoding: gzip
accept-ranges: bytes
set-cookie: _gh_sess=llcdhB1eN5kpYe8rrIE1oAcg0iCM5XsTOzUE%2Fef62kAKAJLDM7XQkWJhdPAkegWmzS4iW6zXU11qdnDGaHCUg3DLzGF76B23rHFHoP9IbPneMdoHLmVgkJItDAVGc%2Bw%2FddQGlVASxrX1nzzHy8te5MajsvsGFz6adZusmNrrBTXYWZaKabq809PTZnLe153Ok%2B0CKf0uoZdVWWmkZUUXSCrD%2F1W7L9HB4OyY8s0u4n2SUUeyJlcBbC344cEJdkhd8N2eZKFhZZrP1ZXkAgZZKw%3D%3D--C2qCb8c%2Fz3nxJuRL--KYN4XYOFZeo3sM7IGeXEdw%3D%3D; Path=/; HttpOnly; Secure; SameSite=Lax
set-cookie: _octo=GH1.1.2015962179.1753302637; Path=/; Domain=github.com; Expires=Thu, 23 Jul 2026 20:30:37 GMT; Secure; SameSite=Lax
set-cookie: logged_in=no; Path=/; Domain=github.com; Expires=Thu, 23 Jul 2026 20:30:37 GMT; HttpOnly; Secure; SameSite=Lax
x-github-request-id: B566:941DF:109CA15:13BF84D:6881466D
How to list all pads · ether/etherpad-lite Wiki · GitHub
Skip to content
Navigation Menu
{{ message }}
-
-
Notifications
You must be signed in to change notification settings - Fork 2.9k
How to list all pads
funkykiwi edited this page Jul 14, 2022
·
8 revisions
This was posted to the mailing list by Daniel Reeves. The script was actually written by Rob Felty.
The following script will extract the full list of public pads sorted by number of revisions:
Remark: The script does not show new pads (where nothing is written on)
mysql -u USER -pPSW etherpad_lite -e 'select store.key from store' \
| grep -Eo '^pad:[^:]+' \
| sed -e 's/pad://' \
| sort \
| uniq -c \
| sort -rn \
| awk '{if ($1!="2") {print $2 }}'or even simpler (here also the new pads are shown):
select distinct substring(store.key,5,locate(":",store.key,5)-5) as "pads" from store where store.key like "pad:%"sqlite3:
#!/bin/bash
sqlite3 ./pad.db 'select store.key from store' \
| grep -Eo '^pad:[^:]+' \
| sed -e 's/pad://' \
| sort \
| uniq -c \
| sort -rn \
| awk '{if ($1!="2") {print $2 }}'PostgreSQL:
create or replace view v_pads as select substring(key from 'pad:(.*):revs:0') as name from store where key ~ 'pad:.*:revs:0' order by key;
select * from v_pads;Alternatively you can use Etherpad API.
ETHERPAD_HOST='https://pad.example.com'
ETHERPAD_API_KEY='...' # can be found in APIKEY.txt file in the Etherpad installation directory
ETHERPAD_API_VERSION='...' # can be found via https://pad.example.com/api
LIST_PADS_URL="${ETHERPAD_HOST}/api/${ETHERPAD_API_VERSION}/listAllPads?apikey=${ETHERPAD_API_KEY}"
curl -s -X GET "${LIST_PADS_URL}" | jq -r '.data.padIDs[]'- Docs
- Translating
- HTTP API
- Plugin framework (API hooks)
- Plugins (available)
- Plugins (list)
- Plugins (wishlist)
- Etherpad URIs / URLs to specific resources IE export
- Etherpad Full data export
- Introduction to the source
- Release Procedure
- Etherpad Developer guidelines
- Project to-do list
- Changeset Library documentation
- Alternative Etherpad-Clients
- Contribution guidelines
- Installing Etherpad
- Deploying Etherpad as a service
- Deploying Etherpad on CloudFoundry
- Deploying Etherpad on Heroku
- Running Etherpad on Phusion Passenger
- Putting Etherpad behind a reverse Proxy (HTTPS/SSL)
- How to setup Etherpad on Ubuntu 12.04 using Ansible
- Migrating from old Etherpad to Etherpad
- Using Etherpad with MySQL
- Customizing the Etherpad web interface
- Enable import/export functionality with AbiWord
- Getting a list of all pads
- Providing encrypted web access to Etherpad using SSL certificates
- Optimizing Etherpad performance including faster page loads
- Getting to know the tools and scripts in the Etherpad /bin/ folder
- Embedding a pad using the jQuery plugin
- Using Embed Parameters
- Integrating Etherpad in a third party app (Drupal, MediaWiki, WordPress, Atlassian, PmWiki)
- HTTP API client libraries
Clone this wiki locally
You can’t perform that action at this time.