MySQL Workbench: Créez vos bases de données MySQL graphiquement. MySQL Workbench est LE logiciel open-source à avoir si vous êtes développeur web ou si vous gérez des bases de données MySQL.
Basé sur le Framework .Net 2.0, le logiciel permet de créer vos bases de données et tables MySQL à l'aide de diagrammes EER (Extended Entity-Relationship), de façon visuelle. Vous pourrez directement générer le code SQL à partir de vos diagrammes ou les exporter en format PNG pour alimenter votre cahier des charges par exemple. Il s'agit du successeur de DBDesigner 4 de fabForce. Et comme ce dernier il reprend les mêmes fonctionnalités en améliorant à la fois l'intuitivité, l'efficacité et la qualité du code généré: Modélisation visuelle des donnéesReverse Engineering (Création du diagramme à partir d'une BDD MySQL)Génération du code SQL de création des tables etc.Synchronisation du schéma MySQL: BDD <-> DiagrammeExport en image, PDFCompatibilité avec DBDesigner4Diagrammes très propres et designs !
Bref, un logiciel à avoir ! Télécharger MySQL Workbench. Database Design Create Tables and Relationships with SQL. This post explains how to design typical relationaships database for socialmedia web application.
Today I'm presenting my labs.9lessons application database relations design and SQL with diagrams. I hope you like this post. labs.9lessons.info Data Modeling Design Here you can see the five tables between relation flow user, friends, updates, comments and vote. This following image generated by using Mysql Workbench tool. Here users table relation with three tables friends, updates and comments. users table Parent table contains all users data, while registration data storing in this table.
CREATE TABLE `users` ( `user_id` INT NOT NULL primary key AUTO_INCREMENT , `username` VARCHAR(45) NULL unique, `password` VARCHAR(45) NULL , `email` VARCHAR(45) NULL , `twitter_token` VARCHAR(99) NULL , `twitter_token_secret` VARCHAR(99) NULL ); Data storing like this here password stored in encrypted formate tutorial link. friends table Contains friend relation data. Friends table data. updates table. 25+ Alternative & Open Source Database Engines. Almost every web developer has a favorite database that he/she feels comfortable working with as all the tricks & gimmicks are already experienced.
It can be one of the popular databases below: or even simpler ones like XML, text, etc. It is understandable why these databases are frequently used; they are well-documented, have a community behind them, integrated with most popular CMSs', easy-to-use, offered by most of the hosting companies ,etc..
But there are also many other databases which are getting popular day-by-day & may have advantages over what you're already using. Here are 25+ open source alternative databases that you may consider using in your next project: MongoDB It is an open source, high-performance, scalable, schema-free & document-oriented (JSON-like data schemas) database. There are ready to use drivers for most popular programming languages like PHP,Python, Perl, Ruby, JavaScript, C++ + more.
Hypertable Apache CouchDB Neo4j Neo4j offer a massive scalability. Riak Memcached Redis.