/core-pg

Epochtalk Core for PostgreSQL

Primary LanguageJavaScript

PostgreSQL core implementation for Epochtalk

Epochtalk's core implementation using PostgreSQL 9.x

Schema

Epochtalk uses UUIDs that are reverse compatible with existing systems that use serial/integer based keying. UUIDs are at a clear advantage in more advanced systems:

This is 16-octet / 128 bit type compatible with most common GUID and UUID generators, supporting distributed application design, defined by RFC 4122, ISO/IEC 9834-8:2005. It is represented by 32 lowercase hexadecimal digits, displayed in five groups separated by hyphens, in the form 8-4-4-4-12 for a total of 36 characters (32 alphanumeric characters and four hyphens).

Usage

Recommended: Use a separate module to use this require and depend it throughout your project. This allows the initialization from the configuration variables to be in just one place.

var path = require('path');
var config = require(path.join(__dirname, 'config'));
var core = require('epochtalk-core-pg');
module.exports = core(config.db);

API

Doc generation coming soon. For now look for code in the following models:

  • boards
  • categories
  • posts
  • threads
  • users

License

ISC Copyright (c) 2015, Slickage Studios LLC