Skip to content

rSQL v1.2.0 - Enhanced SQL Parsing and Performance πŸš€

Latest

Choose a tag to compare

@rustyspottedcatt rustyspottedcatt released this 26 Dec 22:34
· 10 commits to main since this release

Get ready for a better rSQL experience! This update focuses on refining the SQL parsing capabilities, adding a robust grammar-based parser, and significantly improving overall performance.


New Features:

  1. YACC Module:

    • Added a new YACC.luau module for grammar-based SQL parsing.
    • Enables structured parsing of SQL commands into Abstract Syntax Trees (AST) for better query handling.
  2. SQLParser Enhancements:

    • Improved tokenization and syntax analysis to handle complex queries seamlessly.
    • Support for nested conditions, multi-column operations, and advanced SQL features.
    • Alot of bug fixing hours spent to fix annoying bugs.

Other Improvements:

  • Performance Optimization:

    • Faster SQL query processing by optimizing datastore read/write operations.
    • Streamlined normalization and parsing for reduced latency in data operations.
  • Improved Error Handling:

    • Clearer error messages with detailed tracebacks to simplify debugging.
  • Enhanced Query Validation:

    • Advanced lexical and syntax checks for stricter validation of SQL commands.

How to Upgrade:

  1. Download the Latest Version:
    Get it from the Releases Page.
  2. Replace the Old Version:
    Update the rSQL module files in your project directory.
  3. Enjoy Improved SQL Parsing:
    Start leveraging the new grammar-based parsing features and optimizations!

Changelog:

  • Introduced YACC.luau for recursive descent parsing of SQL tokens.
  • Refined SQLParser.luau with enhanced tokenization and grammar handling.
  • Significant performance improvements in datastore operations.
  • Enhanced error handling with detailed debugging information.