fetching a list of all public pads

[Daniel Reeves]

In Etherpad 1.0 I could run this to get a list of all pad names,
ordered by how recently they were touched:
select id from PAD_SQLMETA order by lastWriteTime DESC, headRev DESC

I'm looking for the preferred way to do this in Etherpad Lite.

Thanks everyone!

--
http://dreev.es  --  search://"Daniel Reeves"

[John McLear]

https://github.com/Pita/etherpad-lite/issues/442 

https://github.com/Pita/etherpad-lite/issues/103 

[Daniel Reeves]

Thanks John!

A really dumb question: what's up with the etherpad_lite database?
There's apparently only one table (store) with 2 columns (key, value).
Can I not realistically do any database queries directly for this kind
of thing?

Follow the Yellow Brick Road -- http://beeminder.com

[John McLear]

It's a key value store.

http://duckduckgo.com/?q=key+value+store 

[Daniel Reeves]

Thanks, I knew it was a dumb question :) but I guess my real question
is what's the interface to it? Seems like I can't do much in the way
of mysql queries...

[Daniel Reeves]

I put this in another thread but I'll answer myself here too, for
posterity (ie, future folks searching the archives):

My awesome friend Rob Felty wrote this for extracting the full list of
public pads, sorted by number of revisions:

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 }}'

We couldn't see a way to sort it by last modification time.