Fatigue-Analysis

Choosing the Right Sqlite Indexes to Improve Rainflow Cycle Counting Performance

Apr. 29, 2023 golang · fyne · fatigue-analysis ·

I thought that I knew a thing or two about sql indexes. It’s easy right, you just run a couple sql commands to create your index, and you’re off to the races. Turns out that it isn’t quite that easy to get the index you need. You need to know a few things.

  1. You need to know how sql indexes work (especially for the database you’re using, we’ll be discussing sqlite3)
  2. You need to know how you’re going to query your data.

Example Data Tables

If you’re brand new to sql and have never heard of indexes, it would make sense that we take a bit of a sidebar and discuss why they are important. Let’s lay a bit of groundwork to get us started on this discussion.



Rainflow Cycle Counting: Efficient memory use for large datasets using Go channels

Apr. 26, 2023 golang · fyne · fatigue-analysis ·

Curious how you can get started processing 100 Million data points, using only 150 MiBs of memory, from a native GUI application? Keep reading to figure out how we’ve been working on this problem.

In a previous post, we talked about the design goals that were important to a rainflow cycle counting application that we’re working on. Two of those goals are in somewhat of a conflict, Efficient and Quick, but efficient edged out over quick in the priority scale. We decided being able to run on lower spec hardware instead of a massive datacenter machine with gobs of memory, was more important than being super quick.



Fatigue Analysis Rainflow Cycle Counting

Apr. 15, 2023 golang · fyne · fatigue-analysis ·

Rainflow cycle counting ยท custom software build

At High Creek Software we have been working on a purpose specific tool to extract cycles out of an inline inspection dataset. Our hope is to provide an accurate and fast process for extracting cycle data to be used in fatigue life analysis.

To get started, this is still a work in progress, but we feel that we’ve made good enough progress to start talking about it. Right now, we have a project based UI where you can: