This Veterans Day, Oracle is offering veterans free training and certification on Oracle Cloud Infrastructure and Oracle Autonomous Database.

Over the weekend, I’ve published the 1st issue of my new weekly free newsletter, OpenLamp.tech. I’m so excited about this newsletter. Read on to learn more…

What is the OpenLamp.tech newsletter

OpenLamp.tech is a free newsletter unlike any other that I’m aware of. If it existed, I would be reading it.

Instead, I created it. Let me explain…

Image by Mahesh Patel from Pixabay

Developer, Writer, …

Hi all, just some words to let you know that FOSDEM’22 will take place February 5th and 6th. Like last year, this 2022 edition will be an online edition.

As MySQL, we have submitted our candidature for a devroom/track. We are waiting for the approval list.

As soon as we know FOSDEM’s decision, the eventual Call-For-Papers will be opened.

Stay tuned.

Meanwhile, enjoy MySQL !

When I went over my example of using the WITH clause to solve how to use a series of literal values in data sets, some students got it right away and some didn’t. The original post showed how to solve a problem where one value in the data set is returned in the SELECT-list and two values are used as the minimum and maximum values with a BETWEEN operator. It used three approaches with literal values:

• A list of Python dictionaries that require you to filter the return set from the database through a range loop and if statement that mimics a SQL BETWEEN operator.
• A WITH clause that accepts the literals as bind variables to filter the query results inside the query.
• A table design that holds the literals values that an analyst might use for reporting.

It was the last example that required elaboration. I explained you might build a web form that uses a table, and the table could allow a …

A few weeks ago and in MySQL 5.7, I had an ALTER TABLE that failed with a duplicate entry error.  This is old news as it is happening since MySQL 5.6, but I only saw this recently because I am normally using online schema change from the Percona Toolkit (pt-osc) or GitHub's online schema migration (gh-ost).  I do not like that and I am disappointed this has not been improved, so this

Oracle Intern Rocio Gonzalez Melendez shares how diversity and inclusion has informed her employment pursuits.

Oracle Intern Rocio Gonzalez Melendez shares how diversity and inclusion has informed her employment pursuits.

Oracle volunteers in India have made more than 600 cards to send encouragement to breast cancer patients.

Oracle volunteers in India have made more than 600 cards to send encouragement to breast cancer patients.

The award recognizes OPEN for its proven track record of success and its efforts to advocate for LGBTQ equality in the workplace.