All Questions
63,475
questions
0
votes
1
answer
421
views
Strategies for Rotating MYSQL Encryption Keys
I have a web app that connects to a MYSQL database which has some encrypted data in it. The encrypted data is encrypted using the the mysql AES_ENCRYPT function and a key.
Now, this key has been ...
0
votes
2
answers
1k
views
Best design for a AMQP work queue
I have a system where a user uploads a file to import some users but it's necessary to do some validations and this take some time. I would like to create a work queue with RabbitMQ and the user will ...
0
votes
1
answer
116
views
I have a data set of over a million addresses and I want to display the closest N locations to a given address or current location
I am a student working on a personal project which is essentially a location finder that will be on a website. I have a data set of over a million addresses and I want to display the closest N ...
0
votes
1
answer
180
views
How to handle inherited roles in user stories?
I'm having struggles how dealing with inherited roles. Here is an example :
As an admin, I want to do something 1
As an admin, I want to do something 2
As a super admin, I want to do something 3
So ...
0
votes
1
answer
368
views
Design pattern that can be used for checking and handling a change in version number for incoming JSON message into data stream?
I have a Spark Streaming Job which processes messages coming from Kafka.
My incoming json that I process sort of looks like
{"sv" : 1.0, "field1" : "some data"}
The only thing I do is put these in ...
0
votes
1
answer
856
views
Adding resources to subresource REST API
I'm trying to build an web API that closely represents a library of books. I currently have the following routes.
GET /api/books
GET /api/books/:bookID
GET /api/libraries
POST /api/libraries
This ...
0
votes
1
answer
492
views
Database Design Structure
I am building a WebApp which has a list of Assets. I have a peculiar requirement and I am unsure of the best way to store the data in SQL.
Requirement:
My Asset Headers currently have a relation to ...
0
votes
2
answers
1k
views
Status code for middleware? 200 or 4XX , 5XX?
I have a design dilemma in deciding the response status code and architecture for a middleware we are designing.
So the Client Calls MiddleWare, And middleware calls the 3rd party service to get car-...
0
votes
1
answer
550
views
Bridge/Join Table for a Many to Many Relationship between One Table and Multiple Others
Background
I have a relational database an I want to have a table that contains flags. I want multiple tables in my database to have a many to many relationship with the flag table.
Options
I ...
0
votes
2
answers
3k
views
Circular dependency - is there a good design to eliminate
I was writing some code and came across a scenario that I was thinking about doing a circular dependent class, which I have not done before. I then looked circular dependencies up and whether they are ...
0
votes
1
answer
86
views
Deciding which microservice should write to the database
Let's assume the following architecture where
EventCreatorApp creates an Event which is logged to DB and sent to WorkerApp for processing
WorkerApp processes the event, handles failures, etc.
...
0
votes
1
answer
63
views
rest service with digitally signed parameters
I'd like to build a rest service that will accept objects that has digital signature. This service has to support both xml and json data serialization formats. I'd like to use .Net core framework to ...
0
votes
1
answer
54
views
Handling different error types from diffierent libraries with express
Most of the express error handling documentation and tutorials I've read suggest using Express middleware to throw errors up to, and to handle the errors there.
eg. From the Express documentation:
...
0
votes
1
answer
322
views
Thread-safe C library with OpenMP
I am writing a C library with routines I want to call from an external driver program using many OpenMP threads. The library will have a main container called lib_workspace, which will be used to do ...
0
votes
1
answer
1k
views
How to setup REST API in Codeigniter 3.0
I am creating the REST API using codeigniter. I downloaded this library and installed in my application. It works great! https://github.com/chriskacerguis/codeigniter-restserver
But I have an doubt. ...
0
votes
1
answer
111
views
Use single table with lots of columns or break it out and use Views, when using Entity Framework Core
I am currently building a game series information site and have come to a design issue. I have a table called Abilities that would have character ability information in it. Depending on the game ...
0
votes
1
answer
465
views
How to avoid code duplication caused by javascript dict access?
I have two functions that group a list of dicts according to the value of a certain key. Here's how my array looks:
const sections = [
{
file_id: '1',
heading_level: 4,
readme_file_name:...
0
votes
1
answer
200
views
Keep all user orders in a single aggregate instance
I'm thinking of not keeping user orders as separate Aggregate instances, but combine them into one UserOrders. Is such an approach going to have some flaws in terms of DDD? Along with orders, I would ...
0
votes
1
answer
161
views
How to design a system that can operate and replay its functions call stack?
I am writing a processor for the Citation Style Language (CSL) in JavaScript.
Before I explain what my problem is, I must give some context first:
CSL is an XML specification for describing how to ...
0
votes
1
answer
300
views
What is better: Concrete class with Enums or subclasses implementing an Interface?
Suppose for example, there could be multiple types of vehicles. And in this scenario, only the speed and how many people can seat in the vehicle matters.
Would it be better to have a concrete class, ...
0
votes
1
answer
56
views
What is the function of the special directory(named debian) to the project design?
I am reading a github project:
you see there is a directory(debian) in there, what the function of it?
I have browsed the directory, there seems have some configuration files:
shadowsocks/debian/...
0
votes
1
answer
84
views
Should we still create separate custom ApplicationExceptions?
Given that when is supported in try...catch blocks, does it make sense to create a single CustomApplicationException class, say, with an enum ApplicationExceptionReason Reason property to ...
0
votes
1
answer
101
views
Reliable data synchronisation between several systems
We have several systems that hold the same data in different databases. The requirement is to keep the data synced in as much reliable way as possible. Performance isn't a concern because we don't ...
0
votes
1
answer
525
views
How to manage user serial keys for an application
I have an application in C# where several users access it.
Each user will have a serial key associated with his username in a table users in a local MySQL database.
Example of the table users:
User ...
0
votes
1
answer
497
views
Why shouldn't an event pertain to multiple aggregates?
In my experience, it is often said that in event sourcing "an event must belong to one aggregate" and also "an aggregate is your biggest transactional boundary".
Why is this?
What harm would come of ...
0
votes
1
answer
419
views
Web turn based game Architecture. With or without websockets?
I have written a turn based game (Dominoes) using Scala and Akka actors, where a Server manage all the game state and the clients (Players) receive the new state every time one of them plays a card.
...
0
votes
1
answer
357
views
REST Many To Many Design
Consider a web api exposing two kind of resources: Users and Teams with many-to-many relationship, typically a REST api will expose the following trivial endpoints to read data:
GET /users
GET /users/...
0
votes
1
answer
159
views
OAuth2.0 Grant Type for User Logged In With Google
I have a confusion. So, in OAuth2.0 there are 4 types of Grant (Authorization Code, Password, Client Credentials and Implicit). In my use case, I have two login scenario. The first one is using ...
0
votes
1
answer
495
views
PHP: simple class for storing read-only data structure, array alternative
I need to share some associative data between different parts of my application with two requirements:
immutability (so read-only)
safety against mispelling or unavailable index inside the data
...
0
votes
1
answer
618
views
Storing session state in browser's local storage
Stack Exchange has some bits of what seems to be session state -- for example, whether you want to see 15, 30, or 50 questions per page when you view a list of questions.
You can click on the button ...
0
votes
1
answer
173
views
Seperation of concerns: Submitting a form to create an email, store it and send it
Context
I have a workflow that has an email form. The requirements are the following: A user completes the form that contains email fields and submits it.
If everything goes well then an email model ...
0
votes
1
answer
99
views
What's the better way to organize retrieval of difference in props
I have a system, which stores different objects in DB. Each such object has properties. Some of them are relevant for all objects (like Name, Description), but some are specific to each object and ...
0
votes
1
answer
211
views
What OOP design pattern would work best for an overseeing class connecting related objects enforced at compile-time?
The Problem
I would like to create a managing "overseer" class that connects several related object groups together where any particular group is able to be easily swapped for another using ...
0
votes
1
answer
153
views
Generic crud with jdbc api
I am used to programming java on the server side with ORM frameworks and using abstract classes for CRUD. But now I'm workign on a desktop project without ORM and just the good old JDBC API for ...
0
votes
1
answer
550
views
How would one log into an AWS User Pool from Unreal Engine?
I'm very, very new to the networking and AWS side of things, but experimenting a bit with some concepts. I was wondering if anyone had suggestions for the following use case. I'm in an experimental ...
0
votes
1
answer
252
views
Creating and Approving OAuth2 clients using Laravel Passport
As I understand with laravel passport, in order for a third party application to consume my api they need to register their application with mine by creating a client.
The passport:client artisan ...
0
votes
1
answer
157
views
How large-scale production web crawlers improve performance when it comes to running into already visited links
I have built a very basic webcrawler running off my laptop so it has limited memory and limited hard drive space. The way I have it now is I'm using MongoDB to store the links I find on pages. I make ...
0
votes
1
answer
60
views
What types of Google Cloud application should I consider for something running as a continually available service that subscribes to a pub/sub?
I want to create an application that will run as a service that subscribes to a Google Cloud pub/sub topic, and delivers emails based on 'alerts' that it receives through the pub/sub subscription. It ...
0
votes
1
answer
123
views
When designing a system how could I describe the way sequence diagrams are related?
After the sequence diagram are made the sequence methods become code, before writing some code that would alter database records I would like to know how to detect if a sequence is doing the job ...
0
votes
1
answer
1k
views
Django - should I create related objects immediately or on demand?
Let's say you have a ForeignKey MyModel.related_model and this related_model has all fields either null=True or default=something.
Like User.userprofile which I use on several places in my project. ...
0
votes
2
answers
483
views
Event sourcing in microservices: separate event stores + system-wide event store?
Say each microservice is using event sourcing which means it has it's own event store, do you typically add another "mother" event store that contains all events from all microservices as a source of ...
0
votes
2
answers
114
views
Appropriate pattern for injector that sets a property and client that ONLY gets a property
Suppose I have a method in client code that expects an interface...
void DoWork(IDataManager data) {
//use IDataManager interface in the DoWork method
}
And the IDataManager interface looks like ...
0
votes
1
answer
154
views
Can Aggregate shared between services?
I am working in an event-sourcing architecture and while creating the aggregates I came to an interesting challenge, disclaimer I'm new to this.
I have a UserAggregate encapsulating the logic for ...
0
votes
1
answer
64
views
How to store and access domain vs view state?
I'm currently developing an application using the Dear ImGui library: https://github.com/ocornut/imgui/. And I'm trying to figure out how exactly to access state vs domain data. I'm trying to write it ...
0
votes
1
answer
112
views
Removing unused directives from a file which is not related to the pull request [duplicate]
I'm actually working on the web application which was made using technologies such as asp.net core, c#, angular, ef core. For the version control and CD we use Azure DevOps. As a team we try to follow ...
0
votes
1
answer
760
views
Writing assertion for unit testing queue data structure
I have data structure queue with 2 operations:
typedef struct queue queue
void enqueue(queue *q, void *elem);
void *dequeue(queue *q);
queue *read_from_file(const char *path);
I want to write ...
0
votes
1
answer
1k
views
DDD & composition
I have a project to build, which has the following requirements:
topup a wallet by paying money in exchange for credit; this has also
the constraint of needing an approval from the finance team, if ...
0
votes
1
answer
162
views
What are the differences and connections between UML Profile diagram & UML Class diagrams
I am doing research for developing a software platform and I have created some class diagrams for the platform. My supervisor adviced me to use UML profiles as well to describe the platform in a more ...
0
votes
1
answer
483
views
Designing a WPF / MVVM architecture where view behavior changes in different states
As part of my bachelors thesis, I'm trying to develop something akin to a painting program. That means, I have a toolset, be it selection, drawing, highlighting, etc.
I'll have a canvas that displays ...
0
votes
1
answer
242
views
How to have SQL Server with Git, TeamCity and Octopus auto-deployment work with schema-level restrictions?
We are starting to integrate our SQL Server workflow with Git, by which I mean generating scripts for all objects and storing them in a Git repository so you can pull, edit, commit, push and apply, ...