Whenever you need to get actual page url in Native PHP then you can do using this post I give you the example that way you can get easily current URL in PHP following PHP code through you can getstrongExamplestrongpre classprettyprint langphpcurrentLink httpSERVERHTTPHOS

Paypal is very popular payment gateway Most of the persone are choose paypal as payment gateway because it is very secure and pretty simple way to use If you want to use Paypal API in your laravel 5 application then this post will help you and you can easily use this In this post you can lean how

If you remove a file, file system generally just marks in its metadata that previously occupied blocks can now be used for other files – that operation is usually cheap, unless the file has millions of segments (that is such a rare case, only seen in experimental InnoDB features that Oracle thought was a good idea).

This changes a bit with SSDs – if you update underlying device metadata, it can have smarter compaction / grooming / garbage collection underneath. Linux file systems have ‘discard’ option that one should use on top of SSDs – that will extend the life time of their storage quite a bit by TRIM’ing underlying blocks.

Now, each type of storage device will react differently to that, some of them support large TRIM commands, some of them will support high rate of them, some of them won’t, etc – so one has to take that into account when removing files in production environments.

Currently Linux block …

It is not uncommon to come across MySQL databases where reserved words are in use as identifiers for any kind of database objects.

Perhaps when the application schema was implemented, the words were not reserved yet, and they became reserved later on a subsequent MySQL release.

It is a good practice to check reserved words usage prior to doing any database upgrades, as any newly reserved keywords will cause syntax errors on the new version.

This is usually not a problem if proper quoting is used for referencing the objects, as described on the official manual page.

The actual steps to do this depend on the environment; for example, the following can be configured to tell Hibernate to escape identifiers:

property name="hibernate.globally_quoted_identifiers" value="true"

This does …

This is not a comprehensive review, nor an user guide. It's a step-by-step account of my initial impressions while trying the new MySQL XProtocol and the document store capabilities. In fact, I am barely scratching the surface here: more articles will come as time allows.

MySQL 5.7 has been GA for several months, as it was released in October 2015. Among the many features and improvements, I was surprised to see the MySQL team emphasizing the JSON data type. While it is an interesting feature per se, I failed to see the reason why so many articles and conference talks were focused around this single feature. Everything became clear when, with the release of MySQL 5.7.12, the MySQL team announced a new release model.

Overview

In …

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