WITH...SELECT

support for SQL WITH...SELECT statements

Bugfix 10.1.1

FIxed issue with stored YADA_PAYLOAD query param.

CORS

YADA now supports CORS using a subclass of Jetty's AbstractHandler.

New Dawn

YADA 10 is a major, major, major overhaul.

Since there hasn't technically been a "release" since 2018, this note includes all the major features of YADA 9 as well. Numerous bug fixes are omitted from these notes. See the commit logs for details.

10.0.0

• Implementation of embedded Jetty: YADA can now be deployed as a standalone app, easily. A separate web application server like Tomcat is no longer needed. Along with the version 9.x upgrade from using a database to store YADA queries to using a local git repo, YADA is now compact and distributable. Future upgrades will enable load balancing, parallelization
• maven assemblies: maven builds are now enabled to create tar.gz files containing dependencies, properties, and an executable yada-api jar file
• improved exception handling: with jetty error handler
• added elapsed time metrics: json output now contains millisecond value indicating duration of YADA processing from request object creation to initial delivery in output stream
• removed most obsolete code: including yada-war module, admin tool, etc

9.x

• Support for SQL SELECT...VALUES joins
• Setting of default parameters in data source config files
• Support for JSON POST requests
• Error handling improvements
• Support for OAuth2 REST requests
• RDS (R Data file) support
• Removed depth limitations for FileSystemAdaptor
• Base64 conversion of output (to request images)
• JMESPath url parameter support (jf)

9.0.0 and previous

• Conversion of YADA Index to local git repo: YADA no longer requires a relational database.
• Security Upgrade: secure authentication, authorization, and identity management, including native argon2 hashing of locally stored credentials