This Log Buffer Edition covers Oracle, SQL Server and MySQL blog posts of the week.

Oracle:

Improving PL/SQL performance in APEX

A utility to extract and present PeopleSoft Configuration and Performance Data

No, Oracle security vulnerabilities didn’t just get a whole lot worse this quarter.  Instead, Oracle updated the scoring metric used in the Critical Patch Updates (CPU) from CVSS v2 to CVSS v3.0 for the April 2016 CPU.  The Common Vulnerability Score System (CVSS) is a generally accepted method for scoring and rating security …

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

If you are new and you trying to find how to detect user is login or not in your laravel application So it is very easy to check because laravel 5 provide to Auth facade for check user is login or not Check bellow examplestrongExamplestrongpre classprettyprint langphpif Authch

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