I have had a pretty massive spreadsheet for a while that I need to get a little bit more out of and I don't have the time to write a bunch of custom code to do it.
Many years ago I used Microsoft Access for this sort of thing. Don't you dare tell anyone..... Actually I think I've even used Borland Paradox before for this sort of thing if any of for recall that.
So I'm looking for a rapid self-hosted rdbms software. Not just "install mariadb and write some php". I might be okay with a free or paid cloud-based solution. I've tried a couple. But they look centered around simple customer/order tracking. That's really not what I'm doing though.
I need to be able to generate printable PDFs "reports" from the data, I need input forms to add records to different tables.
I need to import a csv, and normalize its contents into multiple tables. And do that a couple times a year.
I need to be able to visualize some of this data on maps. It has names and addresses, voting and party affiliation history. It's voter data actually. I'm running for office in Merriam Kansas by the way. I wonder if I could become the first mayor that uses Linux.... Lord help us.
Check out my campaign at https://Croan.org if you're interested! ESPECIALLY IF YOU LIVE IN MERRIAM, OR HAVE FRIENDS HERE.
I need a small team to be able to collaborate on this data and be able to create filter views myself without affecting others' access to it. And without creating disparate copies.
I need to be able to set up views for the data the draw from multiple tables and provide buttons and links to accomplish certain tasks.
There are web services that do some of these things but they're geared towards much larger races. My city is only 10,000 houses and only about 1500 voters that regularly vote in City elections. Nearly all the services I've tried come with their own issues.
I know there's a handful of CRM softwares that might kind of apply but voter data is not exactly a match for CRM software. I'm more interested in demographics and history and relationships and mapping than products and sales.
What RDBMS software would you guys recommend?
And would any of you be interested in bringing the basics of this online and then I'll put the rest together as I need it?