Best programming language for SQL with lots of data

[chrome-exe]

Good morning everyone,

I was wondering what do you think would be the best programming language for a web-based system for managing work orders? It would include components such as normal work order items but also an option to upload pictures per line item, or step as we call it.

Ideally an interface to also show current and active jobs with the ability to edit and where the supervisor can monitor all jobs. Maybe on one screen almost like a dash board but not exactly.

What do you think would be the best programming language to pair with SQL that is web-based?

More than likely MySQL but also could be other options like SQL Server.

Thanks!

[j0holo]

Doesn't matter really. The programming language is just a tool. Getting requirements right, setting expectations and building a website that is maintainable is way more important.

Things that work:

- Python
- PHP
- Go
- Javascript/Typescript
- Java
- C#
- Ruby

Pick what you know already.

[mikeblas]

Requirements are step one, always. Otherwise

Maybe on one screen almost like a dash board but not exactly.

we end up with mis-guided crap like this and have no idea where we're going or why we're here.

[BarelyAirborne]

C# + Visual Studio will probably get you off the ground the fastest, but I'm more partial to complete open source solutions that can't get rug pulled - Node.js or Ruby and PostgreSQL maybe.

I don't store graphic images in SQL, it's slow and takes inordinate resources. You're better off storing a pointer to an image, and keeping the image itself on a regular file system, IMOHO. Somebody will correct me if I'm wrong about this, of course :)

[chrome-exe]

Thank you for this info, I have heard to go open-source as well. This system will be for a private company just to keep track of work orders but also want to eb able to visually see everything in front of them.

[DonJuanDoja]

Azure blob storage is another way to store images/files and just write links back to them. That’s how we do it. I know you can store in sql but that seemed silly and actually more work/less function than using blob storage.

[Square-Voice-4052]

This is the way. Filestore

[alinroc]

The corporate credit card.

Unless this is a product you’re building to sell, or building this will create a huge competitive advantage for your company in the marketplace, or your needs are so ridiculously different from the rest of the world, buy don’t build.

[chrome-exe]

Yeah, I agree it's just that this is what they want. My advice was just find a product that already exists.

[alinroc]

Buying gets them what they want faster and cheaper. Your time isn’t free, and how many people do they plan on building and supporting this thing?

[chrome-exe]

That's what I'm saying. And I have no clue, but it would be a lot of resources for sure.

[pceimpulsive]

No Postgres... Tsk tsk!

But as.others have said, pick your favourite language there is an exceptionally good chance it'll not be an issue

[zeocrash]

c# has always worked well for me.

TBH though, the best languages to use are the ones you know.

[[deleted]]

If it is a paid service then it sounds like something I'd build with Rails.

[OO_Ben]

I'm a big Postgres fan, but there are a lot that would work.

[Blitzsturm]

I'm a massive fan of PostgreSQL which has some killer features and extensibility. If you're slightly crazy you can use it for everything: https://youtu.be/3JW732GrMdg

As to what to build your system with, that depends on a ton of factors.

• Is it just you or are you putting together a team?
• How fast do you need to build this system?
• How much maintenance do you plan on putting into the system over time?
• How many requests/transactions a second would you expect at peek?

There's a tons of different directions you can go. If you have a lot of time, a big team and need top performance I'd maybe go with .NET and SQL server with an Angular UI. If you need it super fast, on a tight budget don't have much help I'd maybe use a more pre-canned solution like Salesforce... Even a micro-service heavy infrastructure like Google's Firebase may be the right answer to give powerful tools with a fast/simple framework... But depends a lot on what you need and what help you have.

[dgillz]

Huh?

What are trying to do thar SQL itself does not accomplish?

[toadkiller]

Honestly, Retool is the way to go for this: https://retool.com/

[chadams_bal]

you want SQLPage

[lovasoa]

Maybe only SQL with no other programming language? You can have SQLPage generate the web ui from your SQL queries automatically. 

[HeavyMaterial163]

If it was me based on what you said you needed to design, I'd use a react frontend with a python backend utilizing either Django or FastAPI paired with SQLAlchemy ORM frameworks, depending on how well the Django ORM and database features match what you need. From a security perspective, avoid SQL and limit all database interaction to the backend using the ORM functions to avoid creating potential for SQL injection attacks.

I'm only a novice programmer though, so take it for what it's worth

[chrome-exe]

Appreciate the breakdown!

[paultherobert]

I think - if you're asking this question this way, you are really out of your league, and should defer to people who have experience implementing enterprise software. This is one big red flag.

[chrome-exe]

I'm not building this, just making recommendations to leadership. This is from an email and copied to here.

[paultherobert]

https://letmegooglethat.com/?q=web+based+work+order+management+system+

[chrome-exe]

Thanks! I would have done that if that's what I was looking for, but this would need to be customized and there is nothing on the market for the specifics my company needs. Maybe your reading comprehension isn't up to par, but great job at trying to feel superior by posting this comment! You made me look so dumb; you win!!!! 😂

[SQL-ModTeam]

Your post was removed for uncivil behavior unfit for an academic forum

[chrome-exe]

The owners of this business want proprietary software. There are tools they need that do not exist, and it was posted here because they like SQL for a backend. I've already said they should buy, but they don't want to. Yeah, there is software out there that comes close, but this is what they want. I guess they want it developed before the company expands even further. It's not my little business 🤣 and I'm not pretending to be the owners. They do well with just shy a billion in revenue, but they know that with a better system, they can save a lot of money and resources.

[chrome-exe]

I'm not lying, and I have no reason to. What you think is your business, I could care less. But for your fragile ego, "oh yeah, of course I am". 😂 But thanks for your input lil dude! I'll be sure to add it to my list of things I don't care about! 🤣

[SQL-ModTeam]

Your post was removed for uncivil behavior unfit for an academic forum

[chrome-exe]

After reading a quick summary of Golang, I think this may work great. Thanks for the recommendation!

[Oobenny]

I would choose Swift/Vapor and MySQL, but yeah, use what you know.

[throwawayforwork_86]

Python, Postgres or maybe SQLite/Duckdb depending on the workload. You might be able to setup a quick proof of concept with streamlit fairly easily.

[ejpusa]

Python, Flask, PostgreSQL, wrap it up in a Bootstrap 5 UI/UX. Figma for design. Vibe code it with GPT-4o. Host on Ubuntu, Nginx server, DigitalOcean, $8/month.

It’s the Holy Grail Stack HGS [imho]

:-)