Drumbeat Paris at La Cantine (01/07/2010)

for the iBad fans, check my Apple page!

#drumbeat on identi.ca and Twitter, pic by @msurman, flickr including @kerolic's pics.

Format

  • presentation
  • 15sec round room presentation
  • spectrogram to (physically) take position
    • The web is open
    • Facebook has a positive impact on the web
    • governments must make the web more open
  • 5min projects presentation
  • break (food! alcohol!)
  • group discussions
  • 2min sum ups in French and English
  • last minutes never-ending but still very nice discussions ;)

5min projects presentations

  1. Seeks
    1. notes coming soon
    2. my contribution
      1. shared GoogleIsEvil which was already listing Seeks
  2. Pippi
    1. notes coming soon
    2. my contribution
      1. ask about FSF Stet and phylogenetic tools applied to wiki history analysis
      2. shared Internet#LegislativeUpdates
      3. failed to share WikiLawMonitor
  3. Great Green Open Web
    1. notes coming soon
    2. my contribution
      1. shared Berkeley FSM Cafe VU-meter, Sustainable Server Farm
      2. failed to share Energy
  4. GML
    1. notes coming soon
    2. my contribution
      1. proposed the "input" module through recognition and geo-mapping of existing graphs in a city
  5. Shagai
    1. notes coming soon
  6. Tatoeba
    1. notes coming soon
    2. my contribution
      1. shared http://sourcerer.ics.uci.edu/
  7. P2P School of Webcraft
    1. notes coming soon
    2. my contribution
      1. asked on the feedback loop and public criticism of proposed projects

Note that "my contribution" is in no way a "proprietary" thing, it only aims at distinguishing what the speaker "officially" said and what I had time to offer or ask.

  1. failed to share contact with Francois Taddei

discussions

Crisis management

notes coming soon

HTML5 slideshows

notes coming soon

Open video formats on the web

notes coming soon

..?

notes coming soon (really?)

(political) transparency workshop

  1. lower the participation threshold
    1. baisser la barriere a la participation
  2. engage a mass audience
    1. engager une audience de masse
  3. educate those people in using, understanding and building the tools
    1. eduquer ces citoyens a utiliser, comprendre et produire ces outils

Key tools presented

drumbeat.org/projects

Skimmed through before the actual event.

Visited links

Search engines queries (63), live blogging queries (46) and live wiki editing/reading (176 including 73 for this very page) URLs have been excluded. Please do not be offended if I didn't visit the dedicated page of your project as the whole evening was pretty fast paced. Time is local Paris time (CET, GMT+2:00 summer time).

How did I do that

  1. places.sqlite
    1. SELECT url,title,time(visit_date/1000000, 'unixepoch','localtime') as moment FROM moz_historyvisits, moz_places WHERE moz_historyvisits.place_id = moz_places.id and visit_date>1278000000719000 and visit_date<1278031858293000 and title not like "Fabien%"
      1. extra and url not like "%domain.tld%" to clean
    2. SELECT count(*) FROM moz_historyvisits, moz_places WHERE moz_historyvisits.place_id = moz_places.id and visit_date>1278000000719000 and visit_date<1278031858293000 and title like "Fabien%"
    3. export to CSV
      1. convert to PmWiki format :%s/"\(.*\)","\(.*\)","\(.*\)"/* \3 [[\1|\2]]/
  2. tools
    1. SQLite manager
    2. format
      1. Mozilla Firefox 3 History File Format Forensics Wiki
      2. Places.sqlite at MozillaZine Knowledge Base with its ERD Diagram
    3. Vi
    4. check Cookbook:DataQuery and PHP sqlite-query for proper pmWiki integration

SELECT title,url,time(visit_date/1000000, 'unixepoch','localtime') as moment FROM moz_historyvisits, moz_places WHERE moz_historyvisits.place_id = moz_places.id and visit_date>1278155639783000 and visit_date<1278184750262000 and url not like "" and title not like ""

To do

  1. separate my own links