mysql-data-at-rest-encryption

This week at Redgate HQ we’ve been lucky enough to have a visit from Dave Farley, Continuous Delivery evangelist and co-author of the book Continuous Delivery.
In one of our discussions we started talking about database unit testing. Pretty soon we realized we both meant something fundamentally different when we called something a database unit test.  Read More →

tools

With OSX 10.11 El Capitan, here is how to get the AMP stack up and running. This tutorial will go through the process on getting Apache, MySQL, PHP (or otherwise known as the ‘AMP’ stack) and phpMyAdmin running on the El Capitan OS.
This tutorial sets up the AMP stack in more of a traditional way using the loaded Apache and PHP and downloading MySQL and phpMyAdmin. For Read More →

mysql-data-at-rest-encryption

Summary
To completely uninstall MySql OS X it is neccessary to remove numerous files.
Symptom
You unable to install an older version of MySql even though you thought you have removed everything.
Resolution
To uninstall MySQL and completely remove it (including all databases) from your Mac do the following:

Open a terminal window
Use mysqldump to backup your databases to text files!
Stop the Read More →

L’utilité des dérivées
Laisser un commentaireGo to comments

La dérivée peut sembler être une chose bien abstraite lorsqu’on la regarde sous un angle mathématique, puisqu’il est bien difficile de lui trouver une utilité. Cependant, la dérivée occupe une place bien importante dans d’autres domaines. En physique, elle peut servir à étudier le mouvement d’un objet, c’est-à-dire sa Read More →

OK, you got “.img” virtual machine image. Now what?
Diving in VMWare, Oracle Virutal Machine, etc, etc, there is not a shadow of the option to choose “new virutal machine” from .img image.
What should I do?
1. Download Qemu (ported version for OSX) http://www.kju-app.org/
2. After installing it on Mac (works fine for me on Maverick),

1
2

cd /Application/Q.app/Contents/MacOS/qemu-img
./qemu-img convert -f raw -O vmdk /Volumes/xxx/rawdisk200gb.img /Volumes/xxx/vdisk200gb.vmdk

3. Next, Read More →

tools

Life is full of bugs.
No matter how carefully planned, no matter how much time went into design, any project is going to have unforseen issues when the rubber hits the road in the implementation stage. And that's okay. Perhaps the best measure of resiliency for any organization is not how well they handle things when everything is functioning Read More →

index

This checklist includes basic things to look for in your code reviews, but you should also allow new
styles and patterns specific to your own team to emerge and evolve. when they do, make your own
code review checklist.
Architecture / Design
Style / Readability

php

Make a fully operational REST API in PHP

Routing a JSON REST request
Converting it into SQL
Executing it
Giving a meaningful response

Running
Save this file as “api.php” in your (Apache) document root and call it using:
Or you can use the PHP built-in webserver from the command line using:
The URL when ran in from the command line is:
NB: Don’t forget Read More →

wp

To easily enable (and enforce) WordPress administration over SSL, there are two constants that you can define in your site's wp-config.php file. It is not sufficient to define these constants in a plugin file; they must be defined in your wp-config.php file. You must also already have SSL configured on the server and a (virtual) Read More →

mysql_workbench

Getting started:

http://www.sqlteaching.com/
https://www.codecademy.com/courses/learn-sql

Related tutorials:

MySQL-CLI: https://www.youtube.com/playlist?list=PLfdtiltiRHWEw4-kRrh1ZZy_3OcQxTn7P
Analyzing Business Metrics: https://www.codecademy.com/learn/sql-analyzing-business-metrics
SQL joins infografic: http://cd64.de/sql-joins

Tools:

DataGrip: https://www.jetbrains.com/datagrip/
Sequel Pro: http://www.sequelpro.com/

Commands
Aggregate functions
Multiple tables
Users functions
Find out the IP Address of the Mysql Host

mysql_workbench

Database
Sample database cart table contains four columns cart_id, user_id, product_id and created_at.

Enable MySQL Event Scheduler
Start MySQL event scheduler by executing following query in PhpMyAdmin or MySQL command prompt.

 

Create a Event
Here the following event will run everyday and clear/delete 10 days old data from cart table based on time stamp

 

Alter Event
If you want to modify the Read More →

Instal Apache

Le retour devrait ressembler à ceci :

1
2

Server version: Apache/2.2.22 (Unix)
Server built:   Aug 24 2012 17:16:58

For administration :

1
2
3
4

sudo apachectl start
sudo apachectl restart
sudo apachectl stop
sudo apachectl graceful # relance apache en attendant la fermeture des connexions établies

The document root

The document root is in :

1

 

Sur les anciennes versions de l’OS, les utilisateurs disposaient d’un dossier Sites dans Read More →

index

SQL Server’s query optimizer uses distribution statistics to determine how it’s going to satisfy your SQL query. These statistics represent the distribution of the data within a column, or columns. The Query Optimizer uses them to estimate how many rows will be returned from a query plan.
Distribution statistics are created automatically when you create an Read More →