Profile cover photo
Profile photo
Open Query Pty Ltd
15 followers -
Your databases and online infrastructure. Managed.
Your databases and online infrastructure. Managed.

15 followers
About
Open Query Pty Ltd's posts

Post has attachment
We can all agree on this: security is important, as is trust. Does a pretty seal from an SSL certificate provider create trust? Doubtful. The provider’s own claims aside, it’s marketing fluff. Oh, it used to provide them with some extra Google juice (one…

Post has attachment
The TEXT and VARCHAR definitions in many db schemas are based on old information – that is, they appear to be presuming restrictions and behaviour from MySQL versions long ago. This has consequences for performance. To us, use of for instance VARCHAR(255)…

Post has attachment
Right now we’re volunteering some engineering time to assisting the WordPress and WooCommerce people with scalability issues. In the past we’ve put similar efforts into Drupal. There are many opinions on these systems out there, most of them sadly…

Post has attachment
One of our clients received an email like this: Dear Amazon EC2 Customer, We have important news about your account (…). EC2 has detected degradation of the underlying hardware hosting your Amazon EC2 instance (instance-ID: …) in the […] region. Due to…

Post has attachment
The awesome Tom Eastman presented a session at PyCon Australia (Melbourne) 2016 entitled “The dangerous, exquisite art of safely handing user-uploaded files”. Every web application has an attack surface — the exposed points of interaction where a…

Post has attachment
Open Source is a whole-of-process approach to development that can produce high-quality products better tailored to users’ real world needs.  A key reason for this is the early feedback cycle built into that complete process. Simply publishing something…

Post has attachment
One of the key problems with the 2016 online census was the architecture, but also the how the whole thing was organised and who was contracted for the job. IBM, for the $9.6mln it got paid for the job, built something very clunky. They used Java, which…

Post has attachment
Uber Engineering explains the technical reasoning behind its switch in database technologies, from Postgres to MySQL: https://eng.uber.com/mysql-migration/ These things are always an interesting read, because it looks at one company’s decision making…

Post has attachment
Sijmen writes: A few weeks ago I gave a guest lecture at the Windesheim University of Applied Sciences in The Netherlands. I graduated there and over the years I kept in contact with some of my teachers since then. One of the teachers told me recently…

Post has attachment
You may not be aware that the mechanism used to fingerprint the SSL certificates that  keep your access to websites encrypted and secure is changing. The old method, known as SHA1 is being deprecated – meaning it will no longer be supported. As per…
Wait while more posts are being loaded