93 reputation
7
bio website
location
age
visits member for 1 year, 8 months
seen Oct 22 at 13:18

Mar
29
revised h2 Java server synchronization and caching
added SSCE of question
Mar
29
comment h2 Java server synchronization and caching
Indeed I want to continue to use my relational h2 database, what I'm surprised is that there's no library to simply add a caching and synchronization layer between the application and the database. By the way in some sense I have a central database, however each client has to keep its JLists and Tables updated with the database without continuously querying the central database.
Mar
29
awarded  Student
Mar
28
asked h2 Java server synchronization and caching
Mar
28
awarded  Scholar
Mar
28
accepted H2 SELECT NULLABLE or other equivalent to check a column has NOT NULL constraint or not
Mar
28
asked H2 SELECT NULLABLE or other equivalent to check a column has NOT NULL constraint or not
Mar
25
comment Rent weekly cost database design
The problem with intervals of time and a daily coefficient is that I must check for overlapping intervals, empty intervals and calculate a coefficient which returns a correct price. Given that they will give me excel files with the cost per week calculating intervals from that and maintaining it always consistent might be harder than simply putting a cost for each day.
Mar
25
comment Rent weekly cost database design
I updated my question to the latest design changes so as not to make confusion, I think the coefficient cannot be used because I want to deal also with the most specific case (that is each building unit also inside the same building having a different cost each week). Can you update your answer to this requirement?
Mar
25
revised Rent weekly cost database design
deleted 202 characters in body
Mar
25
answered Rent weekly cost database design
Mar
15
comment Rent weekly cost database design
Your table as I understand it, would have 2*5*4*365*365 = 5329000 rows in the case of 2 Buildings,5 Rooms, 4 Categories and of course all possible combinations of intervals of day in the year? or maybe I don't understand the relation between startdate and weekcoefficient..
Mar
15
awarded  Editor
Mar
15
revised Rent weekly cost database design
added formula for rent calculation
Mar
15
comment Rent weekly cost database design
cost of a room is also based on day of the year or week of the year.. that's the main point of my question
Mar
15
asked Rent weekly cost database design