(Tony Darnell) I received a phone call from a friend of mine who had some questions about storing image files as blobs in MySQL. He wanted to design a web site that would allow someone to upload an image, and then that image would be stored in the MySQL database for viewing later.

(Giuseppe Maxia) MySQL built-in replication includes a concept called relay slave, which allows you to create hierarchical database clusters. You can do the same thing with Tungsten, and this can be done in more than one way. Let’s start with two distinct clusters.

(Adam Donnison) In our last episode we learned how to modify data and table definitions. This will come in handy as we look at building in referential integrity constraints into our database. To begin we will need the database definition resulting from last episode’s changes.

(Giuseppe Maxia) One lesson learned in more than two decades working in this industry is that most of the IT professionals are impatient, want to achieve results immediately, and, most importantly, they don’t read documentation. Much as the average geek is happy to answer many requests with a dismis

(Adam Donnison) In our last episode we covered sorting, searching and grouping. We found out that using the COUNT(*) can be problematic when we have unexpected NULL data. Now we look at how to resolve data issues by updating the data, and perhaps even the table schema. We’ll use the same database we

(Jervin Real) Here’s a quick tip I know some of us has overlooked at some point. When doing SELECT … UNION SELECT, where do you put the the INTO OUTFILE clause? On the first SELECT, on the last or somewhere else? The manual has the answer here, to quote:

(Hovhannes Avoyan) Sometimes, a basic understanding of how a program works just isn’t satisfying. While it is nice to understand how our logger operates, syslog-ng doesn’t start getting interesting until we start playing with some of the more advanced features it has to offer.

(Tony Darnell) In an earlier post Connecting to MySQL with Python, we only returned a single result line from a “SELECT VERSION()” query. We will now take a look at returning multiple rows of data from a MySQL database using Python.

(Adam Donnison) In our last episode we started building up our online bookshop database, with tables for publishers, authors, formats and books. At the moment we only have one book in there, so before we go too far, lets add a few more:

(Shinguz) In this article we have a short look at a simple MySQL example program written in Vala.