7,391 reputation
1254
bio website ledgersmbdev.blogspot.com
location Jakarta, Indonesia
age 38
visits member for 1 year, 11 months
seen Apr 29 at 11:32

I am the most active developer on LedgerSMB, which accounts for most of my consulting and freelance work. I also offer PostgreSQL-related consulting services and more.

I also am a co-founder of Efficito which offers LedgerSMB ERP hosting for small to midsized businesses. Efficito: Robust, flexible, and open.

Finally I am a principal consultant for 2ndQuadrant and offer PostgreSQL consulting services throughout South-East Asia.


Jul
25
awarded  Nice Question
Jul
13
awarded  Revival
Apr
25
awarded  Revival
Apr
9
reviewed Approve suggested edit on MySQL PDO Cannot assign requested address
Apr
9
reviewed Approve suggested edit on How do I validate all my constraints in postgresql?
Apr
7
reviewed Approve suggested edit on How do I Delete A Database And Log Files With SQL 2008 Script?
Mar
27
awarded  Outspoken
Mar
17
reviewed Approve suggested edit on On my local computer, where is the data stored for a search on a dynamodb database
Mar
14
awarded  Revival
Mar
5
answered Is ROLLBACK a fast operation?
Feb
20
awarded  Enlightened
Feb
20
awarded  Nice Answer
Feb
12
awarded  Necromancer
Feb
7
awarded  Revival
Feb
3
answered Postgres slave max_connections = master's max_connections?
Feb
3
reviewed Approve suggested edit on redis tag wiki
Feb
3
reviewed Approve suggested edit on redis tag wiki excerpt
Feb
3
awarded  Revival
Feb
2
answered Counting postgres open connections without SQL query or connecting to postgres itself
Feb
2
comment Is it OK to keep a value which updates in a table?
It occurs to me that one of the huge limits of your approach is that calculating the balance of an account on a specific historical date still requires aggregating, unless you also make the assumption that all transactions are entered sequentially by date (which is usually a bad assumption).