GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → robconery → Pg Auth

robconery / Pg Auth

Licence: other
A complete authentication system built in Postgres using schemas and functions

Labels

plpgsql

Projects that are alternatives of or similar to Pg Auth

Pg Semver
A semantic version data type for PostgreSQL
Stars: ✭ 91 (-22.22%)
Mutual labels:  plpgsql
Serverless Postgraphql
Serverless GraphQL endpoint for PostgresSQL using AWS, serverless and PostGraphQL
Stars: ✭ 105 (-10.26%)
Mutual labels:  plpgsql
Bible Database
Bible databases as XML, JSON, SQL & SQLITE3 Database format for various languages. Developers can download it freely for their development works. Freely received, freely give.
Stars: ✭ 111 (-5.13%)
Mutual labels:  plpgsql
Qt Client
This repository contains the source code for the Desktop client. The Desktop client is built using the Qt framework for C++. The client can be extended or customized using JavaScript. This client is used by all editions of xTuple ERP.
Stars: ✭ 93 (-20.51%)
Mutual labels:  plpgsql
Plpgunit
PostgreSQL Unit Testing Framework
Stars: ✭ 102 (-12.82%)
Mutual labels:  plpgsql
Screampay
screamPay聚合支付，一个强大到让你尖叫的聚合支付系统，使用Java开发，spring-boot架构，已接入环讯、九派、杉德等主流支付渠道，可直接用于生产环境。
Stars: ✭ 107 (-8.55%)
Mutual labels:  plpgsql
Cartodb Postgresql
PostgreSQL extension for CartoDB
Stars: ✭ 90 (-23.08%)
Mutual labels:  plpgsql
Scaledger
A double-entry accounting database with a typed GraphQL API
Stars: ✭ 115 (-1.71%)
Mutual labels:  plpgsql
Postgraphile Lambda Example
Simple serverless / Lambda example with caching and lightweight bundle
Stars: ✭ 104 (-11.11%)
Mutual labels:  plpgsql
Triprecord
咔咔出行——基于高德地图API，Vue+Express实现的移动端webapp，服务器受到攻击网站暂时下掉了
Stars: ✭ 1,495 (+1177.78%)
Mutual labels:  plpgsql
Totp
RFC6238 TOTP implementation in pure PostgreSQL plpgsql
Stars: ✭ 98 (-16.24%)
Mutual labels:  plpgsql
Civicscape
A new standard for real-time policing.
Stars: ✭ 101 (-13.68%)
Mutual labels:  plpgsql
Panda Cloud
Base on SpringCloud MicroService Framework
Stars: ✭ 108 (-7.69%)
Mutual labels:  plpgsql
Pg permission
A simple set of views to see ALL permissions in a PostgreSQL database
Stars: ✭ 92 (-21.37%)
Mutual labels:  plpgsql
Node Sqlcipher
SQLCipher bindings for Node
Stars: ✭ 114 (-2.56%)
Mutual labels:  plpgsql
Postgresql Anyarray
PostgeSQL extension adding highly desirable, data-type independent array functionality.
Stars: ✭ 91 (-22.22%)
Mutual labels:  plpgsql
Aws Database Migration Samples
A set of sample database and associated items to allow customers to among other things follow along with published database migration recipes.
Stars: ✭ 105 (-10.26%)
Mutual labels:  plpgsql
Pg2go
PostgreSQL script that generates Go struct definitions for all tables in a database
Stars: ✭ 116 (-0.85%)
Mutual labels:  plpgsql
Vocabulary V5.0
PALLAS: Build process for OMOP Standardized Vocabularies. Currently not available as independent release. Therefore, do not clone or try to replicate. It is work in progress and not ready for replication.
Stars: ✭ 114 (-2.56%)
Mutual labels:  plpgsql
Common schema
DBA's framework for MySQL
Stars: ✭ 108 (-7.69%)
Mutual labels:  plpgsql
View All Similar Projects ➔

A Bit of Crazy

I'm fairly certain that the existence of this repo will cause anxiety. It's just a thought exercise - people have asked, so here it is.

This is the Postgres Authentication stuff - meaning it's a full authentication system in a box, in your DB. I flipped out one weekend and decided to see if I could do it... I could, so here it is.

Still a bit raw, but tests are passing nicely. Still need to work on a few things.

Installation

I tried to make everything as self-contained as I could. So, to install this just crack open index.js and set DB to whatever local database you want to use.

And then...

npm install
node index.js

This will execute a bulk SQL transaction against your database and will:

  • Create a schema called "membership"
  • Install pgcrypto for hashing passwords
  • Drop in the schema, tables, functions etc needed for this crazy

Development

If you want to play around, the test db is called pg_auth and I build it on the fly. You can see all the scripts in the build/src directory - these get built and dropped into build/dist. If all you want is to check stuff out just install as above and have a good time.

This is Supposed To Be Fun

I like seeing what Postgres can do, and I'm not the world's best programmer so if you see some things that are interesting, have some fun.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].