Search Results for ".sql"
Sort By:
Showing 195 open source projects for ".sql"
View related business solutions-
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
Atera all-in-one platform IT management software with AI agentsAtera’s AI agents don’t just assist, they act. From detection to resolution, they handle incidents and requests instantly, taking your IT management from automated to autonomous.
-
1
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. -
2
PL/JSON
PL/JSON is a generic JSON object written in PL/SQL
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. -
3
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 (tables, columns, size). ... -
4
Cube
Universal semantic layer platform for AI, BI, spreadsheets
...It helps data engineers and application developers access data from modern data stores, organize it into consistent definitions, and deliver it to every application. Cube was designed to work with all SQL-enabled data sources, including cloud data warehouses like Snowflake or Google BigQuery, query engines like Presto or Amazon Athena, and application databases like Postgres. Cube has a built-in relational caching engine to provide sub-second latency and high concurrency for API requests. -
Free and Open Source HR SoftwareGive your HR team the tools they need to streamline administrative tasks, support employees, and make informed decisions with the OrangeHRM free and open source HR software.
-
5
SQLModel
SQL databases in Python, designed for simplicity, compatibility
SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness. SQLModel is a library for interacting with SQL databases from Python code, with Python objects. It is designed to be intuitive, easy to use, highly compatible, and robust. SQLModel is based on Python-type annotations, and powered by Pydantic and SQLAlchemy. -
6
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. -
7
QSV
Blazing-fast Data-Wrangling toolkit
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. -
8
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... -
9
decimal
Arbitrary-precision fixed-point decimal numbers in go
...The zero-value is 0, and is safe to use without initialization. Addition, subtraction, and multiplication with no loss of precision. Division with specified precision. Database/sql serialization/deserialization. JSON and XML serialization/deserialization. big.Int's API is built to reduce the number of memory allocations for maximal performance. This makes sense for its use-case, but the trade-off is that the API is awkward and easy to misuse. In contrast, it's difficult to make such mistakes with decimal. Decimals behave like other go numbers types: even though a = b will not deep copy b into a, it is impossible to modify a Decimal, since all Decimal methods return new Decimals and do not modify the originals. ... -
Construction Takeoff SoftwareStratosphere’s cutting edge cloud platform gives estimators unprecedented freedom to complete takeoffs from anywhere with next generation takeoff and markup tools.
-
10
QxOrm library
C++ Qt ORM (Object Relational Mapping) and ODM library
QxOrm library is an Object Relational Mapping (ORM) and Object Document Mapper (ODM) database library for C++ Qt developers. QxEntityEditor is a graphic editor for QxOrm library : QxEntityEditor provides a graphic way to manage the data model. QxEntityEditor is multi-platform (available for Windows, Linux, and Mac OS X) and generates native code for all environments, desktop (Windows, Linux, Mac OS X), embedded and mobile (Android, iOS, Windows Phone, Raspberry Pi, etc.). A user manual... -
11
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.
-
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 format released into the public domain. See http://www.sqlite.org/ Please check out the Wiki Home page https://sourceforge.net/p/pycsvdb/wiki/Home/ and the General Help page (https://sourceforge.net/p/pycsvdb/wiki/General%20Help/) to find extra information and help. ... -
13
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... -
14
GETL
ETL engine based on Groovy
P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with... -
15
DSNQl
Visualiser, convertir, contôler un fichier DSN
Visualiser et contrôler simplement le contenu d'un fichier DSN en le convertissant en fichier XLS. Interroger le contenu en effectuant des requêtes types SQL sur un fichier DSN. Le fichier XLSX exporté permet d'établir des statistiques ou de suivre des indicateurs à partir du fichier DSN. -
16
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... -
17
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. -
18
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. -
19
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. -
20
generatedata
A powerful, feature-rich, random test data generator
...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 on that. The current major version of the script is 4.x, which was a big change over earlier releases. Earlier versions were written in PHP and MYSQL and 3.x offered a REST API to let you generate the data programmatically rather than via an API. ... -
21
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. -
22
PersonGen
A minor Project in Python which uses the RandomUser API .
A Small Program in Python That Makes Use of RandomUser API To Generate Random Person Data. -
23
XML Editor/Validator/Designer with CAMV
CAM XML Editor for XML+JSON+Hibernate+SQL Open-XDX sponsored by Oracle
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, & OASIS modes) + JAXB bindings; Mindmap FreeMind or UML models(XMI); XML unit test & live SQL data; HTML docs + spreadsheets (NIEM IEPDs). ... -
24
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. -
25
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/ .
