Skip to content

1.0.0-beta

Choose a tag to compare

@JasminDreasond JasminDreasond released this 03 Jul 15:43
· 27 commits to main since this release

🚀 v1.0.0-beta · First public beta release

This is the first public beta release of PuddySQL 🎉 — a fully customizable SQL engine for Node.js, designed to simplify advanced search, tag filters, and structured queries.

Below is a summary of the key changes and features in commit-style format:


✨ Features

  • 🎮 PuddySql.Instance class for PostgreSQL and SQLite3 engines
  • 🏷️ Built-in Tag System with support for AND, OR, NOT, boosts, and wildcards
  • 📦 Powerful .search() and .find() methods with advanced filtering and pagination
  • 🛠️ Custom JOIN parser supporting raw strings, objects, or arrays
  • 📑 Select generator supporting arrays, strings, objects, and boost logic
  • 📁 initTable() utility to create and manage structured table definitions
  • 📚 Built-in getAll, getAmount, set, delete, advancedDelete, and more
  • 🔍 Nested QueryGroup logic with AND/OR groupings and condition trees
  • 🔐 Input sanitization and placeholder binding for secure queries
  • 🧩 Utility modules (Utils, Events, etc.) to support extensions and debugging

🧪 Testing

  • ✅ Full playground demo included at /test/index.mjs
  • 🏷️ Extensive tag filter scenarios tested: inclusion, exclusion, boost, pagination
  • 🧹 Clean and reset logic verified across SQLite3 and PostgreSQL

🛠️ This is a beta release — APIs may change before 1.0.0 stable.
Issues and feedback are welcome! 💬

Full Changelog: https://github.com/JasminDreasond/PuddySQL/commits/1.0.0-beta