Data

Tools

Indexes

Applications

Experiments

Open Source Science

https://github.com/cedrickchee/painless-pg-node

Painless PostgreSQL Node.js backend with Objection + Knex + Express

https://github.com/cedrickchee/painless-pg-node

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Committers with academic emails
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (7.1%) to scientific vocabulary

Keywords

api-server expressjs expressjs-boilerplate nodejs-backend objectionjs postgresql

Keywords from Contributors

projection archival interactive generic sequences genomics observability autograding hacking shellcodes
Last synced: 5 months ago · JSON representation

Repository

Painless PostgreSQL Node.js backend with Objection + Knex + Express

Basic Info
  • Host: GitHub
  • Owner: cedrickchee
  • Language: JavaScript
  • Default Branch: master
  • Homepage:
  • Size: 878 KB
Statistics
  • Stars: 4
  • Watchers: 2
  • Forks: 0
  • Open Issues: 6
  • Releases: 0
Topics
api-server expressjs expressjs-boilerplate nodejs-backend objectionjs postgresql
Created over 5 years ago · Last pushed about 3 years ago
Metadata Files
Readme

README.md

Painless Node.js API with SQL Database

A minimal scaffold project that shows how to painlessly build a robust API with SQL database on Node.js.

What's included

  • node-postgres - Node.js modules for interfacing with PostgreSQL database
  • Knex.js - SQL query builder
  • Objection.js - An SQL-friendly ORM built on Knex for Node.js
  • Express.js - Web framework for Node.js. A myriad of HTTP utility methods for creating API easily.

What does it do

It provides a simple idea/comment database and shows how relation can be modelled with Objection Model class. It also shows how to use eager loading to get related queries.

Development

  • Clone this repo: git clone https://github.com/cedrickchee/painless-pg-node.git
  • cd painless-pg-node
  • npm install to install required project dependencies.
  • Modify database connection according to your machine in knexfile.js.
  • Run it:
    • npm start to start the production server.
    • npm run dev to start the development server.
  • Point your browser to http://localhost:3000/ideas to test if it's working.

Owner

  • Name: Cedric Chee
  • Login: cedrickchee
  • Kind: user
  • Location: PID 1
  • Company: InvictusByte

Lead Software Engineer | LLMs | full stack Go/JS dev, backend | product dev @ startups | 🧑‍🎓 CompSci | alumni: fast.ai, Antler.co

GitHub Events

Total
Last Year

Committers

Last synced: 8 months ago

All Time
  • Total Commits: 46
  • Total Committers: 2
  • Avg Commits per committer: 23.0
  • Development Distribution Score (DDS): 0.217
Past Year
  • Commits: 0
  • Committers: 0
  • Avg Commits per committer: 0.0
  • Development Distribution Score (DDS): 0.0
Top Committers
Name Email Commits
Cedric Chee c****c@i****m 36
dependabot[bot] 4****] 10
Committer Domains (Top 20 + Academic)
invictusbyte.com: 1

Issues and Pull Requests

Last synced: 10 months ago

All Time
  • Total issues: 0
  • Total pull requests: 18
  • Average time to close issues: N/A
  • Average time to close pull requests: about 1 month
  • Total issue authors: 0
  • Total pull request authors: 1
  • Average comments per issue: 0
  • Average comments per pull request: 0.11
  • Merged pull requests: 10
  • Bot issues: 0
  • Bot pull requests: 18
Past Year
  • Issues: 0
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
Pull Request Authors
  • dependabot[bot] (18)
Top Labels
Issue Labels
Pull Request Labels
dependencies (18)