There have been endless discussions already if NULL should be implemented in relational databases, and if it should even be included in the relational theory. My favourite quote on this subject is from the person who helped Ted Codd to divulgate – and probably refine...
Relational DBMSs allow to grant users permissions on certain tables or columns. Privileges can also determine what a user can do – typical privileges are SELECT, INSERT,DELETE, UPDATE. Privileges are assigned or revoked using the GRANT and REVOKE statements. But how...
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. Contributions Before listing the improvements, it's worth mentioning that a...
Many DBMSs support a way to get information about a rows we just deleted, updated, or inserted. The syntax varies depending on the DBMS, and some of them allow more options than others. Currently MySQL has no similar feature. MariaDB supports the RETURNING keyword for...
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, covering most of the...
Federico Razzoli Webinar 2020
Federico Razzoli at MariaDB Server Fest 2020
Federico Razzoli at MariaDB Server Fest 2020
Federico Razzoli at MariaDB Server Fest 2020
Federico Razzoli at PHP London May 2019
