Updating triggers in production without causing a service disruption Continue reading Updating triggers in production with MariaDB and MySQL
Does NULL mean “no value”? Or does it mean “an unknown value”? Its semantics and history are ambiguous and inconsistent. Continue reading What does NULL mean in SQL?
It is possible to prevent some users from seeing a set of rows in a certain table. Continue reading MariaDB/MySQL: Using views to grant or deny row-level privileges
MariaDB implemented several improvements to the DROP TABLE statement. We summarise them here. This article will be kept up to date when MariaDB implements further improvements, in the future. Continue reading DROP TABLE improvements in MariaDB
MariaDB supports RETURNING statements, that can save one query making our applications faster and reducing server source usage. Continue reading MariaDB RETURNING Statements
Though I have many things to write, I’ll keep this post short and avoid it to be auto-congratulatory. Long story short, I turned my freelance business into a company: Vettabase Ltd. My companion Francesca is with me in this adventure, Continue reading Welcome to the Vetta