Epochtalk Core for PostgreSQL
JavaScript PLpgSQL PLSQL
Clone or download
unenglishable Merge pull request #77 from epochtalk/fix-promises
Update bluebird to same version as epochtalk
Latest commit 225d1eb May 18, 2018
Permalink
Failed to load latest commit information.
bans Updated node-pg version to latest Oct 31, 2017
blacklist Added moderation_log table and enum. Updated delete methods Feb 9, 2016
configurations optimization Aug 8, 2017
images Image expiration and post relations Jul 27, 2015
migrations User mention migrations for ignored users Mar 29, 2017
moderation_logs Updated users.byBannedBoards to stack filters Feb 26, 2016
moderators Node-pg promises dont allow chaining of anything but then or catch Oct 31, 2017
notifications Updated node-pg version to latest Oct 31, 2017
polls make poll.create return the same object as polls.bythread Jul 20, 2017
roles Node-pg promises dont allow chaining of anything but then or catch Oct 31, 2017
scripts Moved watchlist methods into the ept-watchlist module Apr 1, 2016
test remove commented notifications test code Mar 22, 2016
user_notes Bug Fix: User notes break when viewer has more than one role May 18, 2016
.gitignore Poll Answers method Dec 11, 2015
MIGRATIONS.md Moderate threads Dec 30, 2015
README.md UUID info in schema section of readme. Mar 11, 2015
circle.yml add circle.yml to use node 5 Jan 27, 2016
config.js config is not initialized in setup.js Oct 22, 2015
db.js Updated node-pg version to latest Oct 31, 2017
errors.js Add NotFoundError to error types May 19, 2018
helper.js Update for messages changes Sep 8, 2017
index.js Updated node-pg version to latest Oct 31, 2017
package-lock.json Update bluebird to same version as epochtalk May 19, 2018
package.json Update bluebird to same version as epochtalk May 19, 2018
schema.sql Removed db-migrate May 3, 2017
setup.js Updated node-pg version to latest Oct 31, 2017
yarn.lock yarn setup, engines removed (deprecated as of npm 3) Dec 13, 2017

README.md

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