• 5 Posts
  • 1.11K Comments
Joined 2 years ago
cake
Cake day: August 3rd, 2023

help-circle
  • I don’t remember a flu causing massive shutdowns throughout the country, empty downtowns, bank runs, empty store shelves, rampant price gouging, large bailouts for industry, an entire program setup to enrich the already rich by raiding the treasury, a massive grifter program for “small business”, large scale free vaccination programs, etc etc etc.

    You’re not reading my posts and then claiming I’m skimming yours. The US hasn’t seen the type of large scale unrest you’re predicting here in a hundred years, and this dude’s approval ratings are up, not down.

    Everything seems to indicate that people will indeed continue to tolerate things getting worse, and that they will continue to blame the unfortunate for their own misfortune.


  • Like it or not, for most people, covid was a minor inconvenience. For most people it did amount to a flu.

    I think your COVID denialist is showing a bit. The impact of the virus itself isn’t what I was writing about. They were running large amounts of con job and swindle programs and engaging in what would best be described as crisis capitalism. That’s what I’m talking about. If you seriously think the red states – the very same red states that voted a guy back in that had run the cupboards bare and sold off whatever wasn’t nailed down, used the pandemic to pitch beans to the public, and then tried to stay in office by throwing a coup – are going to ever come around to acknowledge that they were swindled by this loser and turn on him en masse, I’m not sure what to tell you.


  • But I don’t think that will be possible, because it really seems like there’s no way all of these piss poor executive orders won’t have very tangible repercussions on the working class.

    I think that’s where the rubber hits the road in this country. I don’t think any mass movement against Trump will start up until there are large repercussions that are clearly linked to his actions. But unfortunately, the bar has been raised over the years as well because the rich people are mostly for the pain he’s inflicting and the country is organized and run by the rich.

    It’s starting to look like COVID was the test run the right-wingers on social media were worried about, but as per usual they viewed it through the wrong lens. COVID taught the rich that allowing mass disease, pain, disaster, wealth transfer, and death in the country will not make it more community-oriented and compassionate and will not result in any political repercussions for those exacerbating the problems. COVID was a test run for just how much suffering the people of this country were willing to tolerate without getting unruly (which apparently we as a country have a much bigger appetite than I would have guessed), and the lasting narrative of COVID isn’t that the Republicans did too little, it’s that we shouldn’t have bothered doing as much as we did to help those suffering.

    It’s difficult to see how there will be even a splintering in this coalition before it’s way too late to do anything about it.

    I don’t know why the country and its leaders didn’t see that getting him out of office in 2021 relatively easily was a miracle and we’re not likely to be blessed twice. I think we have a long, and difficult road ahead of us to ever align this country even slightly in the interests of its people.


  • America has no principals therefore any movement peters out without any resolution.

    I think this is very true. However, I don’t think it’s wholly unique to the US. Canada’s idea of being a “mosaic” is also based upon multi-culturalism and I don’t think that the entirety of the country holds that as a principle either.

    America has no identity outside of money.

    This is also a true statement. We used to hold other values until every organization that trumpeted them also turned toward the all-mighty dollar (including – and in a lot of ways led by – religion).




  • I believe you, but this is also a very left-leaning site that pretty much filters out all of the conservative idiocy from it. The general public doesn’t seem to give a shit and when I go out and about in the world it’s like nothing has even changed. I suspect it will be this way for a while even if eventually there is full-blown fascism with a world war and death camps. I remember reading remarks by people who were around during the formation of the Third Reich in Germany and I remember them writing something like all the shops and everything were open and people were going to work like normal for a large portion of it. There was even a person that didn’t realize how crazy the country had gotten until he saw his small child imitating Hitler and saying antisemitic shit about Jews.



  • I’m talking about a SQL join. It’s essentially combining two tables into one set of query results and there are a number of different ways to do it.

    https://www.w3schools.com/sql/sql_join.asp

    Some joins are fast and some can be slow. It depends on a variety of different factors. But making every query require multiple joins to produce anything of use is usually pretty disastrous in real-life scenarios. That’s why one of the basics of schema design is that you usually normalize to what’s called third normal form for transactional tables, but reporting schemas are often even less normalized because that allows you to quickly put together reporting queries that don’t immediately run the database into the ground.

    DB normalization and normal forms are practically a known science, but practitioners (and sometimes DBAs) often have no clue that this stuff is relatively settled and sometimes even use a completely wrong normal form for what they are doing.

    https://en.m.wikipedia.org/wiki/Database_normalization

    In most software (setting aside well-written open source), the schema was put together by someone who didn’t even understand what normal form they were targeting or why they would target it. So the schema for one application will often be at varying forms of normalization, and schemas across different applications almost necessarily will have different normal forms within them even if they’re properly designed.

    All that said, detecting, grouping, comparing, and removing duplicates is a basic function of SQL. It’s definitely not expected that, for instance, database tables would never contain a duplicate reference to a SSN. Leon is indeed demonstrating here that he’s a complete idiot when it comes to databases. (And he goes a step further by saying the government doesn’t use SQL when it obviously does somewhere. SQL databases are so ubiquitous that just about any modern software package contains one.)


  • SSNs being duplicated would be entirely expected depending upon the table’s purpose. There are many forms of normalization in database tables.

    I mean just think about this a little bit, if the purpose is transactions or something and each row has a SSN reference in it for some reason, you’d have a duplicate SSN per transaction row.

    A tiny bit of learning SQL and you could easily see transactional totals grouped by SSN (using, get this, a group by clause). This shit is all 100% normal depending upon the normalization level of the schema. There are even – almost obviously – tradeoffs between fully normalizing data and being able to access it quickly. If I centralize the identities together and then always only put the reference id in a transactional table, every query that needs that information has to go join to it and the table can quickly become a dependency knot.

    There was a “member” table for instance in an IBM WebSphere schema that used to cause all kinds of problems, because every single record was technically a “member” so everything in the whole system had to join to it to do anything useful.










  • I can’t imagine this will reach the right audience, but in the lead up to the superb owl this year I was saying that a great sketch about this country would be to have this giant hyped up spectical where everyone’s getting all fucking jazzed up and talking about how all of this epic shit is going to happen and then at the climax of the sketch you get to the actual “action” and it’s just a dude flipping a coin once.

    That’s America IMO, and it’s definitely illustrated fully in the super bowl: six hours for ten seconds of actual action interrupted constantly by bullshit and commercials and followed by idiots tearing “their city” apart because their laundry was crowned “world champions” of a sport only played by people in one country.