Erwin

34 ms·

301.
by Erwin 11y ago
Thanks -- I had a a query on 9.1 using MEDIAN (implemented in pl/psql) going from 12 seconds to 0.2 seconds by switching to array_to_median(array_agg(the_column)). I found it was faster to actually query a million values and calculate
302.
by Erwin 11y ago
I loved playing with the OO "Turbo Vision" framework back then and getting to learn about OO. Only programming Qt in C++ was equally enjoyable. The modern web is difficult to stand in comparison (though Anders is involved in Types
303.
by Erwin 11y ago
Here's one recent real-life Futurological Congress -- I'm eager to hear know more about what happened: http://www.independent.co.uk/life-style/health-and-families/...
304.
by Erwin 11y ago
Despite the reliability, that product sounds nice -- is there anything for Postgres with similar ease of setup for replication etc. that someone can recommend? E.g. EnterpriseDB ?
305.
by Erwin 11y ago
Hipmunk comes up with this amazing itinerary: New York to Los Angeles, then LA to Sydney (!), then back across to Santiago, spend 22 hours in the airport and finally 6 hours to the final destination. The second LA to Sydney flight takes off
306.
by Erwin 11y ago
The key Sleepycat people went on to write WiredTiger which was acquired by Mongo -- it has some interesting features: http://source.wiredtiger.com/2.6.1/index.html > WiredTiger supports row-oriented storage (where a
307.
by Erwin 11y ago
SI unit prefix are supported; I amused myself by asking for "3 yottatons of bacon". Not numbers though -- I wasn't able to add a million quadrillion eggs to complete the recipe that would feed the entire Milky Way.
308.
by Erwin 11y ago
Sometimes I use this one to validate certs: https://www.sslshopper.com/ssl-checker.html The Qualys SSLlabs scan does not accept an IP address. I'm often in the situation where the cert is installed and ready, but the n
309.
by Erwin 11y ago
I was thinking about some kind of user-owned Database service to ensure the data is forever free. Imagine a discussion board run by any company where you authenticate with your external Bring-Your-Own-Data credentials. Through some SQL-like
310.
by Erwin 11y ago
London hotels are very expensive compared to what you get. Having stayed there many times I was always jaded about the more expensive hotels, but visiting luxury hotels in Berlin or Vienna is a much nicer experience, Hyatt or Sofitel (and s
311.
by Erwin 11y ago
In my app, I've been quite pleased with REST API endpoints mapping segments to objects the API will work on and explicitly declaring the permission before any page specific code runs. So if you have an URL like /{username}/ye
312.
by Erwin 11y ago
Locking the basic data structures seems like it would destroy Python's simplicity. How do you determine the scope of the per-list lock? Do you add a lock to every single data structure that you are required to grab before reading or mo
313.
by Erwin 11y ago
Something similar from Uniqlo (the clothing company!) with interesting Japanese scenes: http://www.uniqlo.com/calendar/
314.
by Erwin 11y ago
If you thought this was an interesting article, here 's the obligatory link to just about the only book on crafting a text editor, "Craft of Text Editing": http://www.finseth.com/craft/
315.
by Erwin 11y ago
You urged to do your math, but didn't present any of yours. Muscle burns an inconsequential amount of energy -- 6-10 per pound depending on sources. So if you were somehow to gain 10 pounds of pure muscle, you'd have enough calori
316.
by Erwin 11y ago
It's almost as bad as the software engineers running the system that control our private information gathering in shady anonymous "hacker" forums to exchange programming tips.
317.
by Erwin 11y ago
Would you apply this to software engineering, and if not why not? Should the engineer that was responsible for some XSS flaw 3 years ago used today to extract personal information (which in turn can be used for identity theft) be personally
318.
by Erwin 11y ago
I like Paul Ford -- first thing that made me subscribe to his Medium feed was this piece about brief, remembering and old computers: https://medium.com/message/networks-without-networks-7644933...
319.
by Erwin 11y ago
It's quite a loud plane, and a lot of fun to see it take off at an airshow. It has a distinctive howling sound: https://www.youtube.com/watch?v=H_ARSE8jEHQ It's hard to believe it's 50 years old when you see
320.
by Erwin 11y ago
That's assuming it's sufficiently parallizable. If you only have a single thread, an ordinary Intel desktop CPU is still faster than any Xeon: https://www.cpubenchmark.net/singleThread.html I thought about 4-core
321.
by Erwin 11y ago
Why can't it be as simple as Linux? If I want Redhat commercial support I simply have to decide between Standard or Premium Subscription with, or without Smart Management, normal or Entry level. Or the version for virtual Datacenters (
322.
by Erwin 11y ago
Would you support a government-run cultural fund which buys all rights to work from the author at market value for taxpayer money and move it into public domain? E.g. the billboard top song for 2014 was by "Pharrel Williams". Sho
323.
by Erwin 11y ago
Southern Europe (mostly around Catalonia) has a similar curiosity which has after 100s of years become a tradition: http://en.wikipedia.org/wiki/Caganer I wonder which cultural oddities today will be commonly accepted
324.
by Erwin 12y ago
For our corporate API, we the Apiary markdown with aglio to convert into nice documentation. I've tried RAML (I didn't like the giant YAML file) and apidoc (I didn't like to put 100 lines of user documentation next to 20 line
325.
by Erwin 12y ago
OK, so slack stores a username, name and email address for each user. This is visible to everyone else in the same Slack team at minimum. You also need it for e.g. password resets, perhaps billing. We can assume they aren't total idiot
326.
by Erwin 12y ago
You never decrypt a password however. You only compare the hashed version of the claimed one to the stored hashed version, a one-way operation. What could you do with a one-way encrypted phone number? I'm not able to enter a phone hash
327.
by Erwin 12y ago
I find the /etc/httpd/logs symlink more annoying. If you want to grep through your Apache configuration you have to explicitly grep through conf and conf.d otherwise just going to /etc/httpd and doing a grep -r you
328.
by Erwin 12y ago
I asked a few people that at the excellent pgnordic conference and got some hand-waving about how repmgr fixes everything: https://github.com/2ndQuadrant/repmgr/blob/master/QUICKSTART... Having tried tha
329.
by Erwin 12y ago
That's going to get you instantly arrested in Albuquerque, NM.
330.
by Erwin 12y ago
The current proposed hack to encourage them to use all the lanes is this: https://i.imgur.com/F8eKjp5.jpg -- periodic narrowing of the lanes so those that don't need to turn stay in the middle.

More ›