C’est officiel, le nouveau règlement européen de protection des données personnelles prévoit la désignation obligatoire d’un Data Protection Officer aussi appelé "DPO".
FrenchTech SAAS
33.5K views |
+3 today
 Your new post is loading...
Your new post is loading...
Scoop.it!
The WITH clause provides a simple way to organize SQL code. It 
Scoop.it!
Le Bon Coin regorge de données intéressantes : nombre d’annonces, prix, localisation, catégories…
Scoop.it!
Le web analytics peut fournir de nombreuses données et informations liées à la performance technique de votre site web, mais les marketeurs ont besoin de données beaucoup plus riches pour comprendre la performance de leurs campagnes marketing...
Scoop.it!
La fiabilité d'un produit est aussi primordiale que difficile à évaluer pour le consommateur.
Scoop.it!
Le Big Data est partout autour de nous, cette infographie de VoucherCloud revient sur les principaux chiffres clés du Big Data. Définition : le Big Data, c’est quoi ? En Français, le mot « Big Data » signifie littéralement un gros volume de données. Les Big Data sont donc des volumes colossales de données qui se doivent d’être …
Scoop.it!
SQL is a type-safe language. Using the wrong data type—e.g. VARCHAR to store numbers—can cause performance problems. How to diagnose and fix them.
Scoop.it!
I got some interesting comments on my previous article about unit testing Maatkit, including echoes of my own conversion to the unit-testing religion. One of the objections I’ve heard a lot about unit-testing is how it’s impossible to test code that talks to a database. “It’s too hard,” they say. “Oh, it’s easy to test a module that calculates a square root, but a database? Way too much work!”
Scoop.it!
I've come to the conclusion that, for me, ORMs are more detriment than benefit. In short, they can be used to nicely augment working with SQL in a program, but they should not replace it.
Scoop.it!
You probably know this scenario from your daily work and projects, where you want to put your fresh or experienced PHPUnit skills to work and get stuck by one of the following problems:
The DbUnit extension considerably simplifies the setup of a database for testing purposes and allows you to verify the contents of a database after performing a series of operations.
Mickael Ruau's insight:
Difficulties in Database Testing There is a good reason why all the examples on unit testing do not include interactions with the database: these kind of tests are both complex to setup and maintain. While testing against your database you need to take care of the following variables:
Because many database APIs such as PDO, MySQLi or OCI8 are cumbersome to use and verbose in writing doing these steps manually is an absolute nightmare. Test code should be as short and precise as possible for several reasons:
Additionally you have to realize that the database is essentially a global input variable to your code. Two tests in your test suite could run against the same database, possibly reusing data multiple times. Failures in one test can easily affect the result of the following tests making your testing experience very difficult. The previously mentioned cleanup step is of major importance to solve the “database is a global input” problem. DbUnit helps to simplify all these problems with database testing in an elegant way. What PHPUnit cannot help you with is the fact that database tests are very slow compared to tests not using the database. Depending on how large the interactions with your database are your tests could run a considerable amount of time. However, if you keep the amount of data used for each test small and try to test as much code using non-database tests you can easily get away in under a minute even for large test suites.
Scoop.it!
Relational database management systems (RDBMSs) often persist mission-critical data which is updated by many applications and potentially thousands if not millions of end users. Furthermore, they implement important functionality in the form of database methods (stored procedures, stored functions, and/or triggers) and database objects (e.g. Java or C# instances). The best way to ensure the continuing quality of these assets, at least from a technical point of view, you should have a full regression test suite which you can run on a regular basis.
Mickael Ruau's insight:
Table of Contents
- See more at: http://www.agiledata.org/essays/databaseTesting.html#sthash.BawnMh8R.dpuf
Scoop.it!
Richard Dallaway notes about database unit testing inspired me the realization of the DbUnit framework. I think this is a very good text about this subject. Hopefully he gave me the permission to present excerpts from his notes here. The original text is much longer and I strongly suggest you to read it as well. See resources for reference to it. - Manuel Laflamme
Scoop.it!
Over the last few years we've developed a number of techniques that allow a database design to evolve as an application develops. This is a very important capability for agile methodologies. The techniques rely on applying continuous integration and automated refactoring to database development, together with a close collaboration between DBAs and application developers. The techniques work in both pre-production and released systems.
Mickael Ruau's insight:
Contents
|
Scoop.it!
Pour piloter votre activité e-commerce, un tableau de bord est indispensable. Il ne s’agit pas uniquement d’en avoir un, même si la démarche de construction du tableau de bord est très structurante, il faut l’utiliser et l’adapter en continu aux évolutions de son activité. Un reporting régulier permet de donner à l’ensemble des décisionnaires une vision globale de l’activité, et surtout la capacité de réévaluer les priorités ou les budgets rapidement. En matière d’e-commerce, la capacité à mesurer, tester et optimiser l’acquisition de trafic et l’entonnoir de conversion est un facteur de succès indiscutable.
Scoop.it!
La Cour de cassation rappelle que la prorection dont bénéficie le producteur d'une base de données est conditionnée par la démonstration de la pr...
Scoop.it!
Non, le paradoxe de Simpson ne tire pas son nom de Homer, mais de Edward Simpson, le statisticien qui l'a décrit pour la première fois en 1951. Il s'agit d'un de ces paradoxes mathématiques qui peu...
Scoop.it!
Google Spreadsheet's ImportXML function is easy to use, and can sometimes look magical. You can use it to grab Web page or blog title and subtitles, stock prices, or movie info from IMDB. You can summarize data, extract Wikipedia table, and so much more. Here is a list of excellent tutorials. Google also has related and useful spreadsheet functions such as ImportData, ImportHTML, ImportFeed. What do you do if the new Google Sheet yield inexplicable errors? What is ImortXML from Google Spreadsheet? How can I use them? What are some examples of use? Where can I find simple and effective tutorials to learn from? Where can I find sample codes? What other Google Spreadsheet functions are there? What do I do if the importXML function yield error about parsing? Try the older Google Sheet http://g.co/oldsheets
Scoop.it!
Pour que ces attaques DDoS découvertes par Symantec puissent s’opérer, les auteurs injectent dans les serveurs MySQL une fonction définie par l’utilisateur (UDF) malicieuse. Cette fonction se nomme Downloader.Chikdos et demeure sur le système de fichiers du serveur. C’est cette dernière qui va télécharger la charge utile qui n’est autre que le malware Chikdos.
Mickael Ruau's insight:
Pour s’en prémunir, Symantec souligne que « les serveurs SQL ne devraient pas être exécutés avec des privilèges administrateur dans la mesure du possible. Les applications qui utilisent le serveur SQL doivent être corrigées régulièrement et suivre de bonnes pratiques de programmation pour atténuer les vulnérabilités d’injection SQL ». Enfin, l’entreprise conseille de « vérifier la présence de nouveaux comptes utilisateurs et de veiller à ce que les services d’accès à distance soient configurés en toute sécurité ».
Scoop.it!
Unit testing is becoming very popular among .NET projects, but unit testing the Data Access Layer (DAL) still remains a common obstacle. The problem stems from the very nature of databases: they are slow, common, persistent, external, and relational. This conflicts the nature of unit tests, which should be quick, independent, and repeatable. Looking at the criteria for good unit tests (from Pragmatic Unit Testing in C# with NUnit, Andrew Hunt and David Thomas), it's easy to see why.
Scoop.it!
Tutoriel sur une alternative à DBUnit : AssertJ-DB en 5 minutes
Scoop.it!
A few years ago I was one of those developers who write unit tests for my data access code. I was testing everything in isolation, and I was pretty pleased with myself. I honestly thought that I was doing a good job.
Mickael Ruau's insight:
Unit Tests Answers to the Wrong Question
We write tests for our data access code because we want to know that it works as expected. In other words, we want to find the answers to these questions:
Can unit tests help us to find the answers we seek? Well, one of the most fundamental rules of unit testing is that unit tests shouldn’t use external systems such as a database.
Scoop.it!
The importance of doing the right test-driven development is to find a good ratio of what kind of code is to be covered…
Scoop.it!
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 …
|
