clickhouse - This is a Golang driver for ClickHouse column-oriented database management system

•    Go

---

This is a Golang driver for ClickHouse column-oriented database management system

clickhouse database golang-driver analytics-database sql

ClickHouse - Columnar DBMS and Real Time Analytics

•    C++

---

ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries. It is Linearly Scalable, Blazing Fast, Highly Reliable, Fault Tolerant, Data compression, Real time query processing, Web analytics, Vectorized query execution, Local and distributed joins. It can process hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second.

database columnar-database column-oriented columnar analytics real-time big-data

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.

clickhouse sql-query dashboard data-visualization bi data-analysis business-intelligence sql-editor database-management

Sqlite JDBC - SQLite JDBC Driver

•    Java

---

SQLite JDBC is a library for accessing and creating SQLite database files in Java. The library requires no configuration since native libraries for major OSs, including Windows, Mac OS X, Linux etc., are assembled into a single JAR (Java Archive) file.

sqlite jdbc database sqllite-library database-library

iSQL-Viewer - JDBC compliant database front end

•    Java

---

iSQL-Viewer is JDBC compliant database front end. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix.

database-front-end adminstration tool sql-client

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

dbeaver - Free universal database tool and SQL client

•    Java

---

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports any database which has JDBC driver (which basically means - ANY database). EE version also supports non-JDBC datasources (WMI, MongoDB, Cassandra, Redis). You can download prebuilt binaries from official web site or directly from GitHub releases.

sql database dbeaver gui mysql postgresql oracle db2 sqlite erd

mssql-jdbc - The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC application program interfaces (APIs)

•    Java

---

Microsoft JDBC Driver for SQL Server. The Azure Key Vault feature in Microsoft JDBC Driver for SQL Server depends on Azure SDK for JAVA and Azure Active Directory Library For Java.

generate-schema - Convert JSON Objects to MySQL Schema, JSON Schema, Mongoose Schema, Google BigQuery, or a Generic template for Swagger files, documentation, code generation, and more

•    Javascript

---

Convert JSON Objects to MySQL Table Schema, JSON Schema, Mongoose Schema, ClickHouse Schema, Google BigQuery, or a Generic template for documentation, code generation, and more. Optionally, add -g to the above if you want the generate-schema command line executable.

json schema object convert manipulate traverse types type is generate produce mongoose generic validation bigquery google data datatypes

JdbcProxy - To trace and stub JDBC calls

•    Java

---

JdbcProxy is a JDBC 2.0 driver that can help debug or test applications. The driver can wrap another JDBC driver to debug the JDBC calls done by the application. The driver can also emulate another JDBC driver to test the application without a database.

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

WS-JDBC

•    Java

---

WS-JDBC is a client/server JDBC Driver, where the server part is implemented as Web services. This means the custom client JDBC Driver can call the service remotely, from anywhere on the Internet.

doobie - principled database access for scala

•    Scala

---

doobie is a pure functional JDBC layer for Scala. It is not an ORM, nor is it a relational algebra; it just provides a principled way to construct programs (and higher-level libraries) that use JDBC. doobie introduces very few new abstractions; if you are familiar with basic scalaz typeclasses like Functor and Monad you should have no trouble here.

database-access-layer dao jdbc scala-database-library

Excel JDBC Driver

•    Java

---

xlSQL JDBC Driver for Excel, CSV and XML files. xlSQL maps a directory of Excel files to a database, workbooks to schemas and sheets to tables. Query documents with either the full HSQL or MySQL dialect. Write objects and data with native xlSQL.

elasticsearch-jdbc - JDBC importer for Elasticsearch

•    Java

---

Image by icons8 Creative Commons Attribution-NoDerivs 3.0 Unported. The Java Database Connection (JDBC) importer allows to fetch data from JDBC sources for indexing into Elasticsearch.

SimpleFlatMapper - Fast and Easy mapping from database and CSV to POJO

•    Java

---

Fast and Easy mapping from database and CSV to POJO. It is a java micro ORM, lightweight alternative to iBatis and Hibernate. It supports Fast Csv Parser and Csv Mapper.

csv jdbc orm mapper spring sql2o jdbi csv-parser

norm - Not Object-Relational Mapping

•    Java

---

Norm is a simple way to access a JDBC database, usually in one line of code. It purges your code of the complex mess that is Hibernate, JPA, and ORM. It is an extremely lightweight layer over JDBC. It gets rid of large amounts of boilerplate JDBC code.

orm persistence database-development orm-java

Pojodbc

•    Java

---

The JAVA library which reconciles JDBC and POJO. Start working with POJO without rewriting all your JDBC application. Without any configuration file, without any annotation, use your native SQL request with JDBC and get POJO(s).

DBTransfer - Versatile and fast database transfer tool

•    Java

---

DBTransfer is a multi-platform java tool, that aims to replicate one database (JDBC or MS Access) to another (JDBC), using an one to one conversion.

database-tools database-replication replication

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