Thu, 2016-04-28 10:03Michaël DeGroot

MariaDB works with many clients to migrate Microsoft SQL and Oracle to MariaDB. With the CONNECT storage engine we can access any ODBC data source in MariaDB. Here's a small HOWTO for those who want to give it a quick try. In this example we use MSSQL, though the same principle should be possible with Oracle ODBC servers.

We start with a clean MariaDB installation, no ODBC drivers installed yet. In this example we used CentOS7. It's important to start at a point where unixODBC is not yet installed, because the Microsoft installation package wants to install its own unixODBC.

Step 1

Microsoft is kind enough to supply us with an ODBC driver for Linux. We download it and unpack it.

Step 2 …

I am one of those crazy people who attempts to write SQL that works on SQlite, MySQL and PostgreSQL. First I should explain why:

This is all for my project sabre/dav. sabre/dav is a server for CalDAV, CardDAV and WebDAV. One of the big design goals is that it this project has to be a library first, and should be easily integratable into existing applications.

To do this effectively, it’s important that it’s largely agnostic to the host platform, and one of the best ways (in my opinion) to achieve that is to have as little dependencies as possible. Adding dependencies such as Doctrine is a great idea for applications or more opinionated frameworks, but for …

Thu, 2016-04-28 08:23Johan WikmanURGENT UPDATE: Do not take 1.4.2 into use. We have found a problem and will provide a 1.4.3 release shortly.

We are pleased to announce that MariaDB MaxScale 1.4.2 GA is now available for download!

If MariaDB MaxScale is new to you, we recommend reading this page first.

1.4.2 is a bugfix release, not bringing any new features but fixing certain issues found in 1.4.1.

MariaDB MaxScale 1.4 brings:

1. The Firewall Filter has been extended and can now be used for either black-listing or white-listing queries. In addition it …

Thu, 2016-04-28 07:33Nishant Vyas

MariaDB’s new analytics engine – MariaDB ColumnStore - has been in the works for some time. What is it and how did it come about? This post outlines our thinking in choosing the engine and features we implemented.

Databases are expanding from their roots as systems of record into new analytics applications that some people call “systems of intelligence.” That means that instead of just storing and querying transactional data, databases are increasingly being used to yield insights, predict the future and prescribe actions users should take. Led by the open-source Hadoop ecosystem, online analytic processing (OLAP) is making its way out of the corporate data center and into the hands of everyone who needs it.

In the last decade, as data analytics became more important, solving these problems became …

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Whenever you require to use select like query in your application then you can easily use Laravel 5 provide query builder and mysql like condition is very simple to use So lets see bellow example did convert bellow sql querystrongSQL ExamplestrongpreSELECT FROM usersWHERE name

Sometimes to require collapse for display large text with titleAlways we like to use collapse for data content So if you think how to use collapse in my project then it is very easy you have to just copy bellow example and run in your local you will find result In this example i provide bootstrap

In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade.

MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters can be set down to microsecond granularity. Obviously, this means format changes, but why is this important?

Are they converted automatically to the new format?

If we had tables in MySQL 5.5 that used TIME, TIMESTAMP or DATETIME are these fields are going to be converted to the new format when upgrading to 5.6? The answer is “NO.” Even if we …

Wed, 2016-04-27 14:20colin

While many are at the ongoing OpenStack Summit in Austin, it came to my attention that the OpenStack project has recently published their latest user survey. From there, it is clear that there is growth in the usage of MariaDB Server -- up 6 points from the previous survey. MariaDB Galera Cluster dropped by 1 point, but it's worth noting that in MariaDB Server 10.1, you're getting it all as an integrated download so it is quite likely that people are just referring to it as "MariaDB" now.

(Screenshot taken from the user …

We always need to dialog box in our project because modal is very interesting and specially for GUI Always we like to use modal for creating data or editing data and also for conformation So if you think how to set modal in my project then it is very easy you have to just copy bellow example and r