Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2 10
Impact
~10k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Feb
21
comment H2 database binary file full of @^@^@^@^
I opened vim in hex editing mode with :setlocal display=uhex, it shows those are actually null values: <00><00><00><00><00>
Dec
17
comment Rent weekly cost database design
You're right, however calculating intervals requires checking gaps and intersections, there's an article "The SQL of Gaps and Islands in Sequences" and it explains how that task is not trivial at all.
Dec
13
comment Why NOSql should be more performant than RDBMS under structured data loads?
accepting your comment :) thank you
Jun
12
comment H2 ALTER TABLE ADD COLUMN BEFORE/AFTER
I know it is irrelevant in practice but in the documentation they have put this possibility for a reason. In my case it is that we often print the schema to paper and want some order for readability reasons.
May
20
comment Database design: Two 1 to many relationships to the same table
My solution #2 to which of your four groups belongs? The "Denormalized Partitioning Attribute Solution" is not quite clear to me..
May
17
comment Database design: Two 1 to many relationships to the same table
I need not only to know whether it is a corporation or natural person but also to know the respective id, so I need an id number and not only a value of 1 or 2! Solution 3 is what I found here I have two columns with ids to corporation or natural person
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.