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

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

Recently I worked on a feature that involved displaying a list of Folders using an auto-complete field. A simple enough task, but one that had a bit of complexity behind it. For starters, each organization in our system has their own "folder hierarchy", or a tree structure of folders, that could be one to many layers deep. The second thing being that the UI we wanted -- auto-complete -- meant that we would need to "search" through the folders to find a match (based on the user's input) as well as display the path information (where the folder lives) so that the user can differentiate folders if they happen to have the same or similar name. Since it was auto-complete, the searching also needed to be fast or else the user experience would be annoying.

The folder tree structure was stored in a MySQL DB table in a very typical self-referencing schema that represented hierarchical data. Each row of data could have a column that referenced the …

This tutorial shows how to prepare a Debian Jessie server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3.1. The web hosting control panel ISPConfig 3 allows you to configure the following services through a web browser: Apache web server, Postfix mail server, Dovecot IMAP/POP3 server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, and many more.

Sublime Text is a very popular text editor in nowdays Most of the developer chooes Sublime Test for codding because it is very smooth and pretty easy I think specially most of the PHP developer are chooes sublime for developing If you are working on ubunu system then you can install very easily

If you require to get file size in php then you can do it easily using filesize of PHP Normally we require to get and check on before image uploading So if you want to get image size then bellow example can help you It will return size on bytestrongExamplestrongpre classprettyprint

MySQL Replication has become an essential component of scale-out architectures in LAMP environments. When there is a necessity to scale out, MySQL offers a multitude of solutions, the most common being to add read replicas. The major bottleneck for our data is generally not so much oriented around writing our data but more around reading back this data. Therefore the easiest way to scale MySQL is to add replicas for reading.

And with today’s cloud environments, where resources are dynamically allocated and deallocated, systems need the ability to automatically adapt to sudden changes. For MySQL Replication, this includes tasks like detecting failures, promoting a slave to master, failing over slaves, and so on. A load balancer with Virtual IP can also help mask topology changes from the application, and dispatches read and write traffic appropriately.

With that in mind, we’d like to introduce the …

Fri, 2016-04-29 08:22Nishant Vyas

Relational databases store data in rows because a typical SQL query looks for multiple fields within a record. For example, if you ask for name, zip code and email address of all your customers in New York, the result is presented in rows, with each row containing several fields from a single record. Row structures are also well optimized to handle a lot of inserts and updates.

But analytic queries are better handled with a column structure because they are more likely to go deep on a column of data, most queries relate only to a tiny subset of all the available columns and they’re also mostly read-only. For example, retrieving daily sales data for all your stores in California for the past two years is a columnar operation because it cuts across many records to retrieve data from a specific field. A typical ad-hoc aggregation query doesn’t care about most fields, just the trends in one …