Search Results for "sql csv"

SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! ...

...The project also embraces an ecosystem of plugins, so you can add custom SQL functions, extra commands, or UIs (including a terminal UI) via separate packages. Because it’s designed by someone who uses SQLite heavily in real projects, the tool includes many small quality-of-life features.

Audax Data Manager is the SQL Editor that's fast enough for a one-off query, and powerful enough for backups, performance tuning, and database design. Supports PostgreSQL, SQLite, Microsoft SQL Server, MySQL, MariaDB, and Oracle. Works on Linux, Windows and Mac. Explore and edit your data, write SQL queries with smart autocomplete, monitor database performance, run background backups and more!

q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings. q fully supports all types of encoding. Use -e data-encoding to set the input data encoding, -Q query-encoding to set the query encoding, and use -E output-encoding to set the output encoding. ...

BiBler is a software for managing references to scientific articles using BibTeX. BiBler runs with a windows GUI or can be used as a Python library

Python scripts that help you pull out hardcoded strings from your source codes and represent them as a .csv table. You can then write localized versions of those strings and put them back into your code. Currently supports: .php, .js, .html, .sql

Db Api client is a simple Python DB Api v2.0 client. It shows some information about database, tables, table\'s description. Db Api Client provides sql queries executing, shows results, and exports to some formats (html, csv).

...Metrics include McCabe's Cyclomatic Complexity metric, LoC, %Comments, etc. Users can also define their own metrics using data from PyMetrics. PyMetrics optionally outputs stdout, SQL command files and CSV

This is a python script for Windows that allows you to convert CSV files to MySQL .SQL formatted text files with ease. Untested with other database formats. Please try it out and contact me if it works.