FrenchTech SAAS
33.5K views | +0 today
FrenchTech SAAS
Les news de l'univers SAAS et FrenchTech
Curated by Mickael Ruau
Your new post is loading...
Your new post is loading...

Popular Tags

Scooped by Mickael Ruau
April 17, 2013 3:48 AM
Scoop.it!

Soundex - Wikipédia

Soundex est un algorithme phonétique d'indexation de noms par leur prononciation en anglais britannique. L'objectif basique est que les noms ayant la même prononciation soient codés avec la même chaîne de manière à pouvoir trouver une correspondance entre eux malgré des différences mineures d'écriture. Soundex est le plus largement connu des algorithmes phonétiques et est souvent utilisé incorrectement comme synonyme de « algorithme phonétique ».

Soundex a été conçu par Robert Russell et Margaret Odell et breveté en 1918 et 1922 (US patent 1,261,167 et 1,435,663). Une variante nommée American Soundex a été utilisée dans les années 1930 pour une analyse rétrospective des recensements américains entre 1890 et 1920.

Le code Soundex s'est fait connaître dans les années 1960 lorsqu'il est devenu le sujet de nombreux articles dans les communiqués et le journal de l'Association for Computing Machinery, et tout spécialement décrit par Donald Knuth dans son magnum opus, The Art of Computer Programming.

No comment yet.
Scooped by Mickael Ruau
April 17, 2013 3:47 AM
Scoop.it!

Making use of procedure analyse()

Making use of procedure analyse() | FrenchTech SAAS | Scoop.it

SELECT Field0[,Field1,Field2,...] FROM TABLE PROCEDURE ANALYSE() is a nice tool to find out more about your table’s columns.

Still, it could be improved in a lot of ways, and the stored procedure below is a starting point. It makes use of procedure analyse (though with ‘SELECT * FROM’), and modifies it’s output to include the actual column datatype and the total number of rows of the table.

No comment yet.
Scooped by Mickael Ruau
April 17, 2013 3:42 AM
Scoop.it!

PHP / mySQL > mySQL - Soundex, ou comment faire des recherches en souplesse [ L'éditeur JavaScript ]

L'éditeur JavaScript vous propose des scripts à éditer ainsi que des astuces, des cours, des livres, des forums et services gratuits et payants pour webmasters !
No comment yet.
Scooped by Mickael Ruau
April 16, 2013 11:40 AM
Scoop.it!

PHP: Opérateurs sur les bits - Manual

No comment yet.
Scooped by Mickael Ruau
April 16, 2013 11:38 AM
Scoop.it!

Manipuler les masques de bits

Manipuler les masques de bits | FrenchTech SAAS | Scoop.it

Certains champs, surtout dans les tables système de MS-SQL ou de Sybase ASE, stockent des informations sous forme de masque de bits. Souvent l'utilisateur rechigne à utiliser ce genre de champ par méconnaissance. Ce petit document a pour but de vous familiariser avec ce type de données. Vous approuverez rapidement qu'un masque de bits n'est pas si compliqué qu'il en a l'air…

 

 

Mickael Ruau's insight:

Un moyen de stocker de l'information riche et très économe en espace.

No comment yet.
Scooped by Mickael Ruau
April 16, 2013 2:59 AM
Scoop.it!

Access MySQL without Password - Kevin van Zonneveld

Access MySQL without Password - Kevin van Zonneveld | FrenchTech SAAS | Scoop.it
Access MySQL without Password Mar 21st, 2010 | Comments If you want to do command-line MySQL administration like restoring databases
or dumping …
Mickael Ruau's insight:

What a lot of people don’t know is that there is an account that’s used by debian related systems to restart the service, perform checks, etc.

The account is called debian-sys-maint, it’s credentials are stored in /etc/mysql/debian.cnf and if you have root access on a database server’s shell you’re in business. You can either look up the account, or tell mysql to do it for you:

1 mysql --defaults-file=/etc/mysql/debian.cnf
No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:22 AM
Scoop.it!

The Etsy Shard Architecture: Starts With S and Ends With Hard

Overview of the etsy shard architecture
No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:20 AM
Scoop.it!

MySQL vs. NoSQL and NewSQL - survey results

The results of 451 Research’s survey into the competitive dynamic between MySQL, NoSQL, and New SQL database technologies.

No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:19 AM
Scoop.it!

Comparing SQL Server and MySQL Functions - Database Journal

Comparing SQL Server and MySQL Functions - Database Journal | FrenchTech SAAS | Scoop.it
Comparing SQL Server and MySQL Functions
Database Journal
This article is the second part in a series examining some of the challenges in porting your databases between MS SQL Server and MySQL.
No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:18 AM
Scoop.it!

New Query Optimizer Features in MySQL 5.6 - Database Journal

New Query Optimizer Features in MySQL 5.6 - Database Journal | FrenchTech SAAS | Scoop.it
New Query Optimizer Features in MySQL 5.6
Database Journal
One of MySQL 5.6's many optimizations apply to the processing of queries that contain subqueries.
No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:17 AM
Scoop.it!

Export MySQL As CSV

Export MySQL As CSV | FrenchTech SAAS | Scoop.it
Export MySQL As CSV is simple code available here to let export your database as csv, So its no more difficult to code in php
No comment yet.
Scooped by Mickael Ruau
April 12, 2013 6:56 AM
Scoop.it!

Vérifier et optimiser la configuration de MySQL - La Ferme du web

Vérifier et optimiser la configuration de MySQL - La Ferme du web | FrenchTech SAAS | Scoop.it
Tuning Timer est une ressource qui va permettre de vérifier et d'optimiser, au mieux, la configuration de son serveur MySQL.
No comment yet.
Scooped by Mickael Ruau
April 17, 2013 3:48 AM
Scoop.it!

Extending procedure_analyse

Extending procedure_analyse | FrenchTech SAAS | Scoop.it

My previous post explored a stored procedure that extended procedure_analyse with the intent of helping DBAs optimize table structure.

Here’s an improved version.

No comment yet.
Scooped by Mickael Ruau
April 17, 2013 3:45 AM
Scoop.it!

Planet MySQL - Archives - SOUNDEX(), triggers, and stored procedures

No comment yet.
Scooped by Mickael Ruau
April 16, 2013 11:40 AM
Scoop.it!

Opérations booléennes et logique binaire en PHP

Opérations booléennes et logique binaire en PHP | FrenchTech SAAS | Scoop.it
Opérations booléennes et logique binaire en PHP
No comment yet.
Scooped by Mickael Ruau
April 16, 2013 11:38 AM
Scoop.it!

Opérateurs bit à bit

Opérateurs bit à bit | FrenchTech SAAS | Scoop.it
Opérateurs binaires en C
No comment yet.
Scooped by Mickael Ruau
April 16, 2013 11:35 AM
Scoop.it!

How to Store and Retrieve Binary Data Using PHP and MySQL | The Benefits of Storing Binary Data in a Database | Peachpit

How to Store and Retrieve Binary Data Using PHP and MySQL | The Benefits of Storing Binary Data in a Database | Peachpit | FrenchTech SAAS | Scoop.it
It isn’t too long into your web development career before you get to a point where you can store and retrieve plain-text data in your sleep. Being strong in this area is important, as plain text is the most commonly stored data format.
No comment yet.
Scooped by Mickael Ruau
April 16, 2013 3:00 AM
Scoop.it!

Improve MySQL Insert Performance - Kevin van Zonneveld

Improve MySQL Insert Performance Mar 31st, 2009 | Comments Sometimes MySQL needs to work hard. I’ve been working on an import script that …
No comment yet.
Scooped by Mickael Ruau
April 16, 2013 2:55 AM
Scoop.it!

Find duplicate input with MySQL - Kevin van Zonneveld

Find duplicate input with MySQL - Kevin van Zonneveld | FrenchTech SAAS | Scoop.it
Find duplicate input with MySQL Mar 4th, 2013 | Comments Back to basic, let’s brush up on some SQL : ) At my company we have employees …
No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:21 AM
Scoop.it!

My sql ssd-mysqluc-2012

SSD introduction and it’s usage with mysql

No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:20 AM
Scoop.it!

HTTP, JSON, JavaScript, Map&Reduce built-in to MySQL

HTTP, JSON, JavaScript, Map&Reduce built in to MySQL - make it happen, today. See how a MySQL Server plugin be developed to built all this into MySQL. A new direct wire between MySQL and client-side JavaScript is created.

No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:18 AM
Scoop.it!

Facebook releases Linkbench MySQL benchmark - Inquirer

Facebook releases Linkbench MySQL benchmark - Inquirer | FrenchTech SAAS | Scoop.it
Moneycontrol.com
Facebook releases Linkbench MySQL benchmark
Inquirer
What is particularly interesting about Facebook's graph benchmark is that it reveals the firm is still using the MySQL database.
No comment yet.
Scooped by Mickael Ruau
April 13, 2013 11:18 AM
Scoop.it!

Why MySQL Performance at Low Concurrency is Important

Why MySQL Performance at Low Concurrency is Important | FrenchTech SAAS | Scoop.it
A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important. This time I want to target an opposite question: why MySQL performance at low concurrency is important for you.
No comment yet.
Scooped by Mickael Ruau
April 12, 2013 7:03 AM
Scoop.it!

Doxygen : Comment documenter un projet de développement informatique ? - Divers - Tutoriels - Informatix

Doxygen : Comment documenter un projet de développement informatique ? - Divers - Tutoriels - Informatix | FrenchTech SAAS | Scoop.it
Générer une documentation automatiquement pour plusieurs langages de programmation.
No comment yet.