Online database entity-relationship diagram editor, data modeler, and SQL generator. Design, visualize, and export scripts without an account and completely free of charge.
ggsql: A grammar of graphics for SQL
Introducing ggsql, a grammar of graphics for SQL that lets you describe visualizations directly inside SQL queries.
Security-first diagramming for teams | draw.io
Free, open source diagramming application with 100M+ users. Store your data wherever you want—we can't access it.
The operad of wiring diagrams: formalizing a graphical language for databases, recursion, and plug-and-play circuits
Wiring diagrams, as seen in digital circuits, can be nested hierarchically and thus have an aspect of self-similarity. We show that wiring diagrams form the morphisms of an operad $\mcT$, capturing this self-similarity. We discuss the algebra $\Rel$ of mathematical relations on $\mcT$, and in so doing use wiring diagrams as a graphical language with which to structure queries on relational databases. We give the example of circuit diagrams as a special case. We move on to show how plug-and-play devices and also recursion can be formulated in the operadic framework as well. Throughout we include many examples and figures.
protolab
A patchbay for your schemas. Bidirectional data transformations, drawn as circuits.
protolab
A patchbay for your schemas. Bidirectional data transformations, drawn as circuits.
Nomnoml
A tool for drawing diagrams based on syntax. Supercharge your boxes and arrows.
Graceful database schema evolution: the PRISM workbench: Proceedings of the VLDB Endowment: Vol 1, No 1
Supporting graceful schema evolution represents an unsolved problem for traditional information systems that is further exacerbated in web information systems, such as Wikipedia and public scientific databases: in these projects based on multiparty ...
Relational foundations for functorial data migration | Proceedings of the 15th Symposium on Database Programming Languages
In this paper we present a simple database definition language: that of categories and functors. A database schema is a small category and an instance is a set-valued functor on it. We show that morphisms of schemas induce three ''data migration ...
Semantic Data Modeling, Graph Query, and SQL, Together at Last?
Our teams advance the state of the art through research, systems engineering, and collaboration across Google.
Leaving technical preview | GraphQL
After over a year of being open sourced we’re bringing GraphQL out of “technical preview” and relaunching graphql.org.
Flowchart Maker & Online Diagram Software
Against SQL
But SQL is the only widely-used implementation of the relational model, and it is:
A Graph-Based Firebase
This essay covers the design behind Instant. If the schleps we face as UI engineers are actually database problems in disguise, would a database-looking solution solve them?
Living documents and interactive schematics — Selin Jessa
Using LLMs to turn static figures from data analysis, schematics, and publications into interactive widgets as tools for thought
