offline database options

[AHarvey]

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.

 

[D3K]

What's stopping you from doing exactly the same with MySQL and a web front end, but keeping it offline and only on their intranet?

 

[touch]

What's stopping you from doing exactly the same with MySQL and a web front end, but keeping it offline and only on their intranet?

This. If it's what you're most comfortable with, just install the database and website on their file server. Maybe SQL express would do what you want rather than MySQL?

 

[chroniclard]

MS SQL express is free and fine for "small" databases, latest verion is 10gb max database size.

 

[AHarvey]

excellent, as usual, I was over complicating it.

Thanks

 

[Dj_Jestar]

I'd choose postgresql over mysql, or even sqlite if it's that small.

 

[Hades]

I'm guessing your wife volunteered you for this

But as above, take the same approach but host locally.