Search Results for "psql"

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases! usql provides a simple way to work with SQL and NoSQL databases via a command-line inspired by PostgreSQL's psql. usql supports most of the core psql features, such as variables, backticks, and commands and has additional features that psql does not, such as syntax highlighting, context-based completion, and multiple database support. Database administrators and developers that would prefer to work with a tool like psql with non-PostgreSQL databases, will find usql intuitive, easy-to-use, and a great replacement for the command-line clients/tools for other databases.

pgzx is a PostgreSQL CLI tool built in Zig for faster, modern command-line interaction with PostgreSQL databases. It aims to be a faster and safer alternative to psql, with a clean interface and additional productivity features. pgzx is a promising experimental tool for developers who frequently work with Postgres via the terminal.

...To enhance the Firebird functionality, IBSurgeon has sponsored the development and now released for public use the free open source "IBSurgeon Full Text Search UDR" to perform full-text search queries within SQL and PSQL. UDR works with Firebird 3 and 4, for Windows, there are ready-to-use binaries, for Linux, it is necessary to build the UDR. The UDR is based on Lucene++ engine, with all the powerful features required for full-text search and with very fast performance (build as native C++ library). The Firebird Project is a commercially independent project of C/C++ programmers.

pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster performances. It is divided in two parts, a collector used to grab statistics on the PostgreSQL cluster using psql and sar, a grapher that will generate all HTML and charts output.

Now also living on gitlab. https://gitlab.com/mds-/xplordb Mineral Exploration Database template/ system for Postgres/PostGIS and QGIS. The project incorporates import scripts, data storage, validation, reporting, 3D drill trace generation and more. psql, pgAdmin and QGIS are the suggested database and GIS front-end programs.

Scripts for many popular DevOps technologies, see Inventory below for more details. Advanced configs for common tools like Git, vim, screen, tmux, PostgreSQL psql etc. CI configs for most major Continuous Integration products (see CI builds page) CI scripts for a drop-in framework of standard checks to run in all CI builds, CI detection, accounting for installation differences across CI environments, root vs user, virtualenvs etc. API scripts auto-handling authentication, tokens and other details to quickly query popular APIs with a few keystrokes just supplying the /path/endpoint. ...

jydbconsole is a database console inspired by psql - terminal-based front-end to PostgreSQL. Is written in jython and uses JDBC drivers to talk to databases, uses terminal console (unix only) or java swing as an user interface.

...I am using this utility to import astronomical catalogs provided as flat tables at CDS ftp-server into postgresql; Build: $ make all [cc={icc|gcc}] Install: $ make install [prefix=/path/to/your/bin/directory] Example of usage: $ gzip -dc table.dat.gz | fw2csv --stops=4,10,11,20,30,36 -d '|' -header 1 | psql wsdb -c "copy mytable from stdin with csv delimiter '|'" For the list of available options call $ fw2csv --help

FasterZip PostgreSQL Loader - ETL for postgresql FasterZip PostgreSQL This is a Java application that lets you filter the information into a file before loading using a copy (psql does not require). Use a configuration file for the data connection to the db, source file and special parameters. You can make SQL (using HSQL) the source file, allowing the transformation of data prior to loading. Can run on any OS that use Java without needing to install any additional components (other than the JRE course) To make SQL on the source file, keep in mind: 1) The file will be played under the name "origin" 2) If the option encCol1era, not in the configuration file or encCol1era = 0, the columns are automatically named file like this: col1, col2, ... coln, and the SQL touches take these names. ...

I really hate that braindead sqlplus and really love psql. Unfortunately I have to work with Oracle, so I wrote psql for Oracle. It's written in Java, and uses GNU readline library.

PgWorksheet is a simple GUI frontend to PostgreSQL for executing SQL queries and psql commands without using the psql command line tool. Please see the project home page for bug reports, forums and installation instructions.

Basic PostgreSQL client applications for Windows. It includes native win32 SQL terminal and backup tools, psql and pg_dump with gzip, for execution of SQL scripts and access to PostgreSQL servers remotely by administrators and end users.

Ligthweight Qt replacement for the "psql" utility in the PostgreSQL database server package.