Soldato
Hi all,
I have a task to build a simple database for my wife's work to track suppliers that offer non-standard services.
Ideally, I'd do it online, MySQL and a web front end. I work with SQL it's easier for me but setting up dbase/software isn't. However, they have a shared file server they use for storing templates letters/forms/policy info and they'd like it stored on there.
What options do I have for creating a simple database and options to expand it over time if needed. SQL ideally, can't be MS Access as the directors don't like it due to previous issues with it.
I've had a quick look at Access alternatives and Libre Base seems like an option, another would be SQLite but I've never used it before, could I create some simple html files to interact with it to run directly in the browser or do I need to look at C#/Python to interact with it?
Could I just put a free version of SSMS on a network machine and use that to create a dbase on the network?
Python is better than C# but both are rusty for me and at a basic level.
I have a task to build a simple database for my wife's work to track suppliers that offer non-standard services.
Ideally, I'd do it online, MySQL and a web front end. I work with SQL it's easier for me but setting up dbase/software isn't. However, they have a shared file server they use for storing templates letters/forms/policy info and they'd like it stored on there.
What options do I have for creating a simple database and options to expand it over time if needed. SQL ideally, can't be MS Access as the directors don't like it due to previous issues with it.
I've had a quick look at Access alternatives and Libre Base seems like an option, another would be SQLite but I've never used it before, could I create some simple html files to interact with it to run directly in the browser or do I need to look at C#/Python to interact with it?
Could I just put a free version of SSMS on a network machine and use that to create a dbase on the network?
Python is better than C# but both are rusty for me and at a basic level.
