Skip to content

Roadmap

This is roadmap for the next-generation of the Spectrum project

  • Branding for Spectrum

  • Logo to represented for all branding

  • Iconic on both documentation and component

  • Intergrated with CDN bucket with related assets

  • Control Portal for user to handle all operation internals

  • Link to Paid Plan

  • Control the authentication process of users

  • Internal portal for news/change/update/issues

  • User component

  • Cache output with Redis

  • Add Trino for query plan for the database and decrease the latency

  • Hanlde background task with targeted engine

  • Research:

  • ratelimit with Open-Source component

  • Compress response output for fast return: starlette-cramjam

  • Support Web Sockets for transfer data method component

  • Ratelimit on specific rule with Cloud Armor

  • Add async query enhancement for async query and performance

  • Key Concept Wso2docs Key Concepts

  • [ROADMAP] Add documentation for public-developer component

  • [ROADMAP] Transfer all component in database into async level

  • For docs with async test

  • Build connection of database using async

  • Handle IO outside of component

  • Has performance test between the transfer

  • [SECURITY] Construct AUTHENTICATION on schema with support of Schema Usage Pattern from Postgres

  • [SECURITY] Construct the SSL context to connect the server more secure

Reference to Postgres 12 - libpq connect

sslcert
This parameter specifies the file name of the client SSL certificate, replacing the default ~/.postgresql/postgresql.crt. This parameter is ignored if an SSL connection is not made.

sslkey
This parameter specifies the location for the secret key used for the client certificate. It can either specify a file name that will be used instead of the default ~/.postgresql/postgresql.key, or it can specify a key obtained from an external “engine” (engines are OpenSSL loadable modules). An external engine specification should consist of a colon-separated engine name and an engine-specific key identifier. This parameter is ignored if an SSL connection is not made.

sslrootcert
This parameter specifies the name of a file containing SSL certificate authority (CA) certificate(s). If the file exists, the server's certificate will be verified to be signed by one of these authorities. The default is ~/.postgresql/root.crt.

  • Configure global parse dictionary from ORM using cursor

  • This can be handle by handle from the raw-engine, not from the sqlalchemy itself

Reference: