Open Source Database Clients

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.

Basic types, integers, floats, string, bool, time.Time, net.IP, net.IPNet. All struct fields are nullable by default and zero values (empty string, 0, zero time, empty map or slice, nil ptr) are marshalled as SQL NULL. pg:",notnull" is used to add SQL NOT NULL constraint and pg:",use_zero" to allow Go zero values. sql.NullBool, sql.NullString, sql.NullInt64, sql.NullFloat64 and pg.NullTime. Structs, maps and arrays are marshalled as JSON by default. PostgreSQL multidimensional Arrays using array tag and Array wrapper. Hstore using hstore tag and Hstore wrapper. go-pg supports 2 last Go versions and requires support for Go modules. So make sure to initialize a Go module. ORM supports has one, belongs to, has many, and many to many with composite/multi-column primary keys. ForEach that calls a function for each row returned by the query without loading all rows into the memory.

This library is a 1 to 1 mapping of the Redis commands. Each Redis command is exposed as a function on the client object. All functions take either an args Array plus optional callback Function or a variable number of individual arguments followed by an optional callback. Node Redis currently doesn't natively support promises (this is coming in v4), however you can wrap the methods you want to use with promises using the built-in Node.js util.promisify method on Node.js >= v8. Care should be taken with user input if arrays are possible (via body-parser, query string or other method), as single arguments could be unintentionally interpreted as multiple args. Minimal parsing is done on the replies. Commands that return a integer return JavaScript Numbers, arrays return JavaScript Array. HGETALL returns an Object keyed by the hash keys. All strings will either be returned as string or as buffer depending on your setting.

Eclipse SQL Client for database querying/browsing any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2, MySQL, PostgreSQL, Sybase, Informix) and can be extended.

The interface supports drag and drop HTML components, javascript and scriptlet events, and generate a very fast code, with no additional softwares layers or libraries. You can put your libraries, like jQuery. The generated code works with all browsers. You can create and debug Applets or Java Swing applications easily with the Visual Editor of the tool. Build C++ applications.

This compiler is focusing on easy gui and databases. It's support PostgreSQL, MariaDB, SqLite, Odbc. It is running under Linux too (wine). OpenGL support (only 64 bits version), easy printer layout (non gui) and serial communication (demo is coming). I've been used it for a long time so it should be stabile (32 bits ver).

DBD2 inserts database records from TCP input. It is a companion project to Syslgod2 and an application in its own right. It ships with a backgrounding client for generic use. The client sends whatever information the user puts on the command-line to the back-end daemon via TCP. Upon successful transmission, the client exits. On failure, it backs off and retries until its life-time timer expires. The back-end daemon accepts data from Syslogd2 or its own client and inserts that data (and envelope information) into one or more databases using MySql client library or dbi drivers (also on SourceForge). The client needs no configuration (all input is via command-line). It is intended for hosts to make database entries without needing database client or interface code. Syslogd2 integration allows DBD2 to act as Syslogd2's database back-end for MySql and other databases supported by the dbi drivers. Original purpose was to track Linux cluster job status but other uses exist.

DBPad is a GUI-based SQL client for relational databases. As long as you have a JDBC driver for your DB, you can use DBPad to view or manipulate your data and metadata of your tables.

SDBC is a MS Access-like database client based on Java swing ui, able to connect to both local and network DBMS. It uses Derby for file-based database and JDBC for SQl-based DBMS.

lib4d_sql is a C library providing the required functions (connect, prepare, execute, ...) to write a SQL client for 4D databases. It uses the public 4D SQL protocol wich is supported by 4D products since... the version 11. It is already used by the PDO_

Visual SQL Builder is a graphical PostgreSQL client written in java that will allow users to Visually build a complete SQL statement, without typing any clause. Building complex SQL queries in an easy way, reducing debugging, syntax and logic errors.

Generic C++ SQL client wrapper over different SQL DB engines. Using a unified interface, it currently supports MySQL/MariaDB, ODBC, PostgreSQL and SQLite.

ioredis is a robust, full-featured Redis client that is used in the world's biggest online commerce company Alibaba and many other awesome companies. Full-featured. It supports Cluster, Sentinel, Streams, Pipelining and of course Lua scripting & Pub/Sub (with the support of binary messages). High performance. Delightful API. It works with Node callbacks and Native promises. Transformation of command arguments and replies. Transparent key prefixing. Abstraction for Lua scripting, allowing you to define custom commands. Support for binary data. Support for TLS. Support for offline queue and ready checking. Support for ES6 types, such as Map and Set. Support for GEO commands. Support for Redis ACL. Sophisticated error handling strategy. Support for NAT mapping. Support for autopipelining. ioredis supports all of the scripting commands such as EVAL, EVALSHA and SCRIPT.

Jisql is a Java based utility to provide a command line interactive session with a SQL server. It can connect to any database with a JDBC driver.

.Net-Control for PDF creation with dynamic Content. It includes a WYSIWYG-Editor to design the PDF-Documents and a Interface to Link SQL-Queries with Fields on the PDFs. Databases are Access(OleDb), MySql(-Client), MS Sql(-Client), all Odbc. Uses itext.