Framedragger: eh, i've to import ~400gb of data into postgres, i do ORM commit every 100k inserts, it's actually quite fast :) (sqlalchemy orm abstraction). not really a problem

Framedragger: parseval: yeah i don't think sqlite is a good solution in terms of scaling. if you're using ORM abstraction, changing the underlying DB shouldn't be a prob, unless you're using some DB-specific functions. postgres is really nice for Shitloads of Data type of situations

Framedragger: yeah, db design can turn into a fetish, unless it turns out significant optimizations are relevant to business strategy and whatnot

Framedragger: heh, postgres + multimaster.. yeah :)

Framedragger: heheh, well if we are also worried about DB _querying_ though..

Framedragger: where responsive near-realtime APIs are built, etc

Framedragger: yeah

Framedragger: parseval: sure, just note that it's usually trivial (as in, perhaps only change the db configuration string in your app's config) to change the underlying DB (installing and starting a DB server with default config is also usually really simple) - but yeah, would be interesting to see your results eventually, good luck!

Framedragger: syria broke off of internet, more or less :(

Framedragger: http://labs.umbrella.com/2013/05/07/breaking-news-traffic-from-syria-disappears-from-internet/

Framedragger: someone asked, what would happen to syrian-based bitcoin transactions that were to be made offline.. :/

Framedragger: truff1es i think that's more about encryption.. in the end, you need actual fibres, or whatever physical medium to carry the data over.. and that's what's at issue in syria

Framedragger: would be nice heh, but would still need hardware on their side to do teh communications

Framedragger: tough times

Framedragger: iran's elections in a month, and they're experimenting with DPI filtering right now, etc etc

Framedragger: *rambles about western companies selling off dpi equipment to authoritarian regimes*

Framedragger: they _throttle_ encrypted channels

Framedragger: apparently they have stateful dpi

Framedragger: so it can (allegedly) create 'standard traffic profiles'

Framedragger: yeah if it's ssl, they can profile ssl.. if it's just bare tcp, sure it's more difficult true

Framedragger: the idea/speculation is, they are experimenting with things (iran is)

Framedragger: speculation again (tor-dev etc): they're trying to discourage off-country services

Framedragger: get people to use youtube.ir, iran's version of gmail etc

Framedragger: it's a more subtle social approach, i get it - why use the slow youtube when i can use iran's fast youtube which also has pirate filmzz

Framedragger: but i think they're actually being rather clever here.

Framedragger: oh they're also doing intense dns poisoning

Framedragger: etc

Framedragger: how many people check/bypass certificate errors

Framedragger: also (at least in syria) chopping heads off people posting pro-uprising messages on fb - sure it's about censorship.. to the most intense/grotesque extent

Framedragger: well yeah, but as i understand it, browsers etc have lists of CA key fingerprints etc

Framedragger: oh of course, by 'country X' i mean 'X state' - true

Framedragger: tbh his speech (afaik) has been very much distorted when translated - by nobody's to argue here

Framedragger: man i remember reading up on stuxnet.. that shit was fucking intense, targeting specific nuclear turbine models to make them malfunction and very slowly fail, etc

Framedragger: s/was/is, there's new shit in town of course

Framedragger: not sure of words sorry

Framedragger: indeed

Framedragger: not a native speaker

Framedragger: hrm don't have any links saved

Framedragger: well, new modular malware somethingsomething scaryscary

Framedragger: (re: new - http://www.wired.com/threatlevel/2012/05/flame/ , http://www.kaspersky.com/about/news/virus/2012/Resource_207_Kaspersky_Lab_Research_Proves_that_Stuxnet_and_Flame_Developers_are_Connected (i dislike the word 'proves' though heh))