Search Results for "redshift"

Simple SQL Client for lightweight data analysis. You can share the result with gist. Supports MySQL, PostgreSQL (Amazon Redshift), SQLite3, Google BigQuery, Treasure Data, Amazon Athena. You can download and install from Web Site or Releases.

Beekeeper Studio is an open source, cross-platform SQL editor and database management app that is both powerful and easy to use. It lets you query and manage your relational databases, with support for connecting to SQLite, MySQL, MariaDB, Postgres, SQL Server and Amazon Redshift databases. Unlike most other open source SQL editors and database managers, Beekeeper Studio isn’t cluttered with unnecessary features, but does come with the essentials that you need. This includes SQL auto completion, sensible keyboard shortcuts, and the option to encrypt your connection with SSL. Beekeeper Studio is available for Windows, Linux and Mac.

Records is a Python library designed to make direct SQL querying convenient without introducing a full object-relational mapper. It supports relational databases including PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, and Amazon Redshift through SQLAlchemy. Query results are exposed as friendly Record objects whose fields can be accessed by attribute, key, or numeric index. Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can be converted into dictionaries or exported through Tablib to formats such as CSV, JSON, Excel, HTML, YAML, and Pandas DataFrames. ...

SQLTabs is a cross-platform SQL client built using Electron and Vue.js that offers a modern and intuitive interface for managing SQL databases. It supports multiple database types and allows users to run queries in tabs, explore schemas, and view results in a clean, responsive UI. SQLTabs is designed for developers and analysts who need a simple yet powerful tool for database interaction.

...Optionally, you can use Falcon as a middleman between plot.ly and your database - so that when your database updates, your charts and dashboards update as well. Currently, Falcon supports connections to RedShift, MySQL, PostgreSQL, IBM DB2, Impala, MS SQL, and SQLite. In version 2.0+, the app will now automatically generate an SSL. This may take several minutes! Falcon is open source and works without an internet connection or a Plotly Chart Studio account. The software works well and we hope you find it useful.