Search Results for "postgresql"

...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.

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.

dblab is a fast and lightweight interactive terminal based UI application for PostgreSQL, MySQL and SQLite3, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. dblab was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL/MySQL/SQLite3/Oracle/SQL Server databases.

1. Developed by pure java 2. Customrized for PostgreSQL 3. Support multi-language 4. Use pg JDBC driver for connection 5. Use swing components for GUI 6. Test with Jdk1.7 and 1.8 on windows and CentOS 6,7

JookDB is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, Oracle, PostgreSQL, SQLite, MongoDB,Redis, DM, OceanBase, TiDB and SQLServer databases from a single application. You can quickly and easily build, manage and maintain your databases.

DB Explorer is a powerful, cross-platform Java-based database query tool and explorer designed for developers, DBAs, and data analysts. It provides an intuitive GUI for connecting to multiple databases including PostgreSQL, MySQL, SQL Server, Oracle, SQLite and Dynamo DB along with support of connection any of database via Generic JDBC driver. Key features include real-time SQL execution with syntax highlighting, interactive schema browsing, result pagination with lazy loading, query export capabilities, and memory management controls including a garbage collection button. ...

Zora is an open-source automated testing framework designed specifically for testing database functionalities. It supports multiple database management systems including MySQL, PostgreSQL, and MongoDB. The framework provides a comprehensive suite of tests to ensure data integrity, reliability, and performance across different database types.

Tabularis is a free, open-source desktop database client for PostgreSQL, MySQL/MariaDB, and SQLite. Built with Rust and Tauri v2, it is fast, lightweight, and cross-platform (Windows, macOS, Linux). Features: SQL Notebooks with inline charts and cross-cell variables. AI-powered SQL assistant (OpenAI, Claude, Ollama, and more). Built-in MCP server for AI agent integration. Visual Query Builder with drag-and-drop JOINs.

tkDerm is a Tcl-based dermatological image database client for PostgreSQL. It relates data with photos automatically based on the time stamps of digital photos.

...It even has a single file compact version with full functionality, which you can quickly deploy on your server. Currently MyWebSQL supports working with MySQL, PostgreSQL and SQLite databases.

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.

...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.

The Hironico Db Tool is a graphical database client that can run on all major platforms today. It provides a powerfull, feature rich and user friendly set of tools to work with databases of any vendor using Java drivers while being fast & light.

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.

The scalable Java DB Client is a customizable java application where fields and general DB info is entered in a config file and the proper GUI is generated at run-time. Entries can then be added, and a final submit/update to the (PostgreSQL/MySQL) Databas