Redgate’s new SQL Monitor now ensures that DevOps teams can monitor and track deployments at all times.
Rockset announced the release of Query Lambdas, a capability that runs developers’ queries in response to events, enabling developers to build data applications faster.
Rockset, built by the team behind RocksDB and Facebook’s online data platform, is focused on increasing developer velocity for teams building modern data applications.
Rockset is a real-time database in the cloud that stores and indexes real-time data from transactional databases and event streams, with schema-free JSON documents and declarative SQL over REST. It is used for building applications that make intelligent decisions on real-time data.
Rockset with Query Lambdas allows developers to use their own data as an API to quickly build modern data applications.
Rockset launches revolutionary Query Lambdas for running developers’ queries in response to events, to include:
- Use APIs instead of client libraries: Query Lambdas allow developers to query their data without needing any special client-side software and without needing to establish and manage database sessions or connections. They can simply hit a REST endpoint to query real-time data.
- Store SQL text and parameter information: Query Lambdas can be created and updated using the Rockset Console or by using the REST API directly. Each Query Lambda is tied to a specific query text and parameter set, and developers can set default values for query parameters or make them mandatory for each execution.
- Expose a REST endpoint to execute underlying query: Each Query Lambda is exposed as its own endpoint, and as part of the creation process developers can specify parameters and optionally provide a default value. Once developers save a SQL/parameter pair as a Query Lambda, they can execute it through a REST endpoint from anywhere.
- Enforce version control: Each Query Lambda maintains a version history, so developers can collaborate with their teams to iterate faster. Any update to a Query Lambda automatically creates a new version, which allows developers to build and test changes without affecting production queries.
- Expose usage metrics and statistics: Each version of a Query Lambda tracks and exposes a number of execution metrics, including time of last execution, user ID associated, time of last execution error and associated error messages.
- Secure querying: Using Query Lambdas to build applications is more secure. Using an API key allows developer to avoid querying with raw SQL directly from application code thus avoiding SQL injection security risks.
“We created Rockset to be the ideal database to develop modern data applications, and Query Lambdas bring us closer toward that goal,” said Venkat Venkataramani, co-founder and CEO of Rockset. “Just as Function-as-a-Service frameworks like AWS Lambda offer developers a way to run code without managing any servers, Rockset’s Query Lambdas allow developers to execute queries from their applications without requiring knowledge of the underlying data infrastructure.”