Manually written forms and the request token

See, that’s for example something I do dislike at Contao. The documentation for developers sucks. Even simple things like adding the request-token to your self-written forms is not documented or I am absolutely blind. I also have the feeling that they (people who wrote the documentation) assume that a developer will read Contao’s source code if he/she has any questions. That’s like assuming a cleaning-lady checks the mechanics of a vacuum cleaner to see how it works. Anyway:

Continue Reading

Swapping values in MySQL without violating constraints

I’ve learned something new! I am synchronizing lots of data coming in XML containers into a MySQL database. Some child nodes of that XML miss identifiers which could be used to update the table and hence I was just truncating the table and re-inserting those values (many to many relation, no id). But since this is a live-used database this lead to the problem that stuff disappeared while using it.

Continue Reading

Contao does not support prepared statements

Due to the naming of methods in Contao’s Database Layer one might get the impression that you might use prepared statements in Contao. Sadly that is not true. The goal of prepared statements is that the Database‘ query compiler does not need to run over and over again for the same query. Due to the method names „prepare“ and „execute“ I assumed (as a bug report shows, other people did as well) that Contao would offer prepared statements.
Continue Reading