Sam's notebook

MediaWiki with two database servers April 18th, 2018, 5PM


I’ve been trying to replicate locally a bug with MediaWiki’s GlobalPreferences extension. The bug is about the increased number of database reads that happen when the extension is loaded, and the increase happens not on the database table that stores the global preferences (as might be expected) but rather on the ‘local’ tables. However, locally […]

[No comments] [Keywords: , , , , , , ] [Permanent link]

Integration (and no unit) tests April 17th, 2014, 7AM


I’ve been writing lots of integration tests lately, for a system that has zero unit tests. Does this make me a bad programmer? Probably. But it’s so easy! This is in Kohana, using ORM, and so the model basically is the database (which idea I rather like), and mocking it or splitting it out to […]

[No comments] [Keywords: , , , , , , , ] [Permanent link]

Entity Relationship Diagrams for WebDB August 21st, 2013, 3PM


I have added a ERD module to WebDB, for producing simple little relationship diagrams like the one above. As with WebDB generally, it’s not about displaying the actual database schema but rather just a simple way to display the semantics of the schema (often, to users who don’t want to see even a single underscore!). […]

[2 comments] [Keywords: , , , , , ] [Permanent link]