Database application recommendations

[kagstrom2100]

Hello!

 

So I got an excel spreadsheet at work that is starting to getting to large for it's own good.

I was thinking about migrating it to some kind of database service, where you can view, enter and edit the data from some kind of application. 

 

 My question then is, does anyone know of some pre-made applications that would fit this? Or would a DIY solution be better? Also like to mention that it need to be "offline" (AKA can't use the cloud)   

 

Thankful for any input on this :)

[Windows7ge]

I'm thinking MySQL + phpMyAdmin but the setup would take a while and you'd how to know how to incorporate it into your workflow. Also I only know of it for Linux so you'd probably have to host it on a local server. Not ideal but just an idea for you.

[kagstrom2100]

1 minute ago, Windows7ge said:

I'm thinking MySQL + phpMyAdmin but the setup would take a while and you'd how to know how to incorporate it into your workflow. Also I only know of it for Linux so you'd probably have to host it on a local server. Not ideal but just an idea for you.

Yeah, I was thinking of something like that too, and if I can't find anything else I'd have to go with that. Was just hoping that there'd be something like this that you could buy somewhere.

 

Anyways, thanks for your reply!

[Windows7ge]

2 minutes ago, kagstrom2100 said:

Yeah, I was thinking of something like that too, and if I can't find anything else I'd have to go with that. Was just hoping that there'd be something like this that you could buy somewhere.

 

Anyways, thanks for your reply!

There definitely is. There's a market for it but I've not had a need for that type of software so I can't name any other than what I mentioned.

[kagstrom2100]

Just now, Windows7ge said:

There definitely is. There's a market for it but I've not had a need for that type of software so I can't name any other than what I mentioned.

Ah okay, thanks anyways!

[LogicalDrm]

If your work has Enterprise version of Office, it has Access included. For basic database stuff, it's quite enough. I use it as intermediate mean between Excel and softwares using databases as part of operations (but which don't support direct import or export from Excel or even CSV).

 

At school we are about to start using PostgreSQL. I have no experience from that.

[speed258]

well I "could" recommend amazon aws DynamoDB, its fast, has database synchronization across different regions(europe, north/south americas and etc), meaning you can get best response times in different regions and use as single DB in all regions, but learning curve is quite steep, but once you understand it will be very easy to use and easiest management this db is in c#, php requires quite too much coding for each query.

[kagstrom2100]

11 hours ago, LogicalDrm said:

If your work has Enterprise version of Office, it has Access included. For basic database stuff, it's quite enough. I use it as intermediate mean between Excel and softwares using databases as part of operations (but which don't support direct import or export from Excel or even CSV).

 

At school we are about to start using PostgreSQL. I have no experience from that.

Yeah I did peek at Access today after I tried doing my own database app site and realized I was way over my head. I'll look further into Access though on Monday, thanks for the tip!

[kagstrom2100]

8 hours ago, speed258 said:

well I "could" recommend amazon aws DynamoDB, its fast, has database synchronization across different regions(europe, north/south americas and etc), meaning you can get best response times in different regions and use as single DB in all regions, but learning curve is quite steep, but once you understand it will be very easy to use and easiest management this db is in c#, php requires quite too much coding for each query.

Thanks, though as I said in my original post It need to be "offline", but thanks anyways!