Current Events > Looking to build an app. Need database recommendations

(+) Yeah! (+)

Going to be building an application in AWS but not sure whats the best type of database. Im really not much of a data guy. Work in cybersecurity but doing some app development for work.

Just gonna use AWS to build a simple inventory management tool thatll store a good bit of information on over 500 systems/applications.

I was thinking of just going basic and doing a basic SQL database. Wanna be able to easily create views and compare fields between our sets of applications.

halp CE Im data dumb

Oracle RDBMS, when properly configured, is by far the best database. However, nobody has ever managed to do that.

Use Kubernetes and MongoDB

MongoDB

Ok so first you need Docker. Then you need to configure it in both your development and production environments, plus a separate QA and UAT environments, which you can deploy to using Kubernetes alongside your visual studio automated build features which can all be managed through active directory and Microsoft system center. After you've got all that set up you can finally install MS SQL Server alongside SQL Server Management Studio and don't forget to install SQL Server Integration Services while you're at it which is what you need to automatically populate the data your SQL Server Reporting Services that can get plugged into your Business Intelligence software of choice.

Or like just use Microsoft access or some shit it's only 500 items.

Tyranthraxus posted...

Ok so first you need Docker. Then you need to configure it in both your development and production environments, plus a separate QA and UAT environments, which you can deploy to using Kubernetes alongside your visual studio automated build features which can all be managed through active directory and Microsoft system center. After you've got all that set up you can finally install MS SQL Server alongside SQL Server Management Studio and don't forget to install SQL Server Integration Services while you're at it which is what you need to automatically populate the data your SQL Server Reporting Services that can get plugged into your Business Intelligence software of choice.

Or like just use Microsoft access or some shit it's only 500 items.

500 applications, which each have about 30-40 attributes each. I know its not super big, but still.

this is gonna be a lot more work than I thought ugh

MFBKBass5 posted...

500 applications, which each have about 30-40 attributes each. I know its not super big, but still.

this is gonna be a lot more work than I thought ugh

You're overthinking this. Grab SQL lite and be done with it. Microsoft Access will also work.

Tyranthraxus posted...

You're overthinking this. Grab SQL lite and be done with it. Microsoft Access will also work.

hmm. Will have to explore both of those options. What about making a simple UI? Would using a free solution like Budibase be a bad idea? I want something simple enough to work with, but has customization accessible if I really need to tweak a function

https://www.youtube.com/watch?v=jVy0JWX5XEY

Heineken14 posted...

https://www.youtube.com/watch?v=jVy0JWX5XEY

hey Im salaried Im just doing stuff out of the normal scope of my job because I wanna learn and it sounds like a fun challenge

[LFAQs-redacted-quote]


lmao still trying to harass and stalk I see

[LFAQs-redacted-quote]


awww you must have missed me so much bby its sweet of you to welcome me back ;)

since you're using AWS, i would recommend Aurora, RDS or DynamoDB (which are their database services). just explore each and see which one suits your needs the best!

What's wrong with just using your own SQL database?

ZevLoveDOOM posted...

since you're using AWS, i would recommend Aurora, RDS or DynamoDB (which are their database services). just explore each and see which one suits your needs the best!

Yeah DynamoDB seemed easiest since it just uses microservices.

I did check out Microsoft Access which is fairly easy to use. I need to learn how to mess around with GUIs next, but thatll come with time haha

MySQL or Postgres. MySQL for speed, Postgres for larger DB. Both are popular RDBMS with well understood and pretty much unchanging license (open source duh).

I can't stress this enough but whichever you pick be very careful with the license TC, especially if you go beyond personal use. Just because a license suits you now doesn't mean it can't change and bite you in the future.

look into DynamoDB since you're already in AWS.

[LFAQs-redacted-quote]


how about you stop shitposting, kid. how do we know this was a shitpost? it brings zero value to the topic and only serves to start shit where there wasn't any.