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@xxxxxxxxxxxx. Thanks, Holistic Team
