Blog‎ > ‎

Python ORM, MIMO, Google Sites, Disclaimer, jQuery CDN

posted May 4, 2014, 2:42 AM by Sami Lehtinen   [ updated Jul 3, 2014, 7:08 AM ]
  • Checked out: OCSP, jQuery Mobile, Pony ORM, SQLAlchemy, Storm, peewee, Python Mini ORM.  I might use one for my test project, just don't know yet which one. GCM Google Cloud Messaging In no particular order.
    One thing I didn't really like about many ORM solutions, is that those use intermediary tables to map between two objects. That's technically totally fine. But that makes joins considerably slower. It might not be a problem with small data set, but it's huge problem when you're joining 100 million records, with 100 million records, which map to another 100 million records. I always prefer referring directly to primary key integers if possible, to avoid using these intermediary tables. Or using some other indexed unique value.
    After analyzing options for a few days, I decided to go with Peewee, because it's clean, powerful and generally fits Python concept well. SQLAlchemy adds only one layer of obfuscation on top of pure SQL, initially it was one of the most expected options but didn't turn out to be as nice as I expected it to be. Pony was also very interesting, but it's not FOSS.
  • Studied net-mimo, co-mimo, coordinated multipoint, LTE-A, 802.11ac, pCell, DIDO. New stuff? When I did read CDMA specifications ages ago, there was a soft handover and Qualcomm made it clear, that it's possible to send and receive data simultaneously to same handset using multiple base stations, enhancing data rate and SNR. But clearly that hasn't been fully utilized.
  • Noticed a security issue with Google Sites, sites leaks out post drafts which haven't been yet published. This is clear privacy issue, what if the data is something you don't want to release just yet? My Google+ post.
  • Something different: Covert Channel for covert communication, nothing new although.
  • The traditional disclaimer: My opinions in this blog and in general are my own, that should be quite obvious without this statement and do not represent my employer(s) or customers.
  • Something totally different: Alcubierre Drive.
  • Little jQuery Mobile CDN download super micro test comparison:

    # wget --delete-after https://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.js
    --2014-05-03 19:25:57--  https://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.js
    Resolving code.jquery.com (code.jquery.com)... 108.161.188.209, 108.161.187.43
    Connecting to code.jquery.com (code.jquery.com)|108.161.188.209|:443... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: 195659 (191K) [application/x-javascript]
    Saving to: `jquery.mobile-1.4.2.min.js'

    100%[=] 195,659     --.-K/s   in 0.1s   

    2014-05-03 19:25:57 (1.76 MB/s) - `jquery.mobile-1.4.2.min.js' saved [195659/195659]

    Removing jquery.mobile-1.4.2.min.js.

    # wget --delete-after http://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.2/jquery.mobile.min.js
    --2014-05-03 19:25:57--  http://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.2/jquery.mobile.min.js
    Resolving ajax.googleapis.com (ajax.googleapis.com)... 74.125.143.95, 2a00:1450:4010:c03::5f
    Connecting to ajax.googleapis.com (ajax.googleapis.com)|74.125.143.95|:80... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: unspecified [text/javascript]
    Saving to: `jquery.mobile.min.js'

        [=] 195,653     --.-K/s   in 0.08s  

    2014-05-03 19:25:57 (2.46 MB/s) - `jquery.mobile.min.js' saved [195653]

    Removing jquery.mobile.min.js.

    # wget --delete-after http://ajax.aspnetcdn.com/ajax/jquery.mobile/1.4.2/jquery.mobile-1.4.2.min.js
    --2014-05-03 19:25:57--  http://ajax.aspnetcdn.com/ajax/jquery.mobile/1.4.2/jquery.mobile-1.4.2.min.js
    Resolving ajax.aspnetcdn.com (ajax.aspnetcdn.com)... 68.232.34.200, 68.232.34.201
    Connecting to ajax.aspnetcdn.com (ajax.aspnetcdn.com)|68.232.34.200|:80... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: 195659 (191K) [application/x-javascript]
    Saving to: `jquery.mobile-1.4.2.min.js'

    100%[=] 195,659     --.-K/s   in 0.04s  

    2014-05-03 19:25:57 (5.08 MB/s) - `jquery.mobile-1.4.2.min.js' saved [195659/195659]

    Removing jquery.mobile-1.4.2.min.js.

    Results are from downtown Helsinki, Finland data center.