• Stars
    star
    119
  • Rank 297,871 (Top 6 %)
  • Language PLpgSQL
  • License
    Other
  • Created over 9 years ago
  • Updated over 8 years ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

A complete authentication system built in Postgres using schemas and functions

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.

More Repositories

1

moebius

A functional query tool for Elixir
Elixir
598
star
2

dox

A Document Database API extension for Postgres
PLpgSQL
193
star
3

peach

An experimental ecommerce thing for Elixir
Elixir
151
star
4

congo

A MongoDB Explorer written in Backbone using Twitter Bootstrap. Part of Tekpub's Backbone.series
JavaScript
136
star
5

meteor-shop

A demo eCommerce site using Meteor.js - the code for this site can also be seen at Pluralsight.
JavaScript
117
star
6

mvc3

Code and Resources for Real-World ASP.NET MVC3
C#
107
star
7

ng-mongo

A MongoDB Explorer written on top of AngularJS and Node/Express
JavaScript
85
star
8

knockout-cart

A simple browser-based shopping cart that uses local storage, powered by KnockoutJS
JavaScript
84
star
9

mvcmusic

Harder Faster Better Stronger
C#
78
star
10

pg_docs_api

A simple abstraction for working with PostgreSQL as a Document Database
41
star
11

vim-settings

My vim action
Vim Script
37
star
12

Vue.Starter

The ASP.NET Vue Starter Template
Vue
19
star
13

dvdrental

The DVD Rental Scripts for Pluralsight's Postgres for .NET Developers
19
star
14

json-sales-data

A data generator for creating detailed, real-world sales data with fullfillments
JavaScript
19
star
15

azx

Azure App Services made easy
JavaScript
17
star
16

pg-dvdrental

The DVD Rental Sample App created for a Pluralsight Video
C#
13
star
17

node-application-patterns

JavaScript
13
star
18

node-pg-start

A Postgres-centric Node JS starter app built with Tailwind CSS and Express
CSS
9
star
19

azx.ms

Azure scripts made easy
CSS
8
star
20

little-sql

The Code for the Little SQL Book
Shell
6
star
21

dotnet-template

A template for you to create your own .NET template
6
star
22

js-inferno

Code for the Javascript Inferno talk
JavaScript
5
star
23

Svelte.Starter

The ASP.NET Svelte Starter Template with ASP.NET Minimal API, Svelte 3.0 and Tailwind
JavaScript
4
star
24

nuxt-walkthrough

The code for the Nuxt walkthrough vids
Vue
4
star
25

azure-project

A Heroku-inspired CLI for Azure's web applications
JavaScript
3
star
26

froggy-membership

Membership module for FroggyFrog
JavaScript
3
star
27

asp-js-docs

Using Vue, Angular and React with ASP.NET and Minimal API
Vue
2
star
28

capistrano-rails-server

Capistrano recipes for building a Rails 3/Nginx/Unicorn/Postgres/Memcached/Redis server, inspired by Railscasts
Ruby
2
star
29

troys-book

A repository for feedback on Troy Hunt's book.
2
star
30

node-mongo-start

An Express app with Mongo DB starter, designed to work with Cosmos DB
CSS
1
star
31

Hacking-WebMatrix

The WebMatrix site built up for the Hacking WebMatrix series
C#
1
star
32

velzy

JavaScript
1
star
33

blog

My blog
JavaScript
1
star