Wed Sep 24 14:56:20 CEST 2008
New package index
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
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
Wed Sep 24 02:17:14 CEST 2008
Make your Intertubez a nicer place
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:
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.
# 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.deEt 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.
Thu Sep 18 00:07:23 CEST 2008
Local File-to-ebuild Database
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!
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!