Archiwizowane April, 2010

One of the most common questions is "how do I get select * from table, but without one of the column". Short answer is of course - name your columns, instead of using *. Or use a view. But I decided to ...

Let's assume you have some simple database with "articles" - each article can be in many "categories". And now you want to get list of all articles in given set of categories. Standard approach: select a.* from ...

More than once I've seen situation when there is a table, with serial primary key, and rows contain also some kind of creation timestamp, which is usually monotonic, or close to monotonic. Example of such case are for example comments or ...

Question from title sounds weird to you? It's just a 'rm backup_filename'? Well. I really wish it was so simple in some cases. One of the servers I'm looking into, there is interesting situation: quite busy database server (2k tps is the ...