7,546 reputation
1456
bio website ledgersmbdev.blogspot.com
location Jakarta, Indonesia
age 38
visits member for 2 years
seen 35 mins ago

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.


Sep
12
answered Finding by ID in postgresql very slow on big table
Sep
12
comment Text-based interface for PostgreSQL?
you can do this with psql, actually @TinyProton. See the \d commands. Use \? for a list.
Sep
12
comment How do I efficiently get “the most recent corresponding row”?
I dont think it needs to be exact, but worried about the problem being lost in the allegory. Something a little closer would be helpful. The issue is that with pricing, the price at a certain day is likely to be a default, and consequently you wouldn't use it for reporting only as a default for transaction entry, so your interesting queries are typically only a few rows at a time.
Sep
10
revised How do I efficiently get “the most recent corresponding row”?
added 1802 characters in body
Sep
10
comment How do I efficiently get “the most recent corresponding row”?
Good point. Re-reading though I spot some real practical deficiencies with the proposed data but I can't tell if it is just a contrived example. As a contrived example, I can't tell what is missing. Maybe an update to point this out would be in order too.
Sep
10
answered How do I efficiently get “the most recent corresponding row”?
Sep
9
answered PostgreSQL Hot Standby
Sep
8
comment Which schema is better for a shopping project?
Also regarding the classic way, I think your problem is that you end up with a lot of the problems of EAV modelling. This can be used, but it means that queries like "show me all hard drives with a capacity of 500GB, using an SATA interface, and with a speed of 7200 RPM" becomes an amazingly complex query which does not scale.
Sep
8
comment Which schema is better for a shopping project?
@burakemre, what you lose with JSON is an ability to do real type enforcement on a db schema level, so you can't be sure that all the required fields are filled in on the db level.
Sep
7
answered Which schema is better for a shopping project?
Sep
5
answered Scaling of PostGIS vs MySQL cos/sin calculations
Sep
4
answered Postgresql vs MySQL - Which is better for join queries & writing data(inserts)
Sep
1
awarded  Revival
Sep
1
answered Truncate table is taking too long in PostgreSQL
Sep
1
answered Performance difference between MySQL and PostgreSQL for the same schema/queries
Aug
31
answered When using a master plus multiple slaves, how do I change over from one server to a brand new one with minimal downtime?
Aug
30
answered Postgres caching and bytea
Aug
30
awarded  Yearling
Aug
30
answered Recovering Postgres database
Aug
30
awarded  Revival