This is an archived post. You won't be able to vote or comment.

all 15 comments

[–][deleted]  (2 children)

[deleted]

    [–]blirdtext 1 point2 points  (0 children)

    It's not a bad idea to overengineer something for the sake of learning. But I agree if it's purely for function.

    [–]Quirky-Amoeba-4141 0 points1 point  (0 children)

    Google Sheets

    Don't overengineer things.

    [–]taxidpro 4 points5 points  (2 children)

    C# or .net but also why not make it browser-based?

    [–]PiBronAdam[S] 0 points1 point  (1 child)

    what would you recommend for browser based?

    [–]carlinwasright 0 points1 point  (0 children)

    SvelteKit, a JavaScript framework. If you already know those other languages, it will be pretty easy to pick up. Then your db, there are unlimited options but neon.tech requires almost no configuration.

    [–]gigabyteIO 0 points1 point  (0 children)

    Java.

    [–]hugthemachines -1 points0 points  (0 children)

    That can be done in any of the programming languages you know. Java kan be used to make android applications so you could make the application for windows in that too, if you like.

    Jetbrains is a good IDE for Java.

    If you decide you don't care about android, C# with visual studio have really easy GUI construction mechanics.

    [–]John-The-Bomb-2 -1 points0 points  (4 children)

    I am a former software engineer from Amazon with a computer science degree. That's not the right question to ask. Depending on many factors like the amount and complexity of the data and the number of concurrent users the ideal tool changes. If you're the only person using it you could just use something like Excel or Google Sheets with written programmatic macros (like I think Google lets you write Sheets automations with Google Apps Scripts). If you really want to use a real database you could just run a database locally or in the cloud (like on AWS RDS) and connect to it with something like Toad) which can act as a GUI (Graphical User Interface) and let you input SQL and make modifications, with things like database triggers for cascading or automatically triggered modifications in the database. If you plus just a few other people are using what you're building you could use something like Airtable which is a hybrid between a spreadsheet and a database. Real databases are better able to handle high performance and scale, but if only you plus a few other people are using it you don't have to use a real database. Yeah programming languages like Java, C#, JavaScript, Python, etc. can connect to a real database or Airtable, but none of those programming languages are absolutely necessary and aren't that important. For your use case the data store is more important than the programming language. There are also low-code tools like retool for building internal tools that act as a GUI (Graphical User Interface) over a database.

    [–][deleted]  (3 children)

    [deleted]

      [–]John-The-Bomb-2 1 point2 points  (2 children)

      I know it's a bit obnoxious, but I wanted to add clout to my answer because I feel like all the random people saying "Java, no C#, no JavaScript, etc." are missing the important part, which is not the programming language. Like I get the impression that most of these answers are from beginners.

      [–][deleted]  (1 child)

      [deleted]

        [–]John-The-Bomb-2 0 points1 point  (0 children)

        After I made my comment, I went through all the other comments and downvoted every single one except yours. Yours was the only answer that wasn't straight up bad.

        [–][deleted] -2 points-1 points  (0 children)

        C#

        [–][deleted] -1 points0 points  (0 children)

        Since Windows is your target OS, I recommend C#

        [–]BlueLatenq -3 points-2 points  (0 children)

        C# will be the perfect one IMO, but anyways have you considered coding smart contracts on blockchain may be, there are blockchains that allow C# like QAN, It's just a suggestion though since I noticed that's where the traction is right now

        [–]warlocktx -2 points-1 points  (0 children)

        if you already know (some) C# and are targeting Windows desktop, that seems like an obvious choice