All Questions
81 questions
0
votes
1
answer
883
views
Clarification on using timestamp without time zone and LocalDateTime in UTC-centric systems
I'm seeking clarification regarding the usage of timestamp without time zone in a database and its corresponding Java type, LocalDateTime. The current setup I'm working on involves servers and (...
user175557
0
votes
1
answer
85
views
Design a sequential processing of records
About 10 to 15 records are processed per day with the time interval of 5 minutes between each record.
System A inserts a record in DB and sends id of that record to active mq.
System B Listener ...
- 119
3
votes
2
answers
377
views
Best approach to microservice shared databse architecture
I have two microservices, one Flask (python) and one Spring (java), they currently share a database. The Flask microservice handles processing json files (~40mb) for each user (could be 100's or 1000'...
- 31
-1
votes
3
answers
322
views
Is it ok to save all fields of an entity as a string if it should not be changed?
I have a complex object that has several fields can be updated until it is locked.
Is it proper to save this locked entity as another entity which has no object child, only string data.
complex object
...
- 109
-1
votes
1
answer
410
views
How to create, manage and use multiple dynamic database connections at run time?
As I am creating different database connections on the basis of database credentials (i.e. JSON or POJO with all the credentials required to create a DB connection).
e.g.
Imagine a Map containing ...
- 11
3
votes
2
answers
427
views
What to do when putting logic into the database seems to be the only option?
I am currently working on an application that models a complex business process that consists of many steps, each having a 1:n relationship with subsequent steps. The software is written Java using ...
- 149
2
votes
1
answer
518
views
How to handle db password change in a live service
Suppose I have a REST application running on a remote server which connects to a mysql database. Now let's say the password of the db has to be changed. What are the right methods and practices that ...
- 129
-2
votes
2
answers
154
views
Is a JVM based dbms like Neo4J implemented ideally?
Since Neo4J is implemented in Java and therefore uses the JVM, wouldn't an equivalent graph database that is written in C++ / Rust or GoLang be more performant?
Why would one decide to build a DBMS ...
- 109
2
votes
1
answer
1k
views
Best approach to handle user statuses and keep their history
I am developing a Spring application which has a few different modules. There will be a bunch of users added in the database.
I want to add a feature, which will allow me to track users' availability,...
- 149
-1
votes
2
answers
355
views
Correct place to store semi dynamic data
What I mean by semi dynamic data are data that are expected to be changed only with product versions.
Now imagine this scenario, In version 1 of the product, I have item status : SUCCESS , FAIL
In ...
- 241
-1
votes
2
answers
2k
views
When self-referencing in a table, do you prefer `parent_id = null` or `parent_id = id` for a row referencing to itself?
For the discussion, I will provide my example. But I am interested in the broad guidelines.
I save in my postgres DB legislation (law texts) composed of a single header (H), paragraphs (P), sub-...
- 155
1
vote
3
answers
176
views
Proper Connection Pool Use
I'm confused as to how to properly interact with my Postgres database throughout the typical user experience on my web app. I'm seeking clarification on the most efficient method of communicating with ...
- 155
1
vote
0
answers
87
views
Java dashboard for machine data
I am currently working on a project for a production facility. The machines in the production are saving so called 'Telemetry Data', measurements like water pressure, plastic volume or temperature ...
- 119
3
votes
0
answers
389
views
Chronicle Queue: how to make a stack and how to limit disk usage
My server and several clients are different JVMs running on the same machine, they need to share persisted time series data: server reads a time series from somewhere, writes to a persisted embedded ...
- 31
0
votes
1
answer
454
views
In new project where you have ability to define DB and write app code, what is seen as best practice?
Good day
When starting a new project and you have access to the db as well as writing the code.
In this specific case it is PostgreSQL and Java EE with JPA and Hibernate.
Should one:
Aim to ...
- 249