Mon, 2016-05-02 13:50Colin Charles

When folk in the MariaDB world think about a GUI front-end, they tend to think of HeidiSQL, which has been shipping as part of MariaDB Server since 5.2.7. If one has a MariaDB Enterprise subscription, you get the Visual Query Editor which is SQLyog by Webyog. In fact the Knowledge Base lists a fairly lengthy list of Graphical and Enhanced Clients.

This past week I got a quick demo of Vertabelo. It is a SaaS based database design tool, that allows you to model within a web …

And for the fourth year in a row, MariaDB Foundation participates in the Google Summer of Code! The MariaDB Organization in GSoC is an umbrella organization for all projects that belongs to the MariaDB ecosystem, be it MariaDB Server, MariaDB Connectors, or MariaDB MaxScale. The complete list of our suggested project ideas is in MariaDB […]

The post MariaDB in Google Summer of Code 2016 appeared first on MariaDB.org.

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache 2.4 web server on an Ubuntu 16.04 (Xenial Xerus) server with PHP 7 support (mod_php) and MySQL / MariaDB. Additionally, I will install PHPMyAdmin to make MySQL administration easier. A LAMP setup is the perfect basis for CMS systems like Joomla, Wordpress or Drupal.

Mon, 2016-05-02 12:08Nishant Vyas

In the previous blog, I've talked about, Why is ColumnStore important?. Let's look at MariaDB ColumnStore architecture and use-cases.

MariaDB ColumnStore is built on a three-tier scalable architecture that supports the kind of growth that MariaDB users have grown accustomed to. Queries are processed by user modules, which assign tasks to parallel performance modules that access the columnar distributed storage layer below. Performance modules scale almost infinitely, providing both performance and capacity growth as you add servers. These modules don’t process queries; they just take instructions from the user modules, which organize and deliver the results.

At the very high-level, when a query arrives at MariaDB Database Server; It gets the data from storage engine, applies projection, filtering, sorting, …

Sometimes we require to run directly mysql query on Laravel for example if you need to copy one table to other table using mysql query I also need in one project and thats why i am fetching problem But you can use sql query on laravel using db statement in bellow example you can learn how to run

Sometimes we require to run directly mysql query on Laravel for example if you need to copy one table to other table using mysql query I also need in one project and thats why i am fetching problem But you can use sql query on laravel using db statement in bellow example you can learn how to run

Multiple authentication is very important in big application of laravel If you work on large project then you mostly prefer to diferente tables like you always prefer users table for site user registration and admins table for admin user that way make strong security we always use Auth for ma

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.25. See the release notes and changelog for details on this release. Download MariaDB 10.0.25 Release Notes Changelog What is MariaDB 10.0? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.0.25 now available appeared first on MariaDB.org.

We are always wanted to use sql query for concatenate fullname or something to concat using mysql concat function now if you think how to use concat function in laravel query builder then this post can help you So if you need to use concat mysql function then see bellow examplestrongExample

In this post you can learn how to add multiple condition in join query of Laravel Eloquent if you use data relationship then you dont need to use but if you need to get manually join with two or more condition then it can help in this example i also add how to add simple inner join in laravel and