• 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.

1 OH! 

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

 

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

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

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

Hide Comments | Add Comment