<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Hacker News: marsovo</title><link>https://news.ycombinator.com/user?id=marsovo</link><description>Hacker News RSS</description><docs>https://hnrss.org/</docs><generator>hnrss v2.1.1</generator><lastBuildDate>Sun, 20 Sep 2026 13:49:58 +0000</lastBuildDate><atom:link href="https://hnrss.org/user?id=marsovo" rel="self" type="application/rss+xml"></atom:link><item><title><![CDATA[New comment by marsovo in "The polar vortex is hitting the brakes"]]></title><description><![CDATA[
<p>Macroeconomics is very different from microeconomics.  Your spending is my income and my spending is your income.  If the government spends a dollar, where does it go?<p>Presumably it goes to some sort of goods and services.  The employees pay income taxes.  The businesses pay corporate taxes.  And so on.<p>Similarly, when a business lays off 10,000 people, it's not their problem anymore.  Whereas from a macroeconomic policy perspective, "everybody" is the government's responsibility.</p>
]]></description><pubDate>Sun, 23 Mar 2025 15:34:37 +0000</pubDate><link>https://news.ycombinator.com/item?id=43453610</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43453610</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43453610</guid></item><item><title><![CDATA[New comment by marsovo in "MySQL transactions per second vs. fsyncs per second (2020)"]]></title><description><![CDATA[
<p>I see what you mean, but ACID is a fairly foundational expectation for SQL transactions (D being the relevant feature here)<p>That being said, my background is primarily Microsoft SQL more than Postgres.  As such I'm occasionally bemused at the sort-of monoculture here around Postgres, where if Postgres doesn't have it, it may as well not exist*.<p>And so it is in this case (the DELAYED_DURABILITY documentation I linked above).  Alas, this doesn't seem to be something I see in standard SQL, so indeed, as you say, it's too bad that the standard doesn't provide for relaxing the rules.<p>Relatedly, the other interesting thing is the chatter about fsync.  I know on Windows that's not the mechanism that's used, and out of curiosity I looked deeper into what MS-SQL does on Linux, and indeed they were able to get significant improvement by leveraging similar mechanisms to ensure the data is hardened to disk without a separate flush (see <a href="https://news.ycombinator.com/item?id=43443703">https://news.ycombinator.com/item?id=43443703</a>).  They contributed to kernel 4.18 to make it happen.<p>> The repeated use of a write request followed by a flush request may be detrimental to performance and will increase traffic on the I/O bus.<p>> Prior to the Linux Kernel 4.18 updates, Linux could use Fua but only for the file system journaling writes and not data writes.<p>> If your system supports Fua and you have the Linux Kernel 4.18 or newer updates, you can enable SQL Server trace flag -T3979 and use /opt/mssql/bin/mssql-conf set control.alternatewritethrough 0.  SQL Server will use Fua write behavior patterns instead of Forced Flush.  File systems supporting optimized Fua align SQL Server on Linux with SQL Server on Windows behavior and performance.<p>*I think performance of CTEs/Views is another topic where I noticed it, where it was just taken as given that they can hurt performance, whereas in T-SQL they are simply equivalent to subqueries</p>
]]></description><pubDate>Sat, 22 Mar 2025 14:02:41 +0000</pubDate><link>https://news.ycombinator.com/item?id=43445690</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43445690</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43445690</guid></item><item><title><![CDATA[New comment by marsovo in "MySQL transactions per second vs. fsyncs per second (2020)"]]></title><description><![CDATA[
<p>I looked into this some more.  There are other ways than explicit fsync.  See this blurb on FUA (which basically treats the I/O as write-through)<p><a href="https://techcommunity.microsoft.com/blog/sqlserver/sql-server-on-linux-forced-unit-access-fua-internals/3199102" rel="nofollow">https://techcommunity.microsoft.com/blog/sqlserver/sql-serve...</a><p>More from kernel.org:
<a href="https://www.kernel.org/doc/html/latest/block/writeback_cache_control.html" rel="nofollow">https://www.kernel.org/doc/html/latest/block/writeback_cache...</a></p>
]]></description><pubDate>Sat, 22 Mar 2025 04:59:23 +0000</pubDate><link>https://news.ycombinator.com/item?id=43443703</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43443703</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43443703</guid></item><item><title><![CDATA[New comment by marsovo in "MySQL transactions per second vs. fsyncs per second (2020)"]]></title><description><![CDATA[
<p>I'm not sure we're using the same terminology.  Committed means the transaction has been hardened to disk.  That's the D in ACID.<p>Otherwise, is the suggestion that there be an artificial delay to allow other transactions to piggyback before returning success on commit 1?<p>Should that be a default? (That was the context of this thread)</p>
]]></description><pubDate>Sat, 22 Mar 2025 04:40:02 +0000</pubDate><link>https://news.ycombinator.com/item?id=43443597</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43443597</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43443597</guid></item><item><title><![CDATA[New comment by marsovo in "MySQL transactions per second vs. fsyncs per second (2020)"]]></title><description><![CDATA[
<p>Sure, but now when transaction 1 is "committed", it isn't actually guaranteed to be there in the face of interruption.  That's a big change to the default behavior...</p>
]]></description><pubDate>Sat, 22 Mar 2025 01:32:23 +0000</pubDate><link>https://news.ycombinator.com/item?id=43442479</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43442479</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43442479</guid></item><item><title><![CDATA[New comment by marsovo in "NASA Whoosh Rocket"]]></title><description><![CDATA[
<p>More context on the external tank: <a href="https://archive.is/2017.03.30-030831/https://www.nasa.gov/mission_pages/station/expeditions/expedition30/tryanny.html" rel="nofollow">https://archive.is/2017.03.30-030831/https://www.nasa.gov/mi...</a><p>> The common soda can, a marvel of mass production, is 94% soda and 6% can by mass. Compare that to the external tank for the Space Shuttle at 96% propellant and thus, 4% structure. The external tank, big enough inside to hold a barn dance, contains cryogenic fluids at 20 degrees above absolute zero (0 Kelvin), pressurized to 60 pounds per square inch, (for a tank this size, such pressure represents a huge amount of stored energy) and can withstand 3gs while pumping out propellant at 1.5 metric tons per second. The level of engineering knowledge behind such a device in our time is every bit as amazing and cutting-edge as the construction of the pyramids was for their time.</p>
]]></description><pubDate>Fri, 21 Mar 2025 12:37:39 +0000</pubDate><link>https://news.ycombinator.com/item?id=43434903</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43434903</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43434903</guid></item><item><title><![CDATA[New comment by marsovo in "Hidden Messages in Emojis and Hacking the US Treasury"]]></title><description><![CDATA[
<p>PHP has grown up but in its wild youth was notorious for such gems as mysql_escape_string vs mysql_real_escape_string, rather than proper parameterization<p>It's not so much about Turing as it is libraries and patterns<p>After all, as I understand it this very issue was caused by escaping SQL rather than parameterizing it</p>
]]></description><pubDate>Mon, 17 Mar 2025 21:53:52 +0000</pubDate><link>https://news.ycombinator.com/item?id=43393105</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43393105</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43393105</guid></item><item><title><![CDATA[New comment by marsovo in "Tj-actions/changed-files GitHub Action Compromised – used by over 23K repos"]]></title><description><![CDATA[
<p>Yes, you're right.  I wasn't able to double-check as the repo was deleted at the time.  That said, AIUI making the tags read-only would still often be vulnerable to semantic-version exploitation.</p>
]]></description><pubDate>Sat, 15 Mar 2025 23:22:27 +0000</pubDate><link>https://news.ycombinator.com/item?id=43375837</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43375837</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43375837</guid></item><item><title><![CDATA[New comment by marsovo in "Tj-actions/changed-files GitHub Action Compromised – used by over 23K repos"]]></title><description><![CDATA[
<p>I don't think that's exactly what happened here: the compromise created new tags but generally the tag consumption relies on semantic versioning<p>In other words: you specify version 44, the attacker creates 44.1, you're still hosed.</p>
]]></description><pubDate>Sat, 15 Mar 2025 17:09:08 +0000</pubDate><link>https://news.ycombinator.com/item?id=43373787</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43373787</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43373787</guid></item><item><title><![CDATA[New comment by marsovo in "In S3 simplicity is table stakes"]]></title><description><![CDATA[
<p>Erm, most file systems allow you to change data too, right?  Hence S3 is emphatically not a file system.</p>
]]></description><pubDate>Sat, 15 Mar 2025 02:18:50 +0000</pubDate><link>https://news.ycombinator.com/item?id=43369348</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43369348</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43369348</guid></item><item><title><![CDATA[New comment by marsovo in "In S3 simplicity is table stakes"]]></title><description><![CDATA[
<p>Here's the link to that 
<a href="https://news.ycombinator.com/item?id=40304666">https://news.ycombinator.com/item?id=40304666</a><p>Moral of the story: the "technical part" of things is not the end of the story<p>Alternative moral: The 3-2-1 backup rule of thumb is still alive and well (is your cloud account a single point of failure?)<p>Related: <a href="https://www.infoworld.com/article/2179073/murder-in-the-amazon-cloud.html" rel="nofollow">https://www.infoworld.com/article/2179073/murder-in-the-amaz...</a></p>
]]></description><pubDate>Sat, 15 Mar 2025 02:15:31 +0000</pubDate><link>https://news.ycombinator.com/item?id=43369333</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43369333</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43369333</guid></item><item><title><![CDATA[New comment by marsovo in "Planes are having their GPS hacked. Could new clocks keep them safe?"]]></title><description><![CDATA[
<p>Not to mention removal of the alternatives in favor of GPS, e.g. shutting down VOR beacons (see e.g. <a href="https://www.flightaware.com/squawks/view/1/24_hours/popular/56667/FAA_Releases_VOR_Decommissioning_Policy" rel="nofollow">https://www.flightaware.com/squawks/view/1/24_hours/popular/...</a>)</p>
]]></description><pubDate>Mon, 10 Mar 2025 15:30:41 +0000</pubDate><link>https://news.ycombinator.com/item?id=43321677</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43321677</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43321677</guid></item><item><title><![CDATA[New comment by marsovo in "Planes are having their GPS hacked. Could new clocks keep them safe?"]]></title><description><![CDATA[
<p>Can you point us to which part of that can deal with the scenario in question?<p>> What stops a malicious actor from recording the signals coming off the satellites and replaying them louder with a delay?</p>
]]></description><pubDate>Mon, 10 Mar 2025 15:25:59 +0000</pubDate><link>https://news.ycombinator.com/item?id=43321637</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43321637</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43321637</guid></item><item><title><![CDATA[New comment by marsovo in "Microsoft is plotting a future without OpenAI"]]></title><description><![CDATA[
<p>I don't think it's wrong to blame people who make life more difficult for others for their own aggrandizement<p>The game doesn't exist without players.  I could make more money if I worked at Meta or Amazon, but at what cost?<p>I understand the realities of Game Theory, but then one could argue that being blamed and criticized for one's choices is also part of the game.  
"Mr Wolfcastle, how do you sleep at night?" "On a big pile of money with many beautiful ladies"</p>
]]></description><pubDate>Sat, 08 Mar 2025 00:24:19 +0000</pubDate><link>https://news.ycombinator.com/item?id=43296287</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43296287</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43296287</guid></item><item><title><![CDATA[New comment by marsovo in "Atlanta Fed predicts -2.8% GDP"]]></title><description><![CDATA[
<p>It depends on what the broader economy is doing<p>Is government spending crowding out private investment? (Is the private sector competing with the government for employees?). If so then GDP should increase<p>Is unemployment high? Then probably it would hurt GDP, but that depends on interest rates.  If interest rates are very low, then there's very little cost to having excess employees being paid by the government: indeed presumably you can find something else useful for them to do.  If interest rates are high, then the government is paying a heavy rate to subsidize these now-redundant employees.  That's stagflation, which is essentially economic hard mode.<p>For example, what a waste it was during the Great Recession, when interest rates were basically zero, to have people unemployed instead of doing something useful, like maintaining or upgrading infrastructure.  Alas!</p>
]]></description><pubDate>Mon, 03 Mar 2025 21:07:04 +0000</pubDate><link>https://news.ycombinator.com/item?id=43246713</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43246713</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43246713</guid></item><item><title><![CDATA[New comment by marsovo in "Losing a 5-year-long Illinois FOIA lawsuit for database schemas"]]></title><description><![CDATA[
<p>As I understand it, the trial was about whether or not providing the database schema is a security risk.<p>> Your request seeks a copy of tables or columns within each table of CANVAS. The dissemination of these pieces of network information could jeopardize the security of the systems of the City of Chicago.<p>Related: <a href="https://news.ycombinator.com/item?id=43175628">https://news.ycombinator.com/item?id=43175628</a></p>
]]></description><pubDate>Mon, 03 Mar 2025 13:21:46 +0000</pubDate><link>https://news.ycombinator.com/item?id=43241464</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43241464</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43241464</guid></item><item><title><![CDATA[New comment by marsovo in "Zelensky leaves White House after angry meeting"]]></title><description><![CDATA[
<p>What evidence have you seen that this was somehow instigated by China, and not Russian ethnic nationalism/imperialism for its own sake?  Remember that this started well before 2022.  This is a recap and prescient analysis from 2014: <a href="https://www.fpri.org/article/2014/05/putins-greater-novorossiya-the-dismemberment-of-ukraine/" rel="nofollow">https://www.fpri.org/article/2014/05/putins-greater-novoross...</a><p>And you can see a premature declaration of victory along similar lines from the Russian state media, which was then taken down when Ukraine did not in fact fold in three days: <a href="https://www.bbc.com/news/technology-60562240" rel="nofollow">https://www.bbc.com/news/technology-60562240</a>.  You can see the archive.org capture of the original article linked there if you wish to see the primary source.<p>Yes, their GDP is weak (nevertheless, Russia persists).  No, it doesn't make any sense if you look at it through a normal Western lens, which is why there was widespread disbelief that Russia was to imminently invade Ukraine.  But, as the saying goes, "Russia can't be understood by the mind alone"</p>
]]></description><pubDate>Sun, 02 Mar 2025 04:58:11 +0000</pubDate><link>https://news.ycombinator.com/item?id=43227492</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43227492</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43227492</guid></item><item><title><![CDATA[New comment by marsovo in "GSA Eliminates 18F"]]></title><description><![CDATA[
<p>I once thought this was the solution too, then NYC's ranked-choice mayoral race gave it Eric Adams.  Now I don't know.  Maybe open primaries?</p>
]]></description><pubDate>Sun, 02 Mar 2025 03:06:20 +0000</pubDate><link>https://news.ycombinator.com/item?id=43226789</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43226789</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43226789</guid></item><item><title><![CDATA[New comment by marsovo in "Zelensky leaves White House after angry meeting"]]></title><description><![CDATA[
<p>Did Jeff Bezos enter your home and annex your attic?</p>
]]></description><pubDate>Sat, 01 Mar 2025 14:25:20 +0000</pubDate><link>https://news.ycombinator.com/item?id=43219496</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43219496</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43219496</guid></item><item><title><![CDATA[New comment by marsovo in "Zelensky leaves White House after angry meeting"]]></title><description><![CDATA[
<p>Not to take away from your accurate point about oil, but I think it's silly to say the "we're still in the cold war" crowd were out of touch in this of all threads.</p>
]]></description><pubDate>Sat, 01 Mar 2025 14:23:42 +0000</pubDate><link>https://news.ycombinator.com/item?id=43219481</link><dc:creator>marsovo</dc:creator><comments>https://news.ycombinator.com/item?id=43219481</comments><guid isPermaLink="false">https://news.ycombinator.com/item?id=43219481</guid></item></channel></rss>