Search Results for "run sql command line"

qsv is a fast, command-line CSV data toolkit written in Rust that extends the capabilities of xsv. It’s designed to make working with CSV files at scale easy and efficient, offering over 40 powerful subcommands for tasks like querying, sampling, splitting, deduplicating, and more. qsv is ideal for data engineers, analysts, and developers who need high-performance CSV manipulation on the command line.

...It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. It is open source GPL v3 and crossplatform, it can run on most operating systems that can run Python (Python is required). More details, example files, and online manual at http://csv2odf.sf.net.

jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate,...

"Database to CSV" allows to back-up data from database(Oracle, MySQL, SQL Server) in the form of CSV files. Each table data is stored in a separate CSV file. It also allows to load data from CSV files into the database. Program can be run from UI or from command line. There's one more advanced feature which allows merging of data from CSV file to Database. It is only available from command line.

dhcp-gen is a perl script that was written by me and Trond Erik Dalho to simplify editing dhcpd.conf for adding static ip to computers and equipment on our school. It also made it easier to do manage the network by limiting some computers access to the local network only. Creating closed networks. And it also worked as a database over all our computers and equipment, making it easier to keep track of everything. All information about equipment is stored inside csv files which are comma separated.