Saturday, November 07


Daily News Stuff 7 November 2020

Because More Reasons Edition

Tech News

  • Working on the UI of the new social platform today.  I licensed a Bootstrap theme that has designs for pretty much everything I need - social newsfeeds, blogs, forums, photo galleries, videos and streams, profile pages, all that stuff.  But it was also visually busy and slow to load.

    I've slimmed it down and sped it up, and made the content load dynamically into a static frame.  There's still a small issue with the initial page load, it's now fast enough that you have to know what you're looking for to notice it.

    Tomorrow I'm going to implement MariaDB bitemporal tables.  These are interesting beasts: They version-track your data.  You can run a query to show you what your blog looked like last Tuesday before you messed it up, or to show all the edits to a post.  Handled entirely by the database server.

    I plan to use bitemporal tables rather than simply temporal tables because if you  dump and load a temporal table all the history vanishes, and likewise you can't import history from an existing source.  A bitemporal table tracks history both by system time and application time.

    I checked on a couple of details tonight, and it looks pretty good.  You can partition a temporal table so that the live data is in one file and the history in another (or several others), you can drop old history partitions if you don't need them and the disk is full, and you can add new columns to a temporal table.  That's not what the SQL:2011 standard says, and it's not correct from an auditing perspective, but I'm glad they did it because I doubt I could use this feature if it meant never changing my database definitions after launch.

    Update: Ugh, they've deprecated TokuDB.  It doesn't work with temporal tables anyway, but it was a really solid database engine.  InnoDB is supposedly the gold standard but it uses far more storage and offers worse performance.

  • Facebook has gone all-in on censorship.  (Vice)

    The usual suspects are still complaining that they aren't silencing people fast enough.

    Orwellian doesn't begin to cover it.

  • Scientists have discovered a planet where it rains rocks and the oceans are lava.  (CBS)

    Sounds like SMOD went to the wrong address.

  • The Xbox Series X vs. The Good God That Thing Is Ugly.  (Tom's Hardware)

    The Xbox is faster, uses less power, and is quieter than the GGTTIU, but not by a huge amount in any category.  For a proper head-to-head test we'll need multiple cross-platform titles optimised for each system, and so far there aren't any.

  • "><SCRIPT SRC=HTTPS://MJT.XSS.HT> LTD has been forced to change its name.  (The Guardian)

    Yes, someone Little Bobby Tablesed the agency responsible for registering business names in the UK.

  • Okay, I don't think that chilli was as gluten-free as the label suggested.  Gotta go.

Video of the Day

Miko showed up in Coco's Minecraft stream and things went about as you would expect.  The chaos starts before this, but the highlight is the three minutes starting at 26:00.

Disclaimer: sakuramiko35 fell from a high place.

Posted by: Pixy Misa at 09:35 PM | Comments (4) | Add Comment | Trackbacks (Suck)
Post contains 527 words, total size 4 kb.

1 OH! 

I was envisioning something like Twitter, Parler, or Pawoo. This sounds rather more impressive. Will we be able to migrate our blogs there or is this activating additional options in the dashboard menu?

Posted by: The Brickmuppet at Sunday, November 08 2020 01:52 AM (5iiQK)

2 Scientists have discovered a planet where sexy purple cat girls are real… Scientists have discovered a planet where overweight losers are considered the true royalty… Scientists have discovered a planet where the jocks who gave them wedgies in high-school are all being given spankings 24/7 by Baron Harkonnen look-alikes…

Posted by: normal at Sunday, November 08 2020 05:35 AM (obo9H)

3 Every slightly conservative FB group I'm in has had post moderation irrevocably forced on it until January 6th.

BTW, Spam.

Posted by: Mauser at Sunday, November 08 2020 01:44 PM (Ix1l6)

Hide Comments | Add Comment

Apple pies are delicious. But never mind apple pies. What colour is a green orange?

53kb generated in CPU 0.016, elapsed 0.2431 seconds.
58 queries taking 0.2324 seconds, 342 records returned.
Powered by Minx 1.1.6c-pink.