PUBLIC MARKS with tags dev & mysql

"The primary online data store for an application is the worst place to take a risk with new technology. If you lose your database or there's corruption, it's a disaster that could be impossible to recover from."

"BitNami MAMPStack greatly simplifies the development and deployment of PHP applications. It includes ready-to-run versions of Apache, MySQL, PHP and phpMyAdmin and required dependencies."

s bases de données, il sera possible d'effectuer des requêtes dynamiques pour récupérer vos données, définir des index pour améliorer les performances, insérer des données et les mettre à jour etc. La grande différence avec MySQL, c'est sans doute l'absence de tables. En effet, vous n'aurez pas à créer un schéma de BDD à respecter. Tout est dynamique, vous pourrez à tout moment créer de nouvelles propriétés, sans pour autant perdre en performances ! Pour comprendre, rien de mieux qu'un exemple pratique. Comparons MongoDB et MySQL sur un exemple simple

Voici quelques pistes qui seront particulièrement utiles à ceux qui développent une application dans un environnement LAMP (Linux, Apache, Php et MySql) ou RoR (Ruby On Rails). Il s’agit en fait des retours d’expérience de sites comme Flickr, Digg

Instant search API in HTML, XML, JavaScript DOM, CSS, Ruby, Rails, Java, C, PHP, Python, ActionScript, Flex, Ant and more!

This is the MySQL GUI Tools Bundle for 5.0. It includes the following products. * MySQL Administrator 1.2 Generally Available (GA) * MySQL Query Browser 1.2 Generally Available (GA) * MySQL Migration Toolkit 1.1 Generally Available (GA)

Comment accéder avec des boucles SPIP à des tables non SPIP dans un squelette SPIP...

SELECT "éEe" = BINARY "eee"

Dealing with characters outside the ASCII range on the web is tough, since text needs to move through so many places without being mangled, from user input, through JavaScript, into and out of PHP and string manipulation functions, into and out of db

Add flexibility to your application with dynamic objects

What I would like to focus on in this article is a different approach, commonly referred to as the Nested Set Model. In the Nested Set Model, we can look at our hierarchy in a new way, not as nodes and lines, but as nested containers.

This article is about tools to discover and monitor the state of your server, so I won't discuss programs for writing queries, designing tables, and the like. I'm also going to focus exclusively on free and open source software.

Some useful PHP classes and snippets.

Polylines on Google Maps tutorial

Google Maps via PHP/Mysql Tutorial

PHP Data Persistence and ORM Tool

cheat sheets (also known as reference cards) that you can print out and keep by your computer. There is a cheat sheet for just about anything and we aim to have the best coverage of cheat sheets available on the web.