Magic words:
psql -U postgresSome interesting flags (to see all, use -h or --help depending on your psql version):
-E: will describe the underlaying queries of the \ commands (cool for learning!)-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
В данной заметке рассматривается работа JWT с симметичным алгоритмом шифрования (HS256/HS384/HS512)
Аутентификация(authentication, от греч. αὐθεντικός [authentikos] – реальный, подлинный; от αὐθέντης [authentes] – автор) - это процесс проверки учётных данных пользователя (логин/пароль). Проверка подлинности пользователя путём сравнения введённого им логина/пароля с логином/паролем, сохранённым в базе данных пользователей.
Авторизация(authorization — разрешение, уполномочивание) - это проверка прав пользователя на доступ к определенным ресурсам.
| /** | |
| * Deep diff between two object, using lodash | |
| * @param {Object} object Object compared | |
| * @param {Object} base Object to compare with | |
| * @return {Object} Return a new object who represent the diff | |
| */ | |
| function difference(object, base) { | |
| function changes(object, base) { | |
| return _.transform(object, function(result, value, key) { | |
| if (!_.isEqual(value, base[key])) { |
| # > It happened to me and it turned out that I removed erroneously the postgres user from "ssl-cert" group, set it back with | |
| gpasswd -a postgres ssl-cert | |
| # Fixed ownership and mode | |
| sudo chown root:ssl-cert /etc/ssl/private/ssl-cert-snakeoil.key | |
| sudo chmod 740 /etc/ssl/private/ssl-cert-snakeoil.key | |
| # now postgresql starts! (and install command doesn't fail anymore) | |
| sudo /etc/init.d/postgresql start |
| document.addEventListener('keyup', function(e) { | |
| 9 != e.keyCode || e.metaKey || e.ctrlKey || console.log(document.activeElement) | |
| }, false) |
| # Create your superuser | |
| $ mongo | |
| > use admin | |
| > db.createUser({user:"someadmin",pwd:"secret", roles:[{role:"root",db:"admin"}]}) | |
| > exit | |
| # Alias for convenience (optional and at your own risk) | |
| $ echo 'alias mongo="mongo --port 27017 -u someadmin -p secret --authenticationDatabase admin"' >> ~/.bash_profile | |
| $ source ~/.bash_profile |
| https://stackoverflow.com/questions/14226410/node-js-cannot-find-module-mongodb | |
| npm install mongodb -g | |
| cd /path/to/my/app/folder | |
| npm link mongodb | |
| With that in place, I could do this in my application file: require('mongodb'). | |
| /**/ | |
| https://docs.mongodb.com/manual/tutorial/install-mongodb-on-ubuntu/ | |
| https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-mongodb-on-ubuntu-16-04 |
| /* | |
| limitLoop.js - limit the frame-rate when using requestAnimation frame | |
| Released under an MIT license. | |
| When to use it? | |
| ---------------- | |
| A consistent frame-rate can be better than a janky experience only | |
| occasionally hitting 60fps. Use this trick to target a specific frame- | |
| rate (e.g 30fps, 48fps) until browsers better tackle this problem |
| for (var ac = 0; ac < results[0].address_components.length; ac++) { | |
| var component = results[0].address_components[ac]; | |
| switch(component.types[0]) { | |
| case 'locality': | |
| storableLocation.city = component.long_name; | |
| break; | |
| case 'administrative_area_level_1': | |
| storableLocation.state = component.short_name; | |
| break; |
| The MIT License (MIT) | |
| Copyright (c) 2015 Justin Perry | |
| Permission is hereby granted, free of charge, to any person obtaining a copy of | |
| this software and associated documentation files (the "Software"), to deal in | |
| the Software without restriction, including without limitation the rights to | |
| use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of | |
| the Software, and to permit persons to whom the Software is furnished to do so, | |
| subject to the following conditions: |