Hi everyone!
DB-related workflow can rapidly eat up time as the complexity of
projects grows. Tracking details and structures gets harder and the
risk of missing an issue that could affect architecture or data
structure dependencies increases. The result is undermined
performance, hours wasted on debugging or catastrophic failures like
data leaks and security flows.
With that in mind, we developed Holistic (holistic.dev) – an online
static SQL code analysis tool for PostgreSQL. Holistic is automatic
(less than 10 minutes to set up), safe (no direct DB connection or
access to user data by design) and comprehensive (proprietary corpus
of recommendation rules).
More than 200 DB architects and administrators, data engineers,
analysts and product managers currently use it to detect database
performance issues, reduce infrastructure costs, eliminate errors,
prevent data leakage and security issues.
See the demo (holistic.dev/playground) and sign up to start working
with Holistic now – it’s in FREE (no hidden costs, upsales or quotas)
public beta. Onboarding is easy:
1. Sign up (app.holistic.dev) and get the holistic.dev API key in the
client area. See more: app.holistic.dev/settings.
2. Create new project in the client area.
3. Import your database schema (DDL, without entries or contents) in
SQL format and upload it to your project. See more:
docs.holistic.dev/#extract-ddl-from-database
4. Activate internal DB tools (docs.holistic.dev/#pg_stat_statements)
for queries monitoring (pg_stat_statements or slow query log) on the
server with the database you want to monitor (cloud/on-premise).
5. Create a cron job (docs.holistic.dev/#pg_stat_statements) that will
regularly upload queries to our holistic.dev API.
6. You'll get a list of query issues as soon as they're processed in
the client area (app.holistic.dev).
Done!
We would really appreciate your comments, questions or feedback at
info@holistic.dev.
Thanks,
Holistic Team