List all table constraints (PK, UK, FK, Check and Default) in SQL Server

Rédigé par Sozezzo - - Aucun commentaire

 

Query lists all table (and view) constraints - primary keys, unique key constraints and indexes, foreign keys and check, default constraints, and isDisabled.

 

Columns

  • SchemaName
  • Name - table or view schema and name
  • object_type - object type:
    • Table
    • View
  • constraint_type - type of constraint:
    • Primary key
    • Unique key
    • Foregin key
    • Check constraint
    • Default constraint
  • constraint_name - name of constraint or index
  • details - details of this constraint:
    • Primary key - PK column(s)
    • Unique key - UK column(s)
    • Foregin key - parent table name
    • Check constraint - check definition
    • Default constraint - column name and default value definition
  • IsDisable – it is disabled or not.

 


SELECT SchemaName
     ,[Name]
     ,object_type
     ,constraint_type
     ,constraint_name
     ,details
     ,IsDisabled
FROM (
     -- Index
     SELECT SCHEMA_NAME(t.schema_id) AS SchemaName
         ,t.[name] AS [Name]
         ,CASE
             WHEN t.[type] = 'U'
                 THEN 'Table'
             WHEN t.[type] = 'V'
                 THEN 'View'
             END AS [object_type]
         ,CASE
             WHEN c.[type] = 'PK'
                 THEN 'Primary key'
             WHEN c.[type] = 'UQ'
                 THEN 'Unique constraint'
             WHEN i.[type] = 1
                 THEN 'Unique clustered index'
             WHEN i.type = 2
                 THEN 'Unique index'
             END AS constraint_type
         ,ISNULL(c.[name], i.[name]) AS constraint_name
         ,SUBSTRING(column_names, 1, LEN(column_names) - 1) AS [details]
         ,i.is_disabled AS IsDisabled
     FROM sys.objects t
     LEFT OUTER JOIN sys.indexes i ON t.object_id = i.object_id
     LEFT OUTER JOIN sys.key_constraints c ON i.object_id = c.parent_object_id
         AND i.index_id = c.unique_index_id
     CROSS APPLY (
         SELECT col.[name] + ', '
         FROM sys.index_columns ic
         INNER JOIN sys.columns col ON ic.object_id = col.object_id
             AND ic.column_id = col.column_id
         WHERE ic.object_id = t.object_id
             AND ic.index_id = i.index_id
         ORDER BY col.column_id
         FOR XML PATH('')
         ) D(column_names)
     WHERE is_unique = 1
         AND t.is_ms_shipped <> 1
    
     UNION ALL
    
     -- Foreign key
     SELECT SCHEMA_NAME(fk_tab.schema_id)
         ,fk_tab.NAME AS foreign_table
         ,'Table'
         ,'Foreign key'
         ,fk.NAME AS fk_constraint_name
         ,SCHEMA_NAME(pk_tab.schema_id) + '.' + pk_tab.NAME
         ,fk.is_disabled AS IsDisabled
     FROM sys.foreign_keys fk
     INNER JOIN sys.tables fk_tab ON fk_tab.object_id = fk.parent_object_id
     INNER JOIN sys.tables pk_tab ON pk_tab.object_id = fk.referenced_object_id
     INNER JOIN sys.foreign_key_columns fk_cols ON fk_cols.constraint_object_id = fk.object_id
    
     UNION ALL
    
     -- Check constraint
     SELECT SCHEMA_NAME(t.schema_id)
         ,t.[name]
         ,'Table'
         ,'Check constraint'
         ,con.[name] AS constraint_name
         ,con.[definition]
         ,con.is_disabled AS IsDisabled
     FROM sys.check_constraints con
     LEFT OUTER JOIN sys.objects t ON con.parent_object_id = t.object_id
     LEFT OUTER JOIN sys.all_columns col ON con.parent_column_id = col.column_id
         AND con.parent_object_id = col.object_id
    
     UNION ALL
    
     -- Default constraint
     SELECT SCHEMA_NAME(t.schema_id)
         ,t.[name]
         ,'Table'
         ,'Default constraint'
         ,con.[name]
         ,col.[name] + ' = ' + con.[definition]
         ,0 AS IsDisabled
     FROM sys.default_constraints con
     LEFT OUTER JOIN sys.objects t ON con.parent_object_id = t.object_id
     LEFT OUTER JOIN sys.all_columns col ON con.parent_column_id = col.column_id
         AND con.parent_object_id = col.object_id
     ) a
ORDER BY SchemaName
     ,[Name]
     ,constraint_type
     ,constraint_name;

 

 

Script to set nocheck on foreign key constaints


-- Script to set nocheck on foreign key constaints
DECLARE @SchemaName VARCHAR(250) = NULL; -- 'dbo';
DECLARE @TableName VARCHAR(250) = NULL;  -- 'Client';
DECLARE @IDKey INT;
DECLARE @SqlScript VARCHAR(max);

SET NOCOUNT ON;

DROP TABLE IF EXISTS #tb;

-- Foreign key
SELECT ROW_NUMBER() OVER(ORDER BY SCHEMA_NAME(fk_tab.schema_id), fk_tab.NAME) AS [IDKey],
        --SCHEMA_NAME(fk_tab.schema_id),
        --fk_tab.NAME AS foreign_table,
        --fk.NAME AS fk_constraint_name,
        --SCHEMA_NAME(pk_tab.schema_id) + '.' + pk_tab.NAME,
        --fk.is_disabled AS IsDisabled,
        'ALTER TABLE [' + SCHEMA_NAME(fk_tab.schema_id) + '].[' + fk_tab.NAME + '] NOCHECK CONSTRAINT ' + fk.NAME + ';' AS SqlScript
INTO #tb
FROM sys.foreign_keys fk
      INNER JOIN sys.tables fk_tab ON fk_tab.object_id = fk.parent_object_id
      INNER JOIN sys.tables pk_tab ON pk_tab.object_id = fk.referenced_object_id
      INNER JOIN sys.foreign_key_columns fk_cols ON fk_cols.constraint_object_id = fk.object_id
WHERE fk.is_disabled = 0
AND (@SchemaName IS NULL OR @SchemaName = SCHEMA_NAME(fk_tab.schema_id))
AND (@TableName IS NULL OR @TableName = fk_tab.NAME)
;

while ((SELECT COUNT(*) FROM #tb) > 0 )
BEGIN
     SELECT top 1 @IDKey=IDKey, @SqlScript = SqlScript FROM #tb ORDER BY IDKey;
     DELETE FROM #tb WHERE @IDKey=IDKey;
     PRINT @SqlScript;
     --EXEC(@SqlScript);
END;

Change SID in Windows Server

Rédigé par Sozezzo - - Aucun commentaire

Why do I need to change it? Joining VM to the domain when we clone VMs...

A SID, short for security identifier, is a number used to identify user, group, and computer accounts in Windows.
SIDs are created when the account is first created in Windows and no two SIDs on a computer are ever the same.
The term security ID is sometimes used in place of the SID or security identifier.

Attention : Before start, make sure you have the “Product Key”, don't have rollback !

Start by check SID with :  whoami /all

image

 

Open folder :


%SystemRoot%\System32\Sysprep\

clip_image004

clip_image006

clip_image008

clip_image010

clip_image012

clip_image014

sources : https://www.lifewire.com/what-is-an-sid-number-2626005

https://blogs.technet.microsoft.com/markrussinovich/2009/11/03/the-machine-sid-duplication-myth-and-why-sysprep-matters/

https://kb.vmware.com/s/article/1000528

Javascript libraries

Rédigé par Sozezzo - - Aucun commentaire

A collection of awesome browser-side JavaScript libraries, resources and shiny things.

Package Managers

Host the javascript libraries and provide tools for fetching and packaging them.

  • npm - npm is the package manager for javascript.
  • Bower - A package manager for the web.
  • component - Client package management for building better web applications.
  • spm - Brand new static package manager.
  • jam - A package manager using a browser-focused and RequireJS compatible repository.
  • jspm - Frictionless browser package management.
  • Ender - The no-library library.
  • volo - Create front end projects from templates, add dependencies, and automate the resulting projects.
  • Duo - Next-generation package manager that blends the best ideas from Component, Browserify and Go to make organizing and writing front-end code quick and painless.
  • yarn - Fast, reliable, and secure dependency management.

Loaders

Module or loading system for JavaScript.

  • RequireJS - A file and module loader for JavaScript.
  • browserify - Browser-side require() the node.js way.
  • SeaJS - A Module Loader for the Web.
  • HeadJS - The only script in your HEAD.
  • curl - A small, fast, extensible module loader that handles AMD, CommonJS Modules/1.1, CSS, HTML/text, and legacy scripts.
  • lazyload - Tiny, dependency-free async JavaScript and CSS loader.
  • script.js - Asyncronous JavaScript loader and dependency manager.
  • systemjs - AMD, CJS & ES6 spec-compliant module loader.
  • LodJS - Module loader based on AMD
  • ESL - Module loader browser first, support lazy define and AMD.
  • modulejs - Lightweight JavaScript module system.

Bundlers

  • browserify - Browserify lets you require('modules') in the browser by bundling up all of your dependencies.
  • webpack - Packs CommonJs/AMD modules for the browser.
  • Rollup - Next-generation ES6 module bundler.
  • Brunch - Fast front-end web app build tool with simple declarative config.

Testing Frameworks

Frameworks

  • mocha - Simple, flexible, fun javascript test framework for node.js & the browser.
  • jasmine - DOM-less simple JavaScript testing framework.
  • qunit - An easy-to-use JavaScript Unit Testing framework.
  • jest - Painless Javascript Unit Testing.
  • prova - Node & Browser test runner based on Tape and Browserify
  • DalekJS - Automated cross browser functional testing with JavaScript
  • Protractor - Protractor is an end-to-end test framework for AngularJS applications.
  • tape - Tap-producing test harness for node and browsers.
  • TestCafe - Automated browser testing for the modern web development stack.
  • ava - 🚀 Futuristic JavaScript test runner

Assertion

  • chai - BDD / TDD assertion framework for node.js and the browser that can be paired with any testing framework.
  • Enzyme - Enzyme is a JavaScript Testing utility for React that makes it easier to assert, manipulate, and traverse your React Components' output.
  • Sinon.JS - Test spies, stubs, and mocks for JavaScript.
  • expect.js - Minimalistic BDD-style assertions for Node.JS and the browser.

Coverage

  • istanbul - Yet another JS code coverage tool.
  • blanket - A simple code coverage library for javascript. Designed to be easy to install and use, for both browser and nodejs.
  • JSCover - JSCover is a tool that measures code coverage for JavaScript programs.

Runner

  • phantomjs - Scriptable Headless WebKit.
  • slimerjs - A PhantomJS-like tool running Gecko.
  • casperjs - Navigation scripting & testing utility for PhantomJS and SlimerJS.
  • zombie - Insanely fast, full-stack, headless browser testing using node.js.
  • totoro - A simple and stable cross-browser testing tool.
  • karma - Spectacular Test Runner for JavaScript.
  • nightwatch - UI automated testing framework based on node.js and selenium webdriver.
  • intern - A next-generation code testing stack for JavaScript.
  • yolpo - A statement-by-statement javascript interpreter in the browser.

QA Tools

  • JSHint - JSHint is a tool that helps to detect errors and potential problems in your JavaScript code.
  • jscs - JavaScript Code Style checker.
  • jsfmt - For formatting, searching, and rewriting JavaScript.
  • jsinspect - Detect copy-pasted and structurally similar code.
  • buddy.js - Magic number detection for JavaScript.
  • ESLint - A fully pluggable tool for identifying and reporting on patterns in JavaScript.
  • JSLint - High-standards, strict & opinionated code quality tool, aiming to keep only good parts of the language.

MVC Frameworks and Libraries

  • angular.js - HTML enhanced for web apps.
  • aurelia - A Javascript client framework for mobile, desktop and web.
  • backbone - Give your JS App some Backbone with Models, Views, Collections, and Events.
  • batman.js - The best JavaScript framework for Rails developers.
  • ember.js - A JavaScript framework for creating ambitious web applications.
  • meteor - An ultra-simple, database-everywhere, data-on-the-wire, pure-Javascript web framework.
  • ractive - Next-generation DOM manipulation.
  • vue - Intuitive, fast & composable MVVM for building interactive interfaces.
  • knockout - Knockout makes it easier to create rich, responsive UIs with JavaScript.
  • spine - Lightweight MVC library for building JavaScript applications.
  • espresso.js - A minimal javascript library for crafting user interfaces.
  • canjs - Can do JS, better, faster, easier.
  • react - A library for building user interfaces. It's declarative, efficient, and extremely flexible. Works with a Virtual DOM.
  • hyperapp - 1kb JavaScript library for building frontend applications.
  • preact - Fast 3kb React alternative with the same ES6 API. Components & Virtual DOM.
  • nativescript - Build truly native cross-platform iOS and Android apps with JavaScript
  • react-native - A framework for building native apps with React.
  • riot - React-like library, but with very small size.
  • thorax - Strengthening your Backbone.
  • chaplin - An architecture for JavaScript applications using the Backbone.js library.
  • marionette - A composite application library for Backbone.js that aims to simplify the construction of large scale JavaScript applications.
  • ripple - A tiny foundation for building reactive views.
  • rivets - Lightweight and powerful data binding + templating solution.
  • derby - MVC framework making it easy to write realtime, collaborative applications that run in both Node.js and browsers.
  • way.js - Simple, lightweight, persistent two-way databinding.
  • mithril.js - Mithril is a client-side MVC framework (Light-weight, Robust, Fast).
  • jsblocks - jsblocks is better MV-ish framework.
  • LiquidLava - Transparent MVC framework for building user interfaces.
  • feathers - A minimalist real-time JavaScript framework for tomorrow's apps.
  • Keo - Functional stateless React components with Shadow DOM support.

Node-Powered CMS Frameworks

  • KeystoneJS - powerful CMS and web app framework
  • Reaction Commerce - reactive CMS, real-time architecture and design
  • Ghost - simple, powerful publishing platform
  • Apostrophe - CMS with content editing and essential services
  • We.js - framework for real time apps, sites or blogs
  • Hatch.js - CMS platform with social features.
  • TaracotJS - fast and minimalist CMS based on Node.js.
  • Nodizecms - CMS for CoffeeScript lovers
  • Cody - CMS with WSYWYG editor
  • PencilBlue - CMS and blogging platform

Templating Engines

Templating engines allow you to perform string interpolation.

  • mustache.js - Minimal templating with {{mustaches}} in JavaScript.
  • handlebars.js - An extension to the Mustache templating language.
  • hogan.js - A compiler for the Mustache templating language.
  • doT - The fastest + concise javascript template engine for nodejs and browsers.
  • dustjs - Asynchronous templates for the browser and node.js.
  • eco - Embedded CoffeeScript templates.
  • JavaScript-Templates - < 1KB lightweight, fast & powerful JavaScript templating engine with zero dependencies.
  • t.js - A tiny javascript templating framework in ~400 bytes gzipped.
  • Jade - Robust, elegant, feature rich template engine for nodejs.
  • EJS - Effective JavaScript templating.
  • xtemplate - eXtensible Template Engine lib for node and the browser
  • marko - A fast, lightweight, HTML-based templating engine for Node.js and the browser with async, streaming, custom tags and CommonJS modules as compiled output.
  • swig - A simple, powerful, and extendable Node.js and browser-based JavaScript template engine.

Articles and Posts

Data Visualization

Data visualization tools for the web.

  • d3 - A JavaScript visualization library for HTML and SVG.
    • metrics-graphics - A library optimized for concise, principled data graphics and layouts.
  • pykcharts.js - Well designed d3.js charting without the complexity of d3.js.
  • three.js - JavaScript 3D library.
  • Chart.js - Simple HTML5 Charts using the canvas tag.
  • paper.js - The Swiss Army Knife of Vector Graphics Scripting – Scriptographer ported to JavaScript and the browser, using HTML5 Canvas.
  • fabric.js - Javascript Canvas Library, SVG-to-Canvas (& canvas-to-SVG) Parser.
  • peity - Progressive svg bar, line and pie charts.
  • raphael - JavaScript Vector Library.
  • echarts - Enterprise Charts.
  • vis - Dynamic, browser-based visualization library.
  • two.js - A renderer agnostic two-dimensional drawing api for the web.
  • g.raphael - Charts for Raphaël.
  • sigma.js - A JavaScript library dedicated to graph drawing.
  • arbor - A graph visualization library using web workers and jQuery.
  • cubism - A D3 plugin for visualizing time series.
  • dc.js - Multi-Dimensional charting built to work natively with crossfilter rendered with d3.js
  • vega - A visualization grammar.
  • processing.js - Processing.js makes your data visualizations work using web standards and without any plug-ins
  • envisionjs - Dynamic HTML5 visualization.
  • rickshaw - JavaScript toolkit for creating interactive real-time graphs.
  • flot - Attractive JavaScript charts for jQuery.
  • morris.js - Pretty time-series line graphs.
  • nvd3 - Build re-usable charts and chart components for d3.js
  • svg.js - A lightweight library for manipulating and animating SVG.
  • heatmap.js - JavaScript Library for HTML5 canvas based heatmaps.
  • jquery.sparkline - A plugin for the jQuery javascript library to generate small sparkline charts directly in the browser.
  • xCharts - A D3-based library for building custom charts and graphs.
  • trianglify - Low poly style background generator with d3.js
  • d3-cloud - Create word clouds in JavaScript.
  • d4 - A friendly reusable charts DSL for D3.
  • dimple.js - Easy charts for business analytics powered by d3
  • chartist-js - Simple responsive charts.
  • epoch - A general purpose real-time charting library.
  • c3 - D3-based reusable chart library.
  • BabylonJS - A framework for building 3D games with HTML 5 and WebGL.
  • recharts - Redefined chart library built with React and D3
  • GraphicsJS - A lightweight JavaScript graphics library with the intuitive API, based on SVG/VML technology.

There're also some great commercial libraries, like amchart, anychart, plotly, and highchart.

Timeline

  • TimelineJS - A Storytelling Timeline built in JavaScript.
  • timesheet.js - JavaScript library for simple HTML5 & CSS3 time sheets.

Spreadsheet

  • HANDSONTABLE - Handsontable is a JavaScript/HTML5 Spreadsheet Library for Developers

Editors

  • ace - Ace (Ajax.org Cloud9 Editor).
  • CodeMirror - In-browser code editor.
  • esprima - ECMAScript parsing infrastructure for multipurpose analysis.
  • quill - A cross browser rich text editor with an API.
  • medium-editor - Medium.com WYSIWYG editor clone.
  • pen - enjoy live editing (+markdown).
  • jquery-notebook - A simple, clean and elegant text editor. Inspired by the awesomeness of Medium.
  • bootstrap-wysiwyg - Tiny bootstrap-compatible WYSIWYG rich text editor.
  • ckeditor-releases - The best web text editor for everyone.
  • editor - A markdown editor. still on development.
  • EpicEditor - An embeddable JavaScript Markdown editor with split fullscreen editing, live previewing, automatic draft saving, offline support, and more.
  • jsoneditor - A web-based tool to view, edit and format JSON.
  • vim.js - JavaScript port of Vim with a persistent ~/.vimrc
  • Squire - HTML5 rich text editor.
  • TinyMCE - The JavaScript Rich Text editor.
  • trix - A rich text editor for everyday writing. By Basecamp.
  • Trumbowyg - A lightweight and amazing WYSIWYG JavaScript editor.
  • Draft.js - A React framework for building text editors.
  • bootstrap-wysihtml5 - Simple, beautiful wysiwyg editor
  • wysihtml5 - Open source rich text editor based on HTML5 and the progressive-enhancement approach. Uses a sophisticated security concept and aims to generate fully valid HTML5 markup by preventing unmaintainable tag soups and inline styles.
  • raptor-editor - Raptor, an HTML5 WYSIWYG content editor!
  • popline - Popline is an HTML5 Rich-Text-Editor Toolbar

Documentation

  • DevDocs is an all-in-one API documentation reader with a fast, organized, and consistent interface.
  • dexy is a free-form literate documentation tool for writing any kind of technical document incorporating code.
  • docco is a quick-and-dirty, hundred-line-long, literate-programming-style documentation generator.
  • styledocco generates documentation and style guide documents from your stylesheets.
  • Ronn builds manuals. It converts simple, human readable textfiles to roff for terminal display, and also to HTML for the web.
  • dox is a JavaScript documentation generator written with node. Dox no longer generates an opinionated structure or style for your docs, it simply gives you a JSON representation, allowing you to use markdown and JSDoc-style tags.
  • jsdox is a JSDoc3 to Markdown documentation generator.
  • YUIDoc is a Node.js application that generates API documentation from comments in source, using a syntax similar to tools like Javadoc and Doxygen.
  • coddoc is a jsdoc parsing library. Coddoc is different in that it is easily extensible by allowing users to add tag and code parsers through the use of coddoc.addTagHandler and coddoc.addCodeHandler. coddoc also parses source code to be used in APIs.
  • sphinx a tool that makes it easy to create intelligent and beautiful documentation
  • Using JSDoc
  • Beautiful docs is a documentation viewer based on markdown files.
  • documentation.js - API documentation generator with support for ES2015+ and flow annotation.
  • jsduck - API documentation generator made for Sencha JavaScript frameworks, but can be used for other frameworks too.

Files

Libraries for working with files.

  • Papa Parse - A powerful CSV library that supports parsing CSV files/strings and also exporting to CSV.
  • jBinary - High-level I/O (loading, parsing, manipulating, serializing, saving) for binary files with declarative syntax for describing file types and data structures.
  • diff2html - Git diff output parser and pretty HTML generator.
  • jsPDF - JavaScript PDF generation.

Functional Programming

Functional programming libraries to extend JavaScript’s capabilities.

  • underscore - JavaScript's utility _ belt.
  • lodash - A utility library delivering consistency, customization, performance, & extras.
  • Sugar - A Javascript library for working with native objects.
  • lazy.js - Like Underscore, but lazier.
  • ramda - A practical functional library for Javascript programmers.
  • mout - Modular JavaScript Utilities.
  • mesh - Streamable data synchronization utility.
  • preludejs - Hardcore Functional Programming for JavaScript.

Reactive Programming

Reactive programming libraries to extend JavaScript’s capabilities.

  • RxJs - The Reactive Extensions for JavaScript.
  • Bacon - FRP (functional reactive programming) library for Javascript.
  • Kefir - FRP library for JavaScript inspired by Bacon.js and RxJS with focus on high performance and low memory consumption.
  • [Highland] (http://highlandjs.org/) - Re-thinking the JavaScript utility belt, Highland manages synchronous and asynchronous code easily, using nothing more than standard JavaScript and Node-like Streams.
  • Most.js - high performance FRP library.
  • MobX - TFRP library for simple, scalable state management.
  • Cycle.js - A functional and reactive JavaScript library for cleaner code.

Data Structure

Data structure libraries to build a more sophisticated application.

  • immutable-js - Immutable Data Collections including Sequence, Range, Repeat, Map, OrderedMap, Set and a sparse Vector.
  • mori - A library for using ClojureScript's persistent data structures and supporting API from the comfort of vanilla JavaScript.
  • buckets - A complete, fully tested and documented data structure library written in JavaScript.
  • hashmap - Simple hashmap implementation that supports any kind of keys.

Date

Date Libraries.

  • moment - Parse, validate, manipulate, and display dates in javascript.
  • moment-timezone - Timezone support for moment.js.
  • jquery-timeago - A jQuery plugin that makes it easy to support automatically updating fuzzy timestamps (e.g. "4 minutes ago").
  • timezone-js - Timezone-enabled JavaScript Date object. Uses Olson zoneinfo files for timezone data.
  • date - Date() for humans.
  • ms.js - Tiny millisecond conversion utility.
  • countdown.js - Super simple countdowns.
  • timeago.js - Simple library (less then 2kb) used to format date with *** time ago statement.
  • fecha - Lightweight date formatting and parsing (~2KB). Meant to replace parsing and formatting functionality of moment.js.

String

String Libraries.

  • selecting - A library that allows you to access the text selected by the user
  • underscore.string - String manipulation extensions for Underscore.js javascript library.
  • string.js - Extra JavaScript string methods.
  • he - A robust HTML entity encoder/decoder written in JavaScript.
  • multiline - Multiline strings in JavaScript.
  • query-string - Parse and stringify URL query strings.
  • URI.js - Javascript URL mutation library.
  • jsurl - Lightweight URL manipulation with JavaScript.
  • sprintf.js - A sprintf implementation.
  • url-pattern - Easier than regex string matching patterns for urls and other strings. Turn strings into data or data into strings

Number

  • Numeral-js - A javascript library for formatting and manipulating numbers.
  • chance.js - Random generator helper in Javascript. Can generate numbers, strings etc.
  • odometer - Smoothly transitions numbers with ease.
  • accounting.js - A lightweight JavaScript library for number, money and currency formatting - fully localisable, zero dependencies.
  • money.js - A tiny (1kb) javascript currency conversion library, for web & nodeJS.
  • Fraction.js - A rational number library for JavaScript
  • Complex.js - A complex number library for JavaScript
  • Polynomial.js - A polynomials library for JavaScript

Storage

  • store.js - LocalStorage wrapper for all browsers without using cookies or flash. Uses localStorage, globalStorage, and userData behavior under the hood.
  • localForage - Offline storage, improved. Wraps IndexedDB, WebSQL, or localStorage using a simple but powerful API.
  • jStorage - jStorage is a simple key/value database to store data on browser side.
  • cross-storage - Cross domain local storage, with permissions.
  • basket.js - A script and resource loader for caching & loading scripts with localStorage.
  • bag.js - A caching script and resource loader, similar to basket.js, but with additional k/v interface and localStorage / websql / indexedDB support.
  • basil.js - The missing Javascript smart persistent layer.
  • jquery-cookie - A simple, lightweight jQuery plugin for reading, writing and deleting cookies.
  • js-cookie - A simple, lightweight JavaScript API for handling browser cookies
  • Cookies - JavaScript Client-Side Cookie Manipulation Library.
  • [DB.js] (https://github.com/aaronpowell/db.js/) - Promise based IndexDB Wrapper library
  • [lawnchair.js] (https://github.com/brianleroux/lawnchair/) - Simple client-side JSON storage.
  • [sql.js] (https://github.com/kripken/sql.js) - SQLite compiled to JavaScript through Emscripten.

Color

  • randomColor - A color generator for JavaScript.
  • chroma.js - JavaScript library for all kinds of color manipulations.
  • color - JavaScript color conversion and manipulation library.
  • colors - Smarter defaults for colors on the web.
  • PleaseJS - JavaScript Library for creating random pleasing colors and color schemes.
  • TinyColor - Fast, small color manipulation and conversion for JavaScript.
  • [Vibrant.js] (https://github.com/jariz/vibrant.js/) - Extract prominent colors from an image.

I18n And L10n

Localization (l10n) and internationalization (i18n) JavaScript libraries.

  • i18next - internationalisation (i18n) with javascript the easy way.
  • polyglot - tiny i18n helper library.
  • babelfish - i18n with human friendly API and built in plurals support.

Class

  • ClassManager - One of the fastest and most convenient class systems in the world
  • klass - A utility for creating expressive classes in JavaScript.
  • augment - The world's smallest and fastest classical JavaScript inheritance pattern.

Control Flow

  • async - Async utilities for node and the browser.
  • q - A tool for making and composing asynchronous promises in JavaScript.
  • step - An async control-flow library that makes stepping through logic easy.
  • contra - Asynchronous flow control with a functional taste to it.
  • Bluebird - fully featured promise library with focus on innovative features and performance.
  • when - A solid, fast Promises/A+ and when() implementation, plus other async goodies.
  • ObjectEventTarget - Provide a prototype that add support to event listeners (with same behavior of EventTarget from DOMElements available on browsers).

Routing

  • director - A tiny and isomorphic URL router for JavaScript.
  • page.js - Micro client-side router inspired by the Express router (~1200 bytes).
  • pathjs - Simple, lightweight routing for web browsers.
  • crossroads - JavaScript Routes.
  • davis.js - RESTful degradable JavaScript routing using pushState.

Security

  • DOMPurify - A DOM-only, super-fast, uber-tolerant XSS sanitizer for HTML, MathML and SVG.
  • js-xss - Sanitize untrusted HTML (to prevent XSS) with a configuration specified by a Whitelist.
  • xss-filters - Secure XSS Filters by Yahoo

Log

  • log - Console.log with style.
  • Conzole - A debug panel built in javascript that wraps javascript native console object methods and functionality in a panel displayed inside the page.
  • console.log-wrapper - Log to the console in any browser with clarity.
  • loglevel - Minimal lightweight logging for JavaScript, adding reliable log level methods to wrap any available console.log methods.
  • minilog – Lightweight client & server-side logging with Stream-API backends
  • storyboard - Universal logging library + Chrome extension; it lets you see all client and server tasks triggered by a user action in a single place.

RegExp

  • RegEx101 - Online regex tester and debugger for JavaScript. Also supports Python, PHP and PCRE.
  • RegExr - HTML/JS based tool for creating, testing, and learning about Regular Expressions.
  • RegExpBuilder - Create regular expressions using chained methods.

Voice Command

  • annyang - A JavaScript library for adding voice commands to your site, using speech recognition.
  • voix.js - A JavaScript library to add voice commands to your sites, apps or games.

API

  • bottleneck - A powerful rate limiter that makes throttling easy.
  • oauth-signature-js - JavaScript OAuth 1.0a signature generator for node and the browser.
  • amygdala - RESTful HTTP client for JavaScript powered web applications.
  • jquery.rest - A jQuery plugin for easy consumption of RESTful APIs.

Streaming

  • Tailor - Streaming layout service for front-end microservices, inspired by Facebook's BigPipe.

Vision Detection

  • tracking.js - A modern approach for Computer Vision on the web.
  • ocrad.js - OCR in Javascript via Emscripten.

Machine Learning

  • ConvNetJS - Deep Learning in Javascript. Train Convolutional Neural Networks (or ordinary ones) in your browser.
  • DN2A - Digital Neural Networks Architecture.
  • Brain.js - Neural networks in JavaScript.
  • Mind.js - A flexible neural network library.
  • Synaptic.js - Architecture-free neural network library for node.js and the browser.

Browser Detection

Benchmark

  • benchmark.js - A benchmarking library. As used on jsPerf.com.
  • matcha - A caffeine driven, simplistic approach to benchmarking.

Code highlighting

  • Highlight.js - Javascript syntax highlighter.
  • PrismJS - Lightweight, robust, elegant syntax highlighting.

Loading Status

Libraries for indicate load status.

  • Mprogress.js - Create Google Material Design progress linear bars.
  • NProgress - Slim progress bars for Ajax'y applications.
  • Spin.js - A spinning activity indicator.
  • progress.js - Create and manage progress bar for every objects on the page.
  • progressbar.js - Beautiful and responsive progress bars with animated SVG paths.
  • pace - Automatically add a progress bar to your site.
  • topbar - Tiny & beautiful site-wide progress indicator.
  • nanobar - Very lightweight progress bars. No jQuery.
  • PageLoadingEffects - Modern ways of revealing new content using SVG animations.
  • SpinKit - A collection of loading indicators animated with CSS.
  • Ladda - Buttons with built-in loading indicators.
  • css-loaders - A collection of loading spinners animated with CSS

Besides libraries, there're Collection on Codepen, and generators like Ajaxload, Preloaders and CSSLoad.

Validation

  • Parsley.js - Validate your forms, frontend, without writing a single line of javascript.
  • jquery-validation - jQuery Validation Plugin.
  • validator.js - String validation and sanitization.
  • validate.js - Lightweight JavaScript form validation library inspired by CodeIgniter.
  • validatr - Cross Browser HTML5 Form Validation.
  • FormValidation - The best jQuery plugin to validate form fields. Formerly BootstrapValidator.
  • is.js - Check types, regexps, presence, time and more.
  • FieldVal - multipurpose validation library. Supports both sync and async validation.

Keyboard Wrappers

  • mousetrap - Simple library for handling keyboard shortcuts in Javascript.
  • keymaster - A simple micro-library for defining and dispatching keyboard shortcuts.
  • Keypress - A keyboard input capturing utility in which any key can be a modifier key.
  • KeyboardJS - A JavaScript library for binding keyboard combos without the pain of key codes and key combo conflicts.
  • jquery.hotkeys - jQuery Hotkeys lets you watch for keyboard events anywhere in your code supporting almost any key combination.
  • jwerty - Awesome handling of keyboard events.

Tours And Guides

  • intro.js - A better way for new feature introduction and step-by-step users guide for your website and project.
  • shepherd - Guide your users through a tour of your app.
  • bootstrap-tour - Quick and easy product tours with Twitter Bootstrap Popovers.
  • tourist - Simple, flexible tours for your app.
  • chardin.js - Simple overlay instructions for your apps.
  • pageguide - An interactive guide for web page elements using jQuery and CSS3.
  • hopscotch - A framework to make it easy for developers to add product tours to their pages.
  • joyride - jQuery feature tour plugin.
  • focusable - Set a spotlight focus on DOM element adding a overlay layer to the rest of the page.

Notifications

  • messenger - Growl-style alerts and messages for your app.
  • noty - jQuery notification plugin.
  • pnotify - JavaScript notifications for Bootstrap, jQuery UI, and the Web Notifications Draft.
  • toastr - Simple javascript toast notifications.
  • humane-js - A simple, modern, browser notification system.
  • smoke.js - Framework-agnostic styled alert system for javascript.
  • notie - Simple notifications and inputs with no dependencies.

Sliders

  • Swiper - Mobile touch slider and framework with hardware accelerated transitions.
  • slick - The last carousel you'll ever need.
  • slidesJs - Is a ressponsive slideshow plug-in for JQuery(1.7.1+) with features like touch and CSS3 transitions
  • FlexSlider - An awesome, fully responsive jQuery slider plugin.
  • unslider - The simplest jQuery slider there is.
  • sly - JavaScript library for one-directional scrolling with item based navigation support.
  • vegas - A jQuery plugin to add beautiful fullscreen backgrounds to your webpages. It even allows Slideshows.
  • Sequence - CSS animation framework for creating responsive sliders, presentations, banners, and other step-based applications.
  • reveal.js - A framework for easily creating beautiful presentations using HTML.
  • impress.js - It's a presentation framework based on the power of CSS3 transforms and transitions in modern browsers and inspired by the idea behind prezi.com.
  • bespoke.js - DIY Presentation Micro-Framework
  • Strut - Strut - An Impress.js and Bespoke.js Presentation Editor
  • PhotoSwipe - JavaScript image gallery for mobile and desktop, modular, framework independent.
  • jcSlider - A responsive slider jQuery plugin with CSS animations.
  • basic-jquery-slider - Simple to use, simple to theme, simple to customise.
  • jQuery.adaptive-slider - A jQuery plugin for a slider with adaptive colored figcaption and navigation.
  • slidr - add some slide effects.
  • Flickity - Touch, responsive, flickable galleries.
  • Glide.js - Responsive and touch-friendly jQuery slider. It's simple, lightweight and fast.
  • jQuery.adaptive-slider - A jQuery plugin for a slider with adaptive colored figcaption and navigation.

Range Sliders

  • Ion.RangeSlider - Powerful and easily customizable range slider with many options and skin support.
  • jQRangeSlider - A javascript slider selector that supports dates.
  • noUiSlider - A lightweight, highly customizable range slider without bloat.
  • rangeslider.js - HTML5 input range slider element polyfill.

Form Widgets

Input

  • typeahead.js - A fast and fully-featured autocomplete library.
  • tag-it - A jQuery UI plugin to handle multi-tag fields as well as tag suggestions/autocomplete.
  • At.js - Add Github like mentions autocomplete to your application.
  • Placeholders.js - A JavaScript polyfill for the HTML5 placeholder attribute.
  • fancyInput - Makes typing in input fields fun with CSS3 effects.
  • jQuery-Tags-Input - Magically convert a simple text input into a cool tag list with this jQuery plugin.
  • vanilla-masker - A pure javascript mask input.
  • Ion.CheckRadio - jQuery plugin for styling checkboxes and radio-buttons. With skin support.
  • awesomplete - Ultra lightweight, usable, beautiful autocomplete with zero dependencies. - http://leaverou.github.io/awesomplete/

Calendar

  • pickadate.js - The mobile-friendly, responsive, and lightweight jQuery date & time input picker.
  • bootstrap-datepicker - A datepicker for @twitter bootstrap forked from Stefan Petre's (of eyecon.ro), improvements by @eternicode.
  • Pikaday - A refreshing JavaScript Datepicker — lightweight, no dependencies, modular CSS.
  • fullcalendar - Full-sized drag & drop event calendar (jQuery plugin).
  • rome - A customizable date (and time) picker. Dependency free, opt-in UI.
  • datedropper - datedropper is a jQuery plugin that provides a quick and easy way to manage dates for input fields.

Select

  • selectize.js - Selectize is the hybrid of a textbox and select box. It's jQuery based and it has autocomplete and native-feeling keyboard navigation; useful for tagging, contact lists, etc.
  • select2 - a jQuery based replacement for select boxes. It supports searching, remote data sets, and infinite scrolling of results.
  • chosen - A library for making long, unwieldy select boxes more friendly.

File Uploader

  • jQuery-File-Upload - File Upload widget with multiple file selection, drag&drop support, progress bar, validation and preview images, audio and video for jQuery.
  • dropzone - Dropzone is an easy to use drag'n'drop library. It supports image previews and shows nice progress bars.
  • flow.js - A JavaScript library providing multiple simultaneous, stable, fault-tolerant and resumable/restartable file uploads via the HTML5 File API.
  • fine-uploader - Multiple file upload plugin with progress-bar, drag-and-drop, direct-to-S3 uploading.
  • FileAPI - A set of javascript tools for working with files. Multiupload, drag'n'drop and chunked file upload. Images: crop, resize and auto orientation by EXIF.
  • plupload - A JavaScript API for dealing with file uploads it supports features like multiple file selection, file type filtering, request chunking, client side image scaling and it uses different runtimes to achieve this such as HTML 5, Silverlight and Flash.

Other

  • form - jQuery Form Plugin.
  • Garlic.js - Automatically persist your forms' text and select field values locally, until the form is submitted.
  • Countable - A JavaScript function to add live paragraph-, word- and character-counting to an HTML element.
  • card - Make your credit card form better in one line of code.
  • stretchy - Form element autosizing, the way it should be.

Tips

  • tipsy - Facebook-style tooltips plugin for jQuery.
  • opentip - An open source javascript tooltip based on the prototype framework.
  • qTip2 - Pretty powerful tooltips.
  • tooltipster - A jQuery tooltip plugin.
  • simptip - A simple CSS tooltip made with Sass.
  • jquery-popup-overlay - jQuery plugin for responsive and accessible modal windows and tooltips.
  • toolbar - A tooltip style toolbar jQuery plugin
  • hint.css - A tooltip library in CSS for your lovely websites.

Modals and Popups

  • Magnific-Popup - Light and responsive lightbox script with focus on performance.
  • jquery-popbox - jQuery PopBox UI Element.
  • jquery.avgrund.js - A jQuery plugin with new modal concept for popups.
  • vex - A modern dialog library which is highly configurable and easy to style.
  • bootstrap-modal - Extends the default Bootstrap Modal class. Responsive, stackable, ajax and more.
  • css-modal - A modal built out of pure CSS.
  • jquery-popup-overlay - jQuery plugin for responsive and accessible modal windows and tooltips.
  • SweetAlert - An awesome replacement for JavaScript's alert.
  • baguetteBox.js - Simple and easy to use lightbox script written in pure JavaScript.
  • colorbox - A light-weight, customizable lightbox plugin for jQuery.
  • fancyBox - A tool that offers a nice and elegant way to add zooming functionality for images, html content and multi-media on your webpages.
  • swipebox - A touchable jQuery lightbox
  • jBox - jBox is a powerful and flexible jQuery plugin, taking care of all your popup windows, tooltips, notices and more.

Scroll

  • scrollMonitor - A simple and fast API to monitor elements as you scroll.
  • headroom - Give your pages some headroom. Hide your header until you need it.
  • onepage-scroll - Create an Apple-like one page scroller website (iPhone 5S website) with One Page Scroll plugin.
  • iscroll - iScroll is a high performance, small footprint, dependency free, multi-platform javascript scroller.
  • skrollr - Stand-alone parallax scrolling library for mobile (Android + iOS) and desktop. No jQuery.
  • parallax - Parallax Engine that reacts to the orientation of a smart device.
  • stellar.js - Parallax scrolling made easy.
  • plax - jQuery powered parallaxing.
  • jparallax - jQuery plugin for creating interactive parallax effect.
  • fullPage - A simple and easy to use plugin to create fullscreen scrolling websites (also known as single page websites).
  • ScrollMenu - A new interface to replace old boring scrollbar.
  • Clusterize.js - Tiny vanilla JS plugin to display large data sets easily.

Menu

  • jQuery-menu-aim - jQuery plugin to fire events when user's cursor aims at particular dropdown menu items. For making responsive mega dropdowns like Amazon's.
  • [jQuery contextMenu] (https://github.com/swisnl/jQuery-contextMenu) - contextMenu manager.
  • Slideout - A responsive touch slideout navigation menu for mobile web apps.
  • Slide and swipe - A sliding swipe menu that works with touchSwipe library.

Table/Grid

  • jTable - A jQuery plugin to create AJAX based CRUD tables.
  • DataTables - (jQuery plug-in) It is a highly flexible tool, based upon the foundations of progressive enhancement, and will add advanced interaction controls to any HTML table.
  • floatThead - (jQuery plug-in) lock any table's header while scrolling within the body. Works on any table and requires no custom html or css.
  • Masonry - A cascading grid layout library.
  • Packery - A grid layout library that uses a bin-packing algorithm. Useable for draggable layouts.
  • Isotope - A filterable, sortable, grid layout library. Can implement Masonry, Packery, and other layouts.
  • flexboxgrid - Grid based on CSS3 flexbox

Frameworks

  • Semantic UI - UI Kit with lots of themes and elements
  • w2ui - A set of jQuery plugins for front-end development of data-driven web applications.
  • fluidity - The worlds smallest fully-responsive css framework
  • Ink - An HTML5/CSS3 framework used at SAPO for fast and efficient website design and prototyping

Boilerplates

  • html5-boilerplate - A professional front-end template for building fast, robust, and adaptable web apps or sites.
  • mobile-boilerplate - A front-end template that helps you build fast, modern mobile web apps.
  • webplate - An awesome front-end framework that lets you stay focused on building your site or app while remaining really easy to use.
  • Cerberus - A few simple, but solid patterns for responsive HTML emails. Even in Outlook.
  • full-page-intro-and-navigation - An intro page with a full width background image, a bold animated menu and an iOS-like blurred effect behind the navigation
  • Fluid-Squares - A fluid grid of square units.
  • Mobile-First-RWD - An example of a mobile-first responsive web design
  • this-is-responsive - This Is Responsive
  • npm run-scripts Task automation with NPM run-scripts.

Gesture

  • hammer.js - A javascript library for multi-touch gestures.
  • touchemulator - Emulate touch input on your desktop.
  • [Dragula] (https://github.com/bevacqua/dragula/) - Drag and drop so simple it hurts

Maps

  • Leaflet - JavaScript library for mobile-friendly interactive maps.
  • Cesium - Open Source WebGL virtual globe and map engine.
  • gmaps - The easiest way to use Google Maps.
  • polymaps - A free JavaScript library for making dynamic, interactive maps in modern web browsers.
  • kartograph.js - Open source JavaScript renderer for Kartograph SVG maps.
  • mapbox.js - Mapbox JavaScript API, a Leaflet Plugin.
  • jqvmap - jQuery Vector Map Library.
  • OpenLayers3 - A high-performance, feature-packed library for all your mapping needs.

Video/Audio

  • prettyembed.js - Prettier embeds for your YouTubes - with nice options like high-res preview images, advanced customization of embed options, and optional FitVids support.
  • html5media - Enables video and audio tags in all major browsers. https://html5media.info/
  • Play-em JS - Play'em is a javascript component that manages a music/video track queue and plays a sequence of songs by embedding several players in a HTML DIV including Youtube, Soundcloud and Vimeo.
  • polyplayer - Rule YouTube, Soundcloud and Vimeo player with one API
  • flowplayer - The HTML5 video player for the web https://flowplayer.org/
  • mediaelement - HTML5 audio or video player with Flash and Silverlight shims that mimics the HTML5 MediaElement API, enabling a consistent UI in all browsers. http://mediaelementjs.com/
  • SoundJS - A library to make working with audio on the web easier. It provides a consistent API for playing audio in different browsers.
  • video.js - Video.js - open source HTML5 & Flash video player
  • FitVids.js - A lightweight, easy-to-use jQuery plugin for fluid width video embeds.
  • Ion.Sound - Simple sounds on any web page
  • photobooth-js - A widget that allows users to take their avatar pictures on your site
  • clappr - An extensible media player for the web http://clappr.io

Typography

  • FlowType.JS - Web typography at its finest: font-size and line-height based on element width.
  • BigText - jQuery plugin, calculates the font-size and word-spacing needed to match a line of text to a specific width.
  • circletype - A jQuery plugin that lets you curve type on the web
  • slabText - A jQuery plugin for producing big, bold & responsive headlines
  • simple-text-rotator - Add a super simple rotating text to your website with little to no markup
  • novacancy.js - Text Neon Golden effect jQuery plug-in.
  • jquery-responsive-text - Make your text sizing responsive!
  • FitText.js - A jQuery plugin for inflating web type
  • Lettering.js - A lightweight, easy to use Javascript <span> injector for radical Web Typography

Animations

  • velocity - Accelerated JavaScript animation.
  • jquery.transit - Super-smooth CSS3 transformations and transitions for jQuery.
  • imrpess.js - Make Prezi-like presentations with CSS3 transformations/transitions in an HTML document.
  • bounce.js - Create tasty CSS3 powered animations in no time.
  • GreenSock-JS - High-performance HTML5 animations that work in all major browsers.
  • TransitionEnd - TransitionEnd is an agnostic and cross-browser library to work with transitionend event.
  • Dynamic.js - Javascript library to create physics-based CSS animations.
  • the-cube - The Cube is an experiment with CSS3 transitions.
  • Effeckt.css - A Performant Transitions and Animations Library
  • animate.css - A cross-browser library of CSS animations. As easy to use as an easy thing.
  • textillate - A simple plugin for CSS3 text animations
  • move.js - CSS3 backed JavaScript animation framework
  • animatable - One property, two values, endless possiblities
  • shuffle-images - The Simplest Way to shuffle through images in a Creative Way http://www.thepetedesign.com/demos/shuffle-images_demo.html
  • smoothState.js - Unobtrusive page transitions with jQuery. http://smoothstate.com/

Image Processing

  • lena.js - A Library for image processing with filters and util functions.
  • pica - High quality image resize (with fast Lanczos filter, implemented in pure JS).
  • cropper - A simple jQuery image cropping plugin.

ES6

SDK

  • javascript-sdk-design - Javascript SDK design guide extracted from work and personal experience
  • Spotify SDK - Entity oriented SDK to work with the Spotify Web API.

Misc

  • echo - Lazy-loading images with data-* attributes.
  • picturefill - A responsive image polyfill for <picture>, srcset, sizes.
  • platform.js - A platform detection library that works on nearly all JavaScript platforms.
  • json3 - A modern JSON implementation compatible with nearly all JavaScript platforms.
  • Logical Or Not - A game about JavaScript specificities.
  • BitSet.js - A JavaScript Bit-Vector implementation
  • spoiler-alert - SPOILER ALERT! A happy little jquery plugin to hide spoilers on your site.
  • jquery.vibrate.js - Vibration API Wrappers
  • list.js - Adds search, sort, filters and flexibility to tables, lists and various HTML elements. Built to be invisible and work on existing HTML. http://www.listjs.com
  • mixitup - MixItUp - A Filter & Sort Plugin
  • grid - Drag and drop library for two-dimensional, resizable and responsive lists.
  • jquery-match-height - a responsive equal heights plugin for jQuery.
  • survey.js - JavaScript Survey Engine. It uses JSON for survey metadata and results. http://surveyjs.org/

Podcasts

  • JavaScript Air - The live video broadcast podcast all about JavaScript and the Web platform.
  • Web of Tomorrow - Podcast about JavaScript for beginners.
  • Javascript Jabber - A weekly podcast about JavaScript, including Node.js, Front-End Technologies, Careers, Teams and more.

Worth Reading

Other Awesome Lists

Mongo DB - Document Database

Rédigé par Sozezzo - - Aucun commentaire

The big thing is … Mongo BD is NOT RDBMS!

In OOP are not tables and rows, objects use polymorphism, inheritance, and it is not uniform. Use objects with RDBMS can be hard.

Mongo DB has no schema to define, no tables and no relationships between collections of objects. Each document can be flat, simple, or complex as we wish. There are no locks of tables, or columns.

Durability vs Consistency

Durability is about whether your data was persisted to durable media before control was returned to you. Eventual consistency in a replica set has to do with whether a document was written to all of the servers, to the primaries and secondaries before control was returned to your application.

· You can ready for inconsistency. Can your application run with? Can it be an issue?

· The application takes control of schema enforcement.

We can backup and restore of Mongo, to import and export information, to monitor the Mongo server, and to share it. You can scale MongoDB horizontally with a replication.

 

What is BSON ? Store byte arrays on disk..

The BSON specifications can be found on bsonspec.org. Basically, BSON is elementary data types into memory into C data types then to read and to write is fast. BSON specification is data storage serialization format with memory mapped files.
BSON documents has length prefixing. It is fast to find particular a field into store arbitrary object structures and not require to adhere to a particular schema, and this is the key of MongoDB.

Index is important in MongoDb, you must be sure the index is useful and with the correct name of column.

Where and When do you use MobgoDB?

  • No transaction at all.
  • Not a lot of updates, less 1% of database.
  • Geo-distributed database;
  • Use for CMS, Logs, Dataware, etc.

Install PHP on Windows Server 2016

Rédigé par Sozezzo - - Aucun commentaire

Easy steps to install PHP on Windows Server 2016

This tutorial was create for Windows Server 2016 x64, but you can do it on Windows Workstation x86, but you just need to use x86 everywhere.

 

REQUIREMENTS

  • Windows Server 2016
  • IIS
  • PHP bin files
  • WinCache
  • VC++

 

 

IIS service with CGI extension.

Before to install, verify if you already have it.


Get-WindowsFeature web-cgi

image

 

Powershell command to install


Install-WindowsFeature -name web-server,web-cgi –IncludeManagementTools

 

Installing PHP

 

Download PHP version you want to install.

http://windows.php.net/download/

Extract file to C:\Program Files\php

 

Select PHP configuration to use

You have 2 configuration files:

  • php.ini-development
  • php.ini-production

You must rename the file configuration to php.ini.

 

Add Wincache configuration

Open php.ini file and add this line in the end:

extension=php_wincache.dll

 

Add PHP path on Environment variables

On Explorer click properties on This PC

Click on Advanced system settings

Click on Advanced \ Environment Variables

On System variables, edit variable : Path

Add new path. ( C:\Program Files\php )

 

Install WinCache Extention

https://www.iis.net/downloads/microsoft/wincache-extension

Download and extract it.

Copy files to folder : C:\Program Files\php\ext

  • php_wincache.dll
  • php_wincache.pdb       (optional)

 

 

Configurate PHP in IIS

In IIS open Handler Mappings

Add Module Mapping

  • Request path : *.php
  • Module : FastCgiModule
  • Executable (optional) : C:\Program Files\php\php-cgi.exe
  • Name : PHP

Click on Request Restriction…

Select "FIle or Folder"

 

Installing VC++

https://support.microsoft.com/en-ca/help/2977003/the-latest-supported-visual-c-downloads

Just install it.

 

Verify if it works.

Open the default web site path, root, and create a file <phpinfo.php> with this line:

<?php  phpinfo(); ?>

 

Usually it is this path: C:\inetpub\wwwroot

 

Open in your local server this page:

http://localhost/phpinfo.php

Fil RSS des articles de cette catégorie