For more info see timestored.com/pulse
Pulse is an open source tool for real-time visual analysis, email reporting and alerting. It allows you to create and share real-time interactive applications with your team.
Pulse supports 40+ databases including kdb, postgresql, mysql, ms sql, clickhouse, proton. Databases that are wire compatible with postgres/mysql also work i.e. timescale, questdb, cockroachdb.
2023-08-18 - 1.50 - Open Sourced Version
2023-08-14 - 1.36 - Improve server tree listing for more databases.
2023-08-07 - 1.34 - Add variable formatters.
2023-08-01 - 1.33 - Support many more database integrations: clickhouse, mongodb, influxdb, SAP.
2023-07-19 - 1.10 - Add Redis support.
2023-07-15 - 1.09 - Bugfixes - Improve handling of illegal characters in dashboard URL, particularly saving.
2023-07-14 - 1.08 - Add date and time column formatters e.g. 14/07/2023 (Thanks CT).
2023-07-07 - 1.07 - Bugfixes - Improve date timezone handling consistency, particularly for kdb times.
2023-06-24 - 1.06 - Add experimental PulsePivot.
2023-06-09 - 1.05 - Add ChatGPT AI SQL generator.
2023-05-24 - 1.04 - Bugfixes - Table clicks faster and more accurate. _SD_BG mixed casing. (Thanks GD)
2023-04-27 - 1.03 - UI Improvements - Allow dragging components on. Show failing queries. (Thanks CA)
2023-04-26 - 1.02 - SQL Server JDBC driver upgrade to improve compatibility (Thanks EL)
2023-04-24 - 1.01 - First ever 1.0 release.
Stability improvements - Set max row limit on queries and notify user when reached.
Speed Improvements - Use smart caching to allow instant browsing of dashboards / connections.
A massive thanks to all those that helped us reach 1.0.
With the recent addition of Interactive Dashboards, Event Handlers and the numerous stability improvements, we've really reached a significant milestone. Pulse is solving the real-time interactive app problem that we initially saw quants and data analysts needing.
2023-04-19 - SQL Editor - Improved handling of very large queries and kdb specific results.
2023-04-05
Add Event Handlers to trigger queries and perform other actions in response to user interactions.
Display warning if backend data sources are slow returning queries.
2023-03-27 - Add User TimeZone Option. Allow author to toggle 1000s separator for numbers.
2023-03-21
Add REST API to allow setting servers dynamically using MASTER_API_KEY
Throttle dashboards if they are slow consuming messages
Add tooltips to ease onboarding new users
2023-03-14
Send websocket heartbeat to prevent timeouts
Add licensing, restrict free version to 3 users and 12 dashboards
2023-03-02 - Stability improvements for large dashboards.
2023-02-22
Interactive Dashboards
Chart Click Events
Table Click Events
2023-02-15
Add JQ in-memory.
2023-02-04
Add Metrics Panel Component
Move internal demo database to port 8999 to avoid overlap with clickhouse on 9000
2023-01-25
Add demos for Dynamic HTML Component
Bundle JRE with installer/zip to make it easier for windows users
Security - Java REST fetch falls back to curl in case java certs are missing
2023-01-16
Add Dynamic HTML Component
2023-01-03
Add Sparklines to Tables
2022-12-17
Improve administration. Add raw json, backup page and -vv very verbose mode.
2022-12-10
Add Dual Axis - Can have 2 Y-Axis and customize both.
2022-12-03
Add Grid Customization - Can add/remove preHeader/Footer/Pager/Filters. Allow setting frozen rows.
2022-11-28
Fix to allow running in subdirectory.
Form Improvements - Add submit button demo
2022-11-14
Enable column renaming
Allow Pulse to be hosted in website subdirectory. Useful for auth proxying.
2022-11-07
Ability to set Column formatting, chart colours etc. from the UI
Add search/filter for custom chart settings
2022-11-02
UI Niceties - Expand default pallette to 20 colours. Add 30 min / 2 hour refresh
Escape quotes / commas in data download
Customizeable Security
KDB Connections - Allow wrapping queries
Security - Support AuthProxy / Apache user authentication
2022-10-14
Reduce build size by removing external dependencies
Add "Add Server List" button to allow importing list straight from qStudio
Add Custom Security to allow REST/kdb configured authentication and authorization
Add YAML based configuration
2022-09-29
JDBC Driver Updates: MySQL/PostgreSQL/SQL Server
Bugfix: UI recovery in event of bad streaming query
Quicker Startup
Increase size of SQL query supported to 10MB
2022-09-28
UI Improvements
Added 3 Chart Demo Dashboards
2022-09-26
Charts - Add horizontal bar chart and horizontal stack chart
Charts - Add Boxplot
Charts - Add 3D Bar Chart, 3D Surface
Charts - Add Sunburst and Tree
2022-09-22
Appearance - Various improvements and refinements to themes, forms, icons
Automatic screenshot generation
Add number/text filters to grid
Improved error handling to retyr charts when user requests or at regular intervals
Demos - Add demo queries for H2/KDB database for all chart types
Charts - Add multi-pie chart support
2022-09-08
Add Editor component that allows editing code or plain text and sending it as a parameter
Allow Dashboard/Widget custom user CSS
Forms - Date component suppoorts date/datetime single values and ranges
Forms - Add textfield/textarea component
Forms - Add submit button and allow delaying form submission unless button clicked
KDB - Improved display of nested types in table
2022-09-01
Improved support for kdb minute/second/date/time types
Allow authors and users to save dashboard parameters
SQL Editor - Allow sharing links
SQL Editor - Allow choosing chart type
Support custom JDBC drivers
Allow theme/css customization
Add new Code/Text input component
2022-08-24
Add demos: stream liquidity, TAQ, candlestick
Improve tooltip formatting, particularly decimal places shown
Improve QueryEditor layout and add chart icon
bugfix for headless JRE on linux
2022-08-16
Improve appearance, expand homepage
Add grid dark theme support
Add candlestick chart
2022-08-01
Add calendar chart type
2022-07-24
Add KDB Streaming Subscriptions
Add ability to set column formatter from context menu
Allow setting query refresh rates
2022-07-16
Add HTML component
Added default queries when new chart added
Reports - screenshot and HTML output can now run
Reports - Add HTML table to email
SQL Editor - Improved kdb support. Added console and list view for non-table objects
Form parameters now use {"{arg}"} and ((arg))
2022-07-08
Add Dashboard history tracking to allow quick restoration of old versions
Users can quick open favourite dashboards
Add User Analytics
Dashboard user arguments to URL allows bookmarking
Add User logins
Add reports / subscriptions CRUD
2022-07-01
Popouts which remember location
Table context menu allows excel/csv download
2022-06-01
Add Screenshot capability
Added SlickGrid table
Automated .exe installer
Added SQL editor.
Alpha Release
Dashboards - Ability to add charts/tables, save dashboards
Automated Continuous Integration