Search Results for "ps-scripts"

ChartDB is a web-based database diagramming editor that allows users to visualize and design their database schemas with a single "Smart Query." It offers instant schema import, customization options, and the ability to export SQL scripts, all without requiring an account. ChartDB is ideal for developers and teams looking to streamline database design and documentation.

...If installed globally (with the -g option), you can run node-pg-migrate and if not, you can run ./node_modules/.bin/node-pg-migrate. Add "migrate": "node-pg-migrate" to scripts section of package.json so you are able to quickly run commands. Run npm run migrate create my first migration. It will create file xxx_my-first-migration.js in migrations folder. Now you should put your DB connection string to DATABASE_URL environment variable and run npm run migrate up. (e.g. DATABASE_URL=postgres://test:test@localhost:5432/test npm run migrate up).

...It allows you to easily build graphs and tables with data pulled from SQL databases, logging databases, metrics databases, HTTP servers, and all kinds of text and binary files. Need to join or munge data? Write embedded scripts as needed in languages like Python, JavaScript, R or SQL. All in one application. Build reports with graphs, charts and tables. Script against data. Cross-platform: Windows, macOS, and Linux. Easily fetch your data, wherever it is: 18 SQL and non-SQL databases, files, HTTP server. Over 20 supported databases out of the box including: PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, ClickHouse, Influx 1 (InfluxQL), Influx 2 (Flux), Prometheus, Elasticsearch, AWS Athena, Google BigQuery, Snowflake, Cassandra, Scylla, TimescaleDB, YugabyteDB, CockroachDB, CrateDB, QuestDB, and Airtable.