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?
