sql
Get flash to fully experience Pearltrees
Firefox 3 History » SANS Computer Forensics, Investigation, and
Analysis of a browser history almost always comes up, no matter what is being investigated. And despite Firefox being one of the most popular browsers currently used there aren't many tools out there that can read and display browser history (at least in a human readable format). There are tools out there, such as f3e from FirefoxForensics.com ( firefoxforensics.com ) however that tool, just as others that I've found, is only distrubuted as an EXE, running on Windows (and no source code is provided). Traditionally Firefox stored the history file as a Mork file format , which could be easily read using any standard editor. The new version, that is version 3 which has been out for quite some time now, uses a different method of storing user history.
Now we have some documentation available under the wikis. Thanks to fairfaxwatershed for these docs. Manage all your sqlite databases using this lightweight extension for firefox, thunderbird, seamonkey, songbird, komodo etc. ( See the complete list of supported applications ) This extension will be useful to developers who want to create and play with sqlite databases.
sqlite-manager - Google Code
Non, MySQL applique une optimisation spécifique qui constitue une "extension de la norme" et est donc en contradiction avec celle-ci. Supposons par exemple que vous ayez une table Vendeurs ( IDvendeur , Nom, Prenom) et une table Commandes ( IDcomm , Montant, IDvendeur). Si vous souhaitez calculer le chiffre d'affaires de chaque vendeur, avec son nom et prénom, la requête normalisée serait celle-ci : SELECT V.IDvendeur, V.Nom, V.Prenom, SUM (C.Montant) AS CA FROM Vendeurs V INNER JOIN Commandes C ON V.IDvendeur = C.IDvendeur GROUP BY V.IDvendeur, V.Nom, V.Prenom MySQL permet d'écrire la requête ainsi, ce qui serait refusé par tout autre SGBD : SELECT V.IDvendeur, V.Nom, V.Prenom, SUM (C.Montant) AS CA FROM Vendeurs V INNER JOIN Commandes C ON V.IDvendeur = C.IDvendeur GROUP BY V.IDvendeur
FAQ MySQL - Fonctionnalités et compatibilité avec la norme SQL