It is only visible to and accessible by account administrators.Įach record contains an event of one of the following types:Īll data source activity including query executions, imports, and exports is saved to the activity feed.Īccount administrators can search the activity by a date/time range, user, data source, or by full text search on the actual query text that was executed. The activity feed is a central log of all data source activity, and consists of a table of records ordered by time. However, we also provide an audit log of all usage and activity that occurs through JackDB. You can always monitor your database activity logs and view the usage statistics that are collected by your database.
JACKDB DOCS LICENSE
gitignore LICENSE README.md init.rb README.md JackDB Heroku Plugin Extends heroku command-line to query and visualize Heroku data sources on JackDB.
JACKDB DOCS SOFTWARE
Monitoring all usage and data source activity SAAS Database / INDUSTRIES / Analytics Software / JackDB / FUNDING / TEAM / CUSTOMERS / BOARD-MEMBERS / COMPETITORS J FOUNDED 2014 Top JackDB Alternatives, Competitors & Similar Software Looking for alternatives and similar software to JackDB Find 20 competitors in the Analytics Software. 31 commits Failed to load latest commit information. History is available to all users as part of unified search. It is only visible to and accessible by you.Įach record contains an event with the following information:Įach record also contains useful query information: Your history is an unlimited history of all your queries, and consists of a table of records ordered by time.
JACKDB DOCS DRIVER
Use of this plugin with JackDB's services shall be subject to the Terms of Service.This feature is only available in JackDB Enterprise. On Fri, at 14:04, Sehrope Sarkuni <> wrote: When auto commit is diabled and using a non-zero fetch size, the pgjdbc driver creates a portal to read the query results from the server in chunks of fetch size. This section is a guide to best practices for security and data access with JackDB.This plugin is released under the MIT license. If you receive this error then try running the plugin command again and it should work. The connection tokens expire after a couple of minutes (currently five) and the server rejects connection attempts for expired tokens. See here for more on how JackDB handles security. Is it secure?Īll data transfer is done using SSL and the encryption key to decrypt your data source configuration is not persisted anywhere on the JackDB server. JackDB works entirely in your web browser. No attempt to connect to your data source is made until after you log in and open the URL in your browser. If your browser does not open automatically, the URL is also printed. If not, then you'll be sent to the login page. If you're already logged into JackDB, then we'll immediately connect you to your data source. The encryption key used to encrypt your database configuration details is not saved by JackDB, and is only sent in response to the plugin's POST request.įinally, the plugin then generates a URL to log in directly to JackDB using the token from the previous step and opens using your default web browser. Returns back a signed token containing the encryption key and id.Saves the encrypted database configuration details, keyed by the id.Encrypts the data source config information with the key using AES-256-CBC.Generates a unique random id for the request.
JACKDB DOCS CODE
JackDB offers everything you need in a database client: syntax highlighting and code formatting as well as intelligent autocompletion. Then, if the plugin finds a valid database configuration, it sends a POST request to JackDB with the config information for your database. Database Software JackDB JackDB Reviews Pricing Starts At: 49 per user per month Alternatives Claim this Product page JackDB Description A fully interactive SQL editor allows you to create and execute queries. The plugin's other commands change where to look for a database configuration and what type of configuration to look for. By default, the plugin attempts to get configuration details for the PostgreSQL database in the Heroku configuration property DATABASE_URL. How does it work?įirst the plugin identifies the database to connect to. The companys platform provides tax and legal advisory services, enabling small and medium enterprises to automatically generate documents and forms to.
JackDB connects directly to your database so it's not currently possible to reach databases that are behind a firewall. Can I use this with a database running on my local machine or network? If your database is behind a firewall, you will need to open up the appropriate ports to allow JackDB to access it. The plugin has been tested with Heroku Postgres and ClearDB MySQL and works without any additional setup with both. Let us know what data sources you'd like us to support next. We're working on adding support for additional data sources. Can I use this for other types of databases? JackDB supports a number of other data source types. The JackDB Heroku plugin currently supports PostgreSQL, MySQL, MariaDB, and Oracle RDBMS databases.
0 kommentar(er)
