Search Results for "sql sorting queries"

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

...ER Diagram visualization. SSH tunneling. Secure credential storage via OS keychain. Split view, saved queries, SQL dump/import, 10+ themes, customizable shortcuts. Hackable, extensible, and built for everyday SQL work. https://tabularis.dev https://github.com/debba/tabularis

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.

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.

Falcon is a free, open-source SQL editor with inline data visualization. With Falcon you can connect to your database in the Connection tab, run SQL queries in the Query tab, then export your results as a CSV or open them in the Chart Studio to unlock the full power of Plotly graphs. 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.

...This is why most of the universities have Relational Algebra as an integral part of their database management courses. But unfortunately, most of the traditional relational DBMS software tools support Structured Query Language (SQL) only. For a student it is very difficult to know whether a relational algebra query written on paper is correct or not. Also as an instructor it is difficult to evaluate an innovative relational query because same result can be gained by different ways. Springbok is a free (non-commercial) educational tool to execute/validate relational algebra queries. ...

Simple SQL query tool that allows to connect to MSSQL and MySQL servers and MS Access files. A form of linking queries is possible and showing result in a map or in a chart is build in.

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

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.

A small .NET application that allows you to connect to the Microsoft Access database files (*. mdb) and execute SQL-queries to them. More information in russian can be fount here - http://2lx.ru/2009/02/mdb-sql-client/

SQL-Kitten is a generic sql client written in Java that can be used to connect to any jdbc compliant database. Some features are: Run SQL queries, Search within resultsets, Easy insert/update/delete, insert/update CLOB and BLOB datatype

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.

Currently dead. Web-based SQL client that can connect to any number of databases using JDBC. Provides a clean, simple and fast interface using HTML and Javascript to make it very easy to run common SQL queries. Faster than your average Swing-based client

JSQL Edit is a database-independent SQL client that allows graphical manipulation for making queries to databases. JSQL Edit is written in Java and uses JDBC for connectivity and Java Swing for a graphical user interface.

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