<!DOCTYPE html><html class="no-js" lang="en"><head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title></title> <link href="https://fonts.googleapis.com/css?family=Lato:400,700|Roboto+Slab:400,700|Inconsolata:400,700" rel="stylesheet" type="text/css"> <link rel="stylesheet" href="/v2/css/theme.css" type="text/css"> <link href="/v2/css/custom.css" rel="stylesheet"> <script src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/modernizr/2.8.3/modernizr.min.js"></script> <script src="./js/theme.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/highlight.js/8.4/highlight.min.js"></script> <script src="search/main.js"></script> <style> body {font-size: 90%;} pre, code {font-size: 100%;} h3, h4, h5, h6 {color: #2980b9; font-weight: 300} </style> <meta name="robots" content="noindex"></head> <body class="wy-body-for-nav" role="document"> <div class="wy-grid-for-nav"> <nav data-toggle="wy-nav-shift" class="wy-nav-side stickynav"> <div class="wy-side-nav-search"> <a href="/v2/" class="icon icon-home"> </a> <div role="search"> <form id="rtd-search-form" class="wy-form" action="" method="get"> <input type="text" name="q" placeholder="Search docs"> <input type="hidden" name="check_keywords" value="yes"> <input type="hidden" name="area" value="default"> </form> </div> </div> <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation"> <ul class="current"> <span class="toctree-l0">Home</span> <li class="toctree-l1 current"> <a class="current" href="/v2/">Welcome</a> <ul> </ul> </li> <li class="toctree-l1 "> <a class="" href="/v2/imprint/">Imprint</a> </li> <span class="toctree-l0">Articles</span> <li class="toctree-l1 "> <a class="" href="/v2/articles/getting-started/">Getting started</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/articles/heroku/">Heroku</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/articles/express/">Usage with Express.JS</a> </li> <span class="toctree-l0">Docs</span> <li class="toctree-l1 "> <a class="" href="/v2/docs/installation/">Installation</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/usage/">Usage</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/promises/">Promises</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/models/">Models</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/instances/">Instances</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/associations/">Associations</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/hooks/">Hooks</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/transactions/">Transactions</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/migrations/">Migrations</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/docs/misc/">Misc</a> </li> <span class="toctree-l0">API</span> <li class="toctree-l1 "> <a class="" href="/v2/api/sequelize/">Sequelize</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/model/">Model</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/instance/">Instance</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/associations/">Associations</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/hooks/">Hooks</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/promise/">Promise</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/transaction/">Transaction</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/datatypes/">Datatypes</a> </li> <li class="toctree-l1 "> <a class="" href="/v2/api/errors/">Errors</a> </li> </ul> </div>   </nav> <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap"> <nav class="wy-nav-top" role="navigation" aria-label="top navigation"> <i data-toggle="wy-nav-top" class="icon icon-reorder"></i> <a href="/v2/"></a> </nav> <div class="wy-nav-content"> <div class="rst-content"> <div role="navigation" aria-label="breadcrumbs navigation"> <ul class="wy-breadcrumbs"> <li><a href="/v2/">Docs</a> 禄</li> <li>Welcome</li> <li class="wy-breadcrumbs-aside"> </li> </ul> <hr> </div> <div role="main"> <div class="section"> <p>The Sequelize library provides easy access to MySQL, MariaDB, SQLite or PostgreSQL databases by mapping database entries to objects and vice versa. To put it in a nutshell, it's an ORM (Object-Relational-Mapper). The library is written entirely in JavaScript and can be used in the Node.JS environment.</p> <h2 id="easy-installation">Easy installation</h2> <pre><code class="language-bash">$ npm install sequelize $ npm install mysql </code></pre> <h2 id="simple-usage">Simple usage</h2> <pre><code class="language-js">var Sequelize = require('sequelize') , sequelize = new Sequelize('database', 'username', 'password') var User = sequelize.define('User', { username: Sequelize.STRING, birthday: Sequelize.DATE }) sequelize.sync().success(function() { User.create({ username: 'sdepold', birthday: new Date(1986, 06, 28) }).success(function(sdepold) { console.log(sdepold.values) }) }) </code></pre> <h2 id="trusted-and-used-by">Trusted and used by</h2> <p><a href="/v2/docs/misc#shutterstock"><img alt="" src="/images/shutterstock.png"></a> <a href="/v2/docs/misc#clevertech"><img alt="" src="/images/clevertech.png"></a> <a href="/v2/docs/misc#metamarkets"><img alt="" src="/images/metamarkets.png"></a> <a href="/v2/docs/misc#filsh"><img alt="" src="/images/filsh.png"></a></p> <p>(c) Sascha Depold, <a href="https://github.com/sequelize/sequelize-doc/graphs/contributors">et al.</a> 2006 - 2014 <a href="/v2/imprint">Imprint</a></p> </div> </div> <footer> <hr> <div role="contentinfo"> <p>  </p> </div> Built with <a href="http://www.mkdocs.org">MkDocs</a>, using a <a href="https://github.com/snide/sphinx_rtd_theme">theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>. </footer> </div> </div> </section> </div> <div class="rst-versions" role="note" style="cursor: pointer"> <span class="rst-current-version" data-toggle="rst-current-version"> <span><a href="/v2/" style="color: #fcfcfc;">芦 Previous</a></span> <span style="margin-left: 15px"><a href="/v2/" style="color: #fcfcfc">Next 禄</a></span> </span> </div> </body></html>

CINXE.COM