{"id":43863,"library":"spas-app","title":"SPAS (Single Page App w/ SQL)","description":"A React boilerplate for building single-page applications with MySQL and Sequelize ORM. Version 1.0.6 is the latest (and possibly only) release. It includes tools like AOS for animations, Radium for inline styles, React-Bootstrap for UI components, and React-Page-Scroller for page-like scrolling. The project is outdated and poorly maintained, using Create React App and lacking modern practices like TypeScript or proper testing. It requires manual MySQL setup and global installation of mysql. Key differentiators: pre-configured Sequelize models and seeds, but the project is largely a personal boilerplate with minimal documentation and no active development.","status":"abandoned","version":"1.0.6","language":"javascript","source_language":"en","source_url":"https://github.com/React-BP/SPAS-store","tags":["javascript"],"install":[{"cmd":"npm install spas-app","lang":"bash","label":"npm"},{"cmd":"yarn add spas-app","lang":"bash","label":"yarn"},{"cmd":"pnpm add spas-app","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"ORM for MySQL database interactions","package":"sequelize","optional":false},{"reason":"MySQL database driver required by sequelize","package":"mysql2","optional":false},{"reason":"Animation library used for scroll animations","package":"aos","optional":false},{"reason":"Inline CSS library for hover and media queries","package":"radium","optional":false},{"reason":"UI component library for styling","package":"react-bootstrap","optional":false},{"reason":"Enables page-like scrolling between sections","package":"react-page-scroller","optional":false}],"imports":[{"note":"Default export of the entire app, but it is not a library; it's a boilerplate. After install, you typically don't import from the package but run the project as a standalone app.","wrong":"const SPAS = require('spas-app')","symbol":"SPAS","correct":"import SPAS from 'spas-app'"}],"quickstart":{"code":"// This package is a boilerplate, not a library. To use, clone or install, then configure:\n// 1. Install dependencies: npm install (uses package.json)\n// 2. Configure MySQL connection in server/config.js with your password.\n// 3. Run schema: mysql -u root -p < server/schema.sql\n// 4. Seed database: mysql -u root -p < server/seeds.sql\n// 5. Start both servers: yarn start (runs react and mysql server via concurrently)","lang":"javascript","description":"Shows how to set up the SPAS boilerplate: install dependencies, configure MySQL, run schema and seeds, then start the development servers."},"warnings":[{"fix":"Install MySQL globally ('npm install -g mysql') and run schema.sql manually.","message":"Package requires global MySQL installation and manual schema/seeds setup. No automated database migration.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Consider migrating to modern Vite or Next.js setup.","message":"Built on Create React App which is deprecated. No updates since 2018.","severity":"deprecated","affected_versions":">=1.0.0"},{"fix":"Add dotenv and use process.env.DB_PASSWORD instead of hardcoded password.","message":"The config file expects a plain password in plaintext; no support for environment variables.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Run 'npm install' in both root and client directories. Manually check package.json for all dependencies.","message":"Instructions refer to 'sequelive' instead of 'sequelize' and missing 'npm i -S' may not install all deps.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.6':22 'activ':109 'anim':36 'ao':34 'app':4,67 'applic':15 'boilerpl':9,103 'bootstrap':43 'build':11 'compon':46 'configur':91 'creat':65 'develop':110 'differenti':88 'document':106 'global':83 'includ':31 'inlin':39 'instal':84 'javascript':111 'key':87 'lack':69 'larg':100 'latest':25 'like':33,55,72 'maintain':63 'manual':79 'minim':105 'model':93 'modern':70 'mysql':17,80,86 'orm':20 'outdat':60 'page':3,14,50,54 'page-lik':53 'person':102 'poor':62 'possibl':27 'practic':71 'pre':90 'pre-configur':89 'project':58,98 'proper':75 'radium':37 'react':8,42,49,66 'react-bootstrap':41 'react-page-scrol':48 'releas':29 'requir':78 'scroll':56 'scroller':51 'seed':95 'sequel':19,92 'setup':81 'singl':2,13 'single-pag':12 'spas':1 'sql':6 'style':40 'test':76 'tool':32 'typescript':73 'ui':45 'use':64 'version':21 'w':5","created_at":"2026-06-05T17:01:50.528895+00:00","updated_at":"2026-06-05T17:01:50.528895+00:00","problems":[{"fix":"Install MySQL globally: 'npm install -g mysql' or use your system package manager.","cause":"MySQL client is not installed globally or not in PATH.","error":"mysql: command not found"},{"fix":"Run 'npm install' in the project root directory to install all dependencies.","cause":"Dependencies not installed correctly.","error":"Error: Cannot find module 'sequelize'"},{"fix":"Run: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; or update mysql2 version.","cause":"MySQL 8+ uses caching_sha2_password by default, not supported by older mysql2.","error":"Unhandled rejection SequelizeConnectionError: Client does not support authentication protocol requested by server"}],"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/React-BP/SPAS-store#readme","github":"https://github.com/React-BP/SPAS-store","docs":null,"changelog":null,"pypi":null,"npm":"spas-app","openapi_spec":null,"status_page":null,"smithery":null,"categories":["devops","testing"],"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}}