Chris Travers

5,406 reputation

433

bio	website	ledgersmbdev.blogspot.com
	location
	age	37
visits	member for	8 months
	seen	yesterday
stats	profile views	122

I am the most active developer on LedgerSMB.

	5,406 reputation	bio	website	ledgersmbdev.blogspot.com	visits	member for	8 months
433 badges		location			seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

562 Actions

suggestions reviews revisions comments badges posts accepts all

May 17	awarded	Revival
May 16	awarded	Nice Answer
May 8	answered	Postgres performance difference on insert
May 7	awarded	database-design
May 6	awarded	Revival
May 1	answered	Big jump in search time for Postgres Index query for results with high selectivity
Apr 30	comment	Mysql float(13,3) not taking 10 digits Additionally I would note that it is way too easy to read float(13,3) as decimal(13,3) and not get that this isn't base 10. If you need to specify precision, use arbitrary precision types.
Apr 29	comment	How does “Be made using the login's current security context” pass the users password to remote server Is the local server using windows integrated authentication?
Apr 29	answered	Is it ever a good idea to denormalize for integrity?
Apr 29	answered	Violates foreign key constraint
Apr 25	comment	Migrate PostGIS geometry data to SQL Server spatial data Did you get this solved, could you post an answer?
Apr 25	comment	How to allow a user to create databases only with a certain prefix? I am not sure how the side effects would be much more unmanageable than with `drop table` or `drop user` both of which can be rolled back. I don't know why one couldn't wait until commit to do essentially an rm -rf and block connections in the mean time.
Apr 25	answered	Transactions, references and how to enforce double entry bookkeeping? (PG)
Apr 25	answered	How to allow a user to create databases only with a certain prefix?
Apr 24	answered	How to fine-tune Postgres for IO usage?
Apr 24	comment	How to create a database for unknown kinds of data? I won't go into the tradeoff of relational vs non-relational modelling here. One thing I will say about EAV is that there are a few areas where I find it really works well. We use it (in slightly modified form) in two areas for LedgerSMB, where the data in fact does really work well in this case. I should write a blog post on where EAV actually works....
Apr 24	awarded	Revival
Apr 24	comment	Witnessing standby failure with repmgr Just to clarify that.... The only difference between synchronous_commit being on or off is that it waits for the standby to say it has committed before returning this to the client. If your answer to "the slave went down" is to turn replication off, you are getting nothing out of the additional guarantee that synchronous commit gives you, which is that once the commit is finished the data exists on at least x number of servers. You will have far fewer issues by simply not offering the guarantee in the first place than by offering it except when you don't.
Apr 24	answered	How is PostgreSQL extension feature compared to SQL Server extended and CLR stored procedures?
Apr 24	comment	How to create a database for unknown kinds of data? Great edit. Very informative. One minor thing I would add is that table inheritance is full of obscure gotchas in PostgreSQL. It can solve important issues (and may well be a part of a solution here) but it doesn't always work the way folks expect. Use it with caution. (My blog, ledgersmbdev.blogspot.com, has a fair number of posts on this sort of thing)