Links tagged “database”

druid.io

Real-time analytics database built for sub-second aggregate queries over large streaming and batch datasets.

imply.io

Commercial platform from the original creators of Apache Druid, selling managed and hybrid Druid deployments for storing and querying observability and security data.

blog.timescale.com

Argues that NoSQL's fragmented query languages pushed developers back to SQL, which is becoming the universal interface for data analysis — the "narrow waist" of the data stack.

microservices.io

Pattern write-up: keep a read-only view database, synchronised by domain events, so a query can span data owned by several microservices.

registries.opencorporates.com

Ranks the company register of every jurisdiction by how open its data is, alongside record counts and what each register publishes freely.

opencorporates.com

Company and officer records collated from over 140 official government registries worldwide, searchable on the web and available through an API and bulk downloads.

timescale.com

Product site for TimescaleDB, the extension that turns PostgreSQL into a time-series database, keeping full SQL over high-rate metric ingestion.

py2neo.org

Documentation for py2neo, a Python client library and command-line toolkit for working with Neo4j; the project is now end of life.

explain.depesz.com

Paste a PostgreSQL EXPLAIN plan and get it back as a readable annotated tree that highlights the costly nodes; plans can be shared or anonymised.

janusgraph.org

Open-source distributed graph database for graphs of billions of vertices and edges, backed by Cassandra, HBase or Bigtable and queried through Apache TinkerPop.

sqlstyle.guide

Style guide for SQL covering naming conventions, keyword capitalisation, whitespace and indentation for joins and subqueries, and portable CREATE syntax.

sqlalchemy-utils.readthedocs.io

Documentation for SQLAlchemy-Utils, a library of extra column types (email, UUID, JSON), model mixins, ORM helpers and database test utilities for SQLAlchemy.

techspot.zzzeek.org

Benchmarked argument that asyncio slows database-bound Python code down, because interpreter overhead — not database I/O — dominates typical CRUD work.

research.google.com

Google's VLDB 2010 paper on Dremel, a scalable interactive ad-hoc query system for read-only nested data that scans trillion-row tables in seconds.

bigchaindb.com

Home of BigchainDB, a database with blockchain characteristics: decentralized control, immutability and asset support, at database throughput.

github.com

A PostgreSQL client library for Python/asyncio, built for fast asynchronous database access.

pouchdb.com

JavaScript database inspired by CouchDB that stores data locally in the browser or Node and syncs it back to a CouchDB server once the app is online again.

prestodb.io

A distributed SQL query engine for interactive analytic queries across data sources of mixed kinds.

josekipedia.com

A community-edited database of joseki, the corner opening sequences of the game of Go.

opentsdb.net

Home page of OpenTSDB, a time series database built on HBase for storing and serving large volumes of metrics without losing granularity.