On-Prem LIMS Ideas
Posted by Maganac@reddit | sysadmin | View on Reddit | 12 comments
So, my work is wanting to look into replacing our On-Prem LIMS. It was made in house, but was developed on an outdated IDE over a decade old. There were attempts to convert it to newer IDE versions, but they apparently did not pan out.
Thing is, we also need it to handle quotes and quickbooks, so I'm already restricted because of that.
I was wondering if anyone had any ideas? I was Considering Labii or QBench, but I have only heard mixed results for QBench and both have to be Online only.
Was considering Jstreet, but it seems al little outdated as well.
Any other ideas would be appreciated.
RedShift9@reddit
The IDE doesn't really matter, what language/framework was it written in?
Maganac@reddit (OP)
PowerBuilder....12.5
RedShift9@reddit
Doesn't necessarily have to be a problem. I've often seen projects like this go wrong because they try to do too much. Whilst moving to a more modern toolchain, they try to fix all the warts etc... Basically "while we're here we might as well"... but this is the wrong approach.
Your first order of business should be to get the existing toolchain under control, so you take that 12.5 version, make sure you can build the program and roll it out. At the same time you create the documentation how this process works.
Once you have everything under control again, then you can start migrating the code to newer PowerBuilder versions. Not the latest and greatest, no, just the next step up from 12.5. Fix whatever is broken, deprecated, etc... Do not make any functional changes or whatever, only make the necessary changes to make the code work on that newer PowerBuilder version. Again your goal here is to make something and then roll it out as well.
Keep iterating through the newer versions of PowerBuilder until you are at a supported release. Do not skip versions, you will have to change too much code at once. And keep releasing your program. Don't stash everything until some large launch or something, that will get in into trouble.
After your code is on a supported release of PowerBuilder, then you can start fixing the warts.
Slow and steady wins the race.
gihutgishuiruv@reddit
Conflating the two typically indicates some sort of RAD framework where the framework, IDE, and compiler are all bundled together. Think VB.NET or Borland C++
Ragepower529@reddit
If it was in house made, and you have experience with Claude code you can probably easily do lots of upgrades to it. To make sure you work on a Sandbox.
I don’t imagine the on prem program being so complicated
Maganac@reddit (OP)
I am not sure Claude has much experience with PowerBuilder 12.5.
Ragepower529@reddit
Surprisingly i look at the training data and there isn’t that much it got trained on. So probably a lot of hallucinations.
Maganac@reddit (OP)
It doesn't help that PowerBuilder is incredibly obscure by this point.
ConflictResident5253@reddit
Dang, son.
kona420@reddit
What's your interface with quickbooks? Is it the SDK for the desktop version? You're going to need to build a new bridge.
I would be tempted to do the whole stack at once, migrate to Quickbooks online and your new LIMS at the same time.
Maybe a workflow tool like n8n to bridge the systems together with LLM for your quoting process?
Maganac@reddit (OP)
I was actually working on a Quickbooks online bridge, but I am more worried about user training as I don't know if there is a big difference between the online browser interface and the desktop version.
applecorc@reddit
The LIMS I use probably is too niche for use, but I imagine you'll need to anticipate building the bridge between your new LIMS' API and QuickBooks yourself or paying your new vendor to do it for you.