Search Results for "sql query"
Sort By:
Showing 25 open source projects for "sql query"
View related business solutions-
Our Free Plans just got better! | Auth0 by OktaYou asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your secuirty. Auth0 now, thank yourself later.
-
Bright Data - All in One Platform for Proxies and Web ScrapingBright Data offers the highest quality proxies with automated session management, IP rotation, and advanced web unlocking technology. Enjoy reliable, fast performance with easy integration, a user-friendly dashboard, and enterprise-grade scaling. Powered by ethically-sourced residential IPs for seamless web scraping.
-
1
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 the... -
2
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... -
3
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. -
4
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... -
Vivantio IT Service ManagementThe Vivantio Platform allows you to focus on the IT service management tools that make sense for your organization’s unique service model: from incident, problem and change requests, to service requests, client knowledge and asset management
-
5
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... -
6
xsd2pgschema
Relational database replication tool based on XML Schema
... database can be optimized at user's discretion. Moreover, differential update, and XPath query evaluation over PostgreSQL are possible. PgSchema server, serialized relational data model server, can be used to speed up the analysis of complex XML Schema. Large XML file can be split through xmlsplitter, a flexible XML splitter based on XPath and StAX. -
7
sql-servant
Personal Query Servant
In your job, do you have queries that you are running regularly and sometimes you need to share those to non-technical people? Now you can do with your personal SQL Servant. Just configure and test it, if all is good distribute it. Those people doesn't need to have any fancy licensed SQL client. -
8
C-squares
Concise spatial query and representation system (c-squares)
C-squares is an easily implemented method for storage, querying and display of spatial data locations, based on a hierarchical, grid-based representation of the Earth' surface. Source code for encoding, decoding, mapping, etc. is provided via this site. Additional support is available by contacting the system developer, Tony.Rees@marinespecies.org; see also the c-squares home page at http://www.cmar.csiro.au/csquares/ . -
9
xplordb
Open mineral exploration database system
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. -
ConnectWise Cybersecurity Management for MSPsConnectWise SIEM (formerly Perch) offers threat detection and response backed by an in-house Security Operations Center (SOC). Defend against business email compromise, account takeovers, and see beyond your network traffic. Our team of threat analysts does all the tedium for you, eliminating the noise and sending only identified and verified treats to action on. Built with multi-tenancy, ConnectWise SIEM helps you keep clients safe with the best threat intel on the market.
-
10
rq
A tool for doing record analysis and transformation
This is the home of the tool called rq (record query). It's a tool that's used for performing queries on streams of records in various formats. The goal is to make ad-hoc exploration of data sets easy without having to use more heavy-weight tools like SQL/MapReduce/custom programs. rq fills a similar niche as tools like awk or sed, but works with structured (record) data instead of text. It was created with love out of the best parts of Rust, and is distributed as a dependency-free binary... -
11
jdbc2csv.jar
Command-line sql JDBC tool
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... -
12
pyDaSSQLiteMan
An easy way to manage SQLite databases and query CSV files
Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ . I'd recommend something after version 3. Testing has been Windows based. SQLite is a free database... -
13
QAL
Query Abstraction Layer
Project has moved to: https://github.com/OptimalBPM/qal QAL is a collection of libraries for mining, transforming and writing data from and to a number of places. Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages. It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming. It uses XML/JSON formats(self-generated SQL schemas... -
14
Document Object Model Structured Query Language! Example: 'SELECT {//title[1]=>innerCode} FROM {http://example.com}';
-
15
SQLui
SQL user interface for JSON
SQLui is a tool that enables the handling of JSON files via SQL commands. You can also use the SQLui class to optimize the query to JSON files using SQL commands. -
16
SITools2 is a new CNES generic tool performed by a joint effort between CNES and scientific laboratories. The aim of SITools is to provide a self-manageable data access layer deployed on already existing scientific laboratory databases.
-
17
SSQML
A schema to describe ANSI/ISO SQL in XML and associated tools
SSQML: Standard Structured Query Markup Language This is an XML dialect that allows any valid SQL statement, clause, expression, predicate, or query to be expressed fully in XML based on an XML compliant schema. The schema is based on Backus Normal Form (BNF) representations of ANSI-ISO/IEC SQL Standards; ISO/IEC 9075 :2003, ISO/IEC 9075 :2006, ISO/IEC 9075 :2008, ISO/IEC 9075-14 :2013 XML-Related Specifications (SQL/XML) Does not include support for Embedded SQL Ada, C, COBOL... -
18
pilot-qof provides a query interface to data on a Palm device, using pilot-link and QOF - the Query Object Framework. pilot-qof supports reading addressbook, datebook, expenses and ToDo data and runs SQL-type queries on the live data or a QSF XML fil
-
19
-
20
ACCESSdb is a JavaScript library used to dynamically connect to and query locally available Microsoft Access database files within Internet Explorer.
-
21
reportmaker allows you to define a generic report in xml containing sections,graphs,tables,images. The data can be retrieved directly with sql query. The report can be exported in various formats (html,xml,rtf,pdf)
-
22
-
23
A cgi program written in Python that turns HTTP GET and POST queries into SQL queries, runs them, turns the results into XML, and then returns the XML as the response to the HTTP query. It also supports returning a single BLOB as the whole response.
-
24
With the program you can simply mapping a XML structure to the sql datebase,such as sqlite,Mysql... Then ,easily add xml files of this kind into the database Or recover the query results from database into xml.
-
25
This is a new generation of SQL (Structured query language) Server which is targeted to serve on a Virtual Appliance. Hybrid SQL Server is targeted to run on VirtualBox from SunMicrosystems.
- Previous
- You're on page 1
- Next