Profile cover photo
Profile photo
Daniël van Eeden
101 followers
101 followers
About
Daniël's posts

Post has attachment
The mysql client, and some improvements
The mysql client is a tool which I use every day as a DBA. I think it's a great tool. When I used a client of several other SQL and NoSQL databases I was quickly reminded of all the features of the mysql client. Note that psql (PostgreSQL client) is also ve...

Post has attachment
Common Table Expressions in MySQL
In a recent labs release a new feature was introduced by Oracle, or actually two very related new features were introduced. The first new feature is Common Table Expressions (CTEs), which is also known as WITH . The second feature is recursive CTEs, also kn...

Post has attachment
About Oracle MySQL and CVE-2016-6662
The issue On 12 September 2016 (three days ago) a MySQL security vulnerability was announced. The CVE id is CVE-2016-6662 . There are 3 claims: By setting malloc-lib in the configuration file access to an OS root shell can be gained. By using the general lo...

Post has attachment
Visualizing the MySQL Bug Tide
On the MySQL Bugs website there are some tide stats available. These show rate of bug creation. I've put them in a graph: I made these with this IPython Notebook .

Post has attachment
Re: JSON document fast lookup with MySQL 5.7
This is a response to the JSON document fast lookup with MySQL 5.7 article by Frederic Descamp. It is very easy to also use MySQL Workbench and the new GeoJSON support to actually show the features. My query: SELECT ST_GeomFromGeoJSON(feature->"$.geometry",...

Post has attachment
When simple SQL can be complex
I think SQL is a very simple language, but ofcourse I'm biased. But even a simple statement might have more complexity to it than you might think. Do you know what the result is of this statement? SELECT FALSE = FALSE = TRUE; scroll down for the answer. The...

Post has attachment
Using Connector/J with Python
With Python you would normally use MySQL Connector/Python or the older MySQLdb to connect from Python to MySQL, but there are more options. There are also multiple Python implementations: CPython (the main implementation), PyPy , Jython and IronPython . PyP...

Post has attachment
The performance of TLS with MySQL Connector/Python
I've ran a simple test to see the performance impact of TLS on MySQL connections with MySQL Connector/Python The test results are in this Jupyter notebook . TL;DR: Try to reuse connections if you use TLS Establishing TLS connections is expensive (server & c...

Post has attachment
The performance of MySQL Connector/Python with C Extension
The source of this post is in this gist . After reading about the difference between MySQL Connector/Python and MySQLdb on this blog post I wondered how the C Extension option in Connector/Python would perform. If you want to run the code yourself you'll ne...

Post has attachment
Wait while more posts are being loaded