Tracking SQLite Database Changes in Git

Re:Tracking SQLite Database Changes in Git by chrismorgan on Friday November 03, 2023 @03:37AM (#38125635)

Improved benchmarking script (I just wasn’t thinking carefully at the time, just getting something out quick; but eval is obviously better than requiring a function):

  try() {
      echo -e "\e[32;1m$1\e[m"
      for (( run = 0; run < 5; run++ )); do
          time (for (( i = 0; i < 1000; i++ )); do
              eval $1
          done)
      done
  }

  try "/usr/bin/echo .dump | true"
  try          "echo .dump | true"
  try            "<<<.dump   true"
  try                       "true"

[ Parent | on HN ]

Re:Tracking SQLite Database Changes in Git by chrismorgan on Saturday November 04, 2023 @12:49AM (#38138244)

I also want to note that this is thoroughly into the nanowatt-hour scale (even at the unrealistically low figure of 1W power consumption, 300μs makes it 83⅓ nWh). Tens or hundreds of thousands of picowatt-hours!

[ Parent | on HN ]