Anyone who knows me will understand it when I say that I am as think as ****. I have an abstract way of looking at things and numbers etc often get jumbled up when I use them. I understand relational databases and have in the past built workable databases using a building tool. I stopped using it several years ago and to transfer my licences will cost £5k. The builder I used was Alpha5 and so I have been looking around for an alternative that is open source. Look back at the first bit of this post... I have decided to install MySQL and run a database builder Nu-Build. I really need someone to help me at various stages of the build, simple stuff that relates more to the background and structures rather than the database itself. I am trying to build a database for case and client management, with invoicing, remittance and financial reporting.
That sounds like it could end up being a fairly complex database utilising stored procedures, reporting services and all sorts. Are you sure there isn't an off the shelf application that will do it all at a bearable cost? Most software seems to be available by monthly subscription these days so no upfront costs.
In 10 years of looking there isn't anything suitable. That's why I wrote my own before and it's the same now.
I am qualified in computerised accounts, I am actually a Sage reseller and we do the bookkeeping for 7 companies using Sage Client manager. The difficulty for example is that I have to produce invoices for insolvent companies. I have 136 different companies on my system and that would cost me a fortune on any accounting program.
I'm not sure what you mean by database builder? Is it some sort of gui or is it a front end for a database? If cost is an issue, just stick an Access front end on a MySQL or SQLExpress database? I currently use SSMS with SSRS or Power BI, but if I was after a front end to take input I'd prob build it in .Net.
Kinell. Sounds like a load of expense, complexity, hassle, time, heartache, ........ I thought technology was supposed to make life easier?!! Maybe just revert to pen and paper, and a simple spreadsheet? Or get someone else to do it? Life's too short. #KISS
