Search Results for "sql table editor"

Redash is an essential tool to help you make sense of your data. It allows everyone, regardless of level of technical know-how to harness the power of data. SQL users connect, query, visualize and share data easily and efficiently, allowing everyone in their organization to use the data. Redash combines the power and comfort of an SQL client with the collaborative benefits of a cloud-based service. It lets you create big, beautiful and easy to digest visualizations on dashboards for...

...OmniDB is a browser-based tool, which means it can be accessed on any platform with the browser as a medium. It features a responsive, single-page interface, a unified workspace, a smart and beautiful SQL editor and more. It currently supports Windows, Linux and OSX platforms, and the following DBMS: PostgreSQL, MariaDB, Oracle, MySQL, SQLite (WIP), Firebird (WIP), SQL Server (WIP), IBM DB2 (WIP).

...Sample Usage: ```js var query_builder = require('query_builder'); var dbconn_default = { host : 'host', user : 'user', pass : 'password', dbase : 'database_schema' }; var qb = new query_builder( dbconn_default ); var select_details = { table : 'table_name', fields : [ 'field1', 'field2', ... ], conditions : { field1 : 'value1', field2 : 'value2' } }; qb.select( select_details, function( err, rows ){ if( err ) console.log( err ); else console.log( rows ); }); ``` By this, we can generate a query something like this: ```sql SELECT `field1`, `field2` FROM `table_name` WHERE `field1` = 'value1' AND `field2` = 'value2' ``` For more information, visit the github project. ...