Search Results for "sql table"

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 (tables, columns, size). ...

PL/JSON is a generic JSON object written in PL/SQL. Using PL/SQL object syntax, users instantiate a JSON object and then add members, arrays and additional JSON objects. This object type can store JSON data, in Oracle, persistently.

The CAM editor is the leading open source XML Editor/Validation/Schema toolset for rapidly building / deploying XML /JSON /Hibernate /SQL data /Forms applications. Visual WYSIWYG data design, rule entry wizards + drag & drop dictionary components. Will import, analyze / refactor from XML Schema / JSON. Oracle is a proud enterprise sponsor; with NIEM.gov support. Do SQL data import/map+ Open Data API delivery+ Hibernate JPA + UI Forms/Pencil Makes XSD schema (default, flatten, NIEM, &...

"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.

ETL Framework is a standalone Extract Transform Load engine written in Java. It includes executables for all major platforms and can be easily integrated into other applications. Key Features: * embeddable, open source and free * fast and scalable * uses target database features to do transformations and loads * manual and automatic data mapping * data streaming * bulk data loads * data quality features using SQL, JavaScript? and regex * data transformations Requirements *...

Python library provides the briefest way to construct SQL queries in JSON form. Simple example: ('*','table',id:[1,3]) is Select * from table where id in [1,3]. Sqlalchemy patch module is provided to extend sqlalchemy with convenient jsonSQL meth

Parser for SDict-based format dictionaries with ability to save in a SQL server (with creating table, index and filling data) and in a text file (SDict text format). NOTE: The project has been moved to GitHub: https://github.com/nuald/sdict2db The old one stays here just for the historical reasons.

QExcel Converter SQL QT4, Import xml excel/openoffice 2003 format, sqlite3 sql text/binary, edit table and export to various Format, Pdf XSL format objects Apache fop JAVA(XSL-FO), XML/XSLT , excel, SQL text sqlite3 dump file and MYSQL SQL to XML/XSL.

This project is an win32 converter from DBF to SQL. It generates a sql script file, and have options to create/drop the table, supress deleted fields, include the data, use transactios...