93 reputation
7
bio website
location
age
visits member for 1 year, 7 months
seen 2 days ago

Jul
21
awarded  Popular Question
Feb
21
revised H2 database binary file full of @^@^@^@^
added 311 characters in body
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>
Feb
21
asked H2 database binary file full of @^@^@^@^
Feb
21
accepted Database throughful design vs Quick and dirty design comparison
Feb
20
asked Database throughful design vs Quick and dirty design comparison
Dec
17
awarded  Commentator
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
Dec
11
asked Why NOSql should be more performant than RDBMS under structured data loads?
Sep
25
awarded  Promoter
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.
Jun
12
asked H2 ALTER TABLE ADD COLUMN BEFORE/AFTER
May
21
accepted Database design: Two 1 to many relationships to the same table
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
May
17
awarded  Custodian
May
17
reviewed Approve suggested edit on Database design: Two 1 to many relationships to the same table
May
17
asked Database design: Two 1 to many relationships to the same table
Mar
29
revised h2 Java server synchronization and caching
added 287 characters in body