Search Results for "import postgresql"

Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

MyWebSQL is a web based WYSIWYG Database client written in PHP. It has a simple and intuitive interface with the look and feel of a desktop application, and offers rich features for database management. No installation is needed, just download, extract and you are ready to go. 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.

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.

SQLeo is a professional lightweight SQL Query tool that permits to create or display complex sql queries (from OBIEE, Microstrategy, SSRS, Cognos, Hyperion, Pentaho ...) and permits to reverse engineer database models as db designers do. This SQL GUI supports all JDBC drivers: Oracle, MySQL, MSSQL, Firebird, HSQLDB, H2, PostgreSQL, CsvJdbc, SQLite, UCanAccess, MonetDB ... (but MySQL jdbc and CsvJdbc are the only driver included in the package) Can be compared with : FreeQueryBuilder...

PgDBF is a program for converting XBase databases - particularly FoxPro tables with memo files - into a format that PostgreSQL can directly import.

Fixed width data files are probably the most annoying data to import into database. This utility allows user to insert user-defined column separators into user-defided positions of flat file table given in fixed-width format. 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

A management system for sensitive system and security information. This system is designed to aid IT/Security professionals in maintaining a repository of sensitive information for their systems, to include: sensitive system information (architecture, assets and inventory, vulnerability data, remediation strategies, assessments) and so on. This is an ever evolving project and will take shape over a given amount of time.

miMas is an intuitive GUI tool for SQL query development and data browsing. It provides a common set of features across all databases and can be installed on any Operating System which has a Java Runtime available. The tool uses JDBC drivers for connecting to a database. For most popular databases (Oracle, DB2, MySQL, MS SQL Server, Sybase, Cloudscape, PostgreSQL and Firebird), the JDBC driver is already included. For connecting to databases other than these, please refer to the tool's...

OpenBibleDB is a web-based Bible tool for community websites that will enable site members to write and save their own commentary notes on the website. Users will be able to export and import their notes to a mobile device.

This tool creates a PHP class to interface to a given database table. The PHP class is a simple relational object mapper. It maps table columns to class attributes. It provides basic CRUD methods as well as utility methods such as CSV import and export.