npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

opcrud-mysql

v1.0.2

Published

Documentation explains the use of the CRUD (Create, Read, Update, Delete) API built using Express.js to manage data in a database.

Downloads

6

Readme

This documentation explains the use of the CRUD (Create, Read, Update, Delete) API built using Express.js to manage data in a database. This API is designed to make it easier for developers to perform basic operations on the database via HTTP requests, allowing for more efficient and structured data management.

This API supports a variety of operations, including:

  • Creating new records in a database table.
  • Reading data from a table, including the ability to count the total records, search for data based on certain criteria, and get distinct (distinct) values.
  • Updating existing data based on ID.
  • Deleting records or tables that are no longer needed.

Key Features

  • CRUD Operations: Supports basic operations for data management, including creating, reading, updating, and deleting data.
  • Batch Operations: printing multiple records in a single request for greater efficiency.
  • Pagination: Organizing data in pages to make it easier to navigate through large results.
  • Search & Filter: Makes it easier to search data based on certain columns and search terms.
  • Grouping: Supports grouping data based on certain columns with aggregation functions.
  • Detail Joins: retrieves record details by combining data from multiple tables.
  • Retrieve Allowed Table Names: Retrieves permitted table names from the database to ensure that operations are performed on valid tables.
  • Table Name Validation: Validates table names before performing operations to ensure that the given table name is valid and does not cause errors in the database.

Prerequisites

Before using this API, make sure you have Node.js installed and have access to the database you want to manage. You will also need to adjust the database connection parameters in the code to match your system settings.

This API is designed for use in applications that require flexible and efficient data management. Please refer to the remaining sections of this documentation for more information on how to use each API endpoint.

Choose How to Use:

  • OpCrud/MySQL Version
  • OpCrud/Json Version