{"id":42841,"library":"hapiest-mysql","title":"hapiest-mysql","description":"A wrapper around the mysql package that provides a more descriptive and fluent way of running queries, designed for use with hapi.js applications. Version 0.0.51 is the latest stable release, but the package appears to be in early development with no recent updates. It differentiates by offering a promise-based query builder, but lacks thorough documentation and has minimal adoption compared to more robust ORMs like Sequelize or TypeORM.","status":"deprecated","version":"0.0.51","language":"javascript","source_language":"en","source_url":"https://github.com/jonathan-fulton/hapiest-mysql","tags":["javascript","hapi.js","hapiest","mysql"],"install":[{"cmd":"npm install hapiest-mysql","lang":"bash","label":"npm"},{"cmd":"yarn add hapiest-mysql","lang":"bash","label":"yarn"},{"cmd":"pnpm add hapiest-mysql","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core dependency for MySQL database connectivity","package":"mysql","optional":false}],"imports":[{"note":"Package may not export default correctly; check for CommonJS compatibility.","wrong":"const HapiestMySQL = require('hapiest-mysql').default","symbol":"default","correct":"import HapiestMySQL from 'hapiest-mysql'"},{"note":"Package is CommonJS, so require is preferred. Named export may not exist.","wrong":"import { HapiestMySQL } from 'hapiest-mysql'","symbol":"HapiestMySQL","correct":"const { HapiestMySQL } = require('hapiest-mysql')"},{"note":"Parent mysql package uses CommonJS; import default works in ES6.","wrong":"const mysql = require('mysql').default","symbol":"mysql","correct":"import mysql from 'mysql'"}],"quickstart":{"code":"import HapiestMySQL from 'hapiest-mysql';\n\nconst config = {\n  host: process.env.DB_HOST ?? 'localhost',\n  user: process.env.DB_USER ?? 'root',\n  password: process.env.DB_PASS ?? '',\n  database: process.env.DB_NAME ?? 'test'\n};\n\nconst db = new HapiestMySQL(config);\n\ndb.query(`SELECT * FROM users WHERE id = ?`, [1])\n  .then(results => console.log(results))\n  .catch(err => console.error(err));\n\ndb.close();","lang":"javascript","description":"Demonstrates basic setup and query execution using hapiest-mysql with promise-based API."},"warnings":[{"fix":"Consider migrating to mysql2 or sequelize.","message":"Package is no longer actively maintained; use at your own risk.","severity":"deprecated","affected_versions":">=0.0.1"},{"fix":"Pin to specific version and test thoroughly.","message":"API may change without notice; version 0.x indicates unstable API.","severity":"breaking","affected_versions":">=0.0.0 <1.0.0"},{"fix":"Create a .d.ts file or use @types/mysql for basic types.","message":"No type definitions provided; TypeScript users need custom type declarations.","severity":"gotcha","affected_versions":">=0.0.0"}],"env_vars":null,"search_vec":"'0.0.51':28 'adopt':64 'appear':37 'applic':26 'around':6 'base':54 'builder':56 'compar':65 'descript':14 'design':21 'develop':42 'differenti':48 'document':60 'earli':41 'fluent':16 'hapi.js':25,75 'hapiest':2,76 'hapiest-mysql':1 'javascript':74 'lack':58 'latest':31 'like':70 'minim':63 'mysql':3,8,77 'offer':50 'orm':69 'packag':9,36 'promis':53 'promise-bas':52 'provid':11 'queri':20,55 'recent':45 'releas':33 'robust':68 'run':19 'sequel':71 'stabl':32 'thorough':59 'typeorm':73 'updat':46 'use':23 'version':27 'way':17 'wrapper':5","created_at":"2026-06-05T16:56:55.554848+00:00","updated_at":"2026-06-05T16:56:55.554848+00:00","problems":[{"fix":"Run npm install hapiest-mysql@0.0.51","cause":"Package not installed or not in node_modules.","error":"Cannot find module 'hapiest-mysql'"},{"fix":"Use const HapiestMySQL = require('hapiest-mysql').HapiestMySQL;","cause":"Incorrect import style; package may not export default.","error":"HapiestMySQL is not a constructor"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/jonathan-fulton/hapiest-mysql#readme","github":"https://github.com/jonathan-fulton/hapiest-mysql","docs":null,"changelog":null,"pypi":null,"npm":"hapiest-mysql","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}