The MySQL Document Store introduced with version 5.7.12 allows developers to create document collections without have to know Structured Query Language. The new feature also comes with a new set of terminology. So let us create a collection and see what it in it (basically creating a table for us SQL speakin' old timers).

So start the mysqlsh program, connect to the server, change to the world-x schema (database) switch to Python mode, a create a collection (table).

What did the server do for us? Switching to SQL mode, we can use describe to see what the server has done for us.

We have a two column …

The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 2.0.2 m1. Note that this is a milestone release and not intended for production usage.

MySQL for Visual Studio 2.0.2 m1 is the first development release of MySQL for Visual Studio to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.

For more information about how the X DevAPI is implemented in MySQL for Visual Studio, and its usage, please refer to the MySQL for Visual Studio Quick-Start Guide.

Please also note that the X …

You can get many returns from a Google search for “MySQL Query Best Practices” or “MySQL Query Optimization.” The drawback is that too many rules can provide confusing or even conflicting advice. After doing some research and tests, I outlined the essential and important ones below:

1) Use proper data types

1.1) Use the smallest data types if possible

MySQL tries to load as much data as possible into memory (innodb-buffer-pool, key-buffer), so a small data type means more rows of data in memory, thus improving performance. Also, small data sizes reduces disk i/o.

1.2) Use Fixed-length Data Types if Possible

MySQL can calculate quickly the position of a fixed-length column in a specific row of a table.

With the flexible-length data type, the row size is not fixed, so every time it needs to do a seek, MySQL might consult the primary key …

massassignmentexception is for the security purpose if laravel 5 function When i did start Laravel 5 and first i did try to add user using Usercreatenamehdpassword1w then i found bellow error I was thinking what was wrong but after investigation i found it for our security pu

Laravel 5 provide several way to send email You can also use core PHP method for send mail and you can also use some email service providers such as sendmail smtp mandrill mailgun mail gmail etc So you can choese any one and set configration Laravel 5 provide Mail facade for mail send that h

Mon, 2016-04-25 11:54janlindstrom

The latest top research identifies a number of big trends and challenges for databases. Jan Lindström, developer at MariaDB, summarises the key issues and challenges and how MariaDB approaches them.

First of all, the opinions expressed in this article are the author's own and do not necessary reflect the view of the MariaDB Corporation. These views are based on the review article by Abadi, et.all.: The Beckman Report on Database Research, Communications of the ACM, Vol. 59, NO. 02, 02/2016. While this meeting with thirty leaders from the database research community met in October 2013, my view is that issues raised in this meeting are still more than valid.

The review article identifies big data as a defining challenge of our time. This is because it has become cheaper to generate data due to inexpensive storage, sensors, smart devices, social software, multiplayer games, …

Join us tomorrow, as we introduce a new webinar series: ‘How to Become a MongoDB DBA’ to answer the question: ‘what does a MongoDB DBA do?’.

This is a series of three webinars during which we will walk you through the most important tasks a MongoDB DBA routinely goes through and provide you with options on how to best complete these tasks.

It is not uncommon for MySQL DBAs, developers, network/system administrators or DevOps folks with general background to find themselves in a situation where they’ve been working with MySQL for a while and are now being asked to also properly maintain one or more MongoDB instances. In fact, with more organisations operating polyglot environments, it’s starting to become commonplace.

In this first webinar, we will show you how you can automate tasks, monitor a cluster and manage MongoDB; whilst also …

Mon, 2016-04-25 06:42colin

AliSQL is the fork of MySQL (maintained by Alibaba) that powers all of the group from Tmall, Taobao, Alibaba.com, 1688.com, AliExpress, Cainiao and the payment's network Alipay.

AliSQL isn't new - they've had this fork since 2011: AliSQL 5.1 (Bugfixes for DDL, eliminate race conditions), 2012: AliSQL 5.5 (parallel replication, optimize hot SKUs), 2014: AliSQL 5.6 (Enhanced threadpool, SQL firewall). The team have found/reported/fixed over 40+ bugs, added 41 new features, and optimised 27 bottlenecks. All recent releases of MySQL have had AliSQL contributions (5.6.25 onwards, 5.7.8 onwards, and even 5.8 branch).

AliSQL benefitting MariaDB Server

While not mentioned in the talk, its clear that MariaDB Server 10.0+ has benefited from their tree as well -- our …

If you want to run any php project directly without virtualhost then you can run easily You must have install PHP only Not only core php project but if you have question like how to run codeigniter project how to run yii2 project how to run symfony project how to run zend framework project how

If you want to run laravel project without virtual host then you can run quickly using laravel artisan command if you are beginner and you are confuse how to run laravel application then it is very simple to run so just run bellow command in your terminalstrongRun Projectstrongprephp arti