Patrick's playground

I've updated the sqlite DB index for my small pkg-search tool.
It contains the files of 8400 packages built for i686 now and is just under 100MB unpacked. Impressive!

To save some space I've switched to lzma for now. Saves near 20% on the compressed file, so less download for you. Thingy can be found here

I've been badly annoyed by some ads lately. As I'm already using AdBlock in Firefox and started growing a large banlist in Konqueror too (leaving Opera dangerously exposed) I started modifying my approach. So here's my additions to /etc/hosts:

# google
127.0.0.1       ssl.google-analytics.com
127.0.0.1       www.google-analytics.com
127.0.0.1       pagead2.googlesyndication.com
127.0.0.1       pagead.googlesyndication.com 
127.0.0.1       adservices.google.com        
127.0.0.1       imageads.googleadservices.com #[Ewido.TrackingCookie.Googleadservices]
127.0.0.1       imageads1.googleadservices.com                                        
127.0.0.1       imageads2.googleadservices.com                                        
127.0.0.1       imageads3.googleadservices.com                                        
127.0.0.1       imageads4.googleadservices.com                                        
127.0.0.1       imageads5.googleadservices.com                                        
127.0.0.1       imageads6.googleadservices.com                                        
127.0.0.1       imageads7.googleadservices.com                                        
127.0.0.1       imageads8.googleadservices.com                                        
127.0.0.1       imageads9.googleadservices.com                                        
127.0.0.1       partner.googleadservices.com                                          
127.0.0.1       www.googleadservices.com                                              
127.0.0.1       apps5.oingo.com #[Microsoft.Typo-Patrol]                              
127.0.0.1       www.appliedsemantics.com                                              
127.0.0.1       service.urchin.com #[Urchin Tracking Module]                          

#doubleclick
127.0.0.1  ad.doubleclick.net #[MVPS.Criteria]
127.0.0.1  ad2.doubleclick.net #[Panda.Spyware:Cookie/Doubleclick]
127.0.0.1  ad.3ad.doubleclick.net                                 
127.0.0.1  ad.3au.doubleclick.net                                 
127.0.0.1  ad.adx.doubleclick.net                                 
127.0.0.1  ad.ae.doubleclick.net                                  
127.0.0.1  ad.ar.doubleclick.net                                  
127.0.0.1  ad.au.doubleclick.net                                  
127.0.0.1  ad.be.doubleclick.net                                  
127.0.0.1  ad.br.doubleclick.net #[SunBelt.DoubleClick]           
127.0.0.1  ad.ca.doubleclick.net                                  
127.0.0.1  ad.ch.doubleclick.net                                  
127.0.0.1  ad.cl.doubleclick.net                                  
127.0.0.1  ad.cn.doubleclick.net                                  
127.0.0.1  ad.de.doubleclick.net #[Tenebril.Tracking.Cookie]      
127.0.0.1  ad.dk.doubleclick.net                                  
127.0.0.1  ad.es.doubleclick.net                                  
127.0.0.1  ad.fi.doubleclick.net                                  
127.0.0.1  ad.fr.doubleclick.net                                  
127.0.0.1  ad.gr.doubleclick.net                                  
127.0.0.1  ad.hk.doubleclick.net                                  
127.0.0.1  ad.hu.doubleclick.net                                  
127.0.0.1  ad.ie.doubleclick.net                                  
127.0.0.1  ad.in.doubleclick.net                                  
127.0.0.1  ad.jp.doubleclick.net                                  
127.0.0.1  ad.kr.doubleclick.net                                  
127.0.0.1  ad.it.doubleclick.net                                  
127.0.0.1  ad.nl.doubleclick.net                                  
127.0.0.1  ad.no.doubleclick.net                                  
127.0.0.1  ad.nz.doubleclick.net                                  
127.0.0.1  ad.pl.doubleclick.net                                  
127.0.0.1  ad.pt.doubleclick.net                                  
127.0.0.1  ad.ro.doubleclick.net                                  
127.0.0.1  ad.ru.doubleclick.net                                  
127.0.0.1  ad.se.doubleclick.net                                  
127.0.0.1  ad.sg.doubleclick.net                                  
127.0.0.1  ad.terra.doubleclick.net                               
127.0.0.1  ad.th.doubleclick.net                                  
127.0.0.1  ad.tw.doubleclick.net                                  
127.0.0.1  ad.uk.doubleclick.net                                  
127.0.0.1  ad.us.doubleclick.net                                  
127.0.0.1  ad.za.doubleclick.net                                  
127.0.0.1  ad.n2434.doubleclick.net                               
127.0.0.1  creatives.doubleclick.net                              
127.0.0.1  dfp.doubleclick.net                                    
127.0.0.1  fls.doubleclick.net                                    
127.0.0.1  ir.doubleclick.net                                     
127.0.0.1  iv.doubleclick.net                                     
127.0.0.1  ln.doubleclick.net #[Lycos]                            
127.0.0.1  m.doubleclick.net                                      
127.0.0.1  m2.doubleclick.net                                     
127.0.0.1  m3.doubleclick.net                                     
127.0.0.1  m.us.doubleclick.net                                   
127.0.0.1  motifcdn.doubleclick.net                               
127.0.0.1  motifcdn2.doubleclick.net                              
127.0.0.1  n3285ad.doubleclick.net                                
127.0.0.1  n3349ad.doubleclick.net                                
127.0.0.1  n4061ad.doubleclick.net                                
127.0.0.1  n4403ad.doubleclick.net                                
127.0.0.1  n479ad.doubleclick.net                                 
127.0.0.1  n609ad.doubleclick.net                                 
127.0.0.1  optout.doubleclick.net                                 
127.0.0.1  optimize.doubleclick.net                               
127.0.0.1  optimize.3optimization.doubleclick.net                 
127.0.0.1  paypalssl.doubleclick.net                              
127.0.0.1  rd.intl.doubleclick.net                                
127.0.0.1  se1.doubleclick.net                                    
127.0.0.1  twx.doubleclick.net                                    
127.0.0.1  doubleclick.ne.jp                                      
127.0.0.1  www3.doubleclick.net                                   
127.0.0.1  www.doubleclick.net                                    
127.0.0.1  doubleclick.com                                        
127.0.0.1  ad.doubleclick.com                                     
127.0.0.1  www2.doubleclick.com                                   
127.0.0.1  www3.doubleclick.com                                   
127.0.0.1  www.doubleclick.com                                    
127.0.0.1  www.messagemedia.com                                   
127.0.0.1  www.performics.com                                     
127.0.0.1  doubleclick.shockwave.com                              
# [Google/DoubleClick via Falk AdSolution][Falk eSolutions AG]    
127.0.0.1  a.as-eu.falkag.net                                     
127.0.0.1  a.as-eu1.falkag.net                                    
127.0.0.1  admin.as-eu.falkag.net                                 
127.0.0.1  bw.as-eu.falkag.net                                    
127.0.0.1  c.as-eu.falkag.net                                     
127.0.0.1  data.as-eu.falkag.net
127.0.0.1  e.as-eu.falkag.net #[Ewido.TrackingCookie.Falkag]
127.0.0.1  f.as-eu.falkag.net
127.0.0.1  origin.as-eu.falkag.net
127.0.0.1  red.as-eu.falkag.net #[McAfee.Adware-Zeno]
127.0.0.1  red01.as-eu.falkag.net
127.0.0.1  sel.as-eu.falkag.net
127.0.0.1  a.as-test.falkag.net #[Panda.Spyware:Cookie/Falkag]
127.0.0.1  bw.as-test.falkag.net
127.0.0.1  red.as-test.falkag.net
127.0.0.1  sel.as-test.falkag.net
127.0.0.1  a.as-us.falkag.net #[SunBelt.as-us.falkag]
127.0.0.1  b.as-us.falkag.net
127.0.0.1  bw.as-us.falkag.net #[a1339.g.akamai.net]
127.0.0.1  c.as-us.falkag.net #[Tenebril.Tracking.Cookie]
127.0.0.1  data.as-us.falkag.net
127.0.0.1  e.as-us.falkag.net #[a1339.g.akamai.net]
127.0.0.1  origin.as-us.falkag.net
127.0.0.1  red.as-us.falkag.net
127.0.0.1  red01.as-us.falkag.net
127.0.0.1  s.as-us.falkag.net
127.0.0.1  sel.as-us.falkag.net
127.0.0.1  as1.falkag.de #[Ad-Aware.Tracking.Cookie]
127.0.0.1  www.falkag.de

Et voila. Your Intertubez have now about 75% less braindamage. It's funny to see websites cleaning up on reload ... blink blink reload empty. Only text left ...

There's one issue though: It's by far not complete. I think I'll need some privoxy added to that to be really happy. If I do I'll let you know how it goes.

Hai everyone,
I've been a bit quiet the last few $timeunits. Life is good.

Here is a little toy I've been working on since yesterday. It is still very embryonic, but what it does is simple: Map files to packages and packages to files, using a local sqlite DB I generated out of binary packages. The index is not complete, it has been generated with ~5500 packages. I will try to update it when I have more packages built.

If you have any great queries just throw them at me and I'll try to update the query script. Also I intend to totally rewrite the database structure because I've already noticed a few issues with the current design. But for now have fun with it!