Allows remote access to MySQL databases running behind PHP enabled web servers A RazorSQL MySQL PHP Bridge for connecting to MySQL databases via a PHP page.TAGS: sql, database, query, tool, editor, client, gui, front end, database navigator, database browser, ODBC, JDBC, Oracle, MySQL What's New: Minor enhancements and bug fixes. Also included are a query builder, tools for creating, editing, and executing stored procedures, triggers, and functions, a tool to compare table data and/or query results, and SQL history. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects tools for importing and exporting data a database browser for the viewing of database objects and structures and a robust programming editor with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and twelve other programming languages. RazorSQL ships with a built in relational database engine that is up and running out of the box and requires no end user administration. Any other JDBC or ODBC (Windows only) compliant database is also supported. RazorSQL is a SQL database query tool, SQL editor, database browser, and administration tool with support for over 40 databases and built in connection capabilities for Access, Cassandra, DB2, Derby, DynamoDB, Firebird, HSQLDB, H2, Informix, Microsoft SQL Server, MariaDB, MongoDB, MySQL, Oracle, Pervasive, PostgreSQL, Redshift, Salesforce, SimpleDB, SQL Anywhere, SQLite, Sybase, and Teradata. You can export data from a DynamoDB table in different file formats (CSV, XLSX, XML, JSON, etc,) or export data directly to another table.RazorSQL - SQL database query tool, browser, and editor that supports all major databases You can also use JSON requests syntax to query documents. You can use the WHERE clause in the same fashion as in regular SQL in order to find or filter documents. Double-click on a document to activate the editor.ĭBeaver supports simple SQL dialect for DynamoDB. You view, search and edit JSON documents. You can use data filters in order to find documents. You may need to switch to the "Data" tab.ĭBeaver converts DynamoDB documents into a table format by default, but you can switch to another data representation. You can open table editor and see the table data. Each table may have its own set of attributes and sub-attributes. Table has primary attributes (a kind of primary key) and indexes.ĭynamoDB is a document-oriented database. Basically, you can only access Table and Global tables. Database navigationĭynamoDB has a simple metadata structure. Press "Test Connection" to validate your connection settings. You account must be added to the whitelist in the 3rd party account. This role will be used for permission management. DynamoDB exists in all available regions in your AWS account but the tables are different.ĪWS Access Key and Secret Key are used for authentication.įor 3rd-party account access you must specify the 3rd party account ID (12-digits number) and the 3rd party role name. Table data edit in document (json) modeĭBeaver supports AWS Cloud and Standalone versions of DynamoDB.įor standalone server you need to enter endpoint (http or https URL).įor cloud server you must enter the AWS region.Connecting to Oracle Database using JDBC OCI driver.Installing extensions - Themes, version control, etc.
0 Comments
Leave a Reply. |