2017-Sep-25, Monday

mindstalk: (Default)
A longish article on cities (or a country) that have built their way to affordable housing, contrary to the claims of many market-allergic leftists.

http://www.sightline.org/2017/09/21/yes-you-can-build-your-way-to-affordable-housing/

Money-quote paragraph:

"Houston, for example, can be Cascadia’s model for how easy it ought to be to get permits to build homes—if we believed, as Houston does, that building homes is in itself a good thing, our permitting processes would encourage rather than discourage it through endless months of hoop-jumping and politicized reviews. Tokyo, meanwhile, reminds us that placing control over development at senior levels of government, and making development of urban property a right of its owner, helps to elevate the broad public interest in abundant housing choices over parochial opposition to change. (Leaders in California have recently succeeded in passing a raft of new laws to act upon this lesson.) Chicago teaches that a pro-housing political orientation can provide abundant housing even under conventional zoning in a deep blue city, while Montreal offers Cascadia a model of a cityscape no longer of single-family homes but of three-story rowhouses, walk-up apartments, and condominiums on quiet, tree-lined streets close to transit and neighborhood centers. Singapore’s lesson is the promise of erecting high-density, park-like “new towns” on underused city land. And Germany shows us that a future is possible where housing is no longer an investment vehicle but “a very durable consumption good that provides a stream of housing services, not a ticket to financial gain.”"


Relatedly, Vienna and Singapore as two examples of massive public housing: https://www.shareable.net/blog/public-housing-works-lessons-from-vienna-and-singapore
Also useful if anyone tries to tout Singapore as a free-market miracle...
mindstalk: (Default)
At work today, Boss suggested I look at sqlite a bit, since our client code uses it. What I thought might be a brief glance turned into hours of reading, as it became rather fascinating. For those who don't know, it's an embedded SQL database, with not much code, unlike the client/server databases of Oracle or anything else you've probably heard of. As their docs put it, they're not competing with such databases, they're competing with fopen() and other filesystem access.

They call their testing "aviation grade", possibly without hyperbole: 100% branch coverage, 100% coverage of something stronger than branches, 700x more testing code than actual library code and a lot of that generates tests parametrically... it sounds pretty nuts. They worship Valgrind but find compiler warnings somewhat useless; getting warnings to zero added more bugs than it solved. https://www.sqlite.org/testing.html

They claim "billions and billions of deployments", which sounded like humorous hyperbole until they added being on every iPhone or Android phone, every Mac or Windows 10 machine, every major browser install... There are over 2 billon smartphones, so just from the phone OS and the phone browser, you've got 4 billion installs...

They also make a pitched case for consider a sqlite database any time you'd be considering some complex file format. With almost no code to write, you'd get consistency robustness, complex queries, machine and language independence, and at least some ability to do partial writes[1], compared to throwing a bunch of files into a zipfile.

https://www.sqlite.org/appfileformat.html
https://www.sqlite.org/affcase1.html

They also had a nicely educational description of their rollback and write-ahead models. https://www.sqlite.org/atomiccommit.html
https://www.sqlite.org/wal.html

[1] I do wonder about this. One odd thing about sqlite is a looseness about types, and AIUI cramming numeric values into the smallest range that will hold them. So I'd think that if you UPDATED a value 100 to a value 1000000000000, you'd have to shuffle the trailing part of the file, compared to a format that e.g. reserved 8 bytes for a numeric type. But maybe they do buffer numeric or string storage. And not having to write the whole file, or not having to read the whole file (e.g. to decompress it) seem like at least partial wins.

October 2017

S M T W T F S
123 4567
89 1011 1213 14
15161718192021
22232425262728
293031    

Expand Cut Tags

No cut tags

Style Credit

Most Popular Tags