Expressa logo

Expressa

  •  0 ratings
In category: Content Management Systems (CMS)

About Expressa

Content Management System for powering database driven websites using JSON schemas. Provides permission management and automatic REST APIs.

  •   509  
  •   0  
  •   0  
  •   0  
Github stats:
  •  Commits: N/A  
  •   N/A  
  •   N/A  
  •  Latest commit: N/A  

Deploy this app to Linode with a free $100 credit!

Languages/Platforms/Technologies:
Lincenses:

More about Expressa

CircleCI

data-driven extendable API middleware for Node.js/Express

Expressa makes it easy to create basic APIs by using JSON schema:

  • django-like admin interface for creating collection-REST endpoints and managing permissions
  • collection schema's can be edited and added through the admin interface
  • re-use collection schema's in your frontend to generate forms
  • easily extendable so you can add complex features as well
  • define collections as JSON schema instead of custom code
  • per-collection database storage: MongoDB, PostgreSQL, or JSON-files (useful for version control)

Best of all: it's just middleware, not a framework

  • mix-and-mash: easily throw in other express middleware and endpoints
  • decorate expressa-endpoints: add event listeners which stop/modify requests (responses)

Getting Started

It's very easy to install expressa in your project directory:

mkdir myapp
cd myapp
npm init
npm install expressa express

Create a file app.js with the following code (or just copy the middle 3 lines into your existing express app)

var express = require('express');
var app = express();

var expressa = require('expressa');
app.use('/admin', expressa.admin({ apiurl: '/api/' }));
app.use('/api', expressa.api());

app.listen(3000, function () {
  console.log('Example app listening on port 3000!');
});

Now start the server by running node --use-strict app.js and navigate your browser to http://localhost:3000/admin/

API endpoints

Once you add a collections in the admin interface, every collection will have the following endpoints:

method endpoint description
POST /users/login expects JSON in the message body. e.g. `{"email": "email@example.com", password: ""}
GET /:collection get an array of all documents in a collection
GET /:collection/:id get a specific document
GET /:collection/?query={..} get an array of documents matching the mongo query
GET /:collection/?query={..}&limit=10&offset=10&orderby={"meta.created":1} same as previous, but with targeted output control and sorting
GET /:collection/?query={..}&page=1&pageitems=10 similar to previous, but with pagination support
GET /:collection/?query={..}&page=1&pageitems=10&pagemetadisable=1 same as previous but slightly faster and with less pagination detail
GET /:collection/?query={..}&fields={..} the fields param can be used to do a mongo projection to request only specific fields
GET /:collection/?fieldname=value get an array of documents matching with the specified values. See node-mongo-querystring for details.
GET /:collection/schema get the collection schema
POST /:collection/ create a new document, the message body should be the JSON document
PUT /:collection/:id replace the document with id. The message body should be the JSON document. If the _id in document is different (the old document _id is deleted and a new one with id is created.)
POST /:collection/:id/update modify the document with id using a mongo update query. The message body should be the update query
DELETE /:collection/:id delete the document

Supported Data: Only standard JSON (strings, numbers, booleans, null) is supported. Dates can be stored as strings using ISO 8601

Documentation

Folder Structure

The Expressa configuration is in a folder called "data" in your project. There is a subfolder for the collections that you choose to persist to disk. By default, the following will be added once you finish the installation.

folder purpose
data/settings Config file per environment. Can include custom variables specific to your project.
data/role List of roles in the permission system. Defaults to "Admin", "Anonymous" and "Authenticated".
data/collection JSON Schemas and settings for each collection.

Note: The files in these data folders are JSON so they can be manually updated or you can edit them in the Admin UI. Generally these files should be checked into version control.

Admin UI Examples/Screenshots

Expressa ecosystem

  • expressa-folder easily extend expressa collections with ORM-ish js-code (get.js/post.js/functions.js/etc) & setup sub-endpoints
  • expressa-swagger middleware to generate online api documentation
  • expressa-client middleware to generate browser REST-client (+nodejs client)
  • expressa-cli commandline interface for expressa

Roadmap

  • Automatic GraphQL Support
  • JWT token expiration
  • Support cookie based authentication as well
  • File uploads

Alternatives

Expressa is not primarily built for simple blog websites or mostly static content websites. For those a cms like Keystone.js and enduro.js could work or maybe you could build you site with a static site generator like Hugo. For database-driven websites that need a strong CRUD backend where you want a clear separation between the frontend and backend, expressa.js is a great choice.

Changelog

Version Important Changes
0.5.3 Fixes bug in install where enforce permissions wasn't activated. Fixes CSV download.
0.5.2 Fixes bug when installing super user in Admin tool
0.5.1 Includes built Admin UI in npm package
0.5.0 Migrates server to use async/await. New Admin UI built with Vue.js. Adds request-id headers
0.4.6 Fix some errors in the install process when choosing to store users in mongo or postgres
0.4.5 Security update
0.4.1 db.create (postgres) now returns the id instead of the full document.
0.4.0 Pagination now starts with page 1. Delete requests can no longer bypass rejections by listeners. Updated permission error codes/messages. Error responses now always json (with an "error" field explaining) PUT /collection/:id response changed to match POST /collection
0.3.3 Fixes security vulnerability with the "edit own" permission and the :collection/:id/update endpoint. Update immediately.
0.3.2 Pagination is now supported by specifying the "page" and "limit"
0.3.1 Makes "development" the default settings file instead of "production". Use NODE_ENV environmental variable to change this. To quickly migrate, just rename your settings file to "development".

Inspired by

Comments (0)

Please login to join the discussion on this project.

Expressa Reviews (0)

Overall Rating

None

based on 0 ratings

Please login to review this project.

No reviews for this project yet.

↑ back to top

pCloud Lifetime

Popular Projects

FluxBB

in Social Networks and Forums
 33k    0    0    0  

Nextcloud

in File Transfer & Synchronization
 20k    1    1    0  

Libreddit

in Social Networks and Forums
 7k    0    1    0  

Dashboard

in Personal Dashboards
 6k    0    0    0  

Audiobookshelf

in Audio Streaming
 5k    0    1    0  

CasaOS

in Self-hosting Solutions
 5k    0    0    0  

Mediagoblin

in Photo and Video Galleries
 4k    0    0    0  

Most Discussed

Nextcloud

in File Transfer & Synchronization
 20k    1    1    0  

Tube Archivist

in Automation
 3k    0    1    0  

OneDev

in Project Management
 2k    0    0    0  

iodine

in Proxy
 2k    0    0    0  

Alf.io

in Booking and Scheduling
 2k    0    0    0  

sysPass

in Password Managers
 1k    0    0    0  

Misskey

in Social Networks and Forums
 2k    0    0    0  
Linux VPS from $11/yr.
RackNerd VPS for $11.38/mo

Top Rated Projects

Gitea

 1 rating
in Project Management

Bagisto

 1 rating
in E-commerce

LinkAce

 1 rating
in Bookmarks and Link Sharing

Pydio

 1 rating
in File Transfer & Synchronization

Audiobookshelf

 1 rating
in Audio Streaming

Nextcloud

 1 rating
in File Transfer & Synchronization

Seafile

 1 rating
in File Transfer & Synchronization

Categories

You May Also Be Interested In

Pagekit logo
Pagekit cover

Pagekit

New modern CMS to create and share.

Strapi logo
Strapi cover

Strapi

The most advanced open-source Content Management Framework …

Rapido logo
Rapido cover

Rapido

Create your website with Rapido. Edit, publish and share co…