FrenchTech SAAS
33.5K views | +3 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
September 20, 2016 4:32 AM
Scoop.it!

BI : Analyse des Données avec Mondrian

Visitez http://liliasfaxi.wix.com/liliasfaxi
No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:32 AM
Scoop.it!

MonoQL - MySQL Admin & MySQL Query Tool

MonoQL is an AJAX web application to manage MySQL databases. MonoQL will provide all major features of phpMyAdmin for MySQL, including database & table design, data browsing & editing, advanced querying & more. MySQL 4+, MySQL 5+ and MySQL 6+ support

No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:28 AM
Scoop.it!

MyWebSQL web based WYSIWYG Database client

MyWebSQL is a web based WYSIWYG Database client written in PHP. It has a simple and intuitive interface with the look and feel of a desktop application, and offers rich features for database management. No installation is needed, just download, extract and you are ready to go. It even has a single file compact version with full functionality, which you can quickly deploy on your server.
Currently MyWebSQL supports working with MySQL, PostgreSQL and SQLite databases.

Mickael Ruau's insight:

Features

  • Multiple Syntax highlighted SQL editors
  • WYSIWYG Table creator/editor
  • Quick Inplace multi-record editing
  • Desktop application look and feel
  • Excellent support for all major browsers
  • Zero configuration installation
  • Multilingual Interface with themes support
  • Supports MySQL 4 and 5, PostgreSQL 8 and 9 and SQLite databases out of the box
  • Import database script, export database, tables or results to multiple formats
  • Multitasking environment so you can perform database management tasks quickly
  • Online up-to-date documentation and help
  • Online demo available to try out
No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:24 AM
Scoop.it!

SchemaSpy

Graphical Database Schema Metadata Browser

 

SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.

It is free software that is distributed under the terms of the Lesser GNU Public License 2.1. Your donations are, however, greatly appreciated.

 

Mickael Ruau's insight:

SchemaSpy is a command line tool. If you're more comfortable with the point-and-click approach then try out Joachim Uhl's SchemaSpyGUI.
SchemaSpy is now in O'Reilly's Java Power Tools book

No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:21 AM
Scoop.it!

SQL Power DQguru: Data Cleansing and MDM Tool

SQL Power DQguru: Data Cleansing and MDM Tool | FrenchTech SAAS | Scoop.it

SQL Power DQguru Community Edition (formerly the SQL Power MatchMaker), sponsored by SQL Power Group Inc, is a cross-platform, open-source data cleansing tool.

No comment yet.
Scooped by Mickael Ruau
September 19, 2016 7:55 AM
Scoop.it!

Docker MySQL official images

Docker MySQL official images | FrenchTech SAAS | Scoop.it

For more information about this image and its history, please see the relevant manifest file (library/mysql). This image is updated via pull requests to the docker-library/official-images GitHub repo.

For detailed information about the virtual/transfer sizes and individual layers of each of the above supported tags, please see the repos/mysql/tag-details.md file in the docker-library/repo-info GitHub repo.

No comment yet.
Scooped by Mickael Ruau
September 19, 2016 3:57 AM
Scoop.it!

Optimized MySQL Docker official images

Optimized MySQL Docker official images | FrenchTech SAAS | Scoop.it

Optimized MySQL Server Docker images. Created, maintained and supported by the MySQL team at Oracle

No comment yet.
Scooped by Mickael Ruau
September 15, 2016 6:56 AM
Scoop.it!

Tout ce que vous devez savoir sur les Big Data

Tout ce que vous devez savoir sur les Big Data | FrenchTech SAAS | Scoop.it
Le but de ce tutoriel est de vous apprendre les bases du Big Data en vous présentant les avantages et les inconvénients de ce concept
No comment yet.
Rescooped by Mickael Ruau from Technology in Business Today
September 15, 2016 3:09 AM
Scoop.it!

How Agriculture is reinventing itself through Data and Biotechnologies

How Agriculture is reinventing itself through Data and Biotechnologies | FrenchTech SAAS | Scoop.it
Agriculture is facing many challenges ranging from environmental footprint to population growth and search for transparency from the consumers’ perspective. Today, it is transforming thanks to data analytic tools and progress made in biotechnologies.

Via TechinBiz
No comment yet.
Scooped by Mickael Ruau
September 14, 2016 4:30 AM
Scoop.it!

Chp3 - Modélisation Multidimensionnelle

Visitez http://liliasfaxi.wix.com/liliasfaxi
No comment yet.
Scooped by Mickael Ruau
September 12, 2016 4:29 AM
Scoop.it!

Chp1 - Introduction à l'Informatique Décisionnelle

Visitez http://liliasfaxi.wix.com/liliasfaxi
No comment yet.
Scooped by Mickael Ruau
September 12, 2016 12:58 AM
Scoop.it!

Utiliser le nested set (arbre par représentation intervallaire) avec doctrine et symfony

Utiliser le nested set (arbre par représentation intervallaire) avec doctrine et symfony | FrenchTech SAAS | Scoop.it
Je vais ici vous expliquer comment utiliser le nestedset pour créer un système de catégorie gérant les parents et enfants sur une infinité de niveaux.

La première étape est de comprendre le principe de gestion des arbres par représentation intervallaire.

Bon, vous avez pris le temps de lire l’article présenté ci-dessus on passe maintenant à la pratique avec symfony et doctrine.

L’idée ici est de créer un système de catégories et de sous catégories sans limitation de niveaux
No comment yet.
Scooped by Mickael Ruau
September 8, 2016 3:58 PM
Scoop.it!

In defence of SQL | Seldo.Com Blog

In defence of SQL | Seldo.Com Blog | FrenchTech SAAS | Scoop.it
If this title does not interest you, here are some alternative, linkbait titles:

Why ORM is the Dumbest Idea Ever
Why NoSQL is a Terrible Idea
OMADS: the future of data storage
Why SQL Will Eventually Conquer The World
No comment yet.
Scooped by Mickael Ruau
September 20, 2016 1:45 AM
Scoop.it!

Official phpMyAdmin Docker image

Official phpMyAdmin Docker image | FrenchTech SAAS | Scoop.it

Run phpMyAdmin with Alpine, supervisor, nginx and PHP FPM.

 

All following examples will bring you phpMyAdmin on http://localhost:8080
where you can enjoy your happy MySQL administration.

 

No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:30 AM
Scoop.it!

SIDU Database web GUI

SIDU is a FREE database web GUI written in PHP. Handy and powerful for MySQL + PostgreSQL + SQLite + CUBRID. SIDU is simple and easy DB tool to use! SIDU has all features you need for database admin and web development. It's a great DB admin tool! No installation need. Best database front-end web based tools, cross platform looking no further

Mickael Ruau's insight:
Features
  • SIDU works via web browsers for MySQL, Postgres and SQLite
  • SIDU works on any OS platform with any browsers
  • SIDU can group objects eg tables by first x chars of table names
  • Data result can be sorted in 1 or 2 columns
  • Connect to mulitple servers locally and remotely, run multiple SIDU at same time
  • Connect protected by SIDU firewall
  • Connect in quick mode or from saved file
  • Object: create, drop, empty, export, analyze, change engine, optimize, ... at one click for bulk tables, etc
  • 3 types of running SQL with SIDU
  • Table data: easy filter, hide columns etc.
  • Table data: drag resize column grid
  • Table data: backup 5 rows before updated or deleted
  • Add multiple new data rows, or edit data, and then save at one click
No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:25 AM
Scoop.it!

Project Mogwai - ERDesignerNG

Project Mogwai - ERDesignerNG | FrenchTech SAAS | Scoop.it

The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. The only difference is that it is Open Source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation.

 

Mickael Ruau's insight:

ERDesigner NG

  • is based on Java and can be run on Windows,Unix and Mac systems
  • is distributed as a zip/tar/installer file or can be launched by WebStart
  • has a powerful WYSIWYG editor for physical database design
  • supports 2D and 3D database modeling, browsing and design
  • generates true 3D anaglyphic views from your database structure
  • handles tables, relations, views, domains, custom types, indexes and comments
  • supports a central repository for all models ( Model Repository )
  • supports subject areas
  • supports MySQL, Oracle, Microsoft SQLServer, PostgreSQL, H2 and HypersonicSQL
  • creates the SQL DDL statements for your database schema
  • supports forward and reverse engineering
  • has an integrated schema version control system
  • can generate schema migration scripts for every change
  • stores the database definition as XML files for further processing
  • can export the database schema as GIF, BMP, JPEG or SVG files
  • has an integrated reverse engineering module for existing schemas
  • has a build in schema compare feature
  • can generate schema documentation as PDF, HTML, RTF and other formats
  • supports schema conversion between different dialects
  • analyzes the database model for common problems
  • generates OpenXava applications
  • it is based on GPL license
  • support is available by authors and newsgroups
No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:22 AM
Scoop.it!

SQL Power Architect: Data Modeling & Profiling Tool

SQL Power Architect: Data Modeling & Profiling Tool | FrenchTech SAAS | Scoop.it

The SQL Power Architect Community Edition is a cross-platform, open-source data modeling tool with a GUI and an embeddable API.

No comment yet.
Scooped by Mickael Ruau
September 19, 2016 8:20 AM
Scoop.it!

SQL Power Wabit Community Edition

SQL Power Wabit Community Edition | FrenchTech SAAS | Scoop.it

SQL Power Wabit Community Edition, sponsored by SQL Power Group Inc, is a cross-platform, open-source ad-hoc reporting tool with a GUI and an embeddable API.

For information about the Community Edition or Enterprise Edition of SQL Power Wabit, please visit http://www.sqlpower.ca/page/wabit

 
No comment yet.
Scooped by Mickael Ruau
September 19, 2016 4:33 AM
Scoop.it!

Le processus ETL (Extraction, Transformation, Chargement)

Présentation général des étapes du processus ETL (Extract,Transform, Load) d'un projet décisionnel. ETL, acronyme de Extraction, Transformation, Loading, est u…
No comment yet.
Scooped by Mickael Ruau
September 16, 2016 4:36 AM
Scoop.it!

Dataviz de la dataviz

Processus de création d'une dataviz étape par étape
No comment yet.
Scooped by Mickael Ruau
September 15, 2016 4:30 AM
Scoop.it!

Conception et Réalisation d'un Data Warehouse

Mémoire de fin d’études Pour l’obtention du diplôme d’Ingénieur d’Etat en Informatique Option : Systèmes d’information …
No comment yet.
Scooped by Mickael Ruau
September 14, 2016 7:59 AM
Scoop.it!

Les petits papiers de SQLPro - Représentation intervallaire des arborescences

Les petits papiers de SQLPro - Représentation intervallaire des arborescences | FrenchTech SAAS | Scoop.it
Le langage de requête SQL, décrit en long en large et en travers... Arbres et arborescense.
No comment yet.
Scooped by Mickael Ruau
September 13, 2016 4:29 AM
Scoop.it!

Chp2 - Les Entrepôts de Données

Visitez http://liliasfaxi.wix.com/liliasfaxi
No comment yet.
Scooped by Mickael Ruau
September 12, 2016 1:55 AM
Scoop.it!

Requêtes récursives et CTE (Common Table Expression - Expression de Table)

Requêtes récursives et CTE (Common Table Expression - Expression de Table) | FrenchTech SAAS | Scoop.it
SQL est-il un langage récursif ? Réponse : OUI ! Grâce à la CTE…
No comment yet.
Scooped by Mickael Ruau
September 9, 2016 8:03 AM
Scoop.it!

Tutoriel Vidéo Mysql Représentation intervallaire

Tutoriel Vidéo Mysql Représentation intervallaire | FrenchTech SAAS | Scoop.it
No comment yet.