Displaying 1 to 20 from 35 results

join-monster - A GraphQL to SQL query execution layer for query planning and batch data fetching.

  •    Javascript

Efficient query planning and data fetching for SQL. Use JOINs and/or batched requests to retrieve all your data. It takes a GraphQL query and your schema and automatically generates the SQL. Send that SQL to your database and get back all the data needed to resolve with only one or a few round-trips to the database. ...and get back correctly hydrated data.

sparkmagic - Jupyter magics and kernels for working with remote Spark clusters

  •    Python

Sparkmagic is a set of tools for interactively working with remote Spark clusters through Livy, a Spark REST server, in Jupyter notebooks. The Sparkmagic project includes a set of magics for interactively running Spark code in multiple languages, as well as some kernels that you can use to turn Jupyter into an integrated Spark environment. There are two ways to use sparkmagic. Head over to the examples section for a demonstration on how to use both models of execution.

Squirrel - Fluent SQL generation for golang

  •    Go

Squirrel is not an ORM, It helps you build SQL queries from composable parts and also supports executing queries directly. Squirrel works well with PostgreSQL.

goqu - SQL builder and query library for golang

  •    Go

In order to start using goqu with your database you need to load an adapter. We have included some adapters by default. Adapters in goqu work the same way as a driver with the database in that they register themselves with goqu once loaded.

Tabix - SQL Editor & Open source simple business intelligence for Clickhouse.

  •    Javascript

Tabix is a SQL Editor & Open source simple business intelligence for Clickhouse. No need to install, it works from the browser. It provides support to Draw charts, Maps of the world, Metrics RealTime charts from system.metrics, Displays database and tables as tree and lot more.

querybuilder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql and Firebird

  •    CSharp

SqlKata Query Builder is a powerful Sql Query Builder written in C#. It's secure and framework agnostic. Inspired by the top Query Builders available, like Laravel Query Builder, and Knex.

jinjasql - Simplify creation and maintenance of complex SQL queries by using Jinja based template language

  •    Python

JinjaSQL is a template language for SQL statements and scripts. Since it's based in Jinja2, you have all the power it offers - conditional statements, macros, looping constructs, blocks, inheritance, and many more. JinjaSQL doesn't actually execute the query - it only prepares the query and the bind parameters. You can execute the query using any database engine / driver you are working with.

data - Agile Data - Data Access Framework for high-latency databases (Cloud SQL/NoSQL).

  •    PHP

Data Access Framework for high-latency databases (Cloud SQL/NoSQL). Since the initial introduction of Agile Data back in 2016 our group of early-adopters used it in large production PHP projects. It is time for you to try Agile Data today.

SQLBuilder - A powerful, fast, cross-platform SQL Builder for PHP

  •    PHP

If you're looking for something that is not an ORM but can generate SQL for you, you just found the right one. SQLBuilder is not an ORM (Object relational mapping) system, but a toolset that helps you generate cross-platform SQL queries in PHP.

deveeldb - DeveelDB is a complete SQL database system, primarly developed for .NET/Mono frameworks

  •    CSharp

Although the core project is thought to be embedded in applications, the modular architecture allows extensions to other uses, such as providing databases through networks: an application is already included in the solution. In the wiki pages of the GitHub space dedicated to the project, it is possible to find more information about the project dynamics and usage.

qhs - SQL queries on CSV and TSV files

  •    Haskell

This is a Haskell implementation of q command. Prepare stack command from here.

database - 💾 A database layer with a familiar PDO-like API but much more powerful

  •    PHP

Nette provides a powerful layer for accessing your database easily. The Nette Database Core is a wrapper around the PDO and provides core functionality.

little_pger - 🐘 PostgreSQL query building with plain data structures.

  •    Python

It's a thin layer just a tad above SQL, for use with Postgres and psycopg2, when you want to wrap queries in a convenient way, using plain data structures (but you don't feel like using an ORM, for some reason). Of course psycopg2 already does a very fine job on its own, but in the context of webapp backend development, I often found myself wanting for an extra-frictionless way of shuffling around Ajax/JSON data. As composing raw SQL queries quickly induces string-manipulation fatigue, I gradually evolved little_pger for that simple purpose.

ZenQuery - Enterprise backend as a service

  •    Java

ZenQuery allows you to easily access databases through a REST API. All you have to do is enter your database connection settings and ZenQuery will generate REST API endpoints for all your database tables and views. Moreover, you can easily add custom SQL queries for access via REST API calls.

qolor - An atom package to color your queries!

  •    CoffeeScript

Qolor applies semantic highlighting to your SQL queries by matching tables to their aliases. Qolor has a few outstanding issues but it's usable and I want to launch it in the spirit of MVP. I say it's usable because it doesn't throw errors or pop up the inspector. If you see it doing this please report ASAP. Please feel free to create issues of broken coloring cases with screen shots or text samples (remember to check out the TODO below and the open issues).

discourse-data-explorer - SQL Queries for admins in Discourse

  •    Ruby

This plugin allows admins to run SQL queries against the live Discourse database, including parameterized queries and formatting for several common column types.

kdbc - SQL DSL for Kotlin

  •    Kotlin

To query or update a table you need a Table object that represents the database table. A Query is encapsulated in a class. Every table you mention in the query needs an alias, defined by instantiating one or more Table instances.

We have large collection of open source products. Follow the tags from Tag Cloud >>

Open source products are scattered around the web. Please provide information about the open source projects you own / you use. Add Projects.