Search Results for "sql file to csv"
Sort By:
Showing 204 open source projects for "sql file to csv"
View related business solutions-
Red Hat Enterprise Linux (RHEL) on Microsoft Azure provides a secure, reliable, and flexible foundation for your cloud infrastructure. Red Hat Enterprise Linux on Microsoft Azure is ideal for enterprises seeking to enhance their cloud environment with seamless integration, consistent performance, and comprehensive support.
-
Drive amazing product experiences with quality product data.
-
1
A read-only JDBC driver for Java that uses Comma Separated Value (CSV) files as database tables. Ideal for writing data import programs and conversion programs.
-
2
Countries States Cities Database
Discover our global repository of countries, states, and cities
Full Database of city state country available in JSON, SQL, XML, YAML & CSV format. All Countries, States and cities are Covered and populated with Different Combinations and versions. The API database is regularly updated to ensure the latest data is available to users. Discover our global repository of countries, states, and cities! Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, time zones (for countries... -
3
World countries JSON
Constantly updated lists of world countries
Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries. Also available are the ISO 3166-2 codes used for identifying the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1. -
4
Miller
Miller is like awk, sed, cut, join, and sort for name-indexed data
Miller is like awk, sed, cut, join, and sort for data formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. With Miller, you get to use named fields without needing to count positional indices, using familiar formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. Then, on the fly, you can add new fields which are functions of existing fields, drop fields, sort, aggregate statistically, pretty-print, and more. Miller operates on key-value-pair data while... -
With Twilio Voice, you can build unique phone call experiences with one API, to create, receive, control and monitor calls with just a few lines of code. Create an engaging voice experience that you can quickly scale and modify with a wide array of customization options and resources.
-
5
dsq
Commandline tool for running SQL queries against JSON, CSV, Excel
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. This is a CLI companion to DataStation (a GUI) for running SQL queries against data files. So if you want the GUI version of this, check out DataStation. -
6
sq data wrangler
sq data wrangler
sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure... -
7
Chronicle Wire
Low Garbage Java Serialisation Library that supports multiple formats
Chronicle Wire is a Wire Format abstraction library. Chronicle Wire uses Chronicle Bytes for bytes manipulation, and Chronicle Core for low-level JVM access. Configuration includes aliased type information. This supports easy extension by adding new classes/versions, and cross-platform using type aliasing. By supporting types, a configuration file can bootstrap itself. You control how the configuration file is decoded. See example Queue Enterprise config. To send the configuration of a server... -
8
Papa Parse
CSV parser that handles large files and malformed input
The world's first multi-threaded CSV parser for the browser. Use Papa when performance, privacy, and correctness matter to you. Papa alleviates privacy concerns related to uploading files. Malformed CSV is handled gracefully with a detailed error report. Now the fastest JavaScript CSV parser for the browser. Papa can handle files gigabytes in size without crashing. CSV to JSON and JSON to CSV. Auto-detect delimiter, open local files, download remote files, stream local and remote files, multi... -
9
Murex
A smarter shell and scripting environment with advanced features
Murex is a shell, like bash / zsh / fish / etc however Murex supports improved features and an enhanced UX. Support for additional type information in pipelines, which can be used for complex data formats like JSON or tables. Meaning all of your existing UNIX tools to work more intelligently and without any additional configuration. Usability improvements such as in-line spell checking, context-sensitive hint text that details the behavior of a command before you hit return, and auto-parsing... -
ConnectWise CPQ, formerly ConnectWise Sell, is a professional quote and proposal automation software for IT solution providers. ConnectWise CPQ offers a wide range of tools that enables IT solution providers to save time, quote more, and win big. Top features include professional quote or proposal templates, product catalog and sourcing, workflow automation, sales reporting, and integrations with best-in-breed solutions like Cisco, Dell, HP, and Salesforce.
-
10
sqlitebiter
A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook
A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to an SQLite database file. -
11
SPyQL
Query data on the command line with SQL-like SELECTs powered by Python
SQL with Python in the middle. SPyQL is a query language that combines the simplicity and structure of SQL with the power and readability of Python. SPyQL offers a command-line interface that allows running SPyQL queries on top of text data (e.g. CSV, JSON). Data can come from files but also from data streams, such as as Kafka, or from databases such as PostgreSQL. Basically, data can come from any command that outputs text :-). More, data can be generated by a Python expression! And since... -
12
FSharp.Data
F# Data: Library for Data Access
The FSharp.Data package implements core functionality to access common data formats in your F# applications and scripts. It contains F# type providers for working with structured file formats (CSV, HTML, JSON and XML) and helpers for parsing CSV, HTML and JSON files and for sending HTTP requests. This library focuses on providing simple access to structured documents and other data sources. The FSharp.Data type providers for CSV, HTML, JSON and XML infer types from the structure of a sample... -
13
PHP7
PHP7 / Laravel Multi-format Streaming Parser
When it comes to parsing XML/CSV/JSON/... documents, there are 2 approaches to consider. DOM loading loads all the documents, making it easy to navigate and parse, and as such provides maximum flexibility for developers. Streaming implies iterating through the document, acts like a cursor, and stops at each element in its way, thus avoiding memory overkill. Thus, when it comes to big files, callbacks will be executed meanwhile file is downloading and will be much more efficient as far as memory... -
14
CSV Quick Viewer
CSV Quick Viewer
Windows file viewer for delimited text files like CSV or Tab delimited files. Nothing needs to be configured. In case of unusual formatting of the text files the option can be adjusted. Simply open any delimited text file and access the information in tabular form. -
15
SQL Trace Interlace
Reads SSMS results and places the corresponding query by its results.
Make finding relevant queries from SQL Profiler easier. When working with SQL Profiler, you may be looking for which query was responsible for a given result/keyword. Profiler does not include query results, and SSMS does not make matching a query to its results simple if there is a large number of queries to review. This tool takes the SSMS query results, and places the corresponding query next to its results in a new text file. This allows for searching for query results/keywords... -
16
asammdf
Fast Python reader and editor for ASAM MDF / MF4 (Measurement Format)
*asammdf* is a fast Python parser and editor for ASAM (Associtation for Standardisation of Automation and Measuring Systems) MDF / MF4 (Measurement Data Format) files. It supports MDF versions 2 (.dat), 3 (.mdf) and 4 (.mf4). *asammdf* works on Python 2.7, and Python >= 3.4 -
17
csv2odf
csv2odf can convert csv data to formatted spreadsheets and documents.
csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. 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... -
18
JRecord
Read Cobol data files in Java
provide Java Record based IO routines for Fixed Width (including Text, Mainframe, Cobol and Binary) and delimited Flat files via a Record Layout (Cobol, CSV or XML). The source is now available at https://github.com/bmTas/JRecord Projects using JRecord include: * https://github.com/thospfuller/rcoboldi - Cobol File in R * https://github.com/tmalaska/CopybookInputFormat - Cobol files in Hadoop * https://github.com/gss2002/copybook_formatter * https://github.com/gss2002/ftp2hdfs has... -
19
generatedata
A powerful, feature-rich, random test data generator
This is the repo for the downloadable version of generatedata.com. The script is essentially an engine to generate any sort of random data in any format. It currently comes with 30 or so Data Types (types of data it generates), 12 Export Types (formats for the data, like CSV, SQL, JSON), plus around 32 data sets for specific countries (city names, regions, etc). But more importantly, it can be extended in any way you want. Check out the developer documentation for more information... -
20
XLSX I/O
C library for reading/writing values from/to Excel .xlsx files.
Cross-platform C library for reading values from and writing values to .xlsx files. XLSX I/O aims to provide a C library for reading and writing .xlsx files. The .xlsx file format is the native format used by Microsoft(R) Excel(TM) since version 2007. The library was written with the following goals in mind: - primary focus on data values organized in tables, on not layout or graphics - written in standard C, but allows being used by C++ - simple interface - small footprint... -
21
xsd2pgschema
Relational database replication tool based on XML Schema
xsd2pgschema is a Java application suite, which converts XML Schema 1.1 (hierarchical data model) to PostgreSQL DDL (relational data model) and supports XML data migration into PostgreSQL based on the XML Schema without defects on information content. It also supports full-text indexing via either Apache Lucene or Sphinx Search utilizing the relational data model. File conversion from XML to CSV, TSV, or JSON is possible as well as mapping XML Schema to JSON Schema. Obtained PostgreSQL... -
22
RecordEditor
Editor for Fixed Width, Csv and Existing Xml files.
The RecordEditor is a Data File editor for Flat Files (delimited and fixed field position). It supports Unix / PC / Legacy (e.g. Mainframe) file formats, both Text and binary files. The Editor uses a Record-Layout description to format the files. This is ideal for Fixed width (Text or Binary) files, Cobol Data Files, Mainframe files and complicated Csv files. Cobol Copybooks can be used to format Cobol Data files. As well as an editor, The following utilities are supplied * Formatted... -
23
Bots-ediint open source edi translator
open source edi translator
Bots-ediint is a file translator for EDI (Electronic Data Interchange). Translate files and databases data format to another one: edifact, x12, tradacoms, xml, json, raw, database (postgres, sqlite, mysql, oracle, ...) and more. Bots-ediint is based on Bots https://bots.sourceforge.net Support Python 2 and Python 3 AS2 communications are carried out with my external software that could work in standalone and/or in a Bots channel to send and receive AS2 messages (SYNC and ASYNC... -
24
reCsvEditor
Editor for simple (only one record type) Csv Files.
Editor for both Csv files and Fixed width files. There is automatic attribute detection for single record Csv Files. You can edit Fixed Width file and Multi-Record Csv / Fixed width files using a Xml Schema. There is also limited editing available for Xml and PO files. -
25
abnamro-effnota
Convert pdf effecten notas van ABN AMRO naar een CSV file
ABN effecten nota's kunnen alleen in pdf formaat gedownload worden. Met deze tool kunnen pdf effecten nota's worden omgezet in een csv file. De tool is een command line tool geschreven in C en voor Windows.