3 ms·
Maybe a combination of AirTable and PowerBI/open-source alternative? Or just ms access backed by a proper database?
by spockz 9mo ago
Maybe a combination of AirTable and PowerBI/open-source alternative? Or just ms access backed by a proper database?
- jon-wood 9mo agoGrist[1] is great for this stuff, at first glance its a spreadsheet but that spreadsheet is backed by a SQLite database and you can put an actual UI on top of it without leaving the tool, or you can write full blown plugins in Javascript and HTML if you need to go further than that. [1] https://www.getgrist.com/ https://www.getgrist.com/
- viraptor 9mo agoJust another yay for Grist here! I've been looking for an Access alternative for quite a while and nothing really comes close. You can try hacking it together with various BI tools, but nothing really feels as accessible as the original Access. While it's not a 1:1 mapping and the graphical report building is not really there, you can still achieve what you need. It's like Access 2.0 to me.
- fsagx 9mo agoAccess as a front end for mssqlserver ran great in a small shop. Seems like there was a wizard that imported the the access tables easily into sqlserver. I've not seen anything as easy to use as the Access visual query builder and drag-n-drop report builder thing.