(Shlomi Noach) And the following query: SELECT `;`.`*`.`.` FROM `;`.`*`; is valid as well.
Tag: Open Source
MySQL Performance Schema (4)
(Peter Gulutzan) This is #4 in a series of blog postings about MySQL Performance Schema.
Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications
(Ernest Bonat) Error handling implementation in Windows database applications is a must for any Application Developer today. The main idea of error handling is to avoid application crashes by finding out the occurred errors and fixing them. Different programming languages have different ways of impl
MySQL Performance Schema (3)
(Peter Gulutzan) This is #3 in a series of blog postings about MySQL Performance Schema.
Beware of MySQL Data Truncation
(Peter Zaitsev) Here is nice gotcha which I’ve seen many times and which can cause just a minefield for many reasons.
PLPython Part 4: PLPython meets aggregates
(Leo Hsu and Regina Obe) In our August 2008/ September 2008 issue we demonstrated the power of PostgreSQL to create median and MS Access-like first and last aggregate functions in SQL language. In this article we shall demonstrate how to create aggregates with Python. We shall call this function ag
MySQL Performance Schema (2)
(Peter Gulutzan) This is #2 in a series of blog postings about MySQL Performance Schema.
PLPython Part 3: Using custom classes, pulling data from PostgreSQL
(Leo Hsu and Regina Obe) One of the great things about Python is the plethora of free libraries around to do very cool things from Engineering, statistical modeling, to BioInformatics.
Unwrapping 10G wrapped PL/SQL
(Anton Scheffer) Many people have tried to unwrap wrapped PL/SQL. Most people haven’t succeeded in doing it, but since Pete Finnegan’s presentation on the 2006 Black Hat conference, http://www.blackhat.com/presentations/bh-usa-06/BH-US-06-Finnigan.pdf, unwrapping PL/SQL on the older database version
Quick DB Setups With MySQL Sandbox
(jgoulah) There are various reasons to set up quick “sandbox” instances of MySQL. You can use them to test different types of replication (such as master-master or various slave topologies), to test your code against different versions of MySQL, or to setup instances of MySQL on a per developer basi
