Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 282 10 Older Entries

Displaying posts with tag: Development (reset)

MariaDB AWS Key Management Service (KMS) Encryption Plugin
+1 Vote Up -0Vote Down

MariaDB 10.1 introduced Data at Rest Encryption. By default we provide a file_key_management plugin. This is a basic plugin storing keys in a file that can be itself encrypted. This file can come from a usb stick removed once keys have been brought into memory. But this remains a basic solution not suitable for security [...]

Print tab separated values as table using MySQL
+0 Vote Up -0Vote Down

Using mysql command line utility to get recordsets, the data rows alignment and line breaks are often  a mess. You can use the command line tool on a mysql database server to get a set of rows into an output TSV file like so: shell> mysql -u your_user -p < your_statement.sql > data.csv I came up with the following python script to grab the output file and pretty print:

You can put your own

MySQL sample databases: for testing and training
+0 Vote Up -0Vote Down

Sometimes it's useful to have a set of data prepared to be used on a fresh MySQL install for testing purposes. Or you might be preparing some training or workshop and want to prepare examples with fake information. For MySQL there are some choices available:

Employees Sample Database: provides a combination of a large base of data (approximately 160MB) spread over six separate tables and

Ubuntu: Steps to install/update MySQL to the latest DMR
+0 Vote Up -0Vote Down

For learning, testing and keep up with things, one might want to install/update the MySQL version to the latest DMR (Development Milestone Release). At the time of this writing the latest DMR for MySQL is  MySQL Community Server 5.7.8-rc. Having chosen Ubuntu server as my operating system and since this is a development version hence not yet part of an official Ubuntu release, you have to install

Developing a MySQL Workbench plugin
+0 Vote Up -0Vote Down

The MySQL Workbench tool is great for development and administration tasks. Also it's available on Windows, Linux and Mac OS X which, according to information from third party sources, is more than you can say for most of the other equivalent tools. And Workbench is free. Having said that, most of the provided functionalities are intuitive and of daily use for developer and DBA staff alike.

MariaDB meetup in Helsinki on March 17th
+0 Vote Up -0Vote Down

If you are in Helsinki on Thursday next week March 17th, join us for the MariaDB meetup at Solinor. MariaDB team members will present the latest on MariaDB 10.1, MaxScale and MariaDB’s future roadmap. On stage Rasmus Johansson VP Engineering, MariaDB Corporation and Johan Wikman & Markus Mäkelä, developers of MaxScale. See the meetup page […]

The post MariaDB meetup in Helsinki on March 17th appeared first on MariaDB.org.

Eating our own dog food – Running JIRA on MariaDB
+1 Vote Up -0Vote Down

A couple of weeks ago we announced that we were moving from a hosted instance of JIRA to our self hosted instance. The main reason was that we hit 2000 active users in the hosted instance of JIRA and that is the upper limit that it  supports. We obviously wanted to allow more people to […]

The post Eating our own dog food – Running JIRA on MariaDB appeared first on MariaDB.org.

New in MariaDB Connector/C 3.0 – Part I: SSL
+0 Vote Up -0Vote Down

New SSL alternatives SSL connections in previous versions of MariaDB Connector/C based on the OpenSSL library. The OpenSSL heartbleed bug, licensing problems and the lack of supporting different transport layers were the main reasons that we decided to offer SSL alternatives. In addition to OpenSSL the following SSL libraries are supported in Connector/C 3.0: GnuTLS […]

The post New in MariaDB Connector/C 3.0 – Part I: SSL appeared first on MariaDB.org.

Using JSON’s Arrays for MariaDB Dynamic Columns
+0 Vote Up -0Vote Down

The JSON format includes the concept of array. A JSON object cant contain an attribute of array type. We have seen that we can use the MariaDB CONNECT Storage Engine provided UDFs (user defined functions) to implement dynamic columns.

Let us create a table with a text column containing a a JSON string and let [...]

Using JSON as Dynamic Columns with MariaDB
+0 Vote Up -0Vote Down

MariaDB CONNECT storage engine handles access to JSON files through standard SQL. It comes with a set of UDFs (user defined functions) to manipulate the JSON format. This JSON content can be stored in a normal text column. This approach can be used to implement dynamic columns. The dynamic column concept was first introduced with [...]

Showing entries 1 to 10 of 282 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.