sql.js - SQLite compiled to JavaScript through Emscripten

•    Javascript

---

sql.js is a port of SQLite to JavaScript, by compiling the SQLite C code with Emscripten. It uses a virtual database file stored in memory, and thus doesn't persist the changes made to the database. However, it allows you to import any existing sqlite file, and to export the created database as a javascript typed array. There is no C bindings or node-gyp compilation here, sql.js is a simple javascript file, that can be used like any traditional javascript library. If you are building a native application in javascript (using Electron for instance), or are working in node.js, you will likely prefer to use a native binding of SQLite to javascript.

sql sqlite stand-alone relational database rdbms data query statement emscripten asm asm.js

Eve - Better tools for thought

•    TypeScript

---

Eve is a programming language based on years of research into building a human-first programming platform. This repository hosts a preview of Eve v0.3 alpha, which is no longer under active development.

programming-language language ide database eve relational dataflow

jDBI - Provides convenient tabular data access in Java

•    Java

---

The Jdbi library provides convenient, idiomatic access to relational databases in Java. Jdbi is built on top of JDBC. If your database has a JDBC driver, you can use Jdbi with it. It uses the Java collections framework for query results, provides a convenient means of externalizing sql statements, and provides named parameter support for any database being used.

orm database-helper database-library query-library jdbc sql relational

rest-hapi - 🚀 A RESTful API generator for Node.js

•    Javascript

---

You need Node.js installed and you'll need MongoDB installed and running.

hapi hapi-plugin joi swagger rest rest-api validation crud mongoose mongodb nosql relational api documentation joi-validation hapi-server audit-log crud-generator crud-api restful generator

muze - Composable data visualisation library for web with a data-first approach now powered by WebAssembly

•    Javascript

---

Muze is a free data visualization library for creating exploratory data visualizations (like Tableau) in browser, using WebAssembly. It uses a layered Grammar of Graphics (GoG) to create composable and interactive data visualization for web. It is ideal for use in visual analytics dashboards & applications to create highly performant, interactive, multi-dimensional, and composable visualizations. It uses a data-first approach to define the constructs and layers of the chart, automatically generates cross-chart interactivity, and allows you to over-ride any behavior or interaction on the chart.

visualization svg pie-chart charts data web webassembly wasm data-visualization barchart data-viz interactive-charts area-chart crosstab linechart html5-charts splom js-charts muze vector graphics renderer relational algebra relation

typedb - TypeDB: a strongly-typed database

•    Java

---

TypeDB is a strongly-typed database with a rich and logical type system. TypeDB empowers you to tackle complex problems, and TypeQL is its query language. TypeDB allows you to model your domain based on logical and object-oriented principles. Composed of entity, relationship, and attribute types, as well as type hierarchies, roles, and rules, TypeDB allows you to think higher-level as opposed to join-tables, columns, documents, vertices, edges, and properties.

database graph logic inference knowledge-graph graph-theory graph-database graphdb knowledge-base type-system strongly-typed graph-visualisation relational knowledge-representation reasoning enterprise-knowledge-graph hyper-relational typedb typeql

VoltDB - Fast Scalable SQL DBMS with ACID

•    Java

---

VoltDB was specifically designed for contemporary software applications that are pushed beyond their limits by high volume data sources. VoltDB provides the ability to capture, store and process incoming data at millions of read/write operations per second. And VoltDB’s relational model opens that data to be analyzed in real-time, using familiar Business Intelligence tools, to identify data patterns and trends, spot anomalies, or perform tracking and alerting.

database relational acid bigdata scale-out distributed distributed-database oltp analytics

InfiniDB - Scale-up analytics database engine for data warehousing and business intelligence

•    C++

---

InfiniDB Community Edition is a scale-up, column-oriented database for data warehousing, analytics, business intelligence and read-intensive applications. InfiniDB's data warehouse columnar engine is multi-terabyte capable and accessed via MySQL.

database column-store data-mining relational column-database no-sql mysql-fork

LucidDB - RDBMS built entirely for Data Warehousing and Business Intelligence

•    Java

---

LucidDB is the RDBMS built entirely for data warehousing and business intelligence. It is based on architectural cornerstones such as column-store, bitmap indexing, hash join/aggregation, and page-level multi versioning. Every component of LucidDB was designed with the requirements of flexible, high-performance data integration and sophisticated query processing in mind.

database column-store data-mining relational

H2 Database - Java based Database Engine

•    Java

---

H2 database is very fast, open source database engine. It supports SQL and JDBC standards. It can run in Embedded and Server mode and it has clustering support.

database cluster relational full-text-search embedded-database in-memory

HyperSQL - Java Database

•    Java

---

HyperSQL supports the widest range of SQL Standard features seen in any open source database engine. It offers a small, fast database engine which offers in-memory and disk-based tables and supports embedded and server modes. It is a relational database engine written in Java, with a JDBC driver, conforming to ANSI SQL:2008. It alsi supports transaction isolation, multiversion concurrency and ACID, Java stored procedures, Scalability and lot more.

database relational persistence relational-database in-memory-database embedded-database

JavaDB

•    Java

---

Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2.5 MB.

database relational transactional

Metakit - embedded database library with small footprint

•    C++

---

Metakit is an embedded database library with a small footprint. It fills the gap between flat-file, relational, object-oriented, and tree-structured databases, supporting relational joins, serialization, nested structures, and instant schema evolution

database column-store embedded-database relational

kibi - Kibi is a friendly - kept in sync - Kibana fork which add support for joins across indexes and external sources, tabbed navigation interface and more

•    Javascript

---

Kibi extends Kibana 5.5.2 with data intelligence features; the core feature of Kibi is the capability to join and filter data from multiple Elasticsearch indexes and from SQL/NOSQL data sources ("external queries").In addition, Kibi provides UI features and visualizations like dashboard groups, tabs, cross entity relational navigation buttons, an enhanced search results table, analytical aggregators, HTML templates on query results, and much more.

kibana elasticsearch relational-browsing logstash analytics visualizations dashboards dashboarding data-intelligence relational sql sparql kibana-alternative

jcabi-jdbc - Fluent Wrapper of JDBC

•    Java

---

jcabi-jdbc is a lightweight wrapper of JDBC. It is very convenient to use when you don't need a full-scale ORM (like Hibernate), but want just to select, insert, or update a few rows in a relational database.

jdbc database-library database-helper sql relational

jSchema - A simple, easy to use data modeling framework for JavaScript

•    Javascript

---

jSchema is a framework for modeling data in JavaScript. By using fundamental data modeling principles you are able to pull multiple datasets into a common schema, define relationships, aggregate, join, and subset datasets to make data easier to work with in the browser. If you use npm, npm install jschema.

multiple-datasets data-visualization data-structures data data-modeling dataset filter drop sort orderby group groupby javascript-library relational json database schema

monarch - A client-side relational modeling framework

•    CoffeeScript

---

Monarch is a relational modeling framework for client-centric web applications. It's superficially similar to Backbone.js, but it uses the relational algebra as a declarative, compositional language for querying data and subscribing to events. Monarch is written in CoffeeScript, but can also be used from JavaScript. Monarch associates model constructors with tables in an in-memory relational database. On the surface, the API resembles ActiveRecord.

relational algebra

node-orm-old - NodeJS Object-Relational Mapping

•    Javascript

---

NodeJS Object-Relational Mapping

orm mysql postgresql mongodb database relational

level-assoc - relational foreign key associations (hasMany, belongsTo) for leveldb

•    Javascript

---

To get a stream of live results, just use the .live() function instead of .list().This example prints out all of the new records associated with the entire list of hackerspaces with names greater than or equal to "sudoroom", but only the new live entries.

has_many belongs_to active record relational sql database

level-join - join leveldb documents based on common nested values

•    Javascript

---

we can populate the database with db.batch() and then join each output's job property with a matching commit id property. This is like a foreign key in an SQL database, except that it can be arbitrarily nested.Note that the results are not grouped or sorted. A grouping and sorting module could be of use here.

join database relational algebra rows sql