stackoverflow.com stackoverflow.com

CSV, JSON, XML, TXT mapping and conversion? Recommended framework/language?

I’m after opinions on the best framework/languages to use for a project at my work. Basically, we need to operate as an integration platform for many customers (1000s). Each customer provides event data to share in their own format/content. (eg. CSV, JSON, XML, TXT, EDI). All customers need to share data between each other - provided they have an agreement. DataHub I see the main challenge areas being: Access rights to data and...

stackoverflow.com stackoverflow.com

Best way to implement Security for Spring Boot API

I’m struggling how to secure my Spring Boot API the best way. Here is an overview about the architecture: Software Components: A monolithic Spring Boot API Backend An Angular Client A Flutter Mobile App Client Users should be able to log in with Apple, Facebook and Google, using the Spring OAuth2 Client Library. I read through several tutorials and stackoverflow questions, but everywhere the answers were different. I’m aware of...

stackoverflow.com stackoverflow.com

What are the pros and cons of adding SQL columns in run time, vs through a different design time architecture?

The company I'm currently working for has a feature in an enterprise app where a user can add columns to a table configuration on a web GUI through fields and a button, and a corresponding SQL table has columns added (or altered or removed). That is, the table is shaped in run time by the user's preferences. This feels wrong to me, but I'm struggling to clarify to myself and to others what the limitations are of this architecture vs...

stackoverflow.com stackoverflow.com

In Ecommerce systems with high load, how are sku stock updates are designed?

When an order is submitted, few things need to happen: sku stocks are decremented if there are enough quantities products returned by subsequent search queries have the latest stocks (sum by sku stocks) stock state of product should be updated if changed, eg. from normal to out of stock A straight forward design is to have a ProductStock aggregate root with totalQuantity, state, and a collection of SkuStock, like this: public Class...

stackoverflow.com stackoverflow.com

Strategy or Design Pattern to ensure version compatibility with external application

This is more of a design guideline question, I don't think technical details matter very much here. So, our (java) application provides a GUI to manage several external devices, each with their own release maps. Any of them may release a new version with new features any time, and our GUI must support all of them, showing the user the correct managing options depending on the connected device's version. This is quite simple to...

stackoverflow.com stackoverflow.com

What should be structure of service layer in Node.js

Background Information: I am trying to implement my server with separate Controller, Service and Dao layers. I am not sure how the Service layer module should be organized. For example, let's consider a UserService module, which is a sub module in the service layer module. However, I don't want to create a single UserService file, but rather divide it into individual files, for example, a FetchUsers class which is part of User service...

stackoverflow.com stackoverflow.com

Multi stage stop and go applications in Java

So we're beginning to plan our design for an application which will involve completing a set of sub-tasks for a parent task to be completed (successfully or otherwise) So assuming it's a task to on-board a user, the process would involve several different internal and external services, with varying degrees of "response" times (hours to days based on how automated it is). I was hoping to learn if there are common design...

stackoverflow.com stackoverflow.com

How to properly create security groups for instance classes in AWS?

So right now I have 4 subnets per availability zone: The internet facing "entrypoint" subnet (associated with a load balancer), the generic "service" subnet for internal computation, the "database" subnet for all things data related, and the "external request" subnet for making requests out to the internet. This defines essentially 4 classes of EC2 instances. I am supposed to now create security...