Their Side

Conversations with the most tragically misunderstood people of our time.

Listen

SQLite Request Logging

Checking out ServiceStack's new SQLite-backed Request Logs feature and enhanced log querying and filtering in the Admin UI

sqlite logging admin-ui api

This episode describes the new SqliteRequestLogger feature which uses SQLite databases to store logs of requests made to the web service. SQLite is chosen for its ability to create lightweight databases on the fly, enabling the storage of request logs without requiring an existing database infrastructure.

The logs are organized into monthly databases, allowing for easy archiving and efficient data analysis. It also introduces a new user interface for browsing and querying the request logs, replacing the traditional Logging UI with an AutoQueryGrid for more advanced filtering and sorting capabilities. This allows developers to gain valuable insights into the usage of their web services through these granular logs and monthly aggregate reports.

Getting Started​

Configure existing .NET 8 Projects to use the new SqliteRequestLogger by running:

x mix sqlitelogs