@OldGrumpyBitWrangler@mastodon.social
@OldGrumpyBitWrangler@mastodon.social avatar

OldGrumpyBitWrangler

@OldGrumpyBitWrangler@mastodon.social

Grumpy old bit wrangler ranting about the state of digital technology across the whole stack and all layers, including 8 to 10.

This profile is from a federated server and may be incomplete. Browse more on the original instance.

OldGrumpyBitWrangler, to php
@OldGrumpyBitWrangler@mastodon.social avatar

An instance of a popular CMS is used for a website. While analyzing I'm coming across a a table in it's MySQL database where a column called "deleted" is defined as such:

deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted‘

🤦‍♂️

There should be a license allowing allowed to write software used by someone else. Like with drivers licenses it needs a points system for violations and license revocation.

OldGrumpyBitWrangler,
@OldGrumpyBitWrangler@mastodon.social avatar

@Crell What I would do? Use PostgresSQL. According to documentation MariaDB has BOOLEAN as an alias for TINYINT(1). MySQL might as well, but their documentation is as crappy as ever.

OldGrumpyBitWrangler,
@OldGrumpyBitWrangler@mastodon.social avatar

@Crell it's both. Well actually more than that. I object the use of MySQL for many reasons, including the sloppy way it's been developed over its lifetime, the BOOLEAN type being a quiet minor example of that. I also object MySQL b/c said sloppyness encourages bad practices with many, less experienced developers and normalizes that. Which leads to my 3rd objection: The definition of the ‚deleted' column by the CMS/module developers. TINYINT(4) for a boolean that by definition is either 0 or 1.

OldGrumpyBitWrangler,
@OldGrumpyBitWrangler@mastodon.social avatar

@Crell To me "odd choice" would apply some thinking behind it. I don't know what that was, but the same part of the code does do even more silly things: https://mastodon.social/@OldGrumpyBitWrangler/112407018128767799

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • provamag3
  • kavyap
  • DreamBathrooms
  • InstantRegret
  • magazineikmin
  • thenastyranch
  • ngwrru68w68
  • Youngstown
  • everett
  • slotface
  • rosin
  • ethstaker
  • Durango
  • GTA5RPClips
  • megavids
  • cubers
  • modclub
  • mdbf
  • khanakhh
  • vwfavf
  • osvaldo12
  • cisconetworking
  • tester
  • Leos
  • tacticalgear
  • anitta
  • normalnudes
  • JUstTest
  • All magazines
    •