In This tutorial i want to show you how to create CRUDCreate Read Update Delete using AngularJS in Codeigniter I added few step to create create edit delete lists search and pagination application in your Codeigniter framework In this tutorial through you can make simple crud search and

Problem:

When multiple client applications such as web applications, desktop applications and mobile applications written in different languages like php, python, java, objective c, etc. need to perform the same database operation (insert), the same operations done by different client applications and client applications are directly accessing the database table using same SQL statement.

Solutions:We are implementing stored procedure; here the client applications will simply call the defined stored procedures to perform the database operation (insert). In this post let us see about the syntax of the stored procedure and will see an example of insert operation using stored procedure using MySQL.

Syntax:

mysql> DELIMITER //

mysql> CREATE PROCEDURE Procedure_name(arguments) 

     ->  BEGIN 

     -> 

     -> SQL Statements; 

I just joined Chocolatey, which is sort of like yum or apt-get for Windows. HeidiSQL was already listed there but was outdated, so I created a package with the current 9.3 release.

See the package here: https://chocolatey.org/packages/HeidiSQL

Hi Valerie,

In my case (and others I know that hit the same bug) was a simple slave upgrade from 10.0 to 10.1 , and wait .
In my case, the content of FIL_PAGE_FILE_FLUSH_LSN (that MariaDB 10.1 renames to FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION) was interpreted as a key.
FIL_PAGE_FILE_FLUSH_LSN is *supposed* to be always 0 with the exception of the first page of the first tablespace (0:0) . For this reason was re-purposed by MariaDB for keys, and by InnoDB to store RTREE Split Sequence Number .
Also, the content of FIL_PAGE_FILE_FLUSH_LSN is not part of page checksum, so anything could be there…
According to https://dev.mysql.com/worklog/task/?id=7990 , FIL_PAGE_FILE_FLUSH_LSN was also written in undo tablespace files.
My hypothesis is that for whatever reasons there were pages in 10.0 that has non-zeros in FIL_PAGE_FILE_FLUSH_LSN, …

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

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

If you use a storage engine that supports transactions, you probably have faced or heard of deadlock's.

From MySQL Documentation:
“Always be prepared to re-issue a transaction if it fails due to deadlock. Deadlocks are not dangerous. Just try again.”

At work, we had an important job that sometimes were failing due to dead lock. I wanted to enhance it, so it will do what the documentation says ( Retry the transaction ). In order to do that, I wanted to have a scenario where I was able to reproduce the deadlock and the victim transaction was the one from the job I was fixing.

Create a deadlock is simple, you just need to have 2 sessions that each one holds a lock that the other is waiting for. For example:
We have a table that has 4 entries on it (entry 1, entry 2, entry 3, entry 4) and we have 2 …

I'm known for telling "Don't use references" (also as video) as those cause different problems (i.e. with foreach) and hurt performance. The reason for the performance loss is that references disable copy-on-write while most places in PHP assume copy-on-write. Meanwhile we have PHP 7. In PHP 7 the internal variable handling changed a lot among other things the reference counting moved from the zval, the container representing a variable, to the actual element. So I decided to run a little test to verify my performance assumption was still valid.

In my test code I'm calling a function which calls strlen (one of the cheapest functions in PHP - PHP strings …

This blog post was co-authored by Peter Sylvester and Valerie Parham-Thompson

Introduced in version 10.1.3 (and with substantial changes in 10.1.4), the MariaDB data encryption at rest feature allows for transparent encryption at the tablespace level for various storage engines, including InnoDB and Aria.

Before now, there have been only two widely accepted encryption methods for MySQL/MariaDB: encryption at the file system level, or encryption at the column level. For comparison, we’ll do a brief overview of how these work, as well as the pros and cons typically associated with each option.

File System Encryption

This is performed by setting a file system to be encrypted at the block level within the operating system itself, and then specifying that the encrypted volume should be the location of the data directory for MySQL/MariaDB. You can also use encrypted volumes to store MariaDB binary logs. …

This Log Buffer browses through Oracle, SQL Server and MySQL spaces and brings forth some of the useful blog posts for this week.

Oracle:

Conner throws it out of the park. As we all (hopefully) know, we should always deploy named program units (procedures/functions) within packages. Its a great method of encapsulation of logic.

Pythian’s Gleb talks about Azure on RAC. Microsoft Azure provides an acceptable and affordable platform for a training environment.

There are some performance improvements that require physical storage options to be set on tables or indexes. One particular technique that I will take as an …

Welcome to today’s installment of Planets9s, our weekly communication on all the latest resources and technologies we create around automation and management of open source databases. I trust that these resources will be useful to you and would love to get your feedback on them.

Download ClusterControl - The Full Monty Release for MySQL, MongoDB & PostgreSQL

This week we’re pleased to announce the release of ClusterControl 1.2.12. This release contains key new features, such as support for the latest versions of MySQL, MongoDB & PostgreSQL, operational reports and enhanced backup options, along with performance improvements and bug fixes. Worth highlighting are also the new replication features for Master & Slave, as well as SSL encryption of Galera

Replication links. …