rusanu

13 ms·

61.
by rusanu 9y ago
> Do a query, get back a handle to a file that you can treat just like you opened it yourself Things are a bit more complex. For one, the trivial problem of client vs. server host. The DB cannot return a handle (a FD) from the server, be
62.
by rusanu 9y ago
To name just a few: Filestream https://docs.microsoft.com/en-us/sql/relational-databases/bl... File Tables https://docs.microsoft.com/en-us/sql/relational-databases/bl..
63.
by rusanu 9y ago
In this case nginx is the 'application'. the requests is still going to be expressed as a SQL query, sent to the PG, parsed, compiled, optimized, executed, then the tabular response formatted as the HTTP response. Many more steps
64.
by rusanu 9y ago
Amen to that. Fastest database query is the one you never run.
65.
by rusanu 9y ago
You have two consystency issues with storing the files in the filesystem: - rollbacks in the DB can lead to orphaned files on disk. One can try to add logic in the app (eg. a catch block that removes the file if the DB rolled back) but that
66.
by rusanu 9y ago
But that would work only for static content, like the game assets. The discussion of BLOBs vs. filesystem comes up mostly in the context of content management and user/app uploaded content.
67.
by rusanu 9y ago
From OP: "SQLite is much faster than direct writes to disk on Windows when anti-virus protection is turned on. Since anti-virus software is and should be on by default in Windows, that means that SQLite is generally much faster than di
68.
by rusanu 9y ago
I must point out Jim Gray's paper To Blob or Not To Blob[0]. His team considered NTFS vs. SQL Server, but most rationale applies to any filesystem vs. database decision. The summary was "The study indicates that if objects are lar
69.
by rusanu 9y ago
Probably the same motivation Yahoo had to release Hadoop, FB to release Hive, Netflix to release so much of their libs and so on and so forth: - if nothing else, it does no harm (no 'secret sauce' competitors could benefit from) -
70.
by rusanu 9y ago
Tangential: George Dow[0] and Harry Beck[1] created the 'Tube map'. [0] https://en.wikipedia.org/wiki/George_Dow [1] https://en.wikipedia.org/wiki/Harry_Beck
71.
by rusanu 9y ago
> a contractor doing maintenance work inadvertently switched off the power supply [...] This resulted in the total immediate loss of power to the facility, bypassing the backup generators and batteries... After a few minutes of this shut
72.
British Airways IT chaos was caused by human error(bbc.com)
2 points by rusanu 9y ago|2 comments
73.
by rusanu 9y ago
I second Code Complete
74.
by rusanu 9y ago
Is Oregon. I still remember my shock at the pump station after being told that I'm not qualified to handle explosive substances (gas)...
75.
by rusanu 9y ago
You can point back to the 2004 benefits overhaul [0], the famous Towels story [1], low compensation rates compared to Google, Amazon and Facebook [2]. Just go over minimsft.blogspot.com posts at the time. Add to this the lack of vision and
76.
by rusanu 9y ago
Tangential. For me the fascinating thing is looking at the list of authors to recognize so many from the 2005-2012 Microsoft SQL Server team. Folk I know personally as exceptional performers. Same when I look at Aurora papers. I see this as
77.
by rusanu 9y ago
We're in the middle of the (minor) Orion Arm right now: https://en.wikipedia.org/wiki/Orion_Arm
78.
by rusanu 9y ago
Apparently they're rather static: https://en.wikipedia.org/wiki/Density_wave_theory
79.
by rusanu 9y ago
They were implementing HTTP Digest[0]. This leaves no room to choose something other than MD5. And I'm not sure what other HTTP authentication scheme they could had chose for firmware (ie. cannot take dependency on anything in infrastr
80.
Who lost the most marks when cheating was stopped?(bbc.com)
2 points by rusanu 9y ago|0 comments
81.
by rusanu 9y ago
> such as would be produced by a black hole of about one solar mass How do such low mass black holes form?
82.
Why is Russia so good at encouraging women into tech?(bbc.com)
30 points by rusanu 9y ago|21 comments
83.
by rusanu 9y ago
BK edits Wiki entry on the Whopper to say is "America's favorite burger", then launches ad that reads from Wikipedia on Home Smart devices. What could go wrong? Wiki entry is edited to read "worst hamburger product&quot
84.
Burger King advert sabotaged on Wikipedia(bbc.com)
1 points by rusanu 9y ago|1 comments
85.
by rusanu 9y ago
I love how they close the stores on Black Friday[1] and invite members to spend the day outdoors. https://www.rei.com/black-friday
86.
by rusanu 10y ago
He is the son of Maurice Jarre [1], and I heard before how this helped him financially quite a bit. [1] https://en.wikipedia.org/wiki/Maurice_Jarre
87.
Lost in space: 'Peggy, I don't have a shield'(bbc.com)
1 points by rusanu 10y ago|0 comments
88.
Low Background Steel(hackaday.com)
2 points by rusanu 10y ago|0 comments
89.
by rusanu 10y ago
I guess otherwise no GitHub employee could ever use GitHub for a personal project, could they?
90.
This Is the Most Detailed Map of the Universe to Date (2014)(futurism.com)
1 points by rusanu 10y ago|0 comments

More ›