Search Results for "pl/json"

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

DB Explorer is a free, cross-platform database query tool and schema explorer built for developers, DBAs, and data analysts. It provides a clean graphical interface for connecting to multiple database systems, writing and executing SQL, exploring schemas, monitoring database health, and generating SQL queries using AI — all from a single application. Supported Databases: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, Amazon DynamoDB, and any JDBC-compatible database.

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. Plugin system to add any database driver. Monaco-based editor with...

Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start. Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples

...Features - Both mongodb:// and mongodb+srv:// connections are supported - Adding, removing and reordering connection strings - Naming connection strings - Auto reconnecting - Creating and deleting collections - Number of documents can be seen in each collection tile - Find queries are supported in json format - CRUD operations are supported - On listing page; documents are represented in expandable tree format - On editing page; documents are represented in json string format - Custom json encoding / decoding - Dark mode support

In your job, do you have queries that you are running regularly and sometimes you need to share those to non-technical people? Now you can do with your personal SQL Servant. Just configure and test it, if all is good distribute it. Those people doesn't need to have any fancy licensed SQL client.

...The application is a combination of a Java based multi-threaded webserver and HTML and Java Script. The major technology used comprises : Java, jQuery, jQuery UI, jqGrid, XML, JSON, Ajax and JDBC. WSQLC’s main components are the WSQLC server and dynamically created HTML pages. 27-May-2012 : Release 1.0 code and manual available

Vela is a Open Source SQL and PL/SQL client software for Oracle database with a graphical user interface developed using Java Swing. It is a Front-End tool for a Oracle developer. It supports most of the common developer tasks.

Quality Assurance & Control database client server system. Postgresql server, C# clients, web php interface. All strategies are ISO 9001: 2000 compliant.Solve almost all traceability requierements.

Built for power and simplicity, Saltwater SQL Client allows the experienced Oracle Guru to perform magic, yet is simple enough for a novice to use. Features: PL/SQL, CLOB tools, import/export, table edit, data dictionary, multiple connections/queries